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_01C1CECA.558BDE70
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 7bit
Thanks Mark but what we want to do is a cold backup.
-----Original Message-----
From: Donaldson, Mark [mailto:Mark.Donaldson AT experianems DOT com]
Sent: Friday, March 15, 2002 2:27 PM
To: Day, Michael; 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: RE: [Veritas-bu] Oracle Backups on a cluster
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 <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 <mailto:mday AT qrs DOT com>
http://www.qrs.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
<http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu>
------_=_NextPart_001_01C1CECA.558BDE70
Content-Type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: [Veritas-bu] Oracle Backups on a cluster</TITLE>
<META content="MSHTML 5.50.4913.1100" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=509211522-18032002><FONT face="Comic Sans MS" color=#0000ff
size=2>Thanks Mark but what we want to do is a cold backup.</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> Donaldson, Mark
[mailto:Mark.Donaldson AT experianems DOT com]<BR><B>Sent:</B> Friday, March
15, 2002
2:27 PM<BR><B>To:</B> Day, Michael;
'veritas-bu AT mailman.eng.auburn DOT edu'<BR><B>Subject:</B> RE:
[Veritas-bu] Oracle
Backups on a cluster<BR><BR></FONT></DIV>
<P><FONT size=2>Michael,</FONT> <BR><FONT size=2>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=2>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=2>2. What we do, because of oracle complexity and license
expense, is what we call a "rolling hot backup". </FONT><BR><FONT
size=2> a. Query the database for all tablespace names </FONT><BR><FONT
size=2> b. For each tablespace, in sequence</FONT> <BR><FONT
size=2> 1. query oracle for datafiles related to the
tablespace (place in a file)</FONT> <BR><FONT size=2>
2. place tablespace in hot-backup mode</FONT> <BR><FONT
size=2> 3. use bpbackup to send the list of datafiles
to netbackup</FONT> <BR><FONT size=2> 4. remove
tablespace from hot-backup mode</FONT> <BR><FONT
size=2> 5. loop for next tablespace.</FONT> <BR><FONT
size=2> c. Alter control file to trace and send that file via bpbackup,
too.</FONT> <BR><FONT size=2> d. Roll the redo logs.</FONT> <BR><FONT
size=2> 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=2>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=2>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=2>Hope this helps.</FONT> </P>
<P><FONT size=2>-Mark Donaldson</FONT> <BR><FONT size=2>Sr. Systems Engineer
-
Experian EMS</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Day,
Michael [<A href="mailto:MDay AT qrs DOT com">mailto:MDay AT qrs DOT
com</A>]</FONT>
<BR><FONT size=2>Sent: Friday, March 15, 2002 2:15 PM</FONT> <BR><FONT
size=2>To: 'veritas-bu AT mailman.eng.auburn DOT edu'</FONT> <BR><FONT
size=2>Subject: [Veritas-bu] Oracle Backups on a cluster</FONT> </P><BR>
<P><FONT size=2>I need some assistance with an Oracle backup on a Microsoft
Cluster server.</FONT> <BR><FONT size=2>Veritas tech support said I needed to
get Veritas Consulting involved but</FONT> <BR><FONT size=2>I'm hoping I
don't
have to go that route and will be able to get some help</FONT> <BR><FONT
size=2>from the vast array of talent available from this forum.</FONT> </P>
<P><FONT size=2>I was not able to understand the problem when our in-house
Oracle DBA</FONT> <BR><FONT size=2>explained it to me since we talk a
different language. He's a database only</FONT> <BR><FONT size=2>guy
and
I'm a system's engineer with no knowledge of oracle databases. I</FONT>
<BR><FONT size=2>think I understand it a little better now.</FONT> </P>
<P><FONT size=2>Here's the problem as described by the Veritas tech support
technician:</FONT> <BR><FONT size=2>"David (the DBA) is using Oracle 9i with
Oracle FailSafe (Clustering) and</FONT> <BR><FONT size=2>also using Microsoft
Clustering. David is trying to perform 2 things. 1) He</FONT> <BR><FONT
size=2>has the CAT DB of each server running on the opposite server. For
high</FONT> <BR><FONT size=2>availability, this is a good thing. He
wants to back it up so how. 2) He is</FONT> <BR><FONT size=2>trying to
perform
a cold backup, which of course requires the DB to be shut</FONT> <BR><FONT
size=2>down. The problem he has here is that the other node in the
cluster sees</FONT> <BR><FONT size=2>that the partner server's DB just went
down; Oracle FailSafe Clustering</FONT> <BR><FONT size=2>performing as it
should, tries to start the db on itself.</FONT> </P>
<P><FONT size=2>Does anyone have any scripts that will help in this
situation?</FONT> </P><BR>
<P><FONT size=2>Michael H. Day</FONT> <BR><FONT size=2>QRS Systems
Engineer</FONT> <BR><FONT size=2>MCSE, MCP +I, A+</FONT> </P>
<P><FONT size=2>QRS Corporation </FONT><BR><FONT size=2>1400 Marina Way
South</FONT> <BR><FONT size=2>Richmond, Ca 94804</FONT> </P>
<P><FONT size=2>Office (510) 965-4417</FONT> <BR><FONT size=2>Pager (510)
264-2546</FONT> <BR><FONT size=2>Cell (510) 812-4953</FONT> <BR><FONT
size=2>Fax (510) 621-4417</FONT> <BR><FONT size=2><A
href="mailto:mday AT qrs DOT com">mailto:mday AT qrs DOT com</A></FONT>
<BR><FONT size=2><A
target=_blank href="http://www.qrs.com">http://www.qrs.com</A></FONT>
</P><BR><BR><BR>
<P><FONT size=2>_______________________________________________</FONT>
<BR><FONT size=2>Veritas-bu maillist -
Veritas-bu AT mailman.eng.auburn DOT edu</FONT> <BR><FONT size=2><A
target=_blank
href="http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu">http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu</A></FONT>
</P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C1CECA.558BDE70--
|