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.