RE: log_archive_dest_state_2
Date: Mon, 5 Oct 2009 13:49:27 -0400
Message-ID: <OFDC05E39E.61A8373E-ON85257646.0061CB3A-85257646.0061E92A_at_lnotes-gw.ent.nwie.net>
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]
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 05 2009 - 12:49:27 CDT