Veritas-bu

[Veritas-bu] integrate shell script into netbackup policy sch edule

2003-03-13 11:13:13
Subject: [Veritas-bu] integrate shell script into netbackup policy sch edule
From: Mark.Donaldson AT experianems DOT com (Donaldson, Mark)
Date: Thu, 13 Mar 2003 09:13:13 -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_01C2E97B.72CBC000
Content-Type: text/plain;
        charset="iso-8859-1"

Be aware, a multi-stream backup will start multiple versions of the
bpstart/bpend scripts.  If you backup your database with multiple streams,
you have to write a script smart enough to be aware of it's other versions
so you don't have multiple shutdown or startup processes running.

It's possible to do hot backups of Oracle without the agent, too.  Here's a
snip from an earlier posting of mine.
-M

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.

3. Use split-mirror technology - EMC BCV's (or similar) or split soft
mirrors like Veritas mirrors.  The method varies strongly by technology but
basically it's
  a. Place entire DB in hotbackup mode, tablespace by tablespace
  b. Split mirrors for data
  c. Place DB in run mode
  d. Roll redo logs
  e. split mirrors for archived redo
  f. mount split mirrors on (usually) another server
  g. backup mirrors
  h. Resynchronize mirrors to primary source

Sometimes you'll see step "h" to be the first step.



-----Original Message-----
From: Buckley, Keith [mailto:kbuckley AT ameritrade DOT com]
Sent: Thursday, March 13, 2003 6:44 AM
To: 'Feroz F. Basir'; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] integrate shell script into netbackup policy
sch edule


You can use the bpstart_notify.class_name.schedule_name and
bpend_notifyclass_name.schedule_name scripts that Veritas provides with
NetBackup do to this action.  As a matter of fact, that is the fist backup
option taught at the Veritas NetBackup for Oracle class.  The start script
goes out and shuts down the Oracle database, while the end script restarts
the database after the backup is complete.

Keith Buckley, MCSE, MCP+I
ATG Backup and Recovery Team
Ph:  402-697-6098
Cell/Pager:  402-510-3814


-----Original Message-----
From: Feroz F. Basir [mailto:dbase77 AT yahoo DOT com]
Sent: Thursday, March 13, 2003 7:05 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] integrate shell script into netbackup policy
schedule


Hi all,

I just wondering myself, is it possible to integrate
shell script with netbckup? what I'm trying to do is,
to stop third party application like oracle before run
the backup. And start it up after backup finish. 

Or there is a better way to achieve this situation.
Anybody could give me some guideline, please?

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

------_=_NextPart_001_01C2E97B.72CBC000
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] integrate shell script into netbackup policy =
sch edule</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Be aware, a multi-stream backup will start multiple =
versions of the bpstart/bpend scripts.&nbsp; If you backup your =
database with multiple streams, you have to write a script smart enough =
to be aware of it's other versions so you don't have multiple shutdown =
or startup processes running.</FONT></P>

<P><FONT SIZE=3D2>It's possible to do hot backups of Oracle without the =
agent, too.&nbsp; Here's a snip from an earlier posting of mine.</FONT>
<BR><FONT SIZE=3D2>-M</FONT>
</P>

<P><FONT SIZE=3D2>1. Use Oracle RMAN - you'll be using Netbackup as =
little more than a media</FONT>
<BR><FONT SIZE=3D2>server for this.&nbsp; This requires a expensive =
per-oracle-client license for</FONT>
<BR><FONT SIZE=3D2>NB.&nbsp; </FONT>
</P>

<P><FONT SIZE=3D2>2. What we do, because of oracle complexity and =
license expense, is what we</FONT>
<BR><FONT SIZE=3D2>call a &quot;rolling hot backup&quot;.&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp; a. Query the database for all tablespace =
names </FONT>
<BR><FONT SIZE=3D2>&nbsp; b. For each tablespace, in sequence </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; 1. query oracle for =
datafiles related to the tablespace (place in a</FONT>
<BR><FONT SIZE=3D2>file) </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; 2. place tablespace in =
hot-backup mode </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; 3. use bpbackup to send the =
list of datafiles to netbackup </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; 4. remove tablespace from =
hot-backup mode </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; 5. loop for next =
tablespace. </FONT>
<BR><FONT SIZE=3D2>&nbsp; c. Alter control file to trace and send that =
file via bpbackup, too. </FONT>
<BR><FONT SIZE=3D2>&nbsp; d. Roll the redo logs. </FONT>
<BR><FONT SIZE=3D2>&nbsp; e. Send relavent archived redo log files, =
this is the set that starts from</FONT>
<BR><FONT SIZE=3D2>just before the first tablespace is put into HB mode =
up to and including the</FONT>
<BR><FONT SIZE=3D2>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</FONT>
<BR><FONT SIZE=3D2>single backup of the entire database.&nbsp; To track =
these as a set, we tie them</FONT>
<BR><FONT SIZE=3D2>together with a keyword based on backup date &amp; =
instance name.</FONT>
</P>

