This is a multipart message in MIME format.
--=_alternative 00546CE48025713A_=
Content-Type: text/plain; charset="us-ascii"
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)?
<Peter.Hitchman AT thomson DOT com>
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu
23/03/2006 14:50
To: <andrew.x.smith AT jpmchase DOT com>
cc: <veritas-bu AT mailman.eng.auburn DOT edu>
Subject: RE: [Veritas-bu] Netbackup expiry of rman backups with
infinite
retentionperiod
Hi,
Thanks, but I have done the rman "change ... delete ..." bit. What
concerns me is that NB is not removing the backup images from tape.
Regards
Pete
-----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?
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.
<Peter.Hitchman AT thomson DOT com>
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu
23/03/2006 14:10
To: <veritas-bu AT mailman.eng.auburn DOT edu>
cc:
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
--=_alternative 00546CE48025713A_=
Content-Type: text/html; charset="us-ascii"
<br><font size=2 face="sans-serif">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)?</font>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b><Peter.Hitchman AT thomson DOT
com></b></font>
<br><font size=1 face="sans-serif">Sent by: veritas-bu-admin AT
mailman.eng.auburn DOT edu</font>
<p><font size=1 face="sans-serif">23/03/2006 14:50</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To:
<andrew.x.smith AT jpmchase DOT com></font>
<br><font size=1 face="sans-serif"> cc:
<veritas-bu AT mailman.eng.auburn DOT edu></font>
<br><font size=1 face="sans-serif"> Subject:
RE: [Veritas-bu] Netbackup expiry of rman backups with
infinite retentionperiod</font></table>
<br>
<br>
<br><font size=2 color=blue face="Arial">Hi,</font>
<br><font size=2 color=blue face="Arial">Thanks, but I have done the rman
"change ... delete ..." bit. What concerns me is that NB is not
removing the backup images from tape.</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 color=blue face="Arial">Regards</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 color=blue face="Arial">Pete</font>
<br><font size=2 face="Tahoma">-----Original Message-----<b><br>
From:</b> andrew.x.smith AT jpmchase DOT com [mailto:andrew.x.smith AT jpmchase
DOT com]<b><br>
Sent:</b> 23 March 2006 14:39<b><br>
To:</b> Hitchman, Peter (TS UK)<b><br>
Cc:</b> veritas-bu AT mailman.eng.auburn DOT edu<b><br>
Subject:</b> Re: [Veritas-bu] Netbackup expiry of rman backups with infinite
retentionperiod<br>
</font>
<br><font size=2 face="sans-serif"><br>
Is this the command ur after?</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
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.</font><font size=3 face="Times New Roman"> <br>
<br>
<br>
<br>
</font>
<table width=100%>
<tr valign=top>
<td width=1%>
<td width=35%><font size=1 face="sans-serif"><b><Peter.Hitchman AT thomson
DOT com></b></font><font size=3 face="Times New Roman"> </font><font size=1
face="sans-serif"><br>
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu</font><font size=3
face="Times New Roman"> </font>
<p><font size=1 face="sans-serif">23/03/2006 14:10</font><font size=3
face="Times New Roman"> </font>
<td width=62%><font size=1 face="Arial">
</font><font size=1 face="sans-serif"><br>
To: <veritas-bu AT
mailman.eng.auburn DOT edu></font><font size=3 face="Times New Roman">
</font><font size=1 face="sans-serif"><br>
cc: </font><font size=3
face="Times New Roman"> </font><font size=1 face="sans-serif"><br>
Subject: [Veritas-bu]
Netbackup expiry of rman backups with infinite retention period</font></table>
<br><font size=3 face="Times New Roman"><br>
<br>
</font><font size=2 face="Courier New"><br>
Hi,<br>
I have recently set-up some Oracle rman backups with Netbackup 4.5 on
Solaris.<br>
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.<br>
<br>
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?<br>
<br>
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?<br>
<br>
Thanks<br>
<br>
Pete<br>
<br>
_______________________________________________<br>
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu<br>
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu</font><font size=3
face="Times New Roman"><br>
<br>
</font>
<br>
<br>
--=_alternative 00546CE48025713A_=--
|