联系：手机/微信(+86 17813235971) QQ(107644445)
标题：ORA-10485: Real-Time Query cannot be enabled while applying migration redo.
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
对于数据库打psu和jvm patch之后,dg备库同步会出现类似ORA-10485: Real-Time Query cannot be enabled while applying migration redo.异常
Tue Aug 15 18:48:18 2023 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION Attempt to start background Managed Standby Recovery process (orcl) Tue Aug 15 18:48:18 2023 MRP0 started with pid=33, OS id=15486 MRP0: Background Managed Standby Recovery process started (orcl) started logmerger process Tue Aug 15 18:48:23 2023 Managed Standby Recovery starting Real Time Apply Parallel Media Recovery started with 80 slaves Waiting for all non-current ORLs to be archived... All non-current ORLs have been archived. Recovery of Online Redo Log: Thread 1 Group 10 Seq 106115 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/orcl/std_redo10.log Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION Tue Aug 15 18:49:50 2023 RFS[1]: Assigned to RFS process 16049 RFS[1]: Opened log for thread 1 sequence 106117 dbid 1490144467 branch 962363734 Tue Aug 15 18:49:50 2023 RFS[2]: Assigned to RFS process 16051 RFS[2]: Selected log 10 for thread 1 sequence 106115 dbid 1490144467 branch 962363734 Tue Aug 15 18:49:50 2023 RFS[3]: Assigned to RFS process 16053 RFS[3]: Opened log for thread 1 sequence 106116 dbid 1490144467 branch 962363734 Archived Log entry 106102 added for thread 1 sequence 106116 rlc 962363734 ID 0x58d223d3 dest 2: RFS[3]: Opened log for thread 1 sequence 106118 dbid 1490144467 branch 962363734 RFS[2]: Opened log for thread 1 sequence 106119 dbid 1490144467 branch 962363734 Tue Aug 15 18:49:50 2023 Archived Log entry 106103 added for thread 1 sequence 106115 ID 0x58d223d3 dest 1: Tue Aug 15 18:49:50 2023 Media Recovery Log /u01/app/oracle/fast_recovery_area/ORCLDG/archivelog/2023_08_15/o1_mf_1_106116_lfpp2ghc_.arc Errors with log /u01/app/oracle/fast_recovery_area/ORCLDG/archivelog/2023_08_15/o1_mf_1_106116_lfpp2ghc_.arc MRP0: Background Media Recovery terminated with error 10485 Errors in file /u01/app/oracle/diag/rdbms/orcldg/orcl/trace/orcl_pr00_15488.trc: ORA-10485: Real-Time Query cannot be enabled while applying migration redo. Managed Standby Recovery not using Real Time Apply Recovery interrupted! Tue Aug 15 18:49:50 2023 MRP0: Background Media Recovery process shutdown (orcl)
这种情况,是由于数据库在upgrade模式下产生日志无法正常被adg实时应用,我一般是临时rman应用备库日志解决,官方解决方案:MRP process getting terminated with error ORA-10485 (Doc ID 1618485.1)
11g CASE
---------
1> Stop DG broker (if used)
i.e., on primary and standby
SQL> alter system set dg_broker_start = false scope = both sid = '*' ;
2> Stop managed recovery in the standby, shutdown the standby and startup mount.
start managed recovery without real time apply.
SQL> alter database recover managed standby database disconnect ;
3> Wait until all the redo is applied to the standby and the standby is in sync.
Do a couple of log switches on the primary, all instances if RAC, and let them apply to the standby.
4> Shutdown the standby and startup mount
start managed recovery with real time apply.
SQL> alter database recover managed standby database using current logfile disconnect ;
5> Restart broker(if used).
on primary and standby
SQL> alter system set dg_broker_start = true scope = both sid = '*' ;
12c CASE
----------
In 12c and later, start Archived log apply using below command with ARCHIVED LOGFILE option:
SQL> alter database recover managed standby database using archived logfile disconnect;
Wait until all the redo is applied to the standby and the standby is in sync.
Do a couple of log switches on the primary, all instances if RAC, and let them apply to the standby.
To stop Redo Apply, Issue the following SQL statement:
SQL> alter database recover managed standby database cancel;
start managed recovery with real time apply, Issue the following SQL statement
SQL> alter database recover managed standby database disconnect;
