#!/bin/sh
export ORACLE_BASE=/data/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export DATA_DIR=/home/oracle/investDatabak/dbbak/data
export LOGS_DIR=/home/oracle/investDatabak/dbbak/log
export DELTIME=`date -d "15 days ago" +%Y%m%d`
export BAKUPTIME=`date +%Y%m%d%H%M%S`
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
mkdir -p $DATA_DIR
mkdir -p $LOGS_DIR
echo "Starting bakup..."
echo "Bakup file path $DATA_DIR/$BAKUPTIME.dmp"
exp system/wang023878@orcl file=$DATA_DIR/investtest$BAKUPTIME.dmp log=$LOGS_DIR/investtest$BAKUPTIME.log
echo "Delete the file bakup before 15 days..."
rm -rf $DATA_DIR/investtest$DELTIME*.dmp
rm -rf $LOGS_DIR/investtest$DELTIME*.log
echo "Delete the file bakup successfully. "
echo "Bakup completed."
