| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data Guard Delete Applied ArcLogs
Thanks to everyone. I decided to do something like what I used to do with
my 8i Standby - create and run a shell script every hour using the
following (called from a cron'd shell script). I know it'll produce error
messages for the logs already removed, but those get directed to
/dev/null.
Connect / As SysDBA
Spool rm_applied_arclogs_run.sh
Select 'rm ' || Name
From V$Archived_Log
Where Completion_Time > SysDate - 1
And Applied = 'YES'
Order By Sequence#
/
Spool Off
Exit
Jack C. Applewhite - Database Administrator
Austin I.S.D.
414.9715 (phone) / 935.5929 (pager)
"David Barbour" <david.barbour1_at_gmail.com>
10/31/2007 04:09 PM
To
"Elliott, Patrick" <patrick.elliott_at_medtronic.com>
cc
"JApplewhite_at_austinisd.org" <JApplewhite_at_austinisd.org>, oracle-l
<oracle-l_at_freelists.org>
Subject
Re: Data Guard Delete Applied ArcLogs
Hmmm....I'm using a catalog and don't think I'd want to do that. I think (from experience) if you're using a recovery catalog and run that command from the standby, you're going to risk deleting logs on the primary as well as potentially deleting logs that haven't been applied (what if your managed recovery process crashes for some reason?).
On 10/31/07, Elliott, Patrick <patrick.elliott_at_medtronic.com> wrote: You could just write an RMAN script to do it. Add the command below to delete the archivelogs up until yesterday. You can connect with nocatalog if you don't have an RMAN catalog.
DELETE ARCHIVELOG UNTIL TIME = sysdate -1; Pat
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of David Barbour
Sent: Wednesday, October 31, 2007 12:59 PM
To: JApplewhite_at_austinisd.org
Cc: oracle-l
Subject: Re: Data Guard Delete Applied ArcLogs
Hi Jack,
In 9i, unless you're backing up from the standby and specify delete all input(which has pitfalls and perils all its own), you're going to have to script something.
On 10/31/07, JApplewhite_at_austinisd.org < JApplewhite_at_austinisd.org> wrote:
Oracle9i ( 9.2.0.8) on HPUX.
Am I just missing it or is there no way to configure a Physical Standby and/or Data Guard Broker to automatically delete archived redo logs after they are successfully applied? I've searched the docs and can't find that it's possible. I also checked to see if RMan could do it - no luck.
Will I just have to cron a script to periodically query V$Archived_Log and generate the rm commands?
Thanks.
Jack C. Applewhite - Database Administrator
Austin I.S.D.
414.9715 (phone) / 935.5929 (pager)
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 31 2007 - 16:22:15 CDT
 |
 |