错误内容:DG失效
SQL> recover managed standby database;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 77 is unknown - rename to correct file
ORA-01110: data file 77: '/oracle/product/9.2.0/dbs/UNNAMED00077'
ORA-01157: cannot identify/lock data file 77 - see DBWR trace file
ORA-01111: name for data file 77 is unknown - rename to correct file
ORA-01110: data file 77: '/oracle/product/9.2.0/dbs/UNNAMED00077'
解决
1) alter system set standby_file_management=MANUAL
2) alter database create datafile '/u01/app/oracle/product/11.2.0.3/dbhome_1/dbs/UNNAMED00006' as ' /data/testdb/datafile/ ts_pub01.dbf';
3) alter system set standby_file_management=AUTO
recover managed standby database;
查看ALERT是否同步成功了
阅读(1547) | 评论(0) | 转发(0) |