RFS not receiving thread 2 logs Live db RAC DR db single instance
edited Nov 12, 2013 8:07PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 10 commentsAnswered ✓
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
0