|
[Veritas-bu] Expected RMAN behavior
2004-03-10 17:17:04
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C406ED.6ACA38B0
Content-Type: text/plain
It looks like you are missing:
allocate channel for maintenance type 'sbt_tape';
After you run rman
This link will help:
http://seer.support.veritas.com/docs/251686.htm
The "run" below is just looking at the Rman catalog.
I hope this helps.
Isidro Rodriguez
-----Original Message-----
From: Donaldson, Mark [mailto:Mark.Donaldson AT experianems DOT com]
Sent: Wednesday, March 10, 2004 12:47 PM
To: Veritasbu (E-mail)
Subject: [Veritas-bu] Expected RMAN behavior
We've got an RMAN backup of our Oracle database. We're using a small RMAN
maintenance script to cleanup weekly.
The core of it looks like:
RUN {
CROSSCHECK BACKUP;
CHANGE ARCHIVELOG ALL CROSSCHECK;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT OBSOLETE;
}
OK - by our reading, this should compare the RMAN catalog against the NB
catalog. It should then clean the RMAN catalog of any images that NB has
lost or expired and the reverse.
After a test, it looks like the reverse didn't happen. Yes - it cleaned the
RMAN catalog but not one tape was released. I thought that if RMAN
retention made a backup piece obsolete, then it would trigger Netbackup to
expire the associated image. Didn't seem to happen.
Can anybody verify if RMAN catalog cleanup should (or should not) affect the
NB image database?
-M
-----------------------------------------------------------------------
"Dust off and nuke the site from orbit. It's the only way to be sure."
-----------------------------------------------------------------------
Mark Donaldson - SE - Experian - 303-675-5844
-----------------------------------------------------------------------
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
------_=_NextPart_001_01C406ED.6ACA38B0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.45">
<TITLE>RE: [Veritas-bu] Expected RMAN behavior</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>It looks like you are missing:</FONT>
</P>
<P> <FONT SIZE=3D2>allocate =
channel for maintenance type 'sbt_tape';</FONT>
</P>
<P><FONT SIZE=3D2>After you run rman</FONT>
</P>
<P><FONT SIZE=3D2>This link will help:</FONT>
</P>
<P><FONT SIZE=3D2><A =
HREF=3D"http://seer.support.veritas.com/docs/251686.htm"; =
TARGET=3D"_blank">http://seer.support.veritas.com/docs/251686.htm</A></F=
ONT>
</P>
<P><FONT SIZE=3D2>The "run" below is just looking at the Rman =
catalog.</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>I hope this helps.</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Isidro Rodriguez</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Donaldson, Mark [<A =
HREF=3D"mailto:Mark.Donaldson AT experianems DOT com">mailto:Mark.Donaldson@exp=
erianems.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, March 10, 2004 12:47 PM</FONT>
<BR><FONT SIZE=3D2>To: Veritasbu (E-mail)</FONT>
<BR><FONT SIZE=3D2>Subject: [Veritas-bu] Expected RMAN behavior</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>We've got an RMAN backup of our Oracle =
database. We're using a small RMAN</FONT>
<BR><FONT SIZE=3D2>maintenance script to cleanup weekly.</FONT>
</P>
<P><FONT SIZE=3D2>The core of it looks like:</FONT>
<BR><FONT SIZE=3D2>RUN {</FONT>
<BR><FONT SIZE=3D2> CROSSCHECK BACKUP;</FONT>
<BR><FONT SIZE=3D2> CHANGE ARCHIVELOG ALL CROSSCHECK;</FONT>
<BR><FONT SIZE=3D2> DELETE NOPROMPT EXPIRED BACKUP;</FONT>
<BR><FONT SIZE=3D2> DELETE NOPROMPT OBSOLETE;</FONT>
<BR><FONT SIZE=3D2>}</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>OK - by our reading, this should compare the RMAN =
catalog against the NB</FONT>
<BR><FONT SIZE=3D2>catalog. It should then clean the RMAN catalog =
of any images that NB has</FONT>
<BR><FONT SIZE=3D2>lost or expired and the reverse.</FONT>
</P>
<P><FONT SIZE=3D2>After a test, it looks like the reverse didn't =
happen. Yes - it cleaned the</FONT>
<BR><FONT SIZE=3D2>RMAN catalog but not one tape was released. I =
thought that if RMAN</FONT>
<BR><FONT SIZE=3D2>retention made a backup piece obsolete, then it =
would trigger Netbackup to</FONT>
<BR><FONT SIZE=3D2>expire the associated image. Didn't seem to =
happen.</FONT>
</P>
<P><FONT SIZE=3D2>Can anybody verify if RMAN catalog cleanup should (or =
should not) affect the</FONT>
<BR><FONT SIZE=3D2>NB image database?</FONT>
</P>
<P><FONT SIZE=3D2>-M</FONT>
</P>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
--------</FONT>
<BR><FONT SIZE=3D2>"Dust off and nuke the site from orbit. =
It's the only way to be sure."</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-------- </FONT>
<BR><FONT SIZE=3D2>Mark Donaldson - SE - Experian - 303-675-5844</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
--------</FONT>
<BR><FONT =
SIZE=3D2>_______________________________________________</FONT>
<BR><FONT SIZE=3D2>Veritas-bu maillist - =
Veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu"; =
TARGET=3D"_blank">http://mailman.eng.auburn.edu/mailman/listinfo/veritas=
-bu</A></FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C406ED.6ACA38B0--
|
|
|
