dataguard dubugs

最新推荐文章于 2025-09-06 09:33:29 发布

weixin_34151004

最新推荐文章于 2025-09-06 09:33:29 发布

阅读量44

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/ruiy/p/4257715.html

本文记录了在Oracle Dataguard环境中遇到的问题及解决过程：尝试将备用数据库设置为只读模式时出现错误ORA-10456，并在进行媒体恢复时遇到不兼容的恢复操作导致ORA-01153错误。文中提供了具体的SQL命令及错误信息。

dataguard dubugs

alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-10456: cannot open standby database; media recovery session may be in
progress

SQL> alter database recover managed standby database using current logfile disconnect from session;
alter database recover managed standby database using current logfile disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active