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_01C318B7.036ECA20
Content-Type: text/plain;
charset="iso-8859-1"
I've done this for Oracle using basically the same technique. YMMV with
informix but your idea seems sound.
Is your DB writing to raw disks now? If you're using a filesystem on your
data drives, you'll be ahead by backing up files & not raw disk. With raw
disk, you have to move every block, with filesystem you only move occupied
blocks.
For oracle, the technique I used was:
1. Place DB tablespaces in hot backup mode (quiesces the data drives)
2. split BCV's for data disks.
3. Put DB in run mode (non-hotbackup or whatever you call it)
4. Roll the redo logs (write active redo to archived redo & start a new log)
5. split the archived-redo disks
6. mount data & archived-redo BCV's on another server
7. back it up.
8. re-silver the BCV's (if you delay the silver, then you've got an
instantly restorable, on-disk backup, too.)
Check with EMC - they've got tons of whitepapers on BCV techniques for lots
of different products.
HTH - Mark
-----Original Message-----
From: Mark Eisenhardt [mailto:Mark.Eisenhardt AT hughessupply DOT com]
Sent: Monday, May 12, 2003 12:17 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Backing up Informix using NBU
Hi,
I'm hoping some of you have done this before.
I have EMC bcv's and Informix instance on a HP-UX system. I would like to
split the data base off and use NBU
to do a cold backup of the raw data residing on the bcv's.
If memory serves me correctly:
I would have to status the data base in Hot backup mode.
Stop writes to the instance, then split the bcv's
Resume writes to the instance
Take the database out of hot backup mode
Then use NBU to do a raw backup of the data
Anyone know if this is correct and will provide a valid backup?
The reason for this is we already have the bcv's and the cost of additional
Veritas licenses for the Informix piece
is not in the budget. We currently do a level zero to a stand alone DLT for
Informix and backup all mounted filesystems
with NBU. We would like to have NBU managing all the tapes and backups.
TIA
Mark Eisenhardt
Sr. UNIX Systems Administrator
Hughes Supply Inc
407.299.6573 ext. 5483
------_=_NextPart_001_01C318B7.036ECA20
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 5.50.4926.2500" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>I've
done this for Oracle using basically the same technique. YMMV with
informix but your idea seems sound.</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>Is
your DB writing to raw disks now? If you're using a filesystem on your
data drives, you'll be ahead by backing up files & not raw disk. With
raw disk, you have to move every block, with filesystem you only move occupied
blocks.</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>For
oracle, the technique I used was:</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>1.
Place DB tablespaces in hot backup mode (quiesces the data
drives)</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>2.
split BCV's for data disks.</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>3.
Put
DB in run mode (non-hotbackup or whatever you call it)</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>4.
Roll the redo logs (write active redo to archived redo & start a new
log)</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>5.
split the archived-redo disks</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>6.
mount data & archived-redo BCV's on another
server</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff
size=2>7. back it up.</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>8.
re-silver the BCV's (if you delay the silver, then you've got an instantly
restorable, on-disk backup, too.)</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>Check
with EMC - they've got tons of whitepapers on BCV techniques for lots of
different products.</FONT></SPAN></DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106494118-12052003><FONT face=Arial color=#0000ff size=2>HTH -
Mark</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> Mark Eisenhardt
[mailto:Mark.Eisenhardt AT hughessupply DOT com]<BR><B>Sent:</B> Monday, May
12, 2003
12:17 PM<BR><B>To:</B> veritas-bu AT mailman.eng.auburn DOT
edu<BR><B>Subject:</B>
[Veritas-bu] Backing up Informix using NBU<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=027163517-12052003>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>I'm hoping some
of
you have done this before.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>I have EMC bcv's
and Informix instance on a HP-UX system. I would like to split the data base
off and use NBU</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>to do a cold
backup of the raw data residing on the bcv's.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>If memory serves
me correctly:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>I would have to
status the data base in Hot backup mode.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>Stop writes to
the
instance, then split the bcv's</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>Resume writes to
the instance</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>Take the database
out of hot backup mode</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>Then use NBU to
do a raw backup of the data</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=027163517-12052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>Anyone know if
this is correct and will provide a valid backup?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=027163517-12052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>The reason for
this is we already have the bcv's and the cost of additional Veritas licenses
for the Informix piece</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>is not in the
budget. We currently do a level zero to a stand alone DLT for Informix and
backup all mounted filesystems</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=027163517-12052003>with NBU. We
would
like to have NBU managing all the tapes and backups. </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=027163517-12052003>TIA</SPAN></FONT></DIV>
<DIV>
<DIV class=MsoCaption align=left><SPAN
style="FONT-FAMILY: 'Matura MT Script Capitals'"><STRONG><FONT
face="Kunstler Script" color=#000080 size=5>Mark
Eisenhardt</FONT></STRONG></SPAN></DIV>
<DIV class=Section1 align=left><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Felix Titling'"><FONT
face="Arial Narrow" color=#800000 size=2><STRONG>Sr. UNIX Systems
Administrator</STRONG></FONT></SPAN></DIV>
<DIV class=Section1 align=left><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Felix Titling'"><STRONG><FONT
face="Arial Narrow" color=#0000ff size=3>Hughes Supply
Inc</FONT></STRONG></SPAN></DIV>
<DIV class=MsoNormal align=left><FONT face="Antique Olive"><FONT size=1><B
style="mso-bidi-font-weight: normal"><SPAN
style="FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Courier; mso-bidi-font-size:
7.5pt">407.299.6573
ext. 5483</SPAN></B></FONT><SPAN
style="FONT-SIZE: 9pt; COLOR: navy; mso-bidi-font-size: 12.0pt"><FONT
size=1> <o:p></o:p></FONT></SPAN></FONT></DIV>
<DIV class=MsoNormal align=left><FONT face=Arial size=2></FONT></DIV></DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C318B7.036ECA20--
|