RE: log_archive_dest_state_2
- From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
- To: <TESTAJ3@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Oct 2009 12:44:03 -0500
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.
Other related posts:
