Veritas-bu

[Veritas-bu] Netbackup expiry of rman backups with infinite retention period

2006-03-24 12:59:13
Subject: [Veritas-bu] Netbackup expiry of rman backups with infinite retention period
From: Peter.Hitchman AT Thomson DOT com (Peter.Hitchman AT Thomson DOT com)
Date: Fri, 24 Mar 2006 17:59:13 -0000
This is a multi-part message in MIME format.

------_=_NextPart_001_01C64F6C.A927E76F
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
Yes I appreciate that, also all of the different backup images on a tape =
need to be expired for the tape to be reused. What stumps me at the =
moment is getting information from Netbackup's catalog. There is no =
bpcatlist in the installation!
=20
Regards
=20
Pete

-----Original Message-----
From: Marianne van den Berg [mailto:MarianneV AT LechabileSS.co DOT za]
Sent: 24 March 2006 12:11
To: Hitchman, Peter (TS UK)
Subject: RE: [Veritas-bu] Netbackup expiry of rman backups with infinite =
retention period


Hi Peter
=20
Just for the record - expiring a NetBackup image simply cleans up the =
image files on the master server. It does not remove data from tape. =
Only when all the images on a tape have expired will it be overwritten.
=20
Regards
=20
Marianne

-----Original Message-----
From: Peter.Hitchman AT thomson DOT com [mailto:Peter.Hitchman AT thomson DOT 
com]
Sent: 23 March 2006 04:51 PM
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.
=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 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=09



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_01C64F6C.A927E76F
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><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D920205717-24032006>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D920205717-24032006>Yes I=20
appreciate that, also all of the different backup images on a tape need =
to be=20
expired for the tape to be reused. What stumps me at the moment is =
getting=20
information from Netbackup's catalog. There is no bpcatlist in the=20
installation!</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D920205717-24032006></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D920205717-24032006>Regards</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D920205717-24032006></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D920205717-24032006>Pete</SPAN></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> Marianne van den =
Berg=20
  [mailto:MarianneV AT LechabileSS.co DOT za]<BR><B>Sent:</B> 24 March 2006=20
  12:11<BR><B>To:</B> Hitchman, Peter (TS UK)<BR><B>Subject:</B> RE:=20
  [Veritas-bu] Netbackup expiry of rman backups with infinite retention=20
  period<BR><BR></FONT></DIV>
  <DIV><SPAN class=3D781530712-24032006><FONT face=3DArial =
color=3D#0000ff size=3D2>Hi=20
  Peter</FONT></SPAN></DIV>
  <DIV><SPAN class=3D781530712-24032006><FONT face=3DArial =
color=3D#0000ff=20
  size=3D2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=3D781530712-24032006><FONT face=3DArial =
color=3D#0000ff size=3D2>Just=20
  for the record - expiring a NetBackup image simply cleans up the image =
files=20
  on the master server. It does not remove data from tape. Only when all =
the=20
  images on a tape have expired will it be =
overwritten.</FONT></SPAN></DIV>
  <DIV><SPAN class=3D781530712-24032006><FONT face=3DArial =
color=3D#0000ff=20
  size=3D2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=3D781530712-24032006><FONT face=3DArial =
color=3D#0000ff=20
  size=3D2>Regards</FONT></SPAN></DIV>
  <DIV><SPAN class=3D781530712-24032006><FONT face=3DArial =
color=3D#0000ff=20
  size=3D2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=3D781530712-24032006><FONT face=3DArial =
color=3D#0000ff=20
  size=3D2>Marianne</FONT></SPAN></DIV>
  <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
    <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
    size=3D2>-----Original Message-----<BR><B>From:</B> =
Peter.Hitchman AT thomson DOT com=20
    [mailto:Peter.Hitchman AT thomson DOT com]<BR><B>Sent:</B> 23 March 2006 =
04:51=20
    PM<BR><B>To:</B> andrew.x.smith AT jpmchase DOT com<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 infinite=20
    retentionperiod<BR><BR></FONT></DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D971244914-23032006>Hi,</SPAN></FONT></DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D971244914-23032006>Thanks, but I have done the rman "change =
... delete=20
    ..." bit. What concerns me is that NB is not removing the backup =
