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_01C34AE2.DC4FAFA0
Content-Type: text/plain
Dear all RMAN users and experts,
We use RMAN here to backup up Oracle databases in various flavours of 8i and
9i, using Netbackup 3.4 on Solaris 2.6 with an StorageTek L700 containing
DLT7000s.
Each Oracle backup kicks of multiple Netbackup streams, one per tablespace I
believe.
If we get a failure of one or a number of streams, often the Auto schedule
will return code 0. Netbackup will retain images for all of the successful
streams, even though these would be no use (I think) to restore from and
even though RMAN will not (I think) keep a record of the backup.
I believe that RMAN can give us a list of when backups were taken, and we
can use this to (somehow) identify which Netbackup images are partial, with
a view to expiring them.
1. How does RMAN link its images to Netbackup i.e. does it store the
Netbackup backup ID - so we could link on this - or will we have to try to
be clever with dates?
2. Is it possible to get the Auto schedule to pick up on failure of some
streams, and return a failure code, possibly preventing this problem of some
streams images being retained?
thanks for any advice...
Phil
Phil Weber
Egg Distributed Hosts - UNIX Systems Engineer
Phone: 01384 26 4136
Mobile:
This private and confidential e-mail has been sent to you by Egg.
The Egg group of companies includes Egg Banking plc
(registered no. 2999842), Egg Financial Products Ltd (registered
no. 3319027) and Egg Investments Ltd (registered no. 3403963) which
carries out investment business on behalf of Egg and is regulated
by the Financial Services Authority.
Registered in England and Wales. Registered offices: 1 Waterhouse Square,
138-142 Holborn, London EC1N 2NA.
If you are not the intended recipient of this e-mail and have
received it in error, please notify the sender by replying with
'received in error' as the subject and then delete it from your
mailbox.
------_=_NextPart_001_01C34AE2.DC4FAFA0
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.2653.12">
<TITLE>How are RMAN & NetBackup Connected?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">Dear all RMAN users and experts,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">We use RMAN here to backup up Oracle datab=
ases in various flavours of 8i and 9i, using Netbackup 3.4 on Solaris 2.6 w=
ith an StorageTek L700 containing DLT7000s.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Each Oracle backup kicks of multiple Netba=
ckup streams, one per tablespace I believe.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">If we get a failure of one or a number of =
streams, often the Auto schedule will return code 0. Netbackup will r=
etain images for all of the successful streams, even though these would be =
no use (I think) to restore from and even though RMAN will not (I think) ke=
ep a record of the backup.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I believe that RMAN can give us a list of =
when backups were taken, and we can use this to (somehow) identify which Ne=
tbackup images are partial, with a view to expiring them.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">1. How does RMAN link its images to =
Netbackup i.e. does it store the Netbackup backup ID - so we could link on =
this - or will we have to try to be clever with dates?</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">2. Is it possible to get the Auto sc=
hedule to pick up on failure of some streams, and return a failure code, po=
ssibly preventing this problem of some streams images being retained?</FONT=
></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">thanks for any advice...</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Phil</FONT>
</P>
<P><B><FONT SIZE=3D2 FACE=3D"Arial">Phil Weber</FONT></B>
<BR><FONT COLOR=3D"#808080" SIZE=3D2 FACE=3D"Arial">Egg Distributed Hosts -=
UNIX Systems Engineer</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D2 FACE=3D"Arial">Phone: 01384 26 4136</F=
ONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D2 FACE=3D"Arial">Mobile: </FONT>
</P>
<CODE><FONT SIZE=3D3><BR>
<BR>
This private and confidential e-mail has been sent to you by Egg.<BR>
The Egg group of companies includes Egg Banking plc<BR>
(registered no. 2999842), Egg Financial Products Ltd (registered<BR>
no. 3319027) and Egg Investments Ltd (registered no. 3403963) which<BR>
carries out investment business on behalf of Egg and is regulated<BR>
by the Financial Services Authority. <BR>
Registered in England and Wales. Registered offices: 1 Waterhouse Square,<B=
R>
138-142 Holborn, London EC1N 2NA.<BR>
If you are not the intended recipient of this e-mail and have<BR>
received it in error, please notify the sender by replying with<BR>
'received in error' as the subject and then delete it from your<BR>
mailbox.<BR>
</FONT></CODE>
</BODY>
</HTML>
------_=_NextPart_001_01C34AE2.DC4FAFA0--
|
