Veritas-bu

[Veritas-bu] Database Backup

2001-09-24 11:40:53
Subject: [Veritas-bu] Database Backup
From: llabonte AT att DOT com (Labonte, L R (Leo), SITS)
Date: Mon, 24 Sep 2001 11:40:53 -0400
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_01C1450F.4B6794B0
Content-Type: text/plain;
        charset="iso-8859-1"

Folks,
 
Sorry............need to change this.  :)
 
    Leo
 
1) When backups finish, initiate multiple concurrent backups to pick up
   backup client databases other than /usr/openv/netbackup/db/images/<master
& media servers>.
2) Follow with NetBackup database backup that includes only
   /usr/openv/netbackup/db/images/<master & media servers>.

-----Original Message-----
From: Labonte, L R (Leo), SITS 
Sent: Monday, September 24, 2001 11:23 AM
To: 'Scott Jacobson'; veritas-bu AT mailman.eng.auburn DOT edu;
Brian_Drager AT vanguard DOT com
Subject: RE: [Veritas-bu] Database Backup


Folks,
 
Here's a brain storm.  It may be possible to use a tiered approach
with concurrent backups to resolve this problem.  When backups complete,
initiate this sort of backup:
 
1) NetBackup database backup that includes only
   /usr/openv/netbackup/db/images/<master & media servers>.
2) At the same time initiate multiple concurrent backups to pick up
   all other databases in /images directory.
 
To recover:
 
1) Use bprecover to restore master and media servers.
2) Once master and media servers are recovered, then use NetBackup
   to recover backup client databases with multiple concurrent jobs.
 
This prevents overflowing the NetBackup database tape and speeds up
NetBackup database backups and restores.
 
    Leo

-----Original Message-----
From: Scott Jacobson [mailto:SJACOBSO AT novell DOT com]
Sent: Friday, September 21, 2001 12:20 PM
To: veritas-bu AT mailman.eng.auburn DOT edu; Brian_Drager AT vanguard DOT com
Subject: Re: [Veritas-bu] Database Backup


Brian,
 
We are facing the same issue and will resolve it (in our case) by
implementing Compaq's Enterprise Volume Manager.  Simply a hardware based
solution using a SAN that will snap the NetBackup database from one lun to
another.  We will then additionally backup the snapped database.
 
Scott J.

>>> < Brian_Drager AT vanguard DOT com <mailto:Brian_Drager AT vanguard DOT 
>>> com> >
09/21/01 06:24AM >>>
Our NetBackup database file system is over 100GB. Is their a faster way of
running database backup? WE can only run it once a week because we always
have
backups running. When we do the database backup it takes about 8 to 9 hours
to
complete after it does all the deletions of images etc.. WE are using NBU
3.4
running on Solaris 2.8.

Thanks

Brian


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
<http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu> 



------_=_NextPart_001_01C1450F.4B6794B0
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 5.50.4616.200" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV><FONT size=1>
<DIV><SPAN class=877450215-24092001>
<DIV><SPAN class=877450215-24092001><FONT face=Courier><FONT size=2><SPAN 
class=535113515-24092001>Folks,</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=877450215-24092001><FONT face=Courier><FONT size=2><SPAN 
class=535113515-24092001></SPAN></FONT></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=877450215-24092001><FONT face=Courier><FONT size=2><SPAN 
class=535113515-24092001>Sorry............need to change this.&nbsp; 
:)</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=877450215-24092001><FONT face=Courier><FONT size=2><SPAN 
class=535113515-24092001></SPAN></FONT></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=877450215-24092001><FONT face=Courier><FONT size=2><SPAN 
class=535113515-24092001>&nbsp;&nbsp;&nbsp; 
Leo</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=877450215-24092001><FONT face=Courier><FONT size=2><SPAN 
class=535113515-24092001></SPAN></FONT></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=877450215-24092001><FONT face=Courier><FONT size=2><SPAN 
class=535113515-24092001>1</SPAN>)&nbsp;<SPAN class=535113515-24092001>When 
backups&nbsp;finish, i</SPAN><SPAN class=535113515-24092001>nitiate</SPAN> 
multiple concurrent backups to pick up</FONT></FONT></SPAN></DIV>
<DIV><FONT face=Courier><FONT size=2><SPAN 
class=877450215-24092001>&nbsp;&nbsp;&nbsp;<SPAN 
class=535113515-24092001>backup 
</SPAN><SPAN class=535113515-24092001>client </SPAN></SPAN><SPAN 
class=877450215-24092001>databases&nbsp;<SPAN class=535113515-24092001>other 
than /usr/openv/netbackup/db/images/&lt;master &amp; media 
servers&gt;.</SPAN></SPAN></FONT></FONT></DIV></SPAN></DIV>
<DIV><SPAN class=877450215-24092001><FONT face=Courier><FONT size=2><SPAN 
class=535113515-24092001>2</SPAN>)&nbsp;<SPAN class=535113515-24092001>Follow 
with </SPAN>NetBackup database backup that includes 
only</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>&nbsp;&nbsp; 
/usr/openv/netbackup/db/images/&lt;master &amp; media 
servers&gt;.</FONT></SPAN></DIV></FONT></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> Labonte, L R (Leo), SITS 
  <BR><B>Sent:</B> Monday, September 24, 2001 11:23 AM<BR><B>To:</B> 'Scott 
  Jacobson'; veritas-bu AT mailman.eng.auburn DOT edu; 
  Brian_Drager AT vanguard DOT com<BR><B>Subject:</B> RE: [Veritas-bu] Database 
  Backup<BR><BR></FONT></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier 
  size=2>Folks,</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>Here's a brain 
  storm.&nbsp; It may be possible to use a tiered approach</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>with concurrent 
  backups </FONT></SPAN><SPAN class=877450215-24092001><FONT face=Courier 
  size=2>to resolve this problem.&nbsp; When backups 
  complete,</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>initiate this 
  sort of backup:</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>1) NetBackup 
  database backup that includes only</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>&nbsp;&nbsp; 
  /usr/openv/netbackup/db/images/&lt;master &amp; media 
  servers&gt;.</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>2) At the same 
  time initiate multiple concurrent backups to pick up</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>&nbsp;&nbsp; 
all 
  other&nbsp;</FONT></SPAN><SPAN class=877450215-24092001><FONT face=Courier 
  size=2>databases in /images directory.</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>To 
  recover:</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>1) Use 
bprecover 
  to restore master and media servers.</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>2) Once master 
  and media servers are recovered, then use&nbsp;NetBackup</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier 
  size=2>&nbsp;&nbsp;&nbsp;to </FONT></SPAN><SPAN 
class=877450215-24092001><FONT 
  face=Courier size=2>recover backup client </FONT></SPAN><SPAN 
  class=877450215-24092001><FONT face=Courier size=2>databases with multiple 
  concurrent jobs.</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>This prevents 
  overflowing the NetBackup database tape and speeds up</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier size=2>NetBackup 
  </FONT></SPAN><SPAN class=877450215-24092001><FONT face=Courier 
  size=2>database backups </FONT></SPAN><SPAN class=877450215-24092001><FONT 
  face=Courier size=2>and restores.</FONT></SPAN></DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=877450215-24092001><FONT face=Courier 
  size=2>&nbsp;&nbsp;&nbsp; Leo</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> Scott Jacobson 
    [mailto:SJACOBSO AT novell DOT com]<BR><B>Sent:</B> Friday, September 21, 
2001 
    12:20 PM<BR><B>To:</B> veritas-bu AT mailman.eng.auburn DOT edu; 
    Brian_Drager AT vanguard DOT com<BR><B>Subject:</B> Re: [Veritas-bu] 
Database 
    Backup<BR><BR></FONT></DIV>
    <DIV><FONT size=2>Brian,</FONT></DIV>
    <DIV><FONT size=2></FONT>&nbsp;</DIV>
    <DIV><FONT size=2>We are facing the same issue and will resolve it (in our 
    case) by implementing Compaq's Enterprise Volume Manager.&nbsp; Simply a 
    hardware based solution using a SAN that will snap the NetBackup database 
    from one lun to another.&nbsp; We will then additionally backup the snapped 
    database.</FONT></DIV>
    <DIV><FONT size=2></FONT>&nbsp;</DIV>
    <DIV><FONT size=2>Scott J.</FONT><BR><BR>&gt;&gt;&gt; &lt;<A 
    href="mailto:Brian_Drager AT vanguard DOT com">Brian_Drager AT vanguard DOT 
com</A>&gt; 
    09/21/01 06:24AM &gt;&gt;&gt;<BR>Our NetBackup database file system is over 
    100GB. Is their a faster way of<BR>running database backup? WE can only run 
    it once a week because we always have<BR>backups running. When we do the 
    database backup it takes about 8 to 9 hours to<BR>complete after it does 
all 
    the deletions of images etc.. WE are using NBU 3.4<BR>running on Solaris 
    
2.8.<BR><BR>Thanks<BR><BR>Brian<BR><BR><BR>_______________________________________________<BR>Veritas-bu
 
    maillist&nbsp; -&nbsp; Veritas-bu AT mailman.eng.auburn DOT edu<BR><A 
    
href="http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu";>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu</A><BR></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C1450F.4B6794B0--

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