1.备库执行select thread#,sequence#,first_time,next_time,applied from v$archived_log where applied='NO';查看是否有日志没被应用
2.若存在,则关闭adg规则:
主库上:shutdown immediate
备库上:alter database recover managed standby database cancel;
备库上:shutdown immediate
3.备库应用日志:
执行startup mount;
执行alter database archivelog;
执行shutdown immediate
4.启动主备库:
备库执行:startup nomount
alter database mount standby database;
alter database open;
alter database recover managed standby database using current logfile disconnect from session;
主库执行:startup
alter system switch logfile;
ADG主库resolved gap手动解决方法
于 2023-09-15 09:59:28 首次发布