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_01C40167.1378CE40
Content-Type: text/plain
The method below works but you should be aware that if every tablespace in
the DB is in hot backup mode at the same time, all writes are queued to the
redo logs and a busy DB will slow to a crawl and go though redo space in a
big hurry.
Another method to do a hot backup is:
Query DB for all tablespace names
for each tablespace in tablespace_list
set tablespace in hotbackup mode
query DB for list of Unix files in tablespace
send files via bpbackup to tape
unset tablespace
loop for next tablespace
Then:
backup control files to trace - send them to tape
roll your redo to archived redo
send all archived redo logs from start of backup time end of backup time
to tape
The set of archived redo logs combined with the file backups are recoverable
by first restoring the files then rolling the files forward to a consistent
point in time using the set of archived redo logs. This method will also
queue writes to redo but only for the tablespace that's in Hotbackup mode at
the time of the write activity.
DB never goes down.
-M
-----Original Message-----
From: ckstehman AT pepco DOT com [mailto:ckstehman AT pepco DOT com]
Sent: Wednesday, March 03, 2004 8:46 AM
To: Paul Esson
Cc: veritas-bu AT mailman.eng.auburn DOT edu;
veritas-bu-admin AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] User Directed Backup and Oracle
Paul,
You can use the BPSTART_NOTIFY and BPEND_NOTIFY feature to have DBA Shutdown
and backup scripts and
have Netbackup run the backup, and then call scripts to restart the
database.
We use thisfeature to perform hot backups of some of our Oracle databases.
The BPSART_NOTIFY script calls a job to put the tablespaces in backup mode,
then runs the backup policy,
when the backup policy is complete, the BPEND_NOTIFY script is called to
take the tablspaces out of backup
mode and return things to normal. We do this for databases that have
archivelog mode turned on.
In your case, you could use this same process to do what you are describing
to call your DBA scripts to set up the flat files,
then have the standard policy backup the files, then the bpend could call
any further scripts to restart the database, etc.
The advantage to this bpend/bpstart featuer is that the backups
are scheduled from the master server and you do not need a cron job to run
the backups.
I can send you copies of our scripts if you like.
=============================
Carl Stehman
PHI Services Company
202-331-6619
Pager 301-765-2703
ckstehman AT pepco DOT com
"Paul Esson" <paul.esson AT redstor DOT com>
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu
03/03/2004 08:22 AM
To: <veritas-bu AT mailman.eng.auburn DOT edu>
cc:
Subject: [Veritas-bu] User Directed Backup and Oracle
Folks,
I am trying to establish policies and schedules to enable me to backup
Oracle databases in the following manner and wanted to know if this is a
sensible approach. Any constructive comments would be much appreciated.
Unfortunatley, my scripting skills are failrly basic.
NetBackup Version 4.5 FP6
Master Server Windows 2000
Oracle clients Solaris 2.6 and 8
We do not want to use RMAN and the NetBackup Oracle Extension because we
want to keep the costs down and simplify the restore process to recovering
flat files. The DBA has scripted routines to backup the databases to flat
files and place those files in a specific directory and I was thinking I
could set-up automated schedules for fulls and incrementals that would
control the backup frequency and corresponding user backup schedules that
would backup the flat files. The user backup schedule would run a script
via its file list that is a wrapper for the DBA's script that calls the
bpbackup command afterwards to backup the flat files to NetBackup.
Can I do this with a standard policy type? I have see something similar for
an Oracle policy type where a wrapper script calls RMAN. Does anyone have
anything similar they could share with me?
I have an additional issue where a database resident on a UNIX client needs
to be backed up in unison with a filestore on a Windows 2000 client. Is
there any way I can relate the two activities and control them through
NetBackup? The logic would have to be something like:
* Shutdown UNIX databases
* Run DBA script to backup UNIX databases
* Run NetBackup backup of UNIX database backup flat files
* Run NetBackup backup of Windows filestore [ideally if this
could be run in parallel with above after database shutdown]
* Start UNIX database
I need to keep the database down while the filestore is backed up for
consistency. I may even need to stop a service on the Windows 2000 system
before commencing the filestore backup. AM I chasing shadows here?
Regards,
Paul Esson
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
------_=_NextPart_001_01C40167.1378CE40
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff size=2>The
method below works but you should be aware that if every tablespace in the DB
is
in hot backup mode at the same time, all writes are queued to the redo logs
and a busy DB will slow to a crawl and go though redo space in a big
hurry.</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2>Another method to do a hot backup is:</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff size=2>Query
DB for all tablespace names</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff size=2>for
each tablespace in tablespace_list</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2>
set tablespace in hotbackup mode</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2>
query DB for list of Unix files in tablespace</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2>
send files via bpbackup to tape</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2>
unset tablespace</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff size=2>loop
for next tablespace</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2>Then:</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2>
backup control files to trace - send them to tape</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2>
roll your redo to archived redo</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2>
send all archived redo logs from start of backup time end of backup time to
tape</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff size=2>The
set of archived redo logs combined with the file backups are recoverable by
first restoring the files then rolling the files forward to a consistent point
in time using the set of archived redo logs. This method will also queue
writes to redo but only for the tablespace that's in Hotbackup mode at the time
of the write activity.</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff size=2>DB
never goes down.</FONT></SPAN></DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=987560321-03032004><FONT face=Arial color=#0000ff
size=2>-M</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> ckstehman AT pepco DOT com
[mailto:ckstehman AT pepco DOT com]<BR><B>Sent:</B> Wednesday, March 03, 2004
8:46
AM<BR><B>To:</B> Paul Esson<BR><B>Cc:</B> veritas-bu AT mailman.eng.auburn
DOT edu;
veritas-bu-admin AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> Re:
[Veritas-bu]
User Directed Backup and Oracle<BR><BR></FONT></DIV><BR><FONT face=sans-serif
size=2>Paul,</FONT> <BR><BR><FONT face=sans-serif size=2>You can use the
BPSTART_NOTIFY and BPEND_NOTIFY feature to have DBA Shutdown and backup
scripts and</FONT> <BR><FONT face=sans-serif size=2>have Netbackup run the
backup, and then call scripts to restart the database. </FONT>
<BR><FONT
face=sans-serif size=2>We use thisfeature to perform hot backups of some of
our Oracle databases.</FONT> <BR><BR><FONT face=sans-serif size=2>The
BPSART_NOTIFY script calls a job to put the tablespaces in backup mode, then
runs the backup policy,</FONT> <BR><FONT face=sans-serif size=2>when the
backup policy is complete, the BPEND_NOTIFY script is called to take the
tablspaces out of backup</FONT> <BR><FONT face=sans-serif size=2>mode and
return things to normal. We do this for databases that have archivelog mode
turned on.</FONT> <BR><BR><FONT face=sans-serif size=2>In your case, you
could
use this same process to do what you are describing to call your DBA scripts
to set up the flat files,</FONT> <BR><FONT face=sans-serif size=2>then have
the standard policy backup the files, then the bpend could call any further
scripts to restart the database, etc.</FONT> <BR><BR><FONT face=sans-serif
size=2>The advantage to this bpend/bpstart featuer is that the backups</FONT>
<BR><FONT face=sans-serif size=2>are scheduled from the master server and you
do not need a cron job to run the backups.</FONT> <BR><BR><FONT
face=sans-serif size=2>I can send you copies of our scripts if you like.
</FONT> <BR><BR><FONT face=sans-serif
size=2><BR>=============================<BR>Carl Stehman<BR>PHI Services
Company<BR>202-331-6619<BR>Pager 301-765-2703<BR>ckstehman AT pepco DOT
com</FONT>
<BR><BR><BR><BR>
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD>
<TD><FONT face=sans-serif size=1><B>"Paul Esson"
<paul.esson AT redstor DOT com></B></FONT> <BR><FONT
face=sans-serif
size=1>Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu</FONT>
<P><FONT face=sans-serif size=1>03/03/2004 08:22 AM</FONT> <BR></P>
<TD><FONT face=Arial size=1> </FONT><BR><FONT
face=sans-serif size=1> To:
<veritas-bu AT mailman.eng.auburn DOT edu></FONT>
<BR><FONT
face=sans-serif size=1> cc:
</FONT> <BR><FONT face=sans-serif size=1>
Subject: [Veritas-bu] User
Directed Backup and Oracle</FONT></TR></TBODY></TABLE><BR><BR><BR><FONT
face="Courier New" size=2>Folks,<BR><BR>I am trying to establish policies and
schedules to enable me to backup Oracle databases in the following manner and
wanted to know if this is a sensible approach. Any constructive comments
would
be much appreciated. Unfortunatley, my scripting skills are failrly
basic.<BR><BR>NetBackup Version 4.5 FP6<BR>Master Server Windows
2000<BR>Oracle clients Solaris 2.6 and 8<BR><BR>We do not want to use RMAN
and
the NetBackup Oracle Extension because we want to keep the costs down and
simplify the restore process to recovering flat files. The DBA has
scripted routines to backup the databases to flat files and place those files
in a specific directory and I was thinking I could set-up automated schedules
for fulls and incrementals that would control the backup frequency and
corresponding user backup schedules that would backup the flat files.
The user backup schedule would run a script via its file list that is a
wrapper for the DBA's script that calls the bpbackup command afterwards to
backup the flat files to NetBackup.<BR><BR>Can I do this with a standard
policy type? I have see something similar for an Oracle policy type
where a wrapper script calls RMAN. Does anyone have anything similar
they could share with me?<BR><BR>I have an additional issue where a database
resident on a UNIX client needs to be backed up in unison with a filestore on
a Windows 2000 client. Is there any way I can relate the two activities
and control them through NetBackup? The logic would have to be
something
like:<BR><BR><BR>*
Shutdown UNIX databases<BR>*
Run DBA script to backup UNIX databases<BR>*
Run NetBackup backup of UNIX
database
backup flat files<BR>*
Run NetBackup backup of Windows filestore [ideally if this could be run in
parallel with above after database shutdown]<BR>*
Start UNIX database<BR><BR>I need to keep the
database down while the filestore is backed up for consistency. I may
even need to stop a service on the Windows 2000 system before commencing the
filestore backup. AM I chasing shadows
here?<BR><BR>Regards,<BR><BR>Paul
Esson<BR><BR><BR>_______________________________________________<BR>Veritas-bu
maillist -
Veritas-bu AT mailman.eng.auburn DOT
edu<BR>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu<BR></FONT><BR><BR><BR></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C40167.1378CE40--
|