Standby database, archive logs only get shipped once

From: Dave <david.best_at_gmail.com>
Date: 21 Feb 2005 12:59:48 -0800
Message-ID: <1109019588.829407.296750@g14g2000cwa.googlegroups.com>

Hey all,

 I have a TAR opened for this but I am curious if anyone has experienced the same problem.

For some reason, archive shipping to our standby server stopped on Friday. The error i'm getting is:

ORA-12154: TNS:could not resolve service name

Now I can tnsping the standby instance from both servers. If I do the following on the primary:
alter system set log_archive_dest_state_2=enable;

alter system archive log current;
alter system archive log current;
alter system archive log current;

alter system set log_archive_dest_state_2=enable; alter system archive log current;

On the standby, v$archived_log shows and those 2 archive logs get shipped.

SEQUENCE# APP
---------- ---

162382     NO
162385     NO

For the 2 other switches in the gap no errors are in the alert log but as soon as I did the second alter system set log_archive_dest_state_2=enable it generated a another TNS error and trace file.

Its curious to see it ship one archive log after I re-enable the destination state but then fail with TNS errors.

Any ideas? Received on Mon Feb 21 2005 - 14:59:48 CST