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

MOSC Banner

RFS not receiving thread 2 logs Live db RAC DR db single instance


Hallo!I have 11.2.0.3 RAC db on AIX 7.1.I am trying to build a DR site by  RMAN duplicate command.I succesfully created the DR db but RFS doesnt seem to work.When I ship a log from PROD RAC RFS seems to be picking only archive logs of thread one (instance 1) but not instance 2 so I suspect that is why MRP0 isnt applying the archivelogs.

From query below

SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS,DELAY_MINS FROM V$MANAGED_STANDBY;
Sample output is as below
RFS    IDLE    0    0    0    0    0
RFS    IDLE    1    2964    2447    1    0
RFS    IDLE    0    0    0    0    0
MRP0    WAIT_FOR_LOG    2    3159    0    0    0

The alert log of DR db during logsiwtch is as below

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center