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.

Hongfeng Sun : 09 Nov 2006 18:09 |  Tags: Oracle Oracle-Availability |  Comments (1) |  Trackbacks (1) |  Report a problem