 | | | Subject: Re: Data Guard Delete Applied ArcLogs | Subject: Re: Data Guard Delete Applied ArcLogs 2007-10-31 - By David Barbour
Back
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@(protected)> 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@(protected) [mailto:
> oracle-l-bounce@(protected)] *On Behalf Of *David Barbour
> *Sent:* Wednesday, October 31, 2007 12:59 PM
> *To:* JApplewhite@(protected)
> *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@(protected) < JApplewhite@(protected)> 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
>
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?). <br><br><div><span class="gmail_quote">On 10/31/07, <b class=
"gmail_sendername">Elliott, Patrick</b> <<a href="mailto:patrick.elliott
@(protected)">patrick.elliott@(protected)</a>> wrote:</span><blockquote
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin:
0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2"
>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.</font></span></div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2"><
/font></span> </div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2"
>DELETE ARCHIVELOG UNTIL TIME = sysdate -1;
</font></span></div>
<div><font color="#0000ff" face="Arial" size="2"></font> </div>
<p><span lang="en-us"><font face="Magneto" size="6">Pat</font></span> </p>
<div> </div><br>
<div align="left" dir="ltr" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b> <a href="mailto:oracle-l-bounce
@(protected)" target="_blank" onclick="return top.js.OpenExtLink(window,event
,this)">oracle-l-bounce@(protected)</a>
[mailto:<a href="mailto:oracle-l-bounce@(protected)" target="_blank" onclick=
"return top.js.OpenExtLink(window,event,this)">oracle-l-bounce@(protected)</a>
] <b>On Behalf Of </b>David
Barbour<br><b>Sent:</b> Wednesday, October 31, 2007 12:59 PM<br><b>To:</b>
<a href="mailto:JApplewhite@(protected)" target="_blank" onclick="return top
.js.OpenExtLink(window,event,this)">JApplewhite@(protected)</a><br><b>Cc:</b>
oracle-l<br><b>Subject:</b> Re: Data
Guard Delete Applied ArcLogs<br></font><br></div><div><span class="e" id="q
_115f79e176e57d0c_1">
<div></div>Hi Jack,<br><br>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. <br><br>
<div><span class="gmail_quote">On 10/31/07, <b class="gmail_sendername"><a href
="mailto:JApplewhite@(protected)" target="_blank" onclick="return top.js
.OpenExtLink(window,event,this)">JApplewhite@(protected)</a></b> <
<a href="mailto:JApplewhite@(protected)" target="_blank" onclick="return top
.js.OpenExtLink(window,event,this)"> JApplewhite@(protected)</a>>
wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204
); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br><font face="sans-serif"
size="2">Oracle9i (<a href="http://9..2.0.8" target="_blank" onclick="return
top.js.OpenExtLink(window,event,this)">
9.2.0.8</a>) on HPUX.</font> <br><br><font face="sans-serif" size="2">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.</font> <br><br><font face="sans-serif" size="2">Will I just have to
cron a
script to periodically query V$Archived_Log and generate the rm
commands?</font> <br><br><font face="sans-serif" size="2">Thanks.<br></font>
<font face="Arial Unicode MS" size="1"><br>Jack C. Applewhite - Database
Administrator<br>Austin I.S.D.<br>414.9715 (phone) / 935.5929
(pager)<br></font></blockquote></div><br></span></div></div>
<table><tbody><tr><td bgcolor="#ffffff"><font color="#000000">__ ____ ____ ____
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
__<br>
CONFIDENTIALITY AND PRIVACY NOTICE<br>
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.<br>
<br>
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: <a href="http://emaildisclaimer.medtronic.com" target="_blank
" onclick="return top.js.OpenExtLink(window,event,this)">http://emaildisclaimer
.medtronic.com</a><br>
</font></td></tr></tbody></table></blockquote></div><br>
|
|
|