- 论坛徽章:
- 0
|
RAC ASM standby 疑问
RAC 主库配置 SID: racdb 使用 ASM 存储,
db_file_name_convert ='/opt/oracle/oradata/standby/', '+RAC_ASM/racdb/datafile/', '/opt/oracle/oradata/standby/', '+RAC_ASM/racdb/tempfile/'
log_file_name_convert='/opt/oracle/oradata/standby/','+RAC_ASM/racdb/onlinelog/'
备库: SID: standby
db_file_name_convert='+RAC_ASM/racdb/datafile/','/opt/oracle/oradata/standby/','+RAC_ASM/racdb/tempfile/','/opt/oracle/oradata/standby/'
log_file_name_convert='+RAC_ASM/racdb/onlinelog/','/opt/oracle/oradata/standby/'
在RAC主库建立数据文件:
建立时,我指定的数据文件位置是: +RAC_ASM/racdb/datafile/user03.ora
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+RAC_ASM/racdb/datafile/system.277.724929393
+RAC_ASM/racdb/datafile/undotbs1.279.724929395
+RAC_ASM/racdb/datafile/sysaux.278.724929395
+RAC_ASM/racdb/datafile/users.280.724929395
+RAC_ASM/racdb/datafile/undotbs2.285.724929501
+RAC_ASM/racdb/datafile/user03.ora---------------------新建立的
+RAC_ASM/racdb/datafile/asm.ora------------------------新建立的
7 rows selected.
备库位置怎么是这里: /opt/oracle/oradata/standby/STANDBY/datafile/ , 多了一些 STANDBY/datafile ?
备库使用文件系统, SID : standby
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/opt/oracle/oradata/standby/system.277.724929393
/opt/oracle/oradata/standby/undotbs1.279.724929395
/opt/oracle/oradata/standby/sysaux.278.724929395
/opt/oracle/oradata/standby/users.280.724929395
/opt/oracle/oradata/standby/undotbs2.285.724929501
/opt/oracle/oradata/standby/STANDBY/datafile/o1_mf_users_64kxkhtz_.dbf---怎么在 standby/standby/datafile 下面?
/opt/oracle/oradata/standby/STANDBY/datafile/o1_mf_asm_64lnhtnd_.dbf-----怎么在 standby/standby/datafile 下面?
7 rows selected. |
|