asked on

ORA-12571 error primary database not sending archive logs across?

Hi there everyone,

I have two 8.1.7.4 databases on win 2k server's, one is the primary and one is the standby.

Now everything was working fine and then I think a log got passed across when either the standby's server was down or it was in open mode. Now when I try and send a log across I get a

ORA-12571: TNS: packet writer failure error

I have tried

Svrgrl:> alter system set log_archive_dest_state_4=enable;

but I am still getting the same error.

The archive section in the primary's init file looks like.

log_archive_start = true
log_archive_min_succeed_dest = 2
log_archive_dest_1 = "location=D:\Oracle\oradata\primary\archive"
log_archive_dest_2 = "location=D:\Oracle\oradata\primary\archive2"
log_archive_dest_3 = "location=G:\Oracle\oradata\standby\tr2archive"
log_archive_dest_4 = 'SERVICE=STANDBY1 OPTIONAL REOPEN=60'
log_archive_dest_state_4= ENABLE
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

Any ideas???

catchmeifuwant

From Oracle Docs:
----------------

TNS-12571 TNS:packet writer failure

Cause: An error occurred during a data send. This message is not normally visible to the user.

In addition, this message could occur when any of the following SQL*Plus commands have been issued:

SHUTDOWN ABORT
SHUTDOWN IMMEDIATE
SHUTDOWN TRANSACTIONAL
Action: For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Support Services.

-----------------

Did you check if the standby server is up & running?

teched1000

ASKER

Hi there catchmeifuwant,

Thanks for the quick reply

Yep the standby database is up and in managed recover mode.

The ORA-12571: TNS: packet writer failure error

is when I run this query

SELECT dest_id "ID",
status "DB_status",
destination "Archive_dest",
error "Error"
From v$archive_dest;

catchmeifuwant

as the error doc clearly says enable tracing and re-run the query.

schwertner

Check if the Standby is running.
Check if the listener of the Standby is running and the alias is correct:
C:>tnsping 10 standby1

teched1000

ASKER

Hi again,

The tnsping standby1 10 worked fine from the primary database.

I have turned on tracing by doing

alter system set oracle_trace_enable = true;

and also the archive tracing by

ALTER SYSTEM SET LOG_ARCHIVE_TRACE=31;

I also pushed a log through to see if a error came up on the trace.

alter system archive log current;

The trace is as follows:

*** SESSION ID:(16.18887) 2004-04-01 13:16:27.910
*** 2004-04-01 13:16:27.910
ARCH: Begin archiving log# 3 seq# 567 thrd# 1
ARCH: VALIDATE
ARCH: PREPARE
ARCH: INITIALIZE
ARCH: SPOOL
ARCH: Creating archive destination 3 : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Creating archive destination 2 : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Creating archive destination 1 : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 1 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 1 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 1 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 513 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 513 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 513 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 1025 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 1025 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 1025 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 1537 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 1537 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 1537 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 2049 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 2049 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 2049 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 2561 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 2561 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 2561 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 3073 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 3073 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 3073 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 3585 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 3585 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 3585 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 4097 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 4097 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 4097 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 4609 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 4609 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 4609 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 5121 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 5121 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 5121 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 5633 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 5633 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 5633 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 6145 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 6145 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 6145 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 6657 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 6657 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 6657 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 7169 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 7169 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 7169 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 7681 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 7681 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 7681 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 8193 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 8193 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 8193 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 8705 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 8705 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 8705 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 9217 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 9217 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 9217 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 9729 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 9729 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 9729 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 10241 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 10241 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 10241 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 10753 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 10753 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 10753 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 11265 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 11265 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 11265 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 11777 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 11777 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 11777 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 12289 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 12289 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 12289 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 12801 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 12801 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 12801 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 13313 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 13313 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 13313 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 13825 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 13825 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 13825 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 14337 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 14337 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 14337 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 14849 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 14849 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 14849 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 15361 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 15361 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 15361 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 15873 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 15873 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 15873 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 16385 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 16385 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 16385 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 16897 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 16897 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 16897 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 17409 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 17409 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 17409 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 17921 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 17921 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 17921 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 18433 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 18433 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 18433 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 18945 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 18945 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 18945 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 19457 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 19457 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 19457 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 19969 count 512 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 19969 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 19969 count 512 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 20481 count 207 to : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archiving block 20481 count 207 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archiving block 20481 count 207 to : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Closing archive destination 3 : G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC
ARCH: Closing archive destination 2 : D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC
ARCH: Closing archive destination 1 : D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC
ARCH: FINISH
ARCH: Archival success destination 3 : 'G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC'
ARCH: Archival success destination 2 : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC'
ARCH: Archival success destination 1 : 'D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC'
ARCH: COMPLETE, all destinations archived
ARCH: ArchivedLog entry added: D:\ORACLE\ORADATA\PRIMARY\ARCHIVE\PRIMARYT001S00567.ARC
ARCH: ArchivedLog entry added: D:\ORACLE\ORADATA\PRIMARY\ARCHIVE2\PRIMARYT001S00567.ARC
ARCH: ArchivedLog entry added: G:\ORACLE\ORADATA\STANDBY1\PRIMARYARCHIVE\PRIMARYT001S00567.ARC
ARCH: ARCHIVED
*** 2004-04-01 13:16:32.113
ARCH: Completed archiving log# 3 seq# 567 thrd# 1

It looks as if it is not even attemping to archive to it.

mjblake

Just for grins, did you check to see that the file system that holds the archives has space avaiable?

schwertner

Look in the alert logs of both systems.
Every failed attempt to transfer archive log has to be recorded there.
May be you have no disk space, investigate the archive log destination.

teched1000

ASKER

Hi everyone,

Both server have more than 3 gig free on the drives where the databases are held.

log_archive_dest_3 = "location=G:\Oracle\oradata\standby\tr2archive"

G:\ is the standby databases c:\

The standby database is not receiving anything so there is nothing in the trc and log files.

When I attemp to do a

alter system archive log current;

It does not recognise that there is a forth destination and so does not appear in the trace file as a error.

I may swop the destination around to see if I can get the service to work at destination 3, will let you know what the results as

teched1000

ASKER

Found this on metalink:

When you remotely archive to a standby database the arch process on the primary creates a "session" with the RFS process on the standby. If you bounce the standby or place it into read only mode then the "session" with the RFS process is killed. When the primary attempts the next remote archival it tries to use the same session that it once held with the RFS process. Since that session is gone the primary archive destination recieves either a ORA-3113 or ORA-12571. Once the destination recieves the error then it will remain closed until the time specified by the reopen attribute expires and a log switch occurs. If you would like to open the destination prior to reopen time period you can simply enable the destination like:

alter system set log_archive_dest_state_2=enable;

This behavior does not exit in 9i.

Then did a

alter system set log_archive_dest_4 = 'SERVICE=STANDBY1 OPTIONAL REOPEN=60'

and it kicked it back into valid.

Thanks for all your contributions

Eddy

sdrozd

Did you try to restart both databases? If you didn't try this just in case, but make sure you bring up standby up first. Restarting the listener is also a good idea.
Also, are you using the correct init.ora file for the primary?
If nothing helps consider recreating control files on both sides (noresetlog option for the primary).

teched1000

ASKER

Sorry sdrozd,

I didn't make myself clear that the problem has not been solved. This solved it

alter system set log_archive_dest_4 = 'SERVICE=STANDBY1 OPTIONAL REOPEN=60'

Thanks for your suggestion.

Eddy

ASKER CERTIFIED SOLUTION

modulo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial