oracle脚本热备,oracle的热备脚本

#!/bin/sh

#

# 该脚本在linux运行成功，脚本还需要改进，在脚本中没有异常处理机制。

# 在这里需要重新设定脚本的备份目录和oracle的环境变量

#

#

#set backup destination

#

BACKUP_DIR=/backup/hot_wholebackup; export BACKUP_DIR

BACKUP_BACK_DIR=$BACKUP_DIR/bak; export BACKUP_BACK_DIR

ARCHIVE_BACK_DIR=$BACKUP_DIR/archivebak; export ARCHIVE_BACK_DIR

LOG=$BACKUP_DIR/log`date +%Y%m%d%H%M%S`.txt

#

#set oracle environment variable. if the user is oracle,you can skip this step.

#

ORACLE_BASE=/home/oracle;export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/9.2.0;export ORACLE_HOME

ORACLE_SID=test; export RACLE_SID

ORACLE_NLS=$ORACLE_HOME/ocommon/nls/admin/data; export ORACLE_NLS

NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG

PATH=$ORACLE_HOME/bin:$PATH;export PATH

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

[@more@]#

#Check the oracle archive mode

#

sqlplus /nolog >$LOG

conn /as sysdba

spool $BACKUP_DIR/arch.txt

archive log list;

spool off

quit

!EO

#if Noarchived mode then return

ARCHIVED=`grep -i "No Archive Mode" $BACKUP_DIR/arch.txt|wc -l`