RE: Data Guard Delete Applied ArcLogs
- From: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
- To: "david.barbour1@xxxxxxxxx" <david.barbour1@xxxxxxxxx>, "JApplewhite@xxxxxxxxxxxxx" <JApplewhite@xxxxxxxxxxxxx>
- Date: Wed, 31 Oct 2007 14:50:01 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of David Barbour
Sent: Wednesday, October 31, 2007 12:59 PM
To: JApplewhite@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx<mailto:JApplewhite@xxxxxxxxxxxxx> <
JApplewhite@xxxxxxxxxxxxx<mailto:JApplewhite@xxxxxxxxxxxxx>> wrote:
Oracle9i (9.2.0.8<http://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)
___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is
intended for use only by the individual or entity to which it is addressed, and
may contain information that is private, privileged, confidential or exempt
from disclosure under applicable law. If you are not the intended recipient or
it appears that this mail has been forwarded to you without proper authority,
you are notified that any use or dissemination of this information in any
manner is strictly prohibited. In such cases, please delete this mail from your
records.
To view this notice in other languages you can either select the following link
or manually copy and paste the link into the address bar of a web browser:
http://emaildisclaimer.medtronic.com
Other related posts:
