重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-10485: Real-Time Query cannot be enabled while applying migration redo [打印本页]

作者: 王亮 时间: 2020-12-30 17:16
标题: ORA-10485: Real-Time Query cannot be enabled while applying migration redo
情景：oracle 11.2.0.1主备库升级，备库利用Dataguard滚动方式升级数据库后，备库应用redo报错：ORA-10485

Media Recovery Log /u01/app/arch_log/1_36_1060434137.dbf
MRP0: Background Media Recovery terminated with error 10485
Errors in file /u01/app/diag/rdbms/orcldg/orcl/trace/orcl_pr00_29156.trc:
ORA-10485: Real-Time Query cannot be enabled while applying migration redo.
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!

[oracle@orcl arch_log]$ oerr ora 10485
10485, 00000, "Real-Time Query cannot be enabled while applying migration redo."
// *Cause:  The Real-Time Query feature was enabled when an attempt was made
//       to recover through migration redo generated during primary upgrades or
//       downgrades.
// *Action: Close the standby database in order to recover through
//       migration redo. Reenable the Real-Time Query feature afterwards.

原因：在应用migration redo的时候不能开启实时查询(即，在主库进行升级时候，备库不能开启实时查询）

解决方法：

shutdown immediate;

startup mount;

alter database recover managed standby database disconnect from session;

--待migration redo 相关的日志应用了后再开启实时apply

当看到alert日志中出现类似Media Recovery Waiting for thread 1 sequence 60 (in transit),即可依次执行下面步骤。

alter database recover managed standby database cancel;

alter database open;

alter database recover managed standby database using current logfile disconnect from session;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)