【文章內(nèi)容簡介】 File List (文件列表)：定義需要備份的文件列表。l Schedules(備份日程表)：定義進行各種備份的時間。　　　　　　　　Class類型ScheduleType開始時間要備份的主機保存期限備份文件oraclewholebackuporacleDays （除每月21號）Auto_full3:00:006:00Orabk1月/opt/openv/netbackup/scripts/oraclearchivebackuporacle每月21號Auto_Full Orabk1月/opt/openv/netbackup/scripts/目前對數(shù)據(jù)庫的備份分成兩類，一類是數(shù)據(jù)庫的全備份，第二類是對生成的歸檔日志的備份。備份時netbackup分別調(diào)用相應的” /opt/openv/netbackup/scripts/”和” /opt/openv/netbackup/scripts/”兩個腳本。目前每天早上3點(除21日)進行全備份到帶庫，保留一個月。每月的21日進行歸檔日志的備份。 備份腳本的內(nèi)容 全備份腳本位于: /opt/openv/netbackup/scripts/!/bin/shCUSER=`id |cut d( f2 | cut d ) f1` RMAN_LOG_FILE=${0}.outthen rm f $RMAN_LOG_FILEfiecho $RMAN_LOG_FILEchmod 666 $RMAN_LOG_FILE echo Script $0 $RMAN_LOG_FILEecho ==== started on `date` ==== $RMAN_LOG_FILEecho $RMAN_LOG_FILEORACLE_HOME=/opt/app/oracle/product/export ORACLE_HOMEORACLE_SID=actdbexport ORACLE_SIDORACLE_USER=oracleTARGET_CONNECT_STR=system/hnadmRMAN=$ORACLE_HOME/bin/rmanecho $RMAN_LOG_FILEecho RMAN: $RMAN $RMAN_LOG_FILEecho ORACLE_SID: $ORACLE_SID $RMAN_LOG_FILEecho ORACLE_USER: $ORACLE_USER $RMAN_LOG_FILEecho ORACLE_HOME: $ORACLE_HOME $RMAN_LOG_FILEecho $RMAN_LOG_FILEecho NB_ORA_FULL: $NB_ORA_FULL $RMAN_LOG_FILEecho NB_ORA_INCR: $NB_ORA_INCR $RMAN_LOG_FILEecho NB_ORA_CINC: $NB_ORA_CINC $RMAN_LOG_FILEecho NB_ORA_SERV: $NB_ORA_SERV $RMAN_LOG_FILEecho NB_ORA_POLICY: $NB_ORA_POLICY $RMAN_LOG_FILEecho $RMAN_LOG_FILEif [ $NB_ORA_FULL = 1 ]then echo Full backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=0 elif [ $NB_ORA_INCR = 1 ]then echo Differential incremental backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=1 elif [ $NB_ORA_CINC = 1 ]then echo Cumulative incremental backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=1 CUMULATIVE elif [ $BACKUP_TYPE = ]then echo Default Full backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=0fiCMD_STR=ORACLE_HOME=$ORACLE_HOMEexport ORACLE_HOMEORACLE_SID=$ORACLE_SIDexport ORACLE_SID$RMAN target $TARGET_CONNECT_STR catalog rman/rman@catadb msglog $RMAN_LOG_FILE append EOFRUN {ALLOCATE CHANNEL ch00 TYPE 39。SBT_TAPE39。ALLOCATE CHANNEL ch01 TYPE 39。SBT_TAPE39。BACKUP $BACKUP_TYPE SKIP INACCESSIBLE TAG hot_db_bk_level0 FILESPERSET 5 remended format FORMAT 39。bk_%s_%p_%t39。 DATABASE。 sql 39。alter system archive log current39。RELEASE CHANNEL ch00。RELEASE CHANNEL ch01。 backup all archive logsALLOCATE CHANNEL ch00 TYPE 39。SBT_TAPE39。ALLOCATE CHANNEL ch01 TYPE 39。SBT_TAPE39。BACKUP filesperset 20 FORMAT 39。al_%s_%p_%t39。 ARCHIVELOG ALL DELETE INPUT。RELEASE CHANNEL ch00。RELEASE CHANNEL ch01。ALLOCATE CHANNEL ch00 TYPE 39。SBT_TAPE39。BACKUP remended format FORMAT 39。trl_%s_%p_%t39。 CURRENT CONTROLFILE。RELEASE CHANNEL ch00。}EOF Initiate the mand string if [ $CUSER = root ]then su $ORACLE_USER c $CMD_STR $RMAN_LOG_FILE RSTAT=$?else /usr/bin/sh c $CMD_STR $RMAN_LOG_FILE RSTAT=$?fi Log the pletion of this script. if [ $RSTAT = 0 ]then LOGMSG=ended successfullyelse LOGMSG=ended in errorfi echo $RMAN_LOG_FILEecho Script $0 $RMAN_LOG_FILEecho ==== $LOGMSG on `date` ==== $RMAN_LOG_FILEecho $RMAN_LOG_FILE exit $RSTAT 增量備份腳本位于: /opt/openv/netbackup/scripts/內(nèi)容:!/bin/shCUSER=`id |cut d( f2 | cut d ) f1` RMAN_LOG_FILE=${0}.outthen rm f $RMAN_LOG_FILEfiecho $RMAN_LOG_FILEchmod 666 $RMAN_LOG_FILE echo Script $0 $RMAN_LOG_FILEecho ==== started on `date` ==== $RMAN_LOG_FILEecho $RMAN_LOG_FILEORACLE_HOME=/opt/app/oracle/product/export ORACLE_HOMEORACLE_SID=actdbexport ORACLE_SIDORACLE_USER=oracleTARGET_CONNECT_STR=system/hnadmRMAN=$ORACLE_HOME/bin/rmanecho $RMAN_LOG_FILEecho RMAN: $RMAN $RMAN_LOG_FILEecho ORACLE_SID: $ORACLE_SID $RMAN_LOG_FILEecho ORACLE_USER: $ORACLE_USER $RMAN_LOG_FILEecho ORACLE_HOME: $ORACLE_HOME $RMAN_LOG_FILEecho $RMAN_LOG_FILEecho NB_ORA_FULL: $NB_ORA_FULL $RMAN_LOG_FILEecho NB_ORA_INCR: $NB_ORA_INCR $RMAN_LOG_FILEecho NB_ORA_CINC: $NB_ORA_CINC $RMAN_LOG_FILEecho NB_ORA_SERV: $NB_ORA_SERV $RMAN_LOG_FILEecho NB_ORA_POLICY: $NB_ORA_POLICY $RMAN_LOG_FILEecho $RMAN_LOG_FILEif [ $NB_ORA_FULL = 1 ]then echo Full backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=0 elif [ $NB_ORA_INCR = 1 ]then echo Differential incremental backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=1 elif [ $NB_ORA_CINC = 1 ]then echo Cumulative incremental backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=1 CUMULATIVE elif [ $BACKUP_TYPE = ]then echo Default Full backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=0fiCMD_STR=ORACLE_HOME=$ORACLE_HOMEexport ORACLE_HOMEORACLE_SID=$ORACLE_SIDexport ORACLE_SID$RMAN target $TARGET_CONNECT_STR catalog rman/rman@catadb msglog $RMAN_LOG_FILE append EOFRUN { backup all archive logsALLOCATE CHANNEL ch00 TYPE 39。SBT_TAPE39。ALLOCATE CHANNEL ch01 TYPE 39。SBT_TAPE39。sql 39。alter system archive log current39。BACKUP filesperset 20 FORMAT 39。al_%s_%p_%t39。 ARCHIVELOG ALL DELETE INPUT。RELEASE CHANNEL ch00。RELEASE CHANNEL ch01。ALLOCATE CHANNEL ch00 TYPE 39。SBT_TAPE39。BACKUP remended format FORMAT 39。trl_%s_%p_%t39。 CURRENT CONTROLFILE。RELEASE CHAN