RAC+DG重建备库时备库的online redolog没创建

最新推荐文章于 2024-06-07 16:36:50 发布

xiaoxiao树

最新推荐文章于 2024-06-07 16:36:50 发布

阅读量2.2k

点赞数

分类专栏： oracle rac oracle dg

本文链接：https://blog.csdn.net/u010719917/article/details/53409534

版权

oracle rac 同时被 2 个专栏收录

14 篇文章 0 订阅

订阅专栏

oracle dg

9 篇文章 0 订阅

订阅专栏

RAC+DG重建备库时备库的online redolog没创建

Errors in file /oracle/app/oracle/diag/rdbms/phyrac/rac1/trace/rac1_dbw0_15812.trc:
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: '+DATA/phyrac/datafile/q2_orders.279.928812061'
ORA-17503: ksfdopn:2 Failed to open file +DATA/phyrac/datafile/q2_orders.279.928812061
ORA-15012: ASM file '+DATA/phyrac/datafile/q2_orders.279.928812061' does not exist
MRP0: Background Media Recovery terminated with error 1110
Errors in file /oracle/app/oracle/diag/rdbms/phyrac/rac1/trace/rac1_mrp0_17708.trc:
ORA-01110: data file 10: '+DATA/phyrac/datafile/q2_orders.279.928812061'
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: '+DATA/phyrac/datafile/q2_orders.279.928812061'
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery process shutdown (rac1)

查过主库发现q2_orders文件是offline，但是在备库的asm上不有发现这个文件，在rman中重新restore 10 就正常了。

alter database recover managed standby database using current logfile disconnect from session;

备库的online redo log 就自动生成.