primary 主库switchover to physical standby
SQL> alter database commit to switchover to physical standby with session shutdown;
主库关闭
SQL> shutdown immediate
主库重启到mount状态
SQL> startup nomount;
SQL> alter database mount standby database;
备库确保应用完日志
SQL> recover database managed standby database disconnect from session;
standby 备库switchover to primary
SQL> alter database commit to switchover to primary with session shutdown;
SQL> alter database open;
原来的主库,现在的备库打开日志应用
SQL> alter database recover managed standby database disconnect from session;
情况2:如果主库因为故障down了,现在要将备库转化为主库。
对备库操作:
alter database activate standby database;
select status from v$instance;
STATUS
------------
STARTED
startup force;