#!/bin/bash
# A script that launches Oracle exports and saves them to a user for backup.
# Oracle Environment
# dbbackup bash script copyright 2005 roqet - http://www.roqet.org.
# dbbackup can be distributed and modified under the terms of the
# GNU General Public License: http://www.gnu.org/copyleft/gpl.html
#   ~~~
#   'l'
#    -

export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle
export ORACLE_SID=ROQDB
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export CLASSPATH

# Set shell search paths
export PATH=$PATH:$ORACLE_HOME/bin

$ORACLE_HOME/bin/exp roqet/mypassword file=/home/roqetman/backup/ROQET.DMP log=/home/roqetman/log/ROQETbackup.LOG

chown roqetman /home/roqetman/log/ROQETbackup.LOG
chgrp users /home/roqetman/log/ROQETbackup.LOG

echo "database backup complete" | mail -s "database backup message" roqetman