DataGuard主备归档存在GAP解决不忘初心 收录于 类别 DB Oracle 2019-03-14 2023-03-16 约 126 字 预计阅读 1 分钟 次阅读 条评论 目录 警告本文最后更新于 2023-03-16,文中内容可能已过时。摘要拷贝归档日志到从库,并进行注册1 2 sql> ALTER DATABASE REGISTER PHYSICAL LOGFILE '/data/oracle/archivelog/1_758_991156185.dbf'; sql> ALTER DATABASE REGISTER PHYSICAL LOGFILE '/data/oracle/archivelog/1_759_991156185.dbf'; 重启主从关闭先关主库:1 sql> shutdown immediate 再关从库:1 2 sql> alter database recover managed standby database cancel; #暂停日志应用 sql> shutdown immediate; 启动先启备库:1 2 3 4 sql> startup nomount; sql> alter database mount standby database; sQL> alter database open read only; sql> alter database recover managed standby database using current logfile disconnect from session; #启动实时应用 再启主库1 sql> startup; 相关内容OracleDataGuard-使用DuplicateDataGuard 日志传输模式Oracle DataGuard主库丢失归档日志后备库的RMAN增量恢复Oracle DataGuard主从切换Oracle11g DataGuard配置 赞赏支持 微信打赏 支付宝打赏Please enable JavaScript to view the comments powered by Waline.