real time apply
Ora_83Aug 7 2011 — edited Aug 8 2011Hi
I know that if the real time apply is enabled, oracle will apply redo to standy database as soon as it is generated on primary database.
1-) Is there way to monitor this ? (applying the redo from standby redolog to standby database)
2-) Why do I see "Media recovery Log" message in standby alert log if the real time apply is enabled ?
I know that when I see "Media Recovery Log" entry in alert log, it means that the archivelog is being applied to standby database.
As far as I know, if the real time apply is enabled, oracle applies redo as soon as it is generated in primary database hence no need to apply archived log.
i.e:
Media Recovery Waiting for thread 1 sequence 14274 (in transit)
Sun Aug 07 10:17:23 2011
Archived Log entry 16969 added for thread 1 sequence 14274 rlc 733530159 ID 0x8af69bb9 dest 2:
RFS[1]: No standby redo logfiles of size 409600 blocks exist
RFS[1]: Opened log for thread 1 sequence 14275 dbid -1125040496 branch 733530159
Sun Aug 07 10:17:24 2011
*Media Recovery Log +DATA/orclprd/archivelog/2011_08_07/thread_1_seq_14274.1315.758542463*
Media Recovery Waiting for thread 1 sequence 14275 (in transit)