I and a partner have done the same. What we did was to run the wizard
multiple times with all the options we wanted, then compiled all the
results into one monolithic script. The script gets the SID from the
policy name.
I just think the wizard is a much better place to _start_ then the
example scripts.
---
W. Curtis Preston
Author of O'Reilly's Backup & Recovery and Using SANs and NAS
VP Data Protection
GlassHouse Technologies
________________________________
From: Steven L. Sesar [mailto:ssesar at mitre.org]
Sent: Thursday, January 04, 2007 12:22 PM
To: Curtis Preston
Cc: Martin, Jonathan (Contractor); NB List Mail
Subject: Re: [Veritas-bu] Oracle Policy - Solution
The one problem with the "wizard" architecture (at least, last that I
checked), is that one script needs to be maintained for each SID. Make
that two, if your backup strategy includes hot and cold backups. Factor
in potential differences in parallelism on databases which reside on
faster disk, versus those on slower disk, and you've got even more
scripts to maintain.
My solution was to create a single, monolithic script, which, based on
input from the NBU schedule being run, determines whether or not it's a
hot or cold backup, if cold, shuts down the associated apps, shuts down
the SID, brings it up in startup mount mode (also cooked in some logic
to test to see if the database actually succeeded in shutting down -
after a period of time, a shutdown abort is issued), builds and executes
the RMAN code that I want and brings the SID/apps back up. This way,
I've got one script to manage, not 160+.
--Steve
Curtis Preston wrote:
You said:
4 - The default scripts are terrible, and while all this
customization
is possible you really have to "dive in" and learn everything
about how
RMAN and NBU communicate to make this happen. As far as I am
concerned
RMAN telling NBU which policy and schedule to use should be
STANDARD.
Are you talking about the example scripts, or the scripts produced by
the wizard? I think the scripts that are produced by the wizard are
pretty good, and include the logic you're looking for. It does a check
for what type of schedule is running, then passes the appropriate
variable to RMAN, last time I checked. You'll have to edit it, of
course, to get it to call the right one.
_______________________________________________
Veritas-bu maillist - Veritas-bu at mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
--
===================================
Steven L. Sesar
Lead Operating Systems Programmer/Analyst
UNIX Application Services R101
The MITRE Corporation
202 Burlington Road - MS K101
Bedford, MA 01730
tel: (781) 271-7702
fax: (781) 271-2600
mobile: (617) 519-8933
email: ssesar at mitre.org
===================================
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070104/ac263b73/attachment.htm
|