Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

real time apply

Ora_83Aug 7 2011 — edited Aug 8 2011
Hi

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)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2011
Added on Aug 7 2011
4 comments
544 views