oracle数据库备份

source ~/.bash_profile

date=`date +%Y%m%d`

days=30

dataname="expdp_"$date.dmp

logname="expdp_"$date.log

ordatabak="expdp_"$date.tar.gz

expdp system/yourpassword@127.0.0.1/orcl directory=myexpdp dumpfile=$dataname  full=y  logfile=$logname

cd /backup/oradata/

tar -zcvf $ordatabak $dataname $logname

find $bakdir -type f -name "*.dmp" -exec rm -rf {} \;

find $bakdir -type f -name "*.log" -exec rm -rf {} \;

find $bakdir -type f -name "*.tar.gz" -mtime +$days -exec rm -rf {} \;

#!/bin/sh

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export ORACLE_SID=orcl

export PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export NLA_LANG=AMERICAN_AMERICA.AL32UTF8

date=`date +%Y%m%d`

days=7

orowner=system

bakpass=yourpassword

bakdir=/backup/oradata

bakdata=$date.dmp

baklog=$date.log

ordatabak=$orowner"_"$date.tar.gz

cd $bakdir

exp $orowner/$bakpass@172.16.1.24:1521/orcl file=$bakdir/$bakdata log=$bakdir/$baklog full=y

tar -zcvf $ordatabak $bakdata $baklog

# find $bakdir -type f -name "*.dmp" -exec rm -rf {} \;

# find $bakdir -type f -name "*.log" -exec rm -rf {} \;

find $bakdir -type f -name "*.tar.gz" -mtime +$days -exec rm -rf {} \;