Skip to Main Content

Oracle Database Discussions

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!

Some Archived logs on PRIMARY are not getting applied on STANDBY

Girish AJan 27 2008 — edited Jul 17 2008
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2008
Added on Jan 27 2008
8 comments
1,469 views