images from=20
    tape.</SPAN></FONT></DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D971244914-23032006></SPAN></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D971244914-23032006>Regards</SPAN></FONT></DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D971244914-23032006></SPAN></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D971244914-23032006>Pete</SPAN></FONT></DIV>
    <BLOCKQUOTE>
      <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
      size=3D2>-----Original Message-----<BR><B>From:</B>=20
      andrew.x.smith AT jpmchase DOT com=20
      [mailto:andrew.x.smith AT jpmchase DOT com]<BR><B>Sent:</B> 23 March 2006 
=

      14:39<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 infinite=20
      retentionperiod<BR><BR></FONT></DIV><BR><FONT face=3Dsans-serif =
size=3D2>Is=20
      this the command ur after?</FONT> <BR><BR><FONT face=3Dsans-serif =
size=3D2>The=20
      change ... delete command removes references to a backup piece, =
datafile=20
      copy, or archivelog from the control file and recovery catalog. It =

      physically deletes the file. This command works with or without a =
recovery=20
      catalog.</FONT> <BR><BR><BR><BR><BR>
      <TABLE width=3D"100%">
        <TBODY>
        <TR vAlign=3Dtop>
          <TD>
          <TD><FONT face=3Dsans-serif=20
            size=3D1><B>&lt;Peter.Hitchman AT thomson DOT com&gt;</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:10</FONT> =
<BR></P>
          <TD><FONT face=3DArial size=3D1>&nbsp; &nbsp; &nbsp; &nbsp;=20
            </FONT><BR><FONT face=3Dsans-serif size=3D1>&nbsp; &nbsp; =
&nbsp; &nbsp;=20
            To: &nbsp; &nbsp; &nbsp;=20
            &nbsp;&lt;veritas-bu AT mailman.eng.auburn DOT edu&gt;</FONT> =
<BR><FONT=20
            face=3Dsans-serif size=3D1>&nbsp; &nbsp; &nbsp; &nbsp; cc: =
&nbsp; &nbsp;=20
            &nbsp; &nbsp;</FONT> <BR><FONT face=3Dsans-serif =
size=3D1>&nbsp; &nbsp;=20
            &nbsp; &nbsp; Subject: &nbsp; &nbsp; &nbsp; =
&nbsp;[Veritas-bu]=20
            Netbackup expiry of rman backups with infinite retention=20
            period</FONT></TD></TR></TBODY></TABLE><BR><BR><BR><FONT=20
      face=3D"Courier New" size=3D2>Hi,<BR>I have recently set-up some =
Oracle rman=20
      backups with Netbackup 4.5 on Solaris.<BR>The retention period in =
the=20
      policy is set to infinite for both the automatic and application =
backup=20
      schedules. I wanted to check that Netbackup would clean up the =
backups=20
      when I obsolete them in rman. But having done the obsolete in rman =
I have=20
      found that Netbackup has not removed the backup images from the =
tapes,=20
      even though they are gone from the rman catalog. I tried running =
"bpimage=20
      -cleanup -client &lt;name&gt;" but the bpdbm log showed that =
nothing was=20
      removed.<BR><BR>There was an oddity with the Netbackup =
configuration on=20
      the client, when the original backup was made, the bp.conf =
contained the=20
      wrong client name. Could this be causing a problem, now that the =
client=20
      name has been changed?<BR><BR>Am I on the wrong track here? =
According to=20
      the manual when rman deletes a backup-piece Netbackup should get =
rid of it=20
      regardless of the retention period. Does anyone know of a way I =
can sort=20
      this out, so that when rman deletes the backup, Netbackup does as=20
      =
well?<BR><BR>Thanks<BR><BR>Pete<BR><BR>__________________________________=
_____________<BR>Veritas-bu=20
      maillist &nbsp;-=20
      =
&nbsp;Veritas-bu AT mailman.eng.auburn DOT 
edu<BR>http://mailman.eng.auburn.edu/=
mailman/listinfo/veritas-bu<BR></FONT><BR><BR></BLOCKQUOTE></BLOCKQUOTE><=
/BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C64F6C.A927E76F--

<Prev in Thread] Current Thread [Next in Thread>