[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2004-04-01
13
Medium Priority
?
1,752 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 48

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
 
LVL 48

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

649 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