oracle数据库切换DG步骤
注意:应用程序服务应该首先停止外部服务。
1.首先将主库切换到备用库,然后将原来的主库启动到物理库状态。
SQL>Alter database commit to switchover to physical standby with session shutdown;
2.关闭主库。
SQL>shutdown immediate;
3.打开数据库nomount
SQL>startup nomount;
4.将主库更改为备用库。
SQL>alter database mount standby database;SQL>alter database recover ***naged standby database disconnect from session;
如果配置了备用重做日志,并且需要启用实时同步,请执行以下代码
SQL>alter database recover ***naged standby database using current logfile disconnect from session;
5.将备用库切换到主库。
SQL>select switchover_status from v$database;SQL>select * from v$version where rownum<2;SQL>alter database commit to switchover to pri***ry with session shutdown;
如果备份库中仍有未使用的日志,则执行。
SQL>alter database recover ***naged standby database disconnect from session;SQL>shutdown immediate;SQL>startup;
切换日志进行检查。
SQL>select ***x(sequence#) from v$log;SQL>select sequence#,applied from v$archived_log;SQL>alter system switch logfile;
本文来自暮以随然投稿,不代表舒华文档立场,如若转载,请注明出处:https://www.chinashuhua.cn/24/535322.html