20160517_expdp

crontab -l
0 1 * * * sh /oracle/shihfa/1.sh
30 0 * * * sh /oracle/shihfa/2.sh

ailksvc:oracle:/oraclebak/shihfa>more 1.sh
#!/bin/bash
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=aidb
FILE=`date +%Y%m%d`
expdp system/xxss_911 full=y directory=expdp logfile=`date +%Y%m%d`_exp.log PARALLEL=4 dumpfile=`date +%Y%m%d`_1.dmp,`date +%Y%m%d`_2.dmp,`date +%Y%m%d`_3.dmp,`date +%Y%m%d`_4.dmp

cd /oraclebak/expdp

if [ "tail -n 1 `date +%Y%m%d`_exp.log | grep successfully |awk '{print $3}'"="successfully" ]; then
  find /oraclebak/expdp -name "*.log" -atime +1 -exec rm {} \;
  find /oraclebak/expdp -name "*.dmp" -atime +1 -exec rm {} \;
  echo "`date +%Y%m%d` successful exp ,and delete the backup the day before yesterday" >> /oraclebak/shihfa/out.log
else
  echo "`date +%Y%m%d` backup is not successful ! do nothing" >> /oraclebak/shihfa/out.log
fi
ailksvc:oracle:/oraclebak/shihfa>more 2.sh
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=aidb
FILE=`date +%Y%m%d`
sqlplus / as sysdba <<EOF
spool /oraclebak/expdp/`date +%Y%m%d`_tbs.log
set line 167
set pagesize 100
SELECT 'create tablespace '||t.tablespace_name||' datafile '||t.file_name||' size '||t.bytes/1024/1024||' M;' FROM dba_data_files t ORDER BY tablespace_name;
spool off
<<EOF
exit;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26179376/viewspace-2101357/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26179376/viewspace-2101357/