重庆思庄Oracle、Redhat认证学习论坛
标题: ORA-10485: Real-Time Query cannot be enabled while applying migration redo [打印本页]
作者: jiawang 时间: 2019-5-9 16:47
标题: ORA-10485: Real-Time Query cannot be enabled while applying migration redo
本帖最后由 jiawang 于 2019-5-9 23:32 编辑
现象：利用Dataguard滚动方式升级数据库后，备库应用redo报错：ORA-10485 Thu May 09 10:33:52 2019
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 48 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log +DGDATA/orcldg/archivelog/2019_04_23/thread_1_seq_19370.4000.1006375899
MRP0: Background Media Recovery terminated with error 10485
Errors in file /u01/app/oracle/diag/rdbms/orcldg/orcl1/trace/orcl1_pr00_26794.trc:
ORA-10485: Real-Time Query cannot be enabled while applying migration redo.
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Completed: alter database recover managed standby database using current logfile disconnect from session
MRP0: Background Media Recovery process shutdown (orcl1)
原因：是由于主库升级过程中生成了多个归档日志，还没有在备库上做应用，当备库执行开启实时应用命令时，便会出现数据不一致的情况，继而导致报错。
解决方法：
shutdown immediate;
startup mount;
alter database recover managed standby database disconnect from session;
待migration redo 相关的日志应用了后再开启实时apply