<P><FONT SIZE=3D2>Restoring is a bitch, compared to a cold backup, =
because there's a lot of</FONT>
<BR><FONT SIZE=3D2>redo logs to apply to get to a time-consistent image =
but it does work.</FONT>
</P>

<P><FONT SIZE=3D2>3. Use split-mirror technology - EMC BCV's (or =
similar) or split soft mirrors like Veritas mirrors.&nbsp; The method =
varies strongly by technology but basically it's</FONT></P>

<P><FONT SIZE=3D2>&nbsp; a. Place entire DB in hotbackup mode, =
tablespace by tablespace</FONT>
<BR><FONT SIZE=3D2>&nbsp; b. Split mirrors for data</FONT>
<BR><FONT SIZE=3D2>&nbsp; c. Place DB in run mode</FONT>
<BR><FONT SIZE=3D2>&nbsp; d. Roll redo logs</FONT>
<BR><FONT SIZE=3D2>&nbsp; e. split mirrors for archived redo</FONT>
<BR><FONT SIZE=3D2>&nbsp; f. mount split mirrors on (usually) another =
server</FONT>
<BR><FONT SIZE=3D2>&nbsp; g. backup mirrors</FONT>
<BR><FONT SIZE=3D2>&nbsp; h. Resynchronize mirrors to primary =
source</FONT>
</P>

<P><FONT SIZE=3D2>Sometimes you'll see step &quot;h&quot; to be the =
first step.</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Buckley, Keith [<A =
HREF=3D"mailto:kbuckley AT ameritrade DOT com">mailto:kbuckley AT ameritrade 
DOT com</=
A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, March 13, 2003 6:44 AM</FONT>
<BR><FONT SIZE=3D2>To: 'Feroz F. Basir'; =
veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2>Subject: RE: [Veritas-bu] integrate shell script =
into netbackup policy</FONT>
<BR><FONT SIZE=3D2>sch edule</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>You can use the =
bpstart_notify.class_name.schedule_name and</FONT>
<BR><FONT SIZE=3D2>bpend_notifyclass_name.schedule_name scripts that =
Veritas provides with</FONT>
<BR><FONT SIZE=3D2>NetBackup do to this action.&nbsp; As a matter of =
fact, that is the fist backup</FONT>
<BR><FONT SIZE=3D2>option taught at the Veritas NetBackup for Oracle =
class.&nbsp; The start script</FONT>
<BR><FONT SIZE=3D2>goes out and shuts down the Oracle database, while =
the end script restarts</FONT>
<BR><FONT SIZE=3D2>the database after the backup is complete.</FONT>
</P>

<P><FONT SIZE=3D2>Keith Buckley, MCSE, MCP+I</FONT>
<BR><FONT SIZE=3D2>ATG Backup and Recovery Team</FONT>
<BR><FONT SIZE=3D2>Ph:&nbsp; 402-697-6098</FONT>
<BR><FONT SIZE=3D2>Cell/Pager:&nbsp; 402-510-3814</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Feroz F. Basir [<A =
HREF=3D"mailto:dbase77 AT yahoo DOT com">mailto:dbase77 AT yahoo DOT 
com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, March 13, 2003 7:05 AM</FONT>
<BR><FONT SIZE=3D2>To: veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2>Subject: [Veritas-bu] integrate shell script into =
netbackup policy</FONT>
<BR><FONT SIZE=3D2>schedule</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Hi all,</FONT>
</P>

<P><FONT SIZE=3D2>I just wondering myself, is it possible to =
integrate</FONT>
<BR><FONT SIZE=3D2>shell script with netbckup? what I'm trying to do =
is,</FONT>
<BR><FONT SIZE=3D2>to stop third party application like oracle before =
run</FONT>
<BR><FONT SIZE=3D2>the backup. And start it up after backup finish. =
</FONT>
</P>

<P><FONT SIZE=3D2>Or there is a better way to achieve this =
situation.</FONT>
<BR><FONT SIZE=3D2>Anybody could give me some guideline, please?</FONT>
</P>

<P><FONT =
SIZE=3D2>__________________________________________________</FONT>
<BR><FONT SIZE=3D2>Do You Yahoo!?</FONT>
<BR><FONT SIZE=3D2>Everything you'll ever need on one web page</FONT>
<BR><FONT SIZE=3D2>from News and Sport to Email and Music Charts</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://uk.my.yahoo.com"; =
TARGET=3D"_blank">http://uk.my.yahoo.com</A></FONT>
<BR><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>
<BR><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_01C2E97B.72CBC000--

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