Re: log_archive_dest_state_2

2009/10/5 <TESTAJ3_at_nationwide.com>

>
> 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 <oracle-l-bounce_at_freelists.org>
> ] *On Behalf Of *TESTAJ3_at_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_at_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_at_freelists.org* <oracle-l-bounce_at_freelists.org>] *On
> Behalf Of *TESTAJ3_at_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.credit-suisse.com/legal/en/disclaimer_email_ib.html>
>
> ==============================================================================
>
>

-- 
Howard A. Latham

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