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;