This is a multi-part message in MIME format.
------_=_NextPart_001_01C64E90.02DCF01B
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
Yes I am setting up to try this out on another database.
=20
Regards
=20
Pete
-----Original Message-----
From: andrew.x.smith AT jpmchase DOT com [mailto:andrew.x.smith AT jpmchase DOT
com]
Sent: 23 March 2006 15:22
To: Hitchman, Peter (TS UK)
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Netbackup expiry of rman backups with =
infiniteretentionperiod
I don't have anywhere to test this, but my understanding is that this =
should do what ur after. Can u test on test box (as u have some issues =
with ur client name or something)?=20
<Peter.Hitchman AT thomson DOT com>=20
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu=20
23/03/2006 14:50=20
=20
To: <andrew.x.smith AT jpmchase DOT com>=20
cc: <veritas-bu AT mailman.eng.auburn DOT edu>=20
Subject: RE: [Veritas-bu] Netbackup expiry of rman =
backups with infinite retentionperiod
Hi,=20
Thanks, but I have done the rman "change ... delete ..." bit. What =
concerns me is that NB is not removing the backup images from tape.=20
=20
Regards=20
=20
Pete=20
-----Original Message-----
From: andrew.x.smith AT jpmchase DOT com [mailto:andrew.x.smith AT jpmchase DOT
com]
Sent: 23 March 2006 14:39
To: Hitchman, Peter (TS UK)
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Netbackup expiry of rman backups with infinite =
retentionperiod
Is this the command ur after?=20
The change ... delete command removes references to a backup piece, =
datafile copy, or archivelog from the control file and recovery catalog. =
It physically deletes the file. This command works with or without a =
recovery catalog.=20
<Peter.Hitchman AT thomson DOT com>=20
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu=20
23/03/2006 14:10=20
=20
To: <veritas-bu AT mailman.eng.auburn DOT edu>=20
cc: =20
Subject: [Veritas-bu] Netbackup expiry of rman backups =
with infinite retention period
Hi,
I have recently set-up some Oracle rman backups with Netbackup 4.5 on =
Solaris.
The retention period in the policy is set to infinite for both the =
automatic and application backup schedules. I wanted to check that =
Netbackup would clean up the backups when I obsolete them in rman. But =
having done the obsolete in rman I have found that Netbackup has not =
removed the backup images from the tapes, even though they are gone from =
the rman catalog. I tried running "bpimage -cleanup -client <name>" but =
the bpdbm log showed that nothing was removed.
There was an oddity with the Netbackup configuration on the client, when =
the original backup was made, the bp.conf contained the wrong client =
name. Could this be causing a problem, now that the client name has been =
changed?
Am I on the wrong track here? According to the manual when rman deletes =
a backup-piece Netbackup should get rid of it regardless of the =
retention period. Does anyone know of a way I can sort this out, so that =
when rman deletes the backup, Netbackup does as well?
Thanks
Pete
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
------_=_NextPart_001_01C64E90.02DCF01B
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D315013915-23032006><FONT face=3DArial color=3D#0000ff =
size=3D2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=3D315013915-23032006><FONT face=3DArial color=3D#0000ff =
size=3D2>Yes I=20
am setting up to try this out on another database.</FONT></SPAN></DIV>
<DIV><SPAN class=3D315013915-23032006><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D315013915-23032006><FONT face=3DArial color=3D#0000ff =
size=3D2>Regards</FONT></SPAN></DIV>
<DIV><SPAN class=3D315013915-23032006><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D315013915-23032006><FONT face=3DArial color=3D#0000ff =
size=3D2>Pete</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> =
andrew.x.smith AT jpmchase DOT com=20
[mailto:andrew.x.smith AT jpmchase DOT com]<BR><B>Sent:</B> 23 March 2006=20
15:22<BR><B>To:</B> Hitchman, Peter (TS UK)<BR><B>Cc:</B>=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> RE:
[Veritas-bu]=20
Netbackup expiry of rman backups with=20
infiniteretentionperiod<BR><BR></FONT></DIV><BR><FONT =
face=3Dsans-serif size=3D2>I=20
don't have anywhere to test this, but my understanding is that this =
should do=20
what ur after. Can u test on test box (as u have some issues with ur =
client=20
name or something)?</FONT> <BR><BR><BR><BR>
<TABLE width=3D"100%">
<TBODY>
<TR vAlign=3Dtop>
<TD>
<TD><FONT face=3Dsans-serif=20
size=3D1><B><Peter.Hitchman AT thomson DOT com></B></FONT> =
<BR><FONT=20
face=3Dsans-serif size=3D1>Sent by:=20
veritas-bu-admin AT mailman.eng.auburn DOT edu</FONT>=20
<P><FONT face=3Dsans-serif size=3D1>23/03/2006 14:50</FONT> =
<BR></P>
<TD><FONT face=3DArial size=3D1> =
</FONT><BR><FONT=20
face=3Dsans-serif size=3D1> To: =
=20
<andrew.x.smith AT jpmchase DOT com></FONT> =
<BR><FONT=20
face=3Dsans-serif size=3D1> cc: =
=20
<veritas-bu AT mailman.eng.auburn DOT edu></FONT> =
<BR><FONT=20
face=3Dsans-serif size=3D1> Subject: =
=20
RE: [Veritas-bu] Netbackup expiry of rman =
backups=20
with infinite =
retentionperiod</FONT></TR></TBODY></TABLE><BR><BR><BR><FONT=20
face=3DArial color=3Dblue size=3D2>Hi,</FONT> <BR><FONT face=3DArial =
color=3Dblue=20
size=3D2>Thanks, but I have done the rman "change ... delete ..." bit. =
What=20
concerns me is that NB is not removing the backup images from =
tape.</FONT>=20
<BR><FONT face=3D"Times New Roman" size=3D3> </FONT> <BR><FONT =
face=3DArial=20
color=3Dblue size=3D2>Regards</FONT> <BR><FONT face=3D"Times New =
Roman"=20
size=3D3> </FONT> <BR><FONT face=3DArial color=3Dblue =
size=3D2>Pete</FONT>=20
<BR><FONT face=3DTahoma size=3D2>-----Original =
Message-----<B><BR>From:</B>=20
andrew.x.smith AT jpmchase DOT com=20
[mailto:andrew.x.smith AT jpmchase DOT com]<B><BR>Sent:</B> 23 March 2006=20
14:39<B><BR>To:</B> Hitchman, Peter (TS UK)<B><BR>Cc:</B>=20
veritas-bu AT mailman.eng.auburn DOT edu<B><BR>Subject:</B> Re:
[Veritas-bu]=20
Netbackup expiry of rman backups with infinite=20
retentionperiod<BR></FONT><BR><FONT face=3Dsans-serif size=3D2><BR>Is =
this the=20
command ur after?</FONT><FONT face=3D"Times New Roman" size=3D3> =
<BR></FONT><FONT=20
face=3Dsans-serif size=3D2><BR>The change ... delete command removes =
references to=20
a backup piece, datafile copy, or archivelog from the control file and =
recovery catalog. It physically deletes the file. This command works =
with or=20
without a recovery catalog.</FONT><FONT face=3D"Times New Roman" =
size=3D3>=20
<BR><BR><BR><BR></FONT>
<TABLE width=3D"100%">
<TBODY>
<TR vAlign=3Dtop>
<TD width=3D"1%">
<TD width=3D"35%"><FONT face=3Dsans-serif=20
size=3D1><B><Peter.Hitchman AT thomson DOT com></B></FONT><FONT=20
face=3D"Times New Roman" size=3D3> </FONT><FONT =
face=3Dsans-serif=20
size=3D1><BR>Sent by: =
veritas-bu-admin AT mailman.eng.auburn DOT edu</FONT><FONT=20
face=3D"Times New Roman" size=3D3> </FONT>
<P><FONT face=3Dsans-serif size=3D1>23/03/2006 14:10</FONT><FONT =
face=3D"Times New Roman" size=3D3> </FONT></P>
<TD width=3D"62%"><FONT face=3DArial size=3D1> =
=20
</FONT><FONT face=3Dsans-serif size=3D1><BR> =
To:=20
=20
<veritas-bu AT mailman.eng.auburn DOT edu></FONT><FONT=20
face=3D"Times New Roman" size=3D3> </FONT><FONT =
face=3Dsans-serif=20
size=3D1><BR> cc: =
</FONT><FONT face=3D"Times New Roman" size=3D3> =
</FONT><FONT=20
face=3Dsans-serif size=3D1><BR> =
Subject: =20
[Veritas-bu] Netbackup expiry of rman =
backups with=20
infinite retention period</FONT></TR></TBODY></TABLE><BR><FONT=20
face=3D"Times New Roman" size=3D3><BR><BR></FONT><FONT face=3D"Courier =
New"=20
size=3D2><BR>Hi,<BR>I have recently set-up some Oracle rman backups =
with=20
Netbackup 4.5 on Solaris.<BR>The retention period in the policy is set =
to=20
infinite for both the automatic and application backup schedules. I =
wanted to=20
check that Netbackup would clean up the backups when I obsolete them =
in rman.=20
But having done the obsolete in rman I have found that Netbackup has =
not=20
removed the backup images from the tapes, even though they are gone =
from the=20
rman catalog. I tried running "bpimage -cleanup -client <name>" =
but the=20
bpdbm log showed that nothing was removed.<BR><BR>There was an oddity =
with the=20
Netbackup configuration on the client, when the original backup was =
made, the=20
bp.conf contained the wrong client name. Could this be causing a =
problem, now=20
that the client name has been changed?<BR><BR>Am I on the wrong track =
here?=20
According to the manual when rman deletes a backup-piece Netbackup =
should get=20
rid of it regardless of the retention period. Does anyone know of a =
way I can=20
sort this out, so that when rman deletes the backup, Netbackup does as =
=
well?<BR><BR>Thanks<BR><BR>Pete<BR><BR>__________________________________=
_____________<BR>Veritas-bu=20
maillist -=20
=
Veritas-bu AT mailman.eng.auburn DOT
edu<BR>http://mailman.eng.auburn.edu/=
mailman/listinfo/veritas-bu</FONT><FONT=20
face=3D"Times New Roman" =
size=3D3><BR><BR></FONT><BR><BR></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C64E90.02DCF01B--
|