#!/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`

ITPub博客

oracle的热备脚本

最新文章