Veritas-bu

[Veritas-bu] RE: Oracle Backup

2005-11-09 12:26:58
Subject: [Veritas-bu] RE: Oracle Backup
From: Mark.Donaldson AT cexp DOT com (Mark.Donaldson AT cexp DOT com)
Date: Wed, 9 Nov 2005 10:26:58 -0700
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_01C5E552.C9898329
Content-Type: text/plain;
        charset="iso-8859-1"

Since you're doing RMAN backups to disk, the obvious, fast, choice is to
start doing RMAN incrementals to disk between the full backups; less data on
disk means less time to move it to tape.  A full backup nightly, to tape or
to disk, is going to take time.  The obvious time saver here is to do RMAN
incrementals. Nothing special from Netbackup, It's all about using the
inherent features of RMAN.  It can do cummulative or differential backups of
the data.
 
If you want to do the RMAN backups, full or incremental, directly to tape
then you can get the Netbackup agent for Oracle but that's not really
necessary if you've got the disk space to stage the dump.
 
Another speed-up option is to have the DBA's use more channels to disk,
making more files in the dump area.  Then use file-pattern matching to break
the files into multiple streams for the transfer to tape.
 
-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 Christopher
Costa
Sent: Wednesday, November 09, 2005 6:40 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] RE: Oracle Backup


Gents,

We have an Oracle Database pretty active and large in size (500GB). Today we
are currently performing RMAN dumps and backing up from the dump area,
however the backups are full each night and take a while.

Our goal is to save our client some money and shorten the backup window
nightly. 

What is a valid best practice for Oracle database backups? Is it the use of
BLIB?

Any comments would be appreciated

Thanks

Charles



------_=_NextPart_001_01C5E552.C9898329
Content-Type: text/html;
        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">


<META content="MSHTML 6.00.2800.1515" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=264231917-09112005><FONT face=Arial color=#0000ff size=2>Since 
you're doing RMAN backups to disk, the obvious, fast, choice is to start doing 
RMAN incrementals to disk between the full backups; less data on disk means 
less 
time to move it to tape.&nbsp; A full backup nightly, to tape or to disk, is 
going to take time.&nbsp; The obvious time saver here is to do RMAN 
incrementals. Nothing special from Netbackup, It's all about using the inherent 
features of RMAN.&nbsp; It can do cummulative or differential backups of the 
data.</FONT></SPAN></DIV>
<DIV><SPAN class=264231917-09112005><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=264231917-09112005><FONT face=Arial color=#0000ff size=2>If 
you 
want to do the RMAN backups, full or incremental, directly to tape then you can 
get the Netbackup agent for Oracle but that's not really necessary if you've 
got 
the disk space to stage the dump.</FONT></SPAN></DIV>
<DIV><SPAN class=264231917-09112005><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=264231917-09112005><FONT face=Arial color=#0000ff 
size=2>Another speed-up option is to have the DBA's use more channels to disk, 
making more files in the dump area.&nbsp; Then use file-pattern matching to 
break the files into multiple streams for the transfer to 
tape.</FONT></SPAN></DIV>
<DIV><SPAN class=264231917-09112005><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=264231917-09112005><FONT face=Arial color=#0000ff 
size=2>-M</FONT></SPAN></DIV>
<BLOCKQUOTE>
  <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>Christopher Costa<BR><B>Sent:</B> Wednesday, November 09, 2005 6:40 
  AM<BR><B>To:</B> veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> 
  [Veritas-bu] RE: Oracle Backup<BR><BR></FONT></DIV>Gents,<BR><BR>We have an 
  Oracle Database pretty active and large in size (500GB). Today we are 
  currently performing RMAN dumps and backing up from the dump area, however 
the 
  backups are full each night and take a while.<BR><BR>Our goal is to save our 
  client some money and shorten the backup window nightly. <BR><BR>What is a 
  valid best practice for Oracle database backups? Is it the use of 
  BLIB?<BR><BR>Any comments would be 
appreciated<BR><BR>Thanks<BR><BR>Charles<BR></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C5E552.C9898329--

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