dategurd oracle_Oracle Dataguard 管理命令

原标题：Oracle Dataguard 管理命令

备份库切换

alter database commit to switchover to physical standby with session shutdown; //切换至standby模式

shutdown immediate

startup mount

select switchover_status from v$database; //检查状态

alter database recover managed standby database disconnect; //开启standby应用恢复模式

select switchover_status from v$database; //再检查状态

切换至主库

alter database commit to switchover to primary;

shutdown immediate

startup

select switchover_status from v$database;

select open_mode,database_role from v$database;

检查状态

select sequence#,applied from v$archived_log; //检查DG归档日志是否完成恢复

select open_mode,database_role,switchover_status from v$database; //备库状态

select protection_mode,protection_level from v$database; //检查DG的保护模式

应急切换Failover

alter database recover managed standby database finish; //停止应用恢复模式

alter database commit to switchover to primary; //转换standbydb为primary db

shutdown immediate

startup

select open_mode,database_role from v$database;

PS：failover将破坏dataguard模式,需要重新配置dataguard,听说可以不用重新配置,。

点击阅读原文可以进入社区Oracle主题，还有更多文章、资料及相关问答。返回搜狐，查看更多

责任编辑：