单实例搭建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