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_01C1CC70.8C100C70
Content-Type: text/plain;
charset="iso-8859-1"
Michael,
There's two ways to do a hot backup of Oracle that I'm aware of (I'm also a
SE, not a DBA so there may be more).
1. Use Oracle RMAN - you'll be using Netbackup as little more than a media
server for this. This requires a expensive per-oracle-client license for
NB.
2. What we do, because of oracle complexity and license expense, is what we
call a "rolling hot backup".
a. Query the database for all tablespace names
b. For each tablespace, in sequence
1. query oracle for datafiles related to the tablespace (place in a
file)
2. place tablespace in hot-backup mode
3. use bpbackup to send the list of datafiles to netbackup
4. remove tablespace from hot-backup mode
5. loop for next tablespace.
c. Alter control file to trace and send that file via bpbackup, too.
d. Roll the redo logs.
e. Send relavent archived redo log files, this is the set that starts from
just before the first tablespace is put into HB mode up to and including the
last one that results from rolling the redo logs.
This makes a whole bunch of images, one per tablespace, that represents a
single backup of the entire database. To track these as a set, we tie them
together with a keyword based on backup date & instance name.
Restoring is a bitch, compared to a cold backup, because there's a lot of
redo logs to apply to get to a time-consistent image but it does work.
Hope this helps.
-Mark Donaldson
Sr. Systems Engineer - Experian EMS
-----Original Message-----
From: Day, Michael [mailto:MDay AT qrs DOT com]
Sent: Friday, March 15, 2002 2:15 PM
To: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: [Veritas-bu] Oracle Backups on a cluster
I need some assistance with an Oracle backup on a Microsoft Cluster server.
Veritas tech support said I needed to get Veritas Consulting involved but
I'm hoping I don't have to go that route and will be able to get some help
from the vast array of talent available from this forum.
I was not able to understand the problem when our in-house Oracle DBA
explained it to me since we talk a different language. He's a database only
guy and I'm a system's engineer with no knowledge of oracle databases. I
think I understand it a little better now.
Here's the problem as described by the Veritas tech support technician:
"David (the DBA) is using Oracle 9i with Oracle FailSafe (Clustering) and
also using Microsoft Clustering. David is trying to perform 2 things. 1) He
has the CAT DB of each server running on the opposite server. For high
availability, this is a good thing. He wants to back it up so how. 2) He is
trying to perform a cold backup, which of course requires the DB to be shut
down. The problem he has here is that the other node in the cluster sees
that the partner server's DB just went down; Oracle FailSafe Clustering
performing as it should, tries to start the db on itself.
Does anyone have any scripts that will help in this situation?
Michael H. Day
QRS Systems Engineer
MCSE, MCP +I, A+
QRS Corporation
1400 Marina Way South
Richmond, Ca 94804
Office (510) 965-4417
Pager (510) 264-2546
Cell (510) 812-4953
Fax (510) 621-4417
mailto:mday AT qrs DOT com
http://www.qrs.com
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
------_=_NextPart_001_01C1CC70.8C100C70
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] Oracle Backups on a cluster</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Michael,</FONT>
<BR><FONT SIZE=3D2>There's two ways to do a hot backup of Oracle that =
I'm aware of (I'm also a SE, not a DBA so there may be more).</FONT>
</P>
<P><FONT SIZE=3D2>1. Use Oracle RMAN - you'll be using Netbackup as =
little more than a media server for this. This requires a =
expensive per-oracle-client license for NB. </FONT></P>
<P><FONT SIZE=3D2>2. What we do, because of oracle complexity and =
license expense, is what we call a "rolling hot =
backup". </FONT>
<BR><FONT SIZE=3D2> a. Query the database for all tablespace =
names </FONT>
<BR><FONT SIZE=3D2> b. For each tablespace, in sequence</FONT>
<BR><FONT SIZE=3D2> 1. query oracle for =
datafiles related to the tablespace (place in a file)</FONT>
<BR><FONT SIZE=3D2> 2. place tablespace in =
hot-backup mode</FONT>
<BR><FONT SIZE=3D2> 3. use bpbackup to send the =
list of datafiles to netbackup</FONT>
<BR><FONT SIZE=3D2> 4. remove tablespace from =
hot-backup mode</FONT>
<BR><FONT SIZE=3D2> 5. loop for next =
tablespace.</FONT>
<BR><FONT SIZE=3D2> c. Alter control file to trace and send that =
file via bpbackup, too.</FONT>
<BR><FONT SIZE=3D2> d. Roll the redo logs.</FONT>
<BR><FONT SIZE=3D2> e. Send relavent archived redo log files, =
this is the set that starts from just before the first tablespace is =
put into HB mode up to and including the last one that results from =
rolling the redo logs.</FONT></P>
<P><FONT SIZE=3D2>This makes a whole bunch of images, one per =
tablespace, that represents a single backup of the entire =
database. To track these as a set, we tie them together with a =
keyword based on backup date & instance name.</FONT></P>
<P><FONT SIZE=3D2>Restoring is a bitch, compared to a cold backup, =
because there's a lot of redo logs to apply to get to a time-consistent =
image but it does work.</FONT></P>
<P><FONT SIZE=3D2>Hope this helps.</FONT>
</P>
<P><FONT SIZE=3D2>-Mark Donaldson</FONT>
<BR><FONT SIZE=3D2>Sr. Systems Engineer - Experian EMS</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Day, Michael [<A =
HREF=3D"mailto:MDay AT qrs DOT com">mailto:MDay AT qrs DOT com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, March 15, 2002 2:15 PM</FONT>
<BR><FONT SIZE=3D2>To: 'veritas-bu AT mailman.eng.auburn DOT edu'</FONT>
<BR><FONT SIZE=3D2>Subject: [Veritas-bu] Oracle Backups on a =
cluster</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>I need some assistance with an Oracle backup on a =
Microsoft Cluster server.</FONT>
<BR><FONT SIZE=3D2>Veritas tech support said I needed to get Veritas =
Consulting involved but</FONT>
<BR><FONT SIZE=3D2>I'm hoping I don't have to go that route and will be =
able to get some help</FONT>
<BR><FONT SIZE=3D2>from the vast array of talent available from this =
forum.</FONT>
</P>
<P><FONT SIZE=3D2>I was not able to understand the problem when our =
in-house Oracle DBA</FONT>
<BR><FONT SIZE=3D2>explained it to me since we talk a different =
language. He's a database only</FONT>
<BR><FONT SIZE=3D2>guy and I'm a system's engineer with no knowledge of =
oracle databases. I</FONT>
<BR><FONT SIZE=3D2>think I understand it a little better now.</FONT>
</P>
<P><FONT SIZE=3D2>Here's the problem as described by the Veritas tech =
support technician:</FONT>
<BR><FONT SIZE=3D2>"David (the DBA) is using Oracle 9i with Oracle =
FailSafe (Clustering) and</FONT>
<BR><FONT SIZE=3D2>also using Microsoft Clustering. David is trying to =
perform 2 things. 1) He</FONT>
<BR><FONT SIZE=3D2>has the CAT DB of each server running on the =
opposite server. For high</FONT>
<BR><FONT SIZE=3D2>availability, this is a good thing. He wants =
to back it up so how. 2) He is</FONT>
<BR><FONT SIZE=3D2>trying to perform a cold backup, which of course =
requires the DB to be shut</FONT>
<BR><FONT SIZE=3D2>down. The problem he has here is that the other node =
in the cluster sees</FONT>
<BR><FONT SIZE=3D2>that the partner server's DB just went down; Oracle =
FailSafe Clustering</FONT>
<BR><FONT SIZE=3D2>performing as it should, tries to start the db on =
itself.</FONT>
</P>
<P><FONT SIZE=3D2>Does anyone have any scripts that will help in this =
situation?</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Michael H. Day</FONT>
<BR><FONT SIZE=3D2>QRS Systems Engineer</FONT>
<BR><FONT SIZE=3D2>MCSE, MCP +I, A+</FONT>
</P>
<P><FONT SIZE=3D2>QRS Corporation </FONT>
<BR><FONT SIZE=3D2>1400 Marina Way South</FONT>
<BR><FONT SIZE=3D2>Richmond, Ca 94804</FONT>
</P>
<P><FONT SIZE=3D2>Office (510) 965-4417</FONT>
<BR><FONT SIZE=3D2>Pager (510) 264-2546</FONT>
<BR><FONT SIZE=3D2>Cell (510) 812-4953</FONT>
<BR><FONT SIZE=3D2>Fax (510) 621-4417</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"mailto:mday AT qrs DOT com">mailto:mday AT qrs DOT com</A></FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://www.qrs.com"; =
TARGET=3D"_blank">http://www.qrs.com</A></FONT>
</P>
<BR>
<BR>
<BR>
<P><FONT =
SIZE=3D2>_______________________________________________</FONT>
<BR><FONT SIZE=3D2>Veritas-bu maillist - =
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_01C1CC70.8C100C70--
|
