Re: log_archive_dest_state_2

I'd be interested in seeing the steps you go thru to get it to switch from log dest 2 back to log dest 1. I set this up a while back and could get it to switch from 1 to 2 to 3.. but getting it to start back at 1 required quite a significant bit of magic that I don't remember at the moment. But, it wasn't particularly easy or clean.

John




________________________________
From: "TESTAJ3_at_nationwide.com" <TESTAJ3_at_nationwide.com>
To: "Baumgartel, Paul" <paul.baumgartel_at_credit-suisse.com>
Cc: oracle-l_at_freelists.org
Sent: Mon, October 5, 2009 1:09:02 PM
Subject: 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_at_credit-suisse.com>  
To:  <TESTAJ3_at_nationwide.com>  
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_at_credit-suisse.com
www.credit-suisse.com 
  


________________________________
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of TESTAJ3@nationwide.com
Sent: Monday, October 05, 2009 1:49 PM
To: Newman, Christopher
Cc: oracle-l_at_freelists.org
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_at_uillinois.edu>  
To:  <TESTAJ3_at_nationwide.com>, <oracle-l@freelists.org>  
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_at_freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of TESTAJ3@nationwide.com
Sent: Monday, October 05, 2009 12:25 PM
To: oracle-l_at_freelists.org
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
============================================================================== 


      

--
http://www.freelists.org/webpage/oracle-l