 | | | Subject: RE: Data Guard Delete Applied ArcLogs | Subject: RE: Data Guard Delete Applied ArcLogs 2007-11-01 - By Elliott, Patrick
Back
If you are worried about deleting unbacked up archive logs then just include
the clause "BACKED UP 1 TIME"
Pat
__ ____ ____ ____ ____ ____ ____
From: David Barbour [mailto:david.barbour1@(protected)]
Sent: Wednesday, October 31, 2007 4:09 PM
To: Elliott, Patrick
Cc: JApplewhite@(protected); oracle-l
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@(protected)<mailto: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)>
[mailto: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)<mailto: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)<mailto:JApplewhite@(protected)> <
JApplewhite@(protected)<mailto: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
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ______
__ ____ ____ ____ __
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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=502250412-01112007><FONT face=Arial
color=#0000ff size=2>If you are worried about deleting unbacked up archive logs
then just include the clause "BACKED UP 1 TIME"</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV><!-- Converted
from text/rtf format -->
<P><SPAN lang=en-us><FONT face=Magneto size=6>Pat</FONT></SPAN> </P>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV><FONT face=Magneto
size=6></FONT><FONT face=Magneto size=6></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> David Barbour
[mailto:david.barbour1@(protected)] <BR><B>Sent:</B> Wednesday, October 31, 2007
4:09 PM<BR><B>To:</B> Elliott, Patrick<BR><B>Cc:</B> JApplewhite@(protected);
oracle-l<BR><B>Subject:</B> Re: Data Guard Delete Applied
ArcLogs<BR></FONT><BR></DIV>
<DIV></DIV>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="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204
,204) 1px solid">
<DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Arial color=#0000ff 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 dir=ltr align=left><SPAN><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT face=Arial color=#0000ff size=2>DELETE
ARCHIVELOG UNTIL TIME = sysdate -1; </FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<P><SPAN lang=en-us><FONT face=Magneto size=6>Pat</FONT></SPAN> </P>
<DIV> </DIV><BR>
<DIV lang=en-us dir=ltr align=left>
<HR>
<FONT face=Tahoma size=2><B>From:</B> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:oracle-l-bounce@(protected)"
target=_blank>oracle-l-bounce@(protected)</A> [mailto:<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:oracle-l-bounce@(protected)"
target=_blank>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
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:JApplewhite@(protected)"
target=_blank>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
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:JApplewhite@(protected)"
target=_blank>JApplewhite@(protected)</A></B> < <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:JApplewhite@(protected)"
target=_blank>JApplewhite@(protected)</A>> wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204
,204) 1px solid"><BR><FONT
face=sans-serif size=2>Oracle9i (<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://9..2.0.8" target=_blank> 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
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://emaildisclaimer.medtronic.com"
target=_blank>http://emaildisclaimer.medtronic.com</A><BR></FONT></TD><
/TR></TBODY></TABLE></BLOCKQUOTE></DIV><BR></BODY></HTML>
<table><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: http
://emaildisclaimer.medtronic.com<br>
</font></td></tr></table>
|
|
|