DataGuard主备归档存在GAP解决
摘要
拷贝归档日志到从库,并进行注册
1 | sql> ALTER DATABASE REGISTER PHYSICAL LOGFILE '/data/oracle/archivelog/1_758_991156185.dbf'; |
重启主从
- 关闭
先关主库:
1 | sql> shutdown immediate |
再关从库:
1 | sql> alter database recover managed standby database cancel; #暂停日志应用 |
- 启动
先启备库:
1 | sql> startup nomount; |
再启主库
1 | sql> startup; |