#!/bin/ksh
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/10.2.0/db_1
export ORA_CRS_HOME=/opt/oracle/product/10.2.0/crs_1
export ORACLE_SID=orcl1
export PATH=$PATH:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$HOME/bin:/usr/ccs/bin:.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export AIXTHREAD_SCOPE=S
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
rq=`/bin/date +%y%0m%0d`
rm /oraclebak/auto/orcl$rq.dmp
exp system/managerconfig@orcl full=y file=/oraclebak/auto/orcl$rq.dmp log=/oraclebak/auto/orcl$rq.log
#This Part to delete extra backup files that be backup more then 60 days;
#This Part be add at 201111230937.
find /oraclebak/auto/ -name 'orcl*.dmp' -mtime +20 -exec rm -rf {} \;
find /oraclebak/auto/ -name 'orcl*.log' -mtime +20 -exec rm -rf {} \;
exp逻辑全备份脚本for AIX
最新推荐文章于 2021-04-14 16:41:11 发布