Veritas-bu

[Veritas-bu] EMC BCV Question

2002-10-30 14:06:46
Subject: [Veritas-bu] EMC BCV Question
From: Mark.Donaldson AT experianems DOT com (Donaldson, Mark)
Date: Wed, 30 Oct 2002 12:06:46 -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_01C28047.7DBB3790
Content-Type: text/plain;
        charset="iso-8859-1"

I've append a previous posting I did earlier on this subject.  

Yes, the BCV image can used for recovery to a later point in time, you just
have to have the archived redo & redo logs handy.  I backup mine hourly to
tape anticipating a big disaster.  

I don't agree with the idea that you shouldn't put the Oracle DB in
hot-backup mode.  Being in hot backup mode guarantees consistency across
data files.  It just seems safe to do so.  You should check with a DBA on
this.  The good news is that the DB only has to be in Hot backup mode for
minutes, just long enough to snap the BCV's.  The redo activity for such a
short period might be negligible.  

Anyway, here's my previous posting on this subject.  EMC has a white paper
on this, too, you should ask your rep to dig it up for you.

-Mark
-----------------
I backup EMC BCV's now.

Currently, I have a ~300M database that is on an EMC 3830.  Each standard
mirror for the data disks has an associated BCV.  These BCV's are not
visible (via port mapping) to the same host that can "see" the Standards.
In other words, when my BCV's are split, those luns are not visible to my
database box.  They are visible, however, to my backup server.  Once I split
the BCV's, I then import the disk group to my backup box, start the volumes,
fsck, & mount the filesystems.  I then just do an ordinary file backup to
tape. 

The fine detail order looks like this:

