Forum Discussion

BarakatiA's avatar
BarakatiA
Level 3
14 years ago

bpstart_notify/bpend_notify Oracle ColdBackup

Dears,   Crontab file is used now in order to Start/Shutdown Oracle DB before  & after ColdBackup? Where should I place bpstart&bpend script? what are the changes should be done on the script? ...
7.1.x and Earlier
Backing Up
Backup and Recovery
NetBackup
Tip-How to
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    14 years ago

    Hi,

     

    You can use the exact same script you call from cron. Just rename the cron script that shuts down the DB bpstart_notify, place it in /usr/openv/netbackup/bin, and do the same for the cron script that starts up the DB. Renaming it to bpend_nofity. Alternitavely you can append .Policyname and even .schedulename to the file name of the scripts. This will have netbackup run it only for certain policies, or certain policies AND certain schedules.

     

    If you dont append policy name to the bpstart_notify and bpend_notify (example bpstart_notify.OracleServer1 and bpend_notify.OracleServer1) it will run it each time any backup runs on the client (oracle server)

     

    Nothing to be done on the master.

Marianne's avatar
Marianne
Level 6
14 years ago

If the crontab is running under oracle user name, you will probably need to add

su - oracle -c "
shutdown commands...
...... "

to the notify scripts.

Alternative option:

Add a User type schedule to the policy and remove the oracle path from the file selection.

Add a line similar to the following to the script executed by cron:

/usr/openv/netbackup/bin/bpbackup -p <policy-name> -s <user-schedule-name> -L </tmp/backup.out> </oracle-path>