Oracle Database automatic backup scripts

#!/bin/sh

PATH=$PATH:$HOME/bin

export PATH

ORACLE_BASE=/RealData
ORACLE_HOME=$ORACLE_BASE/oracle
ORACLE_SID=DATACENTER

PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH DISPLAY

#add enviroment variable nls_lang
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

rq=`date '+%Y_%m_%d %H:%M'`
exp ARCER/ARCER file=/tmp/FGPS_$rq.dmp
echo "$rq backup successfully!" >> /tmp/oracle.txt

 

posted @ 2013-05-05 22:14  ArcerZhang  阅读(106)  评论(0编辑  收藏  举报