DB VERSION : 11.2.0.4
>> Pre-production Activity
Recently Database has been upgraded from 11.2.0.1 to 11.2.0.4.
then i have changed timezone vale on Primary database (from 11 to 14)
After that MRP is not running on standby server.
MRP is going down , if i enable MRP on Standby server.
>> On Primary database
SYS> select TZ_VERSION from registry$database;
TZ_VERSION
----------
14
SYS> SELECT version FROM v$timezone_file;
VERSION
----------
14
>> Alert log of Standby database
Wed Oct 12 17:44:25 2016
alter database recover managed standby database using current logfile disconnect from session
Attempt to start background Managed Standby Recovery process (stbycrms)
Wed Oct 12 17:44:25 2016
MRP0 started with pid=28, OS id=3125
MRP0: Background Managed Standby Recovery process started (stbycrms)
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_10_12/o1_mf_1_250_czvml2m1_.arc
MRP0: Background Media Recovery terminated with error 10485
Errors in file /u01/app/oracle/diag/rdbms/stbycrms/stbycrms/trace/stbycrms_mrp0_3125.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 (stbycrms)
Completed: alter database recover managed standby database using current logfile disconnect from session
>> On Standby database
SQL> SELECT version FROM v$timezone_file;
VERSION
----------
11
SQL> select TZ_VERSION from registry$database;
TZ_VERSION
----------
11
Thanks ..