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???
teched1000Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

catchmeifuwantCommented:
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?
0
teched1000Author Commented:
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;

0
catchmeifuwantCommented:
as the error doc clearly says enable tracing and re-run the query.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

schwertnerCommented:
Check if the Standby is running.
Check if the listener of the Standby is running and the alias is correct:
C:>tnsping 10 standby1
0
teched1000Author Commented:
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.

0
mjblakeCommented:
Just for grins, did you check to see that the file system that holds the archives has space avaiable?
0
schwertnerCommented:
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.
0
teched1000Author Commented:
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

0
teched1000Author Commented:
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
0
sdrozdCommented:
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).
0
teched1000Author Commented:
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
0
moduloCommented:
PAQed, with points refunded (250)

modulo
Community Support Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.