Pre and Post backup scripts

[luisvidal]

Hi all,

Running NBU 7.1.0.2 on SLES 10, and I have a few Solaris 9 servers that need to stop services (bring down DBs) in order to run backups, and--of course--bring them backup after backups are done.

What the best way to do this?

Is it using bpstart_notify and bpend_notify?

thanks for the help!

[Nicolai]

But I prefer the online agent. If those DB's are Oracle consider using RMAN to dump the database to local disk and the backup the dump(s). This way you avoid taking a database down during working hours, if backup is behind schedule (and that happens from time to time).

[luisvidal]

Thanks, Nicolai. No, there are not Oracle. There are in-house apps that need to be brought down before the backup, and up after it is done.

[Mark_Solutions · Accepted solution]

Remember if you use bpstart_notify and bpend_notify (which is a nice easy way of doing things to be honest) then they have a default timeout of 5 minutes

If what they do has not complted by then the backup will fail

You can change these timeouts in the host properties or via the bp.conf:

BPSTART_TIMEOUT =
BPEND_TIMEOUT =
 

If what you want to do is simple and straight forward then these would be the way to go but ensure what ever you run does close to prevent the timeouts

Hope this helps

[J_H_Is_gone]

make a script that downs the database

do a user backup to a policy that has a user schedule

up the databases

put the script in cron

of course you should put a lot of checking in that

is db down before you start the backup

did the backup complete ok

recenlty suggested this for someone else - see this post.

http://www-secure.symantec.com/connect/forums/triggering-backup-netbackup-client#comment-6526011

[luisvidal]

Thanks, J.