dataguard自动与手动的创建数据文件

dataguard自动与手动的创建数据文件：
主库：
SQL> create tablespace test datafile  '/tmp/test.dbf' size 10M autoextend off;
Tablespace created.


搞错目录了，怎么办？删除吧
SQL> drop tablespace test including contents and datafiles;
Tablespace dropped.


可是上述的日志都需要传递到备库，然后执行，
由于设置了standby_file_management              string                 AUTO


备库：
参数设置为
standby_file_management    =    AUTO
db_file_name_convert  =  /u01/app/oracle/oradata/prod, /u01/app/oracle/oradata/stby1
又由于找不到对应的目录,所以无法创建对应的文件，


告警日志报错如下：
Errors in file /u01/app/oracle/diag/rdbms/stby1/stby1/trace/stby1_dbw0_3056.trc:
ORA-01186: file 6 failed verification tests
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01111: name for data file 6 is unknown - rename to correct file
ORA-01110: data file 6: '/u01/app/oracle/product/11g/dbs/UNNAMED00006'


此时备库怎么办？很简单
SQL> alter system set standby_file_management='manual';
System altered.
SQL> alter database create datafile 6 as '/tmp/test02.dbf';
Database altered.
SQL> alter system set standby_file_management='AUTO';
System altered.


此时主库再次尝试建立数据文件
SQL> create tablespace test datafile  '/u01/app/oracle/oradata/prod/test.dbf' size 10M autoextend off;
Tablespace created.


备库自动创建成功，告警日志信息如下：
Media Recovery Log /u01/app/oracle/oradata/stby1_log/1_32_874356072.dbf
Recovery deleting file #6:'/tmp/test02.dbf' from controlfile.
Deleted file /tmp/test02.dbf
Recovery dropped tablespace 'TEST'
Recovery created file /u01/app/oracle/oradata/stby1/test.dbf
Successfully added datafile 6 to media recovery
Datafile #6: '/u01/app/oracle/oradata/stby1/test.dbf'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/89196/viewspace-1463595/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/89196/viewspace-1463595/