This is a multipart message in MIME format.
--=_alternative 0056969D85256E4C_=
Content-Type: text/plain; charset="us-ascii"
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
--=_alternative 0056969D85256E4C_=
Content-Type: text/html; charset="us-ascii"
<br><font size=2 face="sans-serif">Paul,</font>
<br>
<br><font size=2 face="sans-serif">You can use the BPSTART_NOTIFY and
BPEND_NOTIFY feature to have DBA Shutdown and backup scripts and</font>
<br><font size=2 face="sans-serif">have Netbackup run the backup, and then call
scripts to restart the database. </font>
<br><font size=2 face="sans-serif">We use thisfeature to perform hot backups of
some of our Oracle databases.</font>
<br>
<br><font size=2 face="sans-serif">The BPSART_NOTIFY script calls a job to put
the tablespaces in backup mode, then runs the backup policy,</font>
<br><font size=2 face="sans-serif">when the backup policy is complete, the
BPEND_NOTIFY script is called to take the tablspaces out of backup</font>
<br><font size=2 face="sans-serif">mode and return things to normal. We do this
for databases that have archivelog mode turned on.</font>
<br>
<br><font size=2 face="sans-serif">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 size=2 face="sans-serif">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 size=2 face="sans-serif">The advantage to this bpend/bpstart featuer
is that the backups</font>
<br><font size=2 face="sans-serif">are scheduled from the master server and you
do not need a cron job to run the backups.</font>
<br>
<br><font size=2 face="sans-serif">I can send you copies of our scripts if you
like. </font>
<br>
<br><font size=2 face="sans-serif"><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%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>"Paul Esson" <paul.esson AT
redstor DOT com></b></font>
<br><font size=1 face="sans-serif">Sent by: veritas-bu-admin AT
mailman.eng.auburn DOT edu</font>
<p><font size=1 face="sans-serif">03/03/2004 08:22 AM</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To:
<veritas-bu AT mailman.eng.auburn DOT edu></font>
<br><font size=1 face="sans-serif"> cc:
</font>
<br><font size=1 face="sans-serif"> Subject:
[Veritas-bu] User Directed Backup and Oracle</font></table>
<br>
<br>
<br><font size=2 face="Courier New">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>
--=_alternative 0056969D85256E4C_=--
|