Very interesting - will try it! 2009/10/5 <TESTAJ3@xxxxxxxxxxxxxx> > > 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 <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* <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*<http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html> > > ============================================================================== > > -- Howard A. Latham