#! /bin/sh # # $DBA/backPROD # # Performs a backup of the PROD database # # Usually executed by crontab via a line similar to: # 0 1 * * 1-5 /users/oracle/dba/backPROD > /users/oracle/dba/data/backPROD.log # # Last Change 02/24/97 by Brian Lomasky # # Execute batch profile (since crontab's default is to not run .profile) . ./dbabatch cd $DBA #stopnet # Start SQL*Net before backup #run_brl PROD # Collect BRL statistics # # YOU MUST EDIT THIS FILE TO SPECIFY THE DESIRED PARAMETER(S) FOLLOWING # THE ORACLE_SID OF THE DATABASE BEING BACKED UP; See the comments in # $DBA/backup for information. # $DBA/backup PROD # Backup the database if [ $? -ne 0 ] then mailto "Check \$DBA/data/backPROD.log" \ "Unexpected error from \$DBA/backPROD" fi #startnet # Start SQL*Net after backup chmod 700 data/backPROD.log # Fix log file security