High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Log Recovery in Active Dataguard alert log

edited Feb 18, 2019 4:01AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered

Hi all,

I have a 11G Oracle Active Dataguard in maximum performance mode.

I notice this 2 main pattern of log recovery in the oracle  alert log

Pattern 1 ->

RFS[7]: Selected log 11 for thread 2 sequence xxxxxArchived Log entry xxxxx added for thread 2 sequence xxxxxMedia Recovery Log /frapool/STBY/archivelog/2019_02_07/o1_mf_2_xxxxx_g5pv57mj_.arc

Pattern 2 ->

RFS[3]: Selected log 12 for thread 2 sequence yyyyyMedia Recovery Waiting for thread 2 sequence yyyyy (in transit)Recovery of Online Redo Log: Thread 2 Group 12 Seq yyyyy Reading mem 0Archived Log entry yyyyy added for thread 2 sequence yyyyy

Pattern2 seems to perform recovery directly from the standby redolog (archiving come later),  while Pattern 1 seems to perform recovery from the archivelog ( archiving come 1st )

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center