Solved

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

Posted on 2004-04-01
13
1,706 Views
Last Modified: 2013-12-11
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???
0
Comment
Question by:teched1000
  • 5
  • 2
  • 2
  • +3
13 Comments
 
LVL 12

Expert Comment

by:catchmeifuwant
ID: 10731104
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
 

Author Comment

by:teched1000
ID: 10731139
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
 
LVL 12

Expert Comment

by:catchmeifuwant
ID: 10731177
as the error doc clearly says enable tracing and re-run the query.
0
 
LVL 47

Expert Comment

by:schwertner
ID: 10731309
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
 

Author Comment

by:teched1000
ID: 10731441
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
 
LVL 1

Expert Comment

by:mjblake
ID: 10731908
Just for grins, did you check to see that the file system that holds the archives has space avaiable?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 47

Expert Comment

by:schwertner
ID: 10732294
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
 

Author Comment

by:teched1000
ID: 10732419
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
 

Author Comment

by:teched1000
ID: 10733482
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
 
LVL 2

Expert Comment

by:sdrozd
ID: 10733596
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
 

Author Comment

by:teched1000
ID: 10733624
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
 

Accepted Solution

by:
modulo earned 0 total points
ID: 10956823
PAQed, with points refunded (250)

modulo
Community Support Moderator
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now