ORA-10485: Real-Time Query cannot be enabled while applying migration redo

jiawang

现象：利用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

登录/注册后可看大图