Some Archived logs on PRIMARY are not getting applied on STANDBY
Girish AJan 27 2008 — edited Jul 17 2008Hi,
We have a 2 node RAC with physical STANDBY.
I have seen that some of the archived logs on PRIMARY are not been applied on STANDBY.
Here is a output result on PRIMARY.
SEQU FIRST_TIME NEXT_TIME ARCH APP STAT
ENCE# IVED LIED US
910 01/26/2008 20:30:51 01/27/2008 07:30:37 YES NO A
1,096 01/26/2008 22:20:45 01/27/2008 06:00:01 YES YES A
1,097 01/27/2008 06:00:01 01/27/2008 08:27:55 YES NO A
911 01/27/2008 07:30:37 01/27/2008 08:28:29 YES YES A
1,098 01/27/2008 08:27:55 01/27/2008 08:28:04 YES NO A
1,099 01/27/2008 08:28:04 01/27/2008 08:28:09 YES YES A
1,100 01/27/2008 08:28:09 01/27/2008 08:28:59 YES NO A
912 01/27/2008 08:28:29 01/27/2008 08:51:11 YES NO A
1,101 01/27/2008 08:28:59 01/27/2008 08:29:09 YES YES A
1,102 01/27/2008 08:29:09 01/27/2008 09:03:18 YES NO A
913 01/27/2008 08:51:11 01/27/2008 08:51:13 YES YES A
1,103 01/27/2008 09:03:18 01/27/2008 09:47:01 YES NO A
But on STANDBY database it is showing that all are applied
SEQ FIRST_TIME NEXT_TIME APP
ENCE#
---------- --------- --------- ---
910 26-JAN-08 27-JAN-08 YES
911 27-JAN-08 27-JAN-08 YES
912 27-JAN-08 27-JAN-08 YES
913 27-JAN-08 27-JAN-08 YES
1096 26-JAN-08 27-JAN-08 YES
1097 27-JAN-08 27-JAN-08 YES
1098 27-JAN-08 27-JAN-08 YES
1099 27-JAN-08 27-JAN-08 YES
1100 27-JAN-08 27-JAN-08 YES
1101 27-JAN-08 27-JAN-08 YES
1102 27-JAN-08 27-JAN-08 NO
1103 27-JAN-08 27-JAN-08 NO
Also we got following error message on one node
Sun Jan 27 08:21:25 2008
ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16011)
ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
PING[ARC1]: Error 16011 when pinging standby GACL_DR.
Can anybody suggest me why it is not showing APPLIED on PRIMARY database as they are showing APPLIED on STANDBY database.
Thanks,
Girish A.