To start the backup process (part of a bpstart_notify process):
1. Backup Oracle Controlfile to trace
2. Place Oracle tablespaces in Hotbackup mode
3. Split BCV's for data volumes only.
4. End Hotbackup mode for tablespaces
5. Split BCV's associated with Oracle archived redo
6. vxdctl enable on backup server (unnecessary on some
   servers - I think it's scsi chipset on controller)
7. import (with "Clear") the disk groups for data and
   archived redo (vxdg -C import <dgname>) on backup
   server.  The volumes, plexes, & subdisk config
   comes along for the ride on the import.
8. recover the volumes (vxrecover -g <dgname> -sv)
9. start the volumes (vxvol -g <dgname> startall)
10. fsck the volumes
11. mount them locally on the backup box for simple file
    backup to tape.

To reverse this after backup (bpend_notify):
1. unmount the filesystems
2. stop the volumes ( vxvol -g <dgname> stopall )
3. deport the disk groups ( vxdg deport <dgname> )
4. Establish the BCV's

Let me know if you want more

-----Original Message-----
From: Lee, Kenneth [mailto:Kenneth.Lee AT sbs.siemens DOT com]
Sent: Wednesday, October 30, 2002 10:01 AM
To: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: [Veritas-bu] EMC BCV Question


First let me apologize for asking this question as it is only somewhat
related to NB.  We are in the process of implementing EMC BCV to backing up
an Oracle database (500GB).  I was told that you could create a BCV while
Oracle is live (no shutdown or hot backup mode required) and I agree with
this statement.  What I am not sure of is can you roll-forward with this
BCV.  For example, at 1:00, you snap your BCV and the production Oracle
continues to run (no stoppage).  At 4:00, something bad happens to
production Oracle.  You restore your BCV on top of production, can you
roll-forward the production logs up to 4:00?  The reason I am puzzle is
because when you snap the BCV at 1:00, the Oracle database (BCV) is
startable but will go into recovery mode.  It will rollback in-flight
transactions.  Can you apply the production logs to this database to bring
it to 4:00?

Thanks,
Ken

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

------_=_NextPart_001_01C28047.7DBB3790
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: [Veritas-bu] EMC BCV Question</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>I've append a previous posting I did earlier on this =
subject.&nbsp; </FONT>
</P>

<P><FONT SIZE=3D2>Yes, the BCV image can used for recovery to a later =
point in time, you just have to have the archived redo &amp; redo logs =
handy.&nbsp; I backup mine hourly to tape anticipating a big =
disaster.&nbsp; </FONT></P>

<P><FONT SIZE=3D2>I don't agree with the idea that you shouldn't put =
the Oracle DB in hot-backup mode.&nbsp; Being in hot backup mode =
guarantees consistency across data files.&nbsp; It just seems safe to =
do so.&nbsp; You should check with a DBA on this.&nbsp; The good news =
is that the DB only has to be in Hot backup mode for minutes, just long =
enough to snap the BCV's.&nbsp; The redo activity for such a short =
period might be negligible.&nbsp; </FONT></P>

<P><FONT SIZE=3D2>Anyway, here's my previous posting on this =
subject.&nbsp; EMC has a white paper on this, too, you should ask your =
rep to dig it up for you.</FONT></P>

<P><FONT SIZE=3D2>-Mark</FONT>
<BR><FONT SIZE=3D2>-----------------</FONT>
<BR><FONT SIZE=3D2>I backup EMC BCV's now.</FONT>
</P>

<P><FONT SIZE=3D2>Currently, I have a ~300M database that is on an EMC =
3830.&nbsp; Each standard mirror for the data disks has an associated =
BCV.&nbsp; These BCV's are not visible (via port mapping) to the same =
host that can &quot;see&quot; the Standards.&nbsp; In other words, when =
my BCV's are split, those luns are not visible to my database =
box.&nbsp; They are visible, however, to my backup server.&nbsp; Once I =
split the BCV's, I then import the disk group to my backup box, start =
the volumes, fsck, &amp; mount the filesystems.&nbsp; I then just do an =
ordinary file backup to tape. </FONT></P>

<P><FONT SIZE=3D2>The fine detail order looks like this:</FONT>
</P>

<P><FONT SIZE=3D2>To start the backup process (part of a bpstart_notify =
process):</FONT>
<BR><FONT SIZE=3D2>1. Backup Oracle Controlfile to trace</FONT>
<BR><FONT SIZE=3D2>2. Place Oracle tablespaces in Hotbackup mode</FONT>
<BR><FONT SIZE=3D2>3. Split BCV's for data volumes only.</FONT>
<BR><FONT SIZE=3D2>4. End Hotbackup mode for tablespaces</FONT>
<BR><FONT SIZE=3D2>5. Split BCV's associated with Oracle archived =
redo</FONT>
<BR><FONT SIZE=3D2>6. vxdctl enable on backup server (unnecessary on =
some</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; servers - I think it's scsi chipset on =
controller)</FONT>
<BR><FONT SIZE=3D2>7. import (with &quot;Clear&quot;) the disk groups =
for data and</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; archived redo (vxdg -C import =
&lt;dgname&gt;) on backup</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; server.&nbsp; The volumes, plexes, =
&amp; subdisk config</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; comes along for the ride on the =
import.</FONT>
<BR><FONT SIZE=3D2>8. recover the volumes (vxrecover -g &lt;dgname&gt; =
-sv)</FONT>
<BR><FONT SIZE=3D2>9. start the volumes (vxvol -g &lt;dgname&gt; =
startall)</FONT>
<BR><FONT SIZE=3D2>10. fsck the volumes</FONT>
<BR><FONT SIZE=3D2>11. mount them locally on the backup box for simple =
file</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; backup to tape.</FONT>
</P>

<P><FONT SIZE=3D2>To reverse this after backup (bpend_notify):</FONT>
<BR><FONT SIZE=3D2>1. unmount the filesystems</FONT>
<BR><FONT SIZE=3D2>2. stop the volumes ( vxvol -g &lt;dgname&gt; =
stopall )</FONT>
<BR><FONT SIZE=3D2>3. deport the disk groups ( vxdg deport =
&lt;dgname&gt; )</FONT>
<BR><FONT SIZE=3D2>4. Establish the BCV's</FONT>
</P>

<P><FONT SIZE=3D2>Let me know if you want more</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Lee, Kenneth [<A =
HREF=3D"mailto:Kenneth.Lee AT sbs.siemens DOT com">mailto:[email protected]=
ns.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, October 30, 2002 10:01 AM</FONT>
<BR><FONT SIZE=3D2>To: 'veritas-bu AT mailman.eng.auburn DOT edu'</FONT>
<BR><FONT SIZE=3D2>Subject: [Veritas-bu] EMC BCV Question</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>First let me apologize for asking this question as it =
is only somewhat</FONT>
<BR><FONT SIZE=3D2>related to NB.&nbsp; We are in the process of =
implementing EMC BCV to backing up</FONT>
<BR><FONT SIZE=3D2>an Oracle database (500GB).&nbsp; I was told that =
you could create a BCV while</FONT>
<BR><FONT SIZE=3D2>Oracle is live (no shutdown or hot backup mode =
required) and I agree with</FONT>
<BR><FONT SIZE=3D2>this statement.&nbsp; What I am not sure of is can =
you roll-forward with this</FONT>
<BR><FONT SIZE=3D2>BCV.&nbsp; For example, at 1:00, you snap your BCV =
and the production Oracle</FONT>
<BR><FONT SIZE=3D2>continues to run (no stoppage).&nbsp; At 4:00, =
something bad happens to</FONT>
<BR><FONT SIZE=3D2>production Oracle.&nbsp; You restore your BCV on top =
of production, can you</FONT>
<BR><FONT SIZE=3D2>roll-forward the production logs up to 4:00?&nbsp; =
The reason I am puzzle is</FONT>
<BR><FONT SIZE=3D2>because when you snap the BCV at 1:00, the Oracle =
database (BCV) is</FONT>
<BR><FONT SIZE=3D2>startable but will go into recovery mode.&nbsp; It =
will rollback in-flight</FONT>
<BR><FONT SIZE=3D2>transactions.&nbsp; Can you apply the production =
logs to this database to bring</FONT>
<BR><FONT SIZE=3D2>it to 4:00?</FONT>
</P>

<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Ken</FONT>
</P>

<P><FONT =
SIZE=3D2>_______________________________________________</FONT>
<BR><FONT SIZE=3D2>Veritas-bu maillist&nbsp; -&nbsp; =
Veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu"; =
TARGET=3D"_blank">http://mailman.eng.auburn.edu/mailman/listinfo/veritas=
-bu</A></FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C28047.7DBB3790--

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