I got ” ORA-10485: Real-Time Query cannot be enabled while applying migration redo ” error in the Oracle dataguard.
ORA-10485: Real-Time Query cannot be enabled while applying migration redo
Details of error are as follows.
Stopping change tracking 2022-02-04T00:15:08.730266+03:00 Errors in file /u01/app/oracle/diag/rdbms/msdbdr/MSDBDR2/trace/MSDBDR2_pr00_343500.trc: ORA-10485: Real-Time Query cannot be enabled while applying migration redo. 2022-02-04T00:15:08.758519+03:00 Background Media Recovery process shutdown (MSDBDR2)
This ORA-10485 error is related with the Real-Time Query feature was enabled when an attempt was made to recover through migration redo generated during primary upgrades or downgrades.
This error is occured when I apply the Latest Patchset of Oracle ( PSU 14 ).
To solve this error, Stop managed recovery in the standby as follows.
SQL> alter database recover managed standby database cancel;
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.shutdown the standby and startup mount if the Standby is RAC, shutdown all instances of Standby as follows.
$ srvctl stop database -d MSDBDR
Then startup one instance in mount mode and start managed recovery without real time apply.
SQL> startup mount; SQL> alter database recover managed standby database using current logfile disconnect ;