oracle 10g dataguard备库切换时，ORA-16139错误的解决办法
oracle 10g dataguard备库切换时，ORA-16139错误的解决办法
Maximum Protection Mode下，将备库切换到主库报错：
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-16139: media recovery required
解决办法，只需在备库上开启日志应用即可：
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
Database altered.
SQL> alter database open;
Database altered.
SQL>
Maximum Protection Mode下，将备库切换到主库报错：
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-16139: media recovery required
解决办法，只需在备库上开启日志应用即可：
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
Database altered.
SQL> alter database open;
Database altered.
SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29612462/viewspace-1144292/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
