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_000_01C55254.0831D759
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C55254.0831D759"
------_=_NextPart_001_01C55254.0831D759
Content-Type: text/plain;
charset="iso-8859-1"
Without being able to test this. My kneejerk, and slightly informed,
opinion is your DBA's are living in fantasy land.
The thing that should be obvious to them is that the RMAN command set is
different between the two methods. They're doing a backup to disk using an
OPEN DISK FOR BACKUP type command and they'd want to restore directly from
tape using an OPEN SBT_TAPE FOR RESTORE command. The backup devices are
different from an RMAN point of view.
The RMAN catalog is recording backup piece name & filesystem for the
restore, these structures don't exist on tape. The RMAN files in their
disk-backup region are backed up by a filesystem policy so there's no way
that the rman is going to be able to link to a filesystem policy, it needs
an RMAN application policy.
Nope. Isn't going to happen in the current method.
Now, if you hijacked their disk region as a DSSU or regular Disk Storage
Unit and backed-up the database using RMAN to a Netbackup application policy
where Netbackup first wrote it to disk, then you could later duplicate the
netbackup images on disk to tape and RMAN is none the wiser. In your
disaster situation, you switch the primary copy of the backup to the tape
images, if it hasn't already automatcially switched, import the tapes in
your DR environment & you're off & running.
I do this today, do RMAN backup to an NB Oracle Application policy that
first writes the images to a disk storage unit and then later have NB
duplicate them to tape. The retention period of the copy is set longer than
the on-disk image the on-disk images are allowed to expire & delete fairly
rapidly compared to the tape image. Promotion of the tape image to primary
copy is automatic, of course.
-M
-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]On Behalf Of Gavin
Kehlert
Sent: Friday, May 06, 2005 7:30 AM
To: Veritas Mailing List (E-mail)
Subject: [Veritas-bu] Oracle RMAN disk backup restored from NetBackup tape
Hi All, One of my customers is wanting to do the following:
They are running Oracle RMAN backups to disk, mounting the disk on a
different host and then backing up that data using NetBackup to tape as a
file system type of backup. For their DR site they would like to be able to
restore that data directly back from tape via RMAN due to disk size
limitations. Is there any way this will ever be able to be accomplished?
PS The Oracle DBA's are convinced there should be a method/util available.
Kind Regards,
Gavin Kehlert
VERITAS Engineer
Direct : +27 (0)11 519-8125
Mobile : +27 (0)82 442-3094
E-mail : <mailto:GavinK AT LechabileSS.co DOT za> GavinK AT LechabileSS.co DOT
za
LECHABILE Storage Solutions (PTY) Ltd.
"DELIVERING THE INFORMATION ADVANTAGE"
This e-mail and attachments relating thereto, is intended for the
above-mentioned recipient. If you have received this e-mail in error, kindly
notify the sender and delete it immediately as it contains information
relating to the official business of LECHABILE Storage Solutions (PTY) Ltd,
which is confidential, legally privileged and proprietary to LECHABILE
Storage Solutions (PTY) Ltd. LECHABILE Storage Solutions (PTY) Ltd does not
own and endorse any other content. The views and opinions expressed in this
e-mail are those of the sender unless clearly stated as being those of
LECHABILE Storage Solutions (PTY) Ltd
------_=_NextPart_001_01C55254.0831D759
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o = "urn:schemas-microsoft-com:office:office"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1476" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff
size=2>Without being able to test this. My kneejerk, and slightly
informed, opinion is your DBA's are living in fantasy land.</FONT></SPAN></DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff size=2>The
thing that should be obvious to them is that the RMAN command set is
different between the two methods. They're doing a backup to disk using
an
OPEN DISK FOR BACKUP type command and they'd want to restore directly from tape
using an OPEN SBT_TAPE FOR RESTORE command. The backup devices are
different from an RMAN point of view.</FONT></SPAN></DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff size=2>The
RMAN catalog is recording backup piece name & filesystem for the restore,
these structures don't exist on tape. The RMAN files in their
disk-backup region are backed up by a filesystem policy so there's no way that
the rman is going to be able to link to a filesystem policy, it needs an RMAN
application policy. </FONT></SPAN></DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff
size=2>Nope. Isn't going to happen in the current
method.</FONT></SPAN></DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff size=2>Now,
if you hijacked their disk region as a DSSU or regular Disk Storage Unit
and backed-up the database using RMAN to a Netbackup application policy
where Netbackup first wrote it to disk, then you could later duplicate the
netbackup images on disk to tape and RMAN is none the wiser. In your
disaster situation, you switch the primary copy of the backup to the tape
images, if it hasn't already automatcially switched, import the tapes in your
DR
environment & you're off & running.</FONT></SPAN></DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff size=2>I do
this today, do RMAN backup to an NB Oracle Application policy that first
writes the images to a disk storage unit and then later have NB duplicate them
to tape. The retention period of the copy is set longer than the
on-disk image the on-disk images are allowed to expire & delete fairly
rapidly compared to the tape image. Promotion of the tape image to
primary
copy is automatic, of course.</FONT></SPAN></DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=972373915-06052005><FONT face=Arial color=#0000ff
size=2>-M</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]<B>On Behalf Of
</B>Gavin
Kehlert<BR><B>Sent:</B> Friday, May 06, 2005 7:30 AM<BR><B>To:</B> Veritas
Mailing List (E-mail)<BR><B>Subject:</B> [Veritas-bu] Oracle RMAN disk backup
restored from NetBackup tape<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=065151413-06052005>Hi All,
</SPAN></FONT><FONT size=+0><SPAN class=065151413-06052005><FONT
face=Arial><FONT size=2><SPAN class=892541512-06052005><SPAN
class=065151413-06052005>One of my customers is wanting to do the
following:</SPAN></SPAN></FONT></FONT></DIV>
<DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=892541512-06052005><SPAN
class=065151413-06052005></SPAN></SPAN></FONT></FONT> </DIV>
<DIV><FONT size=+0><SPAN class=892541512-06052005><SPAN
class=065151413-06052005></SPAN><FONT face=Arial><FONT size=2><SPAN
class=065151413-06052005>They are running</SPAN> Oracle RMAN <SPAN
class=065151413-06052005>backups </SPAN>to disk<SPAN
class=065151413-06052005>, mounting the disk on a different
host</SPAN> and then back<SPAN class=065151413-06052005>ing up that
data</SPAN> <SPAN class=065151413-06052005>using</SPAN> NetBackup to
tape <SPAN class=065151413-06052005>as a file system type of
backup.</SPAN> <SPAN class=065151413-06052005>For their DR site they
would like to be able to restore that data directly back from tape via RMAN
due to disk size limitations. Is there any way this will ever be able to be
accomplished?</SPAN></FONT></FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=892541512-06052005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=892541512-06052005><SPAN
class=065151413-06052005>PS The Oracle DBA's are convinced there
should be a method/util available.</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=892541512-06052005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=892541512-06052005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=892541512-06052005>Kind
Regards, </SPAN></FONT></DIV></SPAN></FONT></DIV>
<DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT size=2>
<TABLE
style="BORDER-RIGHT: black 1pt outset; BORDER-TOP: black 1pt outset;
BORDER-LEFT: black 1pt outset; WIDTH: 187.5pt; BORDER-BOTTOM: black 1pt outset;
mso-cellspacing: 0cm; mso-padding-alt: 0cm 0cm 0cm 0cm"
cellSpacing=0 cellPadding=0 width=250 border=0>
<TBODY>
<TR>
<TD
style="BORDER-RIGHT: black 1pt inset; PADDING-RIGHT: 0cm; BORDER-TOP:
black 1pt inset; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: black 1pt
inset; WIDTH: 216.75pt; PADDING-TOP: 0cm; BORDER-BOTTOM: black 1pt inset;
BACKGROUND-COLOR: transparent"
width=289>
<TABLE
style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT:
medium none; WIDTH: 204.75pt; BORDER-BOTTOM: medium none; mso-cellspacing: 0cm;
mso-padding-alt: 0cm 0cm 0cm 0cm; mso-table-anchor-vertical: paragraph;
mso-table-anchor-horizontal: column; mso-table-left: left"
cellSpacing=0 cellPadding=0 width=273 align=left border=1>
<TBODY>
<TR style="HEIGHT: 66pt">
<TD
style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 3pt; BORDER-TOP:
#d4d0c8; PADDING-LEFT: 3pt; PADDING-BOTTOM: 3pt; BORDER-LEFT: #d4d0c8; WIDTH:
140.25pt; PADDING-TOP: 3pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 66pt;
BACKGROUND-COLOR: transparent"
width=187>
<P style="MARGIN: 0cm 0cm 0pt"><STRONG><SPAN lang=EN-US
style="COLOR: black; mso-ansi-language: EN-US">Gavin
Kehlert
</SPAN></STRONG><SPAN lang=EN-US
style="COLOR: black; mso-ansi-language:
EN-US"><o:p></o:p></SPAN></P>
<P style="BACKGROUND: black; MARGIN: 0cm 0cm 0pt"><FONT
face=Arial><STRONG><SPAN lang=EN-US
style="COLOR: white; FONT-FAMILY: tim; mso-ansi-language:
EN-US"><FONT
face="Times New Roman">VERITAS Engineer</FONT>
</SPAN></STRONG><STRONG><SPAN
style="COLOR: white; FONT-FAMILY:
tim"><o:p></o:p></SPAN></STRONG></FONT></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=FR
style="FONT-SIZE: 8pt; COLOR: black; mso-ansi-language: FR;
mso-bidi-font-size: 12.0pt"><FONT
face=Arial> <o:p></o:p></FONT></SPAN></P></FONT>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=FR
style="FONT-SIZE: 8pt; COLOR: black; mso-ansi-language: FR;
mso-bidi-font-size: 12.0pt"><FONT
size=1><STRONG>Direct<SPAN
style="mso-spacerun: yes"> </SPAN>:</STRONG> +27 (0)11
519-8125 <o:p></o:p></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=FR
style="FONT-SIZE: 8pt; COLOR: black; mso-ansi-language: FR;
mso-bidi-font-size: 12.0pt"><FONT
size=1><STRONG>Mobile :</STRONG> +27 (0)82
442-3094</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=FR
style="FONT-SIZE: 8pt; COLOR: black; mso-ansi-language: FR;
mso-bidi-font-size: 12.0pt"><FONT
size=1><STRONG>E-mail :</STRONG> </FONT><A
href="mailto:GavinK AT LechabileSS.co DOT za"><FONT
size=1>GavinK AT LechabileSS.co DOT
za</FONT></A></SPAN></P></TD><FONT
size=2>
<TD
style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 3pt; BORDER-TOP:
#d4d0c8; PADDING-LEFT: 3pt; PADDING-BOTTOM: 3pt; BORDER-LEFT: #d4d0c8; WIDTH:
64.5pt; PADDING-TOP: 3pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 66pt;
BACKGROUND-COLOR: transparent"
vAlign=bottom width=86>
<P align=right><FONT size=2><SPAN lang=FR
style="COLOR: navy; mso-ansi-language: FR"><FONT face=Arial><IMG
alt="" hspace=0 src="cid:972373915@06052005-2e79" align=top
border=0></FONT></SPAN></FONT></P></TD></TR>
<TR style="HEIGHT: 18.75pt">
<TD
style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 3pt; BORDER-TOP:
#d4d0c8; PADDING-LEFT: 3pt; BACKGROUND: black; PADDING-BOTTOM: 3pt;
BORDER-LEFT: #d4d0c8; WIDTH: 204.75pt; PADDING-TOP: 3pt; BORDER-BOTTOM:
#d4d0c8; HEIGHT: 18.75pt; mso-shading: windowtext; mso-pattern: solid black"
vAlign=bottom width=273 colSpan=2>
<P style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center"
align=center><STRONG><SPAN
style="FONT-WEIGHT: normal; FONT-SIZE: 10pt; COLOR: white"><FONT
face=Arial><STRONG><FONT face="Times New Roman">LECHABILE Storage
Solutions (PTY) Ltd.</FONT></STRONG>
<o:p></o:p></FONT></SPAN></STRONG></P>
<P style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center"
align=center><FONT face=Arial><STRONG><SPAN
style="FONT-WEIGHT: normal; FONT-SIZE: 7.5pt; COLOR: white"><FONT
face="Times New Roman">"DELIVERING THE INFORMATION
ADVANTAGE"</FONT></SPAN></STRONG><SPAN
style="FONT-SIZE: 10pt; COLOR: navy">
<o:p></o:p></SPAN></FONT></P></TD></TR></TBODY></TABLE>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><o:p><FONT
face=Arial></FONT></o:p></P></FONT></TD></TR></TBODY></TABLE></FONT></DIV>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-ansi-language:
EN-GB; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-US;
mso-bidi-language: AR-SA"><FONT
face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-ansi-language:
EN-GB; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-US;
mso-bidi-language: AR-SA">
<DIV><FONT size=1><SPAN
style="COLOR: gray; FONT-FAMILY: Times New Roman; mso-ansi-language: EN-GB;
mso-fareast-font-family: Times New Roman; mso-fareast-language: EN-US;
mso-bidi-language: AR-SA">This
e-mail and attachments relating thereto, is intended for the above-mentioned
recipient. If you have received this e-mail in error, kindly notify the
sender
and delete it immediately as it contains information relating to the official
business of LECHABILE Storage Solutions (PTY) Ltd, which is confidential,
legally privileged and proprietary to LECHABILE Storage Solutions (PTY) Ltd.
LECHABILE Storage Solutions (PTY) Ltd does not own and endorse any other
content. The views and opinions expressed in this e-mail are those of the
sender unless clearly stated as being those of LECHABILE Storage Solutions
(PTY) Ltd</SPAN></FONT></DIV></SPAN></DIV></DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C55254.0831D759--
------_=_NextPart_000_01C55254.0831D759
Content-Type: image/gif;
name="LSS (Bus Card).gif"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="LSS (Bus Card).gif"
Content-ID: <972373915@06052005-2e79>
R0lGODdhSwBHAPcAAAAAAIAAAACAAICAAAAAgIAAgACAgMDAwMDcwKbK8EAgAGAgAIAgAKAgAMAg
AOAgAABAACBAAEBAAGBAAIBAAKBAAMBAAOBAAABgACBgAEBgAGBgAIBgAKBgAMBgAOBgAACAACCA
AECAAGCAAICAAKCAAMCAAOCAAACgACCgAECgAGCgAICgAKCgAMCgAOCgAADAACDAAEDAAGDAAIDA
AKDAAMDAAODAAADgACDgAEDgAGDgAIDgAKDgAMDgAODgAAAAQCAAQEAAQGAAQIAAQKAAQMAAQOAA
QAAgQCAgQEAgQGAgQIAgQKAgQMAgQOAgQABAQCBAQEBAQGBAQIBAQKBAQMBAQOBAQABgQCBgQEBg
QGBgQIBgQKBgQMBgQOBgQACAQCCAQECAQGCAQICAQKCAQMCAQOCAQACgQCCgQECgQGCgQICgQKCg
QMCgQOCgQADAQCDAQEDAQGDAQIDAQKDAQMDAQODAQADgQCDgQEDgQGDgQIDgQKDgQMDgQODgQAAA
gCAAgEAAgGAAgIAAgKAAgMAAgOAAgAAggCAggEAggGAggIAggKAggMAggOAggABAgCBAgEBAgGBA
gIBAgKBAgMBAgOBAgABggCBggEBggGBggIBggKBggMBggOBggACAgCCAgECAgGCAgICAgKCAgMCA
gOCAgACggCCggECggGCggICggKCggMCggOCggADAgCDAgEDAgGDAgIDAgKDAgMDAgODAgADggCDg
gEDggGDggIDggKDggMDggODggAAAwCAAwEAAwGAAwIAAwKAAwMAAwOAAwAAgwCAgwEAgwGAgwIAg
wKAgwMAgwOAgwABAwCBAwEBAwGBAwIBAwKBAwMBAwOBAwABgwCBgwEBgwGBgwIBgwKBgwMBgwOBg
wACAwCCAwECAwGCAwICAwKCAwMCAwOCAwACgwCCgwECgwGCgwICgwKCgwMCgwOCgwADAwCDAwEDA
wGDAwIDAwKDAwP/78KCgpICAgP8AAAD/AP//AAAA//8A/wD//////yH5BAAAAAAALAAAAABLAEcA
AAj/AP8JHEiwoMGDCBMqXLjQ3oGHECNKnEixosWLGCPaG3gvicePIEOKHEmypMmTIA9wTCJFk8uX
MGPKnEmzps2bUpKoFNhRFLqfQIMKHUq0qNGjSDXpXOkTqdOnUKMq3fmvZ9SrWLNOZZq1q1ejW3km
afrV6LyySZeKJYs2aLo/+2q1LRq26ti5Qu3s22crqrqrda1eTccq3VG4+344VWcrMWC1dtk+bfyD
lVHE+ywXVfdjL9/HVAVHZeVZ81C9e/8YJe0Za+C7WDGvI8racVHM+1xDFu23c2LDQzH/HVp7n2rQ
XLOu83xcaO3Zpz1n1h0adtZapYk2jktUumLqybti/5Y7FDv0oMs9k0e+9ms63z+AP639HXz7r5z3
mnaKXX/X15IFVYsd+xXFSi3nqTNgLawMJ+Be69kXWVH97WWLg0etg5p0dzQI1Cq1YLgZKwWiA2BR
G3pmi3xDqZOidNJFeFQtvu1z3k8nUljjXj/I+FNxMAb5R4lBsbLjHUPlaBSNMMq4nXd2RHmHd4kR
uQ5uf/ho4m7WGZXOk3udhxtfBTK2F4FhClXhPh2CxWWAm9nimx0/gfmHiOh1Vgt2dP70lnREBqUk
VOoMV1xfSOU3yl7ApWccnkm+6dV7KkJF2h961RdloJFWB+dklUYlJ2teDXqVb80Ruk8rU0LqlKms
2P/RGaa2eFikZzdCZcsfrdj4n6RAqRMkc7UA1x+SWcWKTq2/eiqUglMOqxlqnCKlmC1avgosbbXY
YgezQKHmqlO5KasVl5p0hdqnSImyjzir9ImVFlyiRFIbe9k70hb7kLGFHR9JQUYbbfi7BRlRtjFS
dfqKxMVeOTX8ERn7EAywRy9yuPBKEoMkRWdkdIxxvxV/1AZ8UUYZ8sZiifyRG/tcLDG/blC8hcse
MdwwF23czFJnPjes1xaY4pwzxygJjNgPHz18R8T2UmyHGz9A7bLOJdkRrXRQ4/tHTlsEPdLHxvVr
9NEt37u1Z3eInQTMf7QBsx1Wf/TvHbK6cTbadpX/FKQdXJBEcWJuuEG33VTv82/Me/PdUUn/2tEz
SkQz94MbbSyduN6N19s5SycP+0PYgCfhNs5Y4+y2wGuzGfhHP/zwutGpdywFviRJEfYWdSfhmcK0
Iy2yFNHOLrRnpzdcu77Ecx3SwyXvy3bwaXcMs2cym3xmSfjuBbzIy9tb49ciobYySUv3bm/4J0HP
pvrdcy64Z+dLzL5JqFV9b2omSYHYH1cT3vH2YbyQdO97JOEXmwJYvYZJgQv1E0n3kuex9zGwb58D
yQQpp771CTCD+BpdBlmGwREmAWEdzOD9TMhCz7XwhSn5IAxbuMIZdq6GNtwbDnNIvRLy0IRUYYgQ
EYdIxCIa8YhITKISl8hEIQYEADs=
------_=_NextPart_000_01C55254.0831D759--
|