情景:利用Dataguard滾動方式升級資料庫後,備庫應用redo報錯:ORA-10485 MRP0: Background Media Recovery terminated with error 10485Errors in file /home/u01/app/diag/rdbms/orcl1 ...
情景:利用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;