Recovery Slave PR00 previously exited with exception 10459

最新推荐文章于 2024-05-30 22:33:46 发布

huangliang0703

最新推荐文章于 2024-05-30 22:33:46 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： RAC

本文链接：https://blog.youkuaiyun.com/huangliang0703/article/details/82910299

RAC 专栏收录该内容

21 篇文章

订阅专栏

本文记录了在单实例搭建RAC备库时遇到的ORA-10459错误，详细解释了错误原因及解决步骤。通过关闭冲突实例，成功避免了备库启动时的媒体恢复冲突。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

单实例搭建RAC 备库，备库的两个节点都mount后，启动日志应用，报下下面的错误：

alter database recover managed standby database using current logfile disconnect;

Errors in file /oracle/database/diag/rdbms/bpmrac/bpmrac01/trace/bpmrac01_pr00_54583.trc:
ORA-10459: cannot start media recovery on standby database; conflicting state detected
Managed Standby Recovery not using Real Time Apply
Recovery Slave PR00 previously exited with exception 10459
MRP0: Background Media Recovery process shutdown (bpmrac01)

查看该错误的解释：

-bash: ora: command not found
[oracle@bpmrac01 trace]$ oerr ora 10459
10459, 00000, "cannot start media recovery on standby database; conflicting state detected"
// *Cause:  An attempt was made to perform media recovery on a standby
//          database while another instance was performing recovery on
//          the standby database, had the standby database open, or a data file
//          move operation was in progress.
// *Action: Close the standby on all other instances, cancel any conflicting
//          recovery session or data file move operation, and perform manual
//          recovery.
//

从解释中看到关闭其他实例的字眼，这样情况是不是备库只能启动一个实例呢？那就把另外一个节点关闭，在启动日志应用进进程，发现没有报错了

srvctl stop  instance -d bpmrac   -i  bpmrac02