Oracle数据库RMAN的自动备份脚本.docx

Oracle数据库RMAN的自动备份脚本1、数据库设置为归档方式2、数据库的备份脚本db_full_backup.sh ：数据库全备脚本db_l0_backup.sh ：数据库0级备份脚本db_l1_backup.sh ：数据库1级备份脚本ftp.sh ：数据FTP上传脚本ftp_del.sh ：数据FTP清理脚本rman_bak.sh ：数据备份主程序3、备份原理每周1、3、6进行0级备份每周日、2、4、5进行1级备份备份文件上传到FTP服务器FTP服务器每周清理一次，但是清理后将周六和周日的备份进行保留(6.bak和0.bak)所有工作防暑crontab中自动执行备份4、备份目录含义arc ：数据库归档目录rmanbak ：数据库备份文件的保存目录rmanscripts ：数据库脚本存放路径5、FTP目录ftp上必须手动建立目录L0：-1-3-6-6.bakL1：-2-4-5-0-0.bakrman_bak.sh脚本主程序#!/bin/bash#-# Oracle auto backup using rman# author:songrh# week:1,3,6 Level 0 backup# 2,4,5,0 Level 1 backup# Copyright by ChenLong Tec#-#export ORACLE_BASE=/u02/oracleexport ORACLE_HOME=/u02/oracle/product/9.2.4export ORACLE_SID=PRODexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlibexport NLS_LANG=american_america.ZHS16GBKexport TNS_ADMIN=$ORACLE_HOME/network/adminexport ORA_NL33=$ORACLE_HOME/ocommon/nls/admin/dataexport PATH=/bin:/usr/bin:/usr/sbin:$ORACLE_HOME/bin:$PATHexport PATH=$PATH:/opt/local/bin#SH_PATH=/u02/rmanscriptsARC_PATH=/u02/archRMAN_BAK_PATH=/u02/rmanbak#FULL_PATH=$RMAN_BAK_PATH/fullL0_PATH=$RMAN_BAK_PATH/L0L1_PATH=$RMAN_BAK_PATH/L1#DAY_TAG=date %Y-%m-%dLOG_TAG=date %Y-%m-%d#FIRST_DAY=date %eWEEK=date %w#WEEK=1# FTP configureIP=55FTPUSER=ftpbakFTPPASS=*FTPROOT0=L0FTPROOT1=L1#DISK_USE=df -k |sed -n /u02/p | awk print $5 |sed s/%/#check path function#if $DISK_USE -ge 90 ; thenrm -rf $L0_PATH/*rm -rf $L1_PATH/*fiif $WEEK = 6 -o $WEEK = 3 -o $WEEK = 1 ; thenif ! -d $L0_PATH ; thenmkdir $L0_PATHfiif $WEEK = 1 ; thenrm -rf $L0_PATH/*rm -rf $L1_PATH/*mkdir $L0_PATH/$WEEK$SH_PATH/db_l0_backup.sh $L0_PATH/$WEEKcd $L0_PATH/$WEEK$SH_PATH/ftp_del.sh $IP $FTPUSER $FTPPASS $FTPROOT0 $WEEK $WEEK_$LOG_TAG.logelseif ! -d $L0_PATH/$WEEK ; thenmkdir $L0_PATH/$WEEK$SH_PATH/db_l0_backup.sh $L0_PATH/$WEEKcd $L0_PATH/$WEEK$SH_PATH/ftp.sh $IP $FTPUSER $FTPPASS $FTPROOT0 $WEEK $WEEK_$LOG_TAG.logelserm -rf $L0_PATH/$WEEK/*$SH_PATH/db_l0_backup.sh $L0_PATH/$WEEKcd $L0_PATH/$WEEK$SH_PATH/ftp.sh $IP $FTPUSER $FTPPASS $FTPROOT0 $WEEK $WEEK_$LOG_TAG.logfifielseif ! -d $L1_PATH ; thenmkdir $L1_PATHfiif ! -d $L1_PATH/$WEEK ; thenmkdir $L1_PATH/$WEEK$SH_PATH/db_l1_backup.sh $L1_PATH/$WEEKcd $L1_PATH/$WEEK$SH_PATH/ftp.sh $IP $FTPUSER $FTPPASS $FTPROOT1 $WEEK $WEEK_$LOG_TAG.logelserm -rf $L1_PATH/$WEEK/*$SH_PATH/db_l1_backup.sh $L1_PATH/$WEEKcd $L1_PATH/$WEEK$SH_PATH/ftp.sh $IP $FTPUSER $FTPPASS $FTPROOT1 $WEEK $WEEK_$LOG_TAG.logfifidb_l0_backup.sh零级备份程序#!/bin/bashL0_PATH=$1DAY_TAG=date %Y-%m-%drman target / nocatalog msglog $L0_PATH/L0_db_backup_$DAY_TAG.log /dev/nullrunallocate channel c0 type disk;backup incremental level 0 database tag L0_dbf_bak format $L0_PATH/L0_%d_DF_s.%s_p.%p_%T.bak plus archivelog tag L0_arc_bak format $L0_PATH/L0_%d_ARC_s.%s_p.%p_%T.bak delete all input;backup tag L0_spfile_bak format $L0_PATH/L0_%d_SPFILE_s.%s_p.%p_%T.bak spfile;backup tag L0_ctl_bak format $L0_PATH/L0_%d_CTL_s.%s_p.%p_%T.bak current controlfile;release channel c0;#crosscheck backup;#delete noprompt expired backup;#delete noprompt obsolete;EOFdb_l1_backup.sh一级备份程序#!/bin/bashL1_PATH=$1DAY_TAG=date %Y-%m-%drman target / nocatalog msglog $L1_PATH/L1_db_backup_$DAY_TAG.log /dev/nullrunallocate channel c1 type disk;backup incremental level 1 database tag L1_dbf_bak format $L1_PATH/L1_%d_DF_s.%s_p.%p_%T.bak plus archivelog tag L1_arc_bak format $L1_PATH/L1_%d_ARC_s.%s_p.%p_%T.bak delete all input;backup tag L1_spfile_bak format $L1_PATH/L1_%d_SPFILE_s.%s_p.%p_%T.bak spfile;backup tag L1_ctl_bak format $L1_PATH/L1_%d_CTL_s.%s_p.%p_%T.bak current controlfile;release channel c1;#crosscheck backup;#delete noprompt expired backup;#delete noprompt obsolete;EOFFTP主程序#!/bin/bash_IP=$1_FTPUSER=$2_FTPPASS=$3_FTPROOT=$4_WEEK=$5_LOG=$6#_FILE=$7echo .FTP Trans $_IP. $_LOGdate %Y-%m-%d-%T:FTP $_IP Trans Begin. $_LOG 2$_LOGftp -d -i -n $_LOG 2$_LOGopen $_IPuser $_FTPUSER $_FTPPASScd $_FTPROOT/$_WEEKbimdelete *mput *byeFTPITFTP目录维护程序#!/bin/bash_IP=$1_FTPUSER=$2_FTPPASS=$3_FTPROOT=$4_WEEK=$5_LOG=$6#_FILE=$7echo .FTP Delete And Trans $_IP. $_LOGdate %Y-%m-%d-%T:FTP $_IP Begin. $_LOG 2$_LOGftp -d -i -n $_LOG 2$_LOGopen $_IPuser $_FTPUSER $_FTPPASScd /l1/2mdelete *cd /l1/4mdelete *