ORA-10485: Real-Time Query cannot be enabled while applying migration redo
情景：利用Dataguard滚动方式升级数据库后，备库应用redo报错：ORA-10485
MRP0: Background Media Recovery terminated with error 10485
Errors in file /home/u01/app/diag/rdbms/orcl11g/ORCL/trace/ORCL_pr00_1644.trc:
ORA-10485: Real-Time Query cannot be enabled while applying migration redo.
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
MRP0: Background Media Recovery process shutdown (ORCL)
[oracle@app scripts]$ 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
alter database recover managed standby database cancel;
alter database open;
alter database recover managed standby database using current logfile disconnect from session;
优质内容筛选与推荐>>1、字符串连接之“+”和append
2、POJ 1486
3、在线视频播放软件
4、[LeetCode] 56. Merge Intervals 合并区间
5、Socket and JSON