< 2025年3月 >
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

主库
alter system switch logfile;

alter system set log_archive_dest_state_2='defer';

select switchover_status from v$database;

alter database commit to switchover to physical standby with session shutdown;

shutdown immediate;

startup mount;

alter database recover managed standby database disconnect;


备库
alter database recover managed standby database disconnect; 转换不需要cancel先停掉,防止报ORA-16139: media recovery required,可能是由于未应用日志引起,可先执行

select switchover_status from v$database;

alter database commit to switchover to primary with session shutdown;

alter database open;

alter system set log_archive_dest_state_2='enable';

 

posted on   馒头斋  阅读(738)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示