报错信息:
select 'ERROR DG standby redolog transport delay 3600s',status,FIRST_TIME,LAST_TIME from v$standby_log
*
ERROR at line 1:
ORA-00308: cannot open archived log '+XXX_DATA01/xxx/standbyfile/stdredo80.log'
ORA-17503: ksfdopn:2 Failed to open file +XXX_DATA01/xxx/standbyfile/stdredo80.log
ORA-15173: entry 'stdredo80.log' does not exist in directory 'standbyfile'
分析:DG库
80 STANDBY
+XXX_DATA01/xxx/standbyfile/stdredo80.log --这个文件在asm磁盘中是没有的
处理办法:
alter database recover managed standby database cancel;
alter database drop logfile group 80;
alter database recover managed standby database disconnect from session parallel 12 using current logfile;