备库
alter database commit to switchover to primary;
media recovery required
--如果报ORA-16139: media recovery required,可能是由于未应用日志引起,可先执行
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
然后再执行该命令
2022-10-22 21:13:19
备库
alter database commit to switchover to primary;
media recovery required
--如果报ORA-16139: media recovery required,可能是由于未应用日志引起,可先执行
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
然后再执行该命令