A-A+
DG关于ASM目录同步的问题
DG关于ASM目录同步的问题
第一种：在sql*plus中使用sql创建目录，查看是否同步到备库
主库
SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- +DATA/racdb/system01.dbf +DATA/racdb/sysaux01.dbf +DATA/racdb/undotbs01.dbf +DATA/racdb/users01.dbf +DATA/racdb/undotbs02.dbf +DATA/racdb/datafile/yallonking.432.812066619 +DATA/racdb/yallonking_2.dbf 7 rows selected.
备库
SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/system01.dbf /u01/app/oracle/oradata/sysaux01.dbf /u01/app/oracle/oradata/undotbs01.dbf /u01/app/oracle/oradata/users01.dbf /u01/app/oracle/oradata/undotbs02.dbf /u01/app/oracle/oradata/datafile/yallonking.432.812066619 /u01/app/oracle/oradata/yallonking_2.dbf 7 rows selected.
主库操作
SQL> create tablespace cfca datafile '+DATA/racdb_p/yallonking_2.dbf' size 1m; create tablespace cfca datafile '+DATA/racdb_p/yallonking_2.dbf' size 1m * ERROR at line 1: ORA-01119: error in creating database file '+DATA/racdb_p/yallonking_2.dbf' ORA-17502: ksfdcre:4 Failed to create file +DATA/racdb_p/yallonking_2.dbf ORA-15173: entry 'racdb_p' does not exist in directory '/' SQL> alter diskgroup data add directory '+data/racdb_p'; Diskgroup altered. SQL> create tablespace cfca datafile '+DATA/racdb_p/yallonking_2.dbf' size 1m; Tablespace created. SQL> select name from v$datafile; NAME ------------------------------------------------------------------------------------------------------------------------------------ +DATA/racdb/system01.dbf +DATA/racdb/sysaux01.dbf +DATA/racdb/undotbs01.dbf +DATA/racdb/users01.dbf +DATA/racdb/undotbs02.dbf +DATA/racdb/datafile/yallonking.432.812066619 +DATA/racdb/yallonking_2.dbf +DATA/racdb_p/yallonking_2.dbf 8 rows selected.
备库查看
SQL> select name from v$datafile; NAME ------------------------------------------------------------------------------------------------------------------------------------ /u01/app/oracle/oradata/system01.dbf /u01/app/oracle/oradata/sysaux01.dbf /u01/app/oracle/oradata/undotbs01.dbf /u01/app/oracle/oradata/users01.dbf /u01/app/oracle/oradata/undotbs02.dbf /u01/app/oracle/oradata/datafile/yallonking.432.812066619 /u01/app/oracle/oradata/yallonking_2.dbf /u01/app/oracle/oradata_p/yallonking_2.dbf 8 rows selected.
注意：此处在主库通过sql创建的asm目录后，会自动同步到备库并在备库创建相关目录。
第二种：在ASM中使用ASMCMD命令创建目录，查看是否同步到备库
主库
SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- +DATA/racdb/system01.dbf +DATA/racdb/sysaux01.dbf +DATA/racdb/undotbs01.dbf +DATA/racdb/users01.dbf +DATA/racdb/undotbs02.dbf +DATA/racdb/datafile/yallonking.432.812066619 +DATA/racdb/yallonking_2.dbf 7 rows selected.
备库
SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/system01.dbf /u01/app/oracle/oradata/sysaux01.dbf /u01/app/oracle/oradata/undotbs01.dbf /u01/app/oracle/oradata/users01.dbf /u01/app/oracle/oradata/undotbs02.dbf /u01/app/oracle/oradata/datafile/yallonking.432.812066619 /u01/app/oracle/oradata/yallonking_2.dbf 7 rows selected.
主库操作
SQL> create tablespace cfca datafile '+DATA/racdb_p/yallonking_2.dbf' size 1m; create tablespace cfca datafile '+DATA/racdb_p/yallonking_2.dbf' size 1m * ERROR at line 1: ORA-01119: error in creating database file '+DATA/racdb_p/yallonking_2.dbf' ORA-17502: ksfdcre:4 Failed to create file +DATA/racdb_p/yallonking_2.dbf ORA-15173: entry 'racdb_p' does not exist in directory '/' [grid@11grac1 ~]$ asmcmd ASMCMD> ls DATA/ ASMCMD> cd data ASMCMD> ls RACDB/ racscan/ ASMCMD> pwd +data ASMCMD> mkdir racdb_p ASMCMD> ls RACDB/ racdb_p/ racscan/
此刻在主库继续之前的创建sql
SQL> / Tablespace created.
日志如下：
<msg time='2013-04-08T23:15:12.090+08:00' org_id='oracle' comp_id='rdbms' msg_id='opiexe:2994:4222364190' client_id='' type='NOTIFICATION' group='admin_ddl' level='16' host_id='11grac1' host_addr='192.168.137.161' module='sqlplus@11grac1 (TNS V1-V3)' pid='6524'> <txt>create tablespace cfca datafile '+DATA/racdb_p/yallonking_2.dbf' size 1m </txt> </msg> <msg time='2013-04-08T23:15:49.869+08:00' org_id='oracle' comp_id='rdbms' msg_id='opiexe:3065:2802784106' client_id='' type='NOTIFICATION' group='admin_ddl' level='16' host_id='11grac1' host_addr='192.168.137.161' module='sqlplus@11grac1 (TNS V1-V3)' pid='6524'> <txt>Completed: create tablespace cfca datafile '+DATA/racdb_p/yallonking_2.dbf' size 1m </txt> </msg>
查看主库新的文件
SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- +DATA/racdb/system01.dbf +DATA/racdb/sysaux01.dbf +DATA/racdb/undotbs01.dbf +DATA/racdb/users01.dbf +DATA/racdb/undotbs02.dbf +DATA/racdb/datafile/yallonking.432.812066619 +DATA/racdb/yallonking_2.dbf +DATA/racdb_p/yallonking_2.dbf 8 rows selected.
主库切换日志后查看备库
备库查看
SQL> select name from v$datafile; NAME ------------------------------------------------------------------------------------------------------------------------------------ /u01/app/oracle/oradata/system01.dbf /u01/app/oracle/oradata/sysaux01.dbf /u01/app/oracle/oradata/undotbs01.dbf /u01/app/oracle/oradata/users01.dbf /u01/app/oracle/oradata/undotbs02.dbf /u01/app/oracle/oradata/datafile/yallonking.432.812066619 /u01/app/oracle/oradata/yallonking_2.dbf /u01/app/oracle/oradata_p/yallonking_2.dbf 8 rows selected.
注意：此处在主库通过ASMCMD创建的asm目录后，也会自动同步到备库并在备库创建相关目录。
小结：无论在主库是从sql*plus命令行用sql还是在ASMCMD命令行用命令创建的目录，都会同步到备库。
