If you backup the database with only one image, the bpstart/bpend_notify will work. However, bpend_notify does run with every image completion, as you've found so it's no good for multi-image backups. bpstart_notify also runs with every image starting up so your preparation script might run more than once (OK if it checks state when it runs, perhaps, "If NOT down, then SHUTDOWN"). There's also lots of issues when your jobs run sequentially rather than in parallel, various race conditions, and all sorts of other painful stuff. Look at the parent_end_notify & parent_start_notify scripts. The run at the beginning of a multiple image job. Some of the early documentation said they run on the client - they don't - they run on the master server only. If you want to perform a client task, you'll have to "ssh" from your master to your client. Unfortunately, most solutions for pre- and post- multi-image jobs stink. The classic oracle solution is to use the oracle agent, of course. Do you have a license for it? If so, create an oracle job. The "include" list is the batch file than runs the RMAN script. The one schedule triggers the RMAN backup to a UBAK (called "Application" in this case) schedule located in the same policy. Works great & RMAN takes care of the heavy lifting. If you don't have an oracle license, you can run a batch job from the scheduler to shutdown the database, run "bpbackup -w" to a user-backup schedule with a filelist for the oracle directory(s), then start the database again from the same batch script. HTH - M
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dustin Damour Sent: Monday, May 18, 2009 10:47 AM To: [email protected] Subject: Re: [Veritas-bu] Pre / Post Scripts on Backup Jobs with Streams When we had a client with Oracle we used bpstart_notify and bpend_notify to bring down the Oracle service and then bring it back up. It works like a charm. Dustin D'Amour Wireless Switch Technician Plateau Wireless 575.389.4189 - office 575.309.6372 - cell [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of WEAVER, Simon (external) Sent: Monday, May 18, 2009 10:41 AM To: [email protected] Subject: [Veritas-bu] Pre / Post Scripts on Backup Jobs with Streams Hi All In a NBU 5.1 MP5 environment, I have client machines that require Oracle to be taken down. the client backup is in an existing policy with many other Windows Systems. The policy allows for streams. Problem I am seeing: Although for this client, the Services STOP when the job begins, the post job starts the minute one of the smaller streams complete. What I want to do, is allow the post job to run once ALL streams for this client has completed. I found this document: http://seer.support.veritas.com/docs/274059.htm <http://seer.support.veritas.com/docs/274059.htm> which I have been running through for tests. Now, I am wondering if I should be calling a different command for this like session_notify.cmd or bpend_notify.bat? Essentially, what I want to be sure of, is when the complete Full or INCR backup completes, the relevant service I stopped earlier is restart only when everything is completed. I have got Scheduled Tasks to run for the time being, but any pointers, would be appreciated. Thanks Regards Simon This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified. -o- Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
_______________________________________________ Veritas-bu maillist - [email protected] http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
