当前位置： 移动技术网 > IT编程>数据库>Oracle > ORA-10485: Real-Time Query cannot be enabled while applying migration redo

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

2018年05月29日  | 移动技术网IT编程  | 我要评论

别担心 是女鬼,lzr种子,晋中干部培训网络学院

 

情景：利用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;

 

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网