Veritas-bu

Re: [Veritas-bu] Pre / Post Scripts on Backup Jobs with Streams

2009-05-19 02:12:50
Subject: Re: [Veritas-bu] Pre / Post Scripts on Backup Jobs with Streams
From: "WEAVER, Simon \(external\)" <simon.weaver AT astrium.eads DOT net>
To: "Donaldson, Mark" <Mark.Donaldson AT Staples DOT com>, "Dustin Damour" <dustind AT plateautel DOT com>, <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Tue, 19 May 2009 07:09:31 +0100
Cheers Mark,
Although the client in question is Oracle, I have other Servers that need specific tasks to be run but again, the problem I have is they are all in policies to allow multiple Data Streams.
 
I will take a look at this Parent end scripts to see if they do anything for me.
 
Simon


From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Donaldson, Mark
Sent: Monday, May 18, 2009 6:38 PM
To: Dustin Damour; veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Pre / Post Scripts on Backup Jobs with Streams

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: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Dustin Damour
Sent: Monday, May 18, 2009 10:47 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
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

dustind AT plateautel DOT com

 

From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of WEAVER, Simon (external)
Sent: Monday, May 18, 2009 10:41 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
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 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

 

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  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu