November 09, 2006

Force Oracle primary DB to reset connection to logical standby

This morning the network between a hot-standby Oracle database was broken. After the connection was resume, the primary database still complained that it cannot connect to logical standby db.

ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (1041)
ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
PING[ARC1]: Error 1041 when pinging standby

I can manually connect to standby db.
I have came across this problem before and believe that primary ARCH keep a persistent connection to standby and wont notice a broken connection was assumed.

Last time I was luck to get a chance to restart the primary db and fixed the problem.

I digged around metalink and found that it is a bug (Bug No. 5344954) and there is a workaround

 SQL> alter system set log_archive_dest_state_n=defer;
SQL> alter system set log_archive_dest_state_n=enable;

It then strikes me that I had done the same thing at another occasion and just forgot it.

Always good to take a note.

- One comment Not publicly viewable

  1. Mauriel Rosero

    Tnx this was great for me same problem happend and solved thanks alot

    23 Jan 2007, 02:42

Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

Search Warwick Blogs



Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder