|
[Veritas-bu] Database Backup
2001-09-24 13:12:53
|
Subject: |
[Veritas-bu] Database Backup |
|
From: |
Bob Bakh" <bob.bakh AT home DOT com (Bob Bakh) |
|
Date: |
Mon, 24 Sep 2001 10:12:53 -0700 |
This is a multi-part message in MIME format.
------=_NextPart_000_0009_01C144E1.79095670
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
You will also need the directories bellow db
the best thing to do is a backup of the /images directory with an =
exclude of the master during the day when no other jobs are running.
Then do a NBU database backup of all the directories under db, except =
images where you only backup the master's directory under images. And =
don't forget /usr/openv/volmgr/database on the master and media servers.
That should still give you pretty good performance.
You can even get tricky and make the backup job multi streamed and =
backup /usr/openv/netbackup/db/* to get an independent stream per =
directory.
Bob
----- Original Message -----=20
From: Labonte, L R (Leo), SITS=20
To: Scott Jacobson ; veritas-bu AT mailman.eng.auburn DOT edu ; =
Brian_Drager AT vanguard DOT com=20
Sent: Monday, September 24, 2001 8:40 AM
Subject: RE: [Veritas-bu] Database Backup
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=20
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> 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
------=_NextPart_000_0009_01C144E1.79095670
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style=3D"MARGIN-TOP: 2px; FONT: 8pt MS Sans Serif; MARGIN-LEFT: =
2px"=20
bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>You will also need the directories =
bellow=20
db</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>the best thing to do is a backup of the =
/images=20
directory with an exclude of the master during the day when no other =
jobs are=20
running.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Then do a NBU database backup of all =
the=20
directories under db, except images where you only backup the master's =
directory=20
under images. And don't forget /usr/openv/volmgr/database on the =
master=20
and media servers.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>That should still give you pretty good=20
performance.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>You can even get tricky and make the =
backup job=20
multi streamed and backup /usr/openv/netbackup/db/* to get an =
independent stream=20
per directory.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Bob</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Dllabonte AT att DOT com href=3D"mailto:llabonte AT att DOT
com">Labonte, =
L R (Leo),=20
SITS</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3DSJACOBSO AT novell DOT com=20
href=3D"mailto:SJACOBSO AT novell DOT com">Scott Jacobson</A> ; <A=20
title=3Dveritas-bu AT mailman.eng.auburn DOT edu=20
=
href=3D"mailto:veritas-bu AT mailman.eng.auburn DOT edu">veritas-bu AT mailman
DOT eng.=
auburn.edu</A>=20
; <A title=3DBrian_Drager AT vanguard DOT com=20
=
href=3D"mailto:Brian_Drager AT vanguard DOT com">Brian_Drager AT vanguard DOT
com</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, September 24, =
2001 8:40=20
AM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: [Veritas-bu] =
Database=20
Backup</DIV>
<DIV><BR></DIV>
<DIV><FONT size=3D1>
<DIV><SPAN class=3D877450215-24092001>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier><FONT =
size=3D2><SPAN=20
class=3D535113515-24092001>Folks,</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier><FONT =
size=3D2><SPAN=20
class=3D535113515-24092001></SPAN></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier><FONT =
size=3D2><SPAN=20
class=3D535113515-24092001>Sorry............need to change this. =
:)</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier><FONT =
size=3D2><SPAN=20
class=3D535113515-24092001></SPAN></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier><FONT =
size=3D2><SPAN=20
class=3D535113515-24092001> =20
Leo</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier><FONT =
size=3D2><SPAN=20
class=3D535113515-24092001></SPAN></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier><FONT =
size=3D2><SPAN=20
class=3D535113515-24092001>1</SPAN>) <SPAN =
class=3D535113515-24092001>When=20
backups finish, i</SPAN><SPAN =
class=3D535113515-24092001>nitiate</SPAN>=20
multiple concurrent backups to pick up</FONT></FONT></SPAN></DIV>
<DIV><FONT face=3DCourier><FONT size=3D2><SPAN=20
class=3D877450215-24092001> <SPAN=20
class=3D535113515-24092001>backup </SPAN><SPAN =
class=3D535113515-24092001>client=20
</SPAN></SPAN><SPAN class=3D877450215-24092001>databases <SPAN=20
class=3D535113515-24092001>other than =
/usr/openv/netbackup/db/images/<master=20
& media =
servers>.</SPAN></SPAN></FONT></FONT></DIV></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier><FONT =
size=3D2><SPAN=20
class=3D535113515-24092001>2</SPAN>) <SPAN =
class=3D535113515-24092001>Follow=20
with </SPAN>NetBackup database backup that includes=20
only</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2> =20
/usr/openv/netbackup/db/images/<master & media=20
servers>.</FONT></SPAN></DIV></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Labonte, L R =
(Leo), SITS=20
<BR><B>Sent:</B> Monday, September 24, 2001 11:23 AM<BR><B>To:</B> =
'Scott=20
Jacobson'; <A=20
=
href=3D"mailto:veritas-bu AT mailman.eng.auburn DOT edu">veritas-bu AT mailman
DOT eng.=
auburn.edu</A>;=20
Brian_Drager AT vanguard DOT com<BR><B>Subject:</B> RE: [Veritas-bu] =
Database=20
Backup<BR><BR></FONT></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier=20
size=3D2>Folks,</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2>Here's a brain=20
storm. It may be possible to use a tiered =
approach</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2>with=20
concurrent backups </FONT></SPAN><SPAN =
class=3D877450215-24092001><FONT=20
face=3DCourier size=3D2>to resolve this problem. When backups=20
complete,</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2>initiate this=20
sort of backup:</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2>1) NetBackup=20
database backup that includes only</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2> =20
/usr/openv/netbackup/db/images/<master & media=20
servers>.</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2>2) At the same=20
time initiate multiple concurrent backups to pick =
up</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2> =20
all other </FONT></SPAN><SPAN class=3D877450215-24092001><FONT=20
face=3DCourier size=3D2>databases in /images =
directory.</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2>To=20
recover:</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2>1) Use=20
bprecover to restore master and media servers.</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2>2) Once master=20
and media servers are recovered, then =
use NetBackup</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier=20
size=3D2> to </FONT></SPAN><SPAN=20
class=3D877450215-24092001><FONT face=3DCourier size=3D2>recover =
backup client=20
</FONT></SPAN><SPAN class=3D877450215-24092001><FONT face=3DCourier=20
size=3D2>databases with multiple concurrent =
jobs.</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2>This prevents=20
overflowing the NetBackup database tape and speeds =
up</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier =
size=3D2>NetBackup=20
</FONT></SPAN><SPAN class=3D877450215-24092001><FONT face=3DCourier=20
size=3D2>database backups </FONT></SPAN><SPAN =
class=3D877450215-24092001><FONT=20
face=3DCourier size=3D2>and restores.</FONT></SPAN></DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D877450215-24092001><FONT face=3DCourier=20
size=3D2> Leo</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Scott Jacobson =
[mailto:SJACOBSO AT novell DOT com]<BR><B>Sent:</B> Friday, September 21,
=
2001=20
12:20 PM<BR><B>To:</B> veritas-bu AT mailman.eng.auburn DOT edu;=20
Brian_Drager AT vanguard DOT com<BR><B>Subject:</B> Re: [Veritas-bu] =
Database=20
Backup<BR><BR></FONT></DIV>
<DIV><FONT size=3D2>Brian,</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>We are facing the same issue and will resolve =
it (in our=20
case) by implementing Compaq's Enterprise Volume Manager. =
Simply a=20
hardware based solution using a SAN that will snap the NetBackup =
database=20
from one lun to another. We will then additionally backup =
the=20
snapped database.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Scott J.</FONT><BR><BR>>>> <<A=20
=
href=3D"mailto:Brian_Drager AT vanguard DOT com">Brian_Drager AT vanguard DOT
com</A>&g=
t;=20
09/21/01 06:24AM >>><BR>Our NetBackup database file =
system is=20
over 100GB. Is their a faster way of<BR>running database backup? =
WE can=20
only run it once a week because we always have<BR>backups running. =
When we=20
do the database backup it takes about 8 to 9 hours to<BR>complete =
after it=20
does all the deletions of images etc.. WE are using NBU =
3.4<BR>running on=20
Solaris=20
=
2.8.<BR><BR>Thanks<BR><BR>Brian<BR><BR><BR>______________________________=
_________________<BR>Veritas-bu=20
maillist - Veritas-bu AT mailman.eng.auburn DOT edu<BR><A=20
=
href=3D"http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu";>http:/=
/mailman.eng.auburn.edu/mailman/listinfo/veritas-bu</A><BR></DIV></BLOCKQ=
UOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0009_01C144E1.79095670--
|
| <Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Veritas-bu] Database Backup, Brian_Drager AT Vanguard DOT com
- [Veritas-bu] Database Backup, RYAN_ANDERSON AT udlp DOT com
- [Veritas-bu] Database Backup, Tim McMurphy
- [Veritas-bu] Database Backup, Scott Jacobson
- [Veritas-bu] Database Backup, Labonte, L R (Leo), SITS
- [Veritas-bu] Database Backup, Labonte, L R (Leo), SITS
- [Veritas-bu] Database Backup,
<bob.bakh AT home DOT com (Bob Bakh) <=
|
|
|
