RE: log_archive_dest_state_2

Ok oracle people, here is what I did in oracle 11.1.0.7 on linux:

Your init.ora:

log_archive_dest_2='location=/u02/arch'
log_archive_dest_state_2=alternate
log_archive_dest_1='location=+FLASHAREA reopen=1 max_failure=1 
alternate=log_archive_dest_2'
log_archive_dest_1_state='enable'

What i saw happen was once the archiver got stuck, it automatically 
started writing to the alternate place.

This has been around since 9i i believe.

your mileage may vary :)

joe

PS: to switch back, just enable dest_1 and make dest_2 alternate again.

_______________________________________
Joe Testa, Oracle Certified Professional 
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.




From:
"Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
To:
<TESTAJ3@xxxxxxxxxxxxxx>
Date:
10/05/2009 01:54 PM
Subject:
RE: log_archive_dest_state_2



I'd like to know the specifics, please!
 
Thanks,
 
Paul Baumgartel 
CREDIT SUISSE 
Information Technology 
Prime Services Databases Americas 
One Madison Avenue 
New York, NY 10010 
USA 
Phone 212.538.1143 
paul.baumgartel@xxxxxxxxxxxxxxxxx 
www.credit-suisse.com 
 

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
On Behalf Of TESTAJ3@xxxxxxxxxxxxxx
Sent: Monday, October 05, 2009 1:49 PM
To: Newman, Christopher
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: log_archive_dest_state_2


Nevermind, i got it working as an overflow device, it works beautifully. I 
set up a primary destination, setup an alternate destinatoipn and when 
primary got full, it started writing to optional automatically. 

Not sure if anyone cares, but let me know and I'll post the specifics. 

joe 

_______________________________________
Joe Testa, Oracle Certified Professional 
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.



From: 
"Newman, Christopher" <cjnewman@xxxxxxxxxxxxx> 
To: 
<TESTAJ3@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx> 
Date: 
10/05/2009 01:44 PM 
Subject: 
RE: log_archive_dest_state_2




Hi Joe, 
  
The secondary location isn’t an ‘overflow’ one; it gets written to 
concurrently  with the primary.  If you are having space issues, a good 
option is to run rman archivelog backup periodically to backup the files 
and move them someplace else.  Make sure to ‘delete input’ or ‘delete all 
input’ depending on your need to keep one or both of your archival 
locations cleaned up. 
  
-       Chris 
  
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
On Behalf Of TESTAJ3@xxxxxxxxxxxxxx
Sent: Monday, October 05, 2009 12:25 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: log_archive_dest_state_2 
  

Ok so i'm trying to setup a process so we have an alternate location to 
write out archive logs.  It appears the log_archive_dest_state_2 with an 
option of alternate would fit the bill.  No matter what I do, the primary 
destination( on local filesystem on the server), once it fills up, then 
the archiver just hangs.  Am i thinking incorrectly in how this should 
work? 

linux, 11.1.0.7. 


thanks, joe 

_______________________________________
Joe Testa, Oracle Certified Professional 
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus. 

==============================================================================
Please access the attached hyperlink for an important electronic 
communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================



Other related posts: