Oracle备份脚本

#!/bin/bash

#define variable
BASE_DIR=/home/user1/dbbak
CURRENT_DATE=`date +%Y%m%d`
DEST_DIR=dbbak-$CURRENT_DATE
FULL_DEST_DIR=$BASE_DIR/$DEST_DIR
ORACLE_BIN=/opt/oracle/product/10.2/db/bin

#set env variable
export NLS_LANG='SIMPLIFIED CHINESE_CHINA.AL32UTF8'

#create dir
cd $BASE_DIR
mkdir $DEST_DIR

#export data
cd $ORACLE_BIN
./exp ora1/ora1pwd@orcl file=$FULL_DEST_DIR/dbbak-$CURRENT_DATE.dmp

#compress
cd $BASE_DIR
zip -r $DEST_DIR.zip $DEST_DIR