ORACLE dump ksh

最新推荐文章于 2025-05-17 16:00:52 发布

ctz51934

最新推荐文章于 2025-05-17 16:00:52 发布

阅读量102

点赞数

文章标签：数据库

本文介绍了一个用于跨不同操作系统环境下Oracle数据库完全备份的Shell脚本。该脚本根据当前运行的操作系统调整必要的环境变量，并执行数据库的完整导出操作。文中详细解释了如何配置ORACLE_HOME、ORACLE_SID等参数，确保导出过程顺利进行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

$ more exp_full_db.ksh
#!/usr/bin/ksh
HostName='hostname'
LogName='whoami'
EnvFlag='echo $LogName|cut -c1-1'
OsName='uname'

case $OsName in
AIX ) echo $OsName ...
GET_ACL="aclget"
MAIL="mailx"
ZIP="/usr/bin/gzip"
LogName='/usr/bin/whoami'
export LogName
;;
HP-UX ) echo $OsName ...
GET_ACL="getacl"
MAIL="mailx -m"
ZIP="/usr/contrib/bin/gzip"
LogName='/usr/bin/whoami'
export LogName
;;
SunOS ) echo $OsName ...
LogName='/usr/ucb/whoami'
ZIP="/usr/bin/gzip"
MAIL="mailx"
export LogName
GET_ACL="getfacl"
;;
Linux ) echo $OsName ...
LogName='/usr/bin/whoami'
MAIL="mailx"
ZIP="gzip"
export LogName
GET_ACL="getfacl"
;;
esac

Cnt=`echo $#`
if [ $Cnt -ne 3 ]
then
echo "Usage : exp_full_db.ksh "
echo " e.g. exp_full_db.ksh testdb /optware/oracle/10.2/db /optware/oracle/exportdmp"
exit 0
fi
dbname=$1
ORACLE_HOME=$2
EXPDIR=$3
export ORACLE_HOME
ORACLE_SID=$dbname
export ORACLE_SID
PATH=$ORACLE_HOME/bin:$PATH
export PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH

if [ ! -d ${ORACLE_HOME} ]
then
echo "ORACLE_HOME ${ORACLE_HOME} does not exist "
exit 0
fi

if [ ! -d ${EXPDIR} ]
then
echo "EXPDIR ${EXPDIR} does not exist "
exit 0
fi

if [ ! -d ${EXPDIR}/log ]
then
mkdir -p ${EXPDIR}/log
fi

dd=`date +%d`
TODAY=`date +'%d-%m-%Y'`
time_to_delete='date +"%d%m%Y%H%M%S"'
LOG=${EXPDIR}/log/exp_full_db_${TODAY}.log

ORA_VER_CHK='11'

### echo exp file=${EXPDIR}/exp_db_${ORACLE_SID}_$dd.dmp log=${EXPDIR}/log/exp_db_${ORACLE_SID}_$dd.log buffer=512000 compres
s=y rows=y statistics=none
echo "/ as sysdba" |exp file=${EXPDIR}/exp_db_${ORACLE_SID}_$dd.dmp log=${EXPDIR}/log/exp_db_${ORACLE_SID}_$dd.log buffer=512
000 compress=y rows=y statistics=none

if [ `grep EXP- ${EXPDIR}/log/exp_db_${ORACLE_SID}_$dd.log | wc -l ` -eq 0 ]
then

echo "Export DB$ table is successful... " >> $LOG

else
echo "Export DB is failed..." >> $LOG
fi

[@more@]

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

转载于:http://blog.itpub.net/8337095/viewspace-1052058/