在 MaximumProtectionMode 下，当尝试将 Oracle 10g 备库切换到主库时遇到 ORA-16139 错误，通过在备库上开启日志应用即可解决。具体步骤包括：使用 SQL 命令 `ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION` 开启日志应用，然后再次执行 `ALTER DATABASE COMMIT TO SWITCH OVER TO PRIMARY` 切换操作，并最终执行 `ALTER DATABASE OPEN` 操作来完成数据库的重启。
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博客 ” ，链接：http://blog.itpub.net/29612462/viewspace-1144292/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/29612462/viewspace-1144292/
扫一扫
2213
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
