1. 备库停止redo应用:
alter database recover managed standby database cancel;
2. 主库重启:
shutdown immediate;
startup mount
3. 主库升级切换保护模式:
alter database set standby database to maximize availability;
(或者alter database set standby database to maximize protection;)
alter database open;
4. 备库启动redo应用:
alter database recover managed standby database disconnect from session;
降级切换步骤:
1. 备库停止redo应用:
alter database recover managed standby database cancel;
2. 主库调整保护模式:
alter database set standby database to maximize performance;
3. 备库启动redo应用:
alter database recover managed standby database disconnect from session;