#!/bin/sh
source /home/oracle/.bash_profile


if [ -z 
          
#!/bin/sh
source /home/oracle/.bash_profile


if [ -z $1 ]
then
  echo "Please Input a number,Usage: 0|1|2"
  exit
else
  RMAN_LEVEL=$1
fi


export ORACLE_SID=xxxx
export TODAY=`date "+%Y%m%d"`
export RMAN_DIR=/backup/archivelog/rman/$ORACLE_SID/$TODAY-$RMAN_LEVEL




mkdir -p $RMAN_DIR
cd $RMAN_DIR
LogFile=ora_rman_bk_$ORACLE_SID-L$RMAN_LEVEL-`date "+%Y%m%d"`.log


# rman backup 
rman target /  msglog=$RMAN_DIR/$LogFile<<EOF
delete noprompt obsolete; 
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "$RMAN_DIR/cf%F";
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup as compressed backupset incremental level $RMAN_LEVEL filesperset 3 tag "dbL$RMAN_LEVEL" format "$RMAN_DIR/ora_o_%d_%t%s%p%u"
 database skip readonly include current controlfile;
sql "alter system archive log current" ;
backup(archivelog all format "$RMAN_DIR/ora_a_%d_%t%s%p%u" delete input);
release channel c1;
release channel c2;
}


list backup;
exit;
EOF


#mail backup log
mail -s "$ORACLE_SID rman L$RMAN_LEVEL backup log $TODAY"  [email protected] < $RMAN_DIR
/$LogFile





顺便提一嘴：
delete noprompt
 obsolete与delete obsolete区分

noprompt ：是不用提醒，在shell脚本中不须要对发起的delete命令进行“yes
 or no”的确认。




在crontab 中设置以下：
0 4 * * 5 sh /backup/scripts/oracle/oracle_rman_bak.sh 0 > /backup/archivelog/logs/rman.log 2>&1

0 4 * * 2 sh /backup/scripts/oracle/oracle_rman_bak.sh 1 > /backup/archivelog/logs/rman.log 2>&1



进行一周一次增量与0级备份。

#!/bin/sh
source /home/oracle/.bash_profile


if [ -z $1 ]
then
  echo "Please Input a number,Usage: 0|1|2"
  exit
else
  RMAN_LEVEL=$1
fi


export ORACLE_SID=xxxx
export TODAY=`date "+%Y%m%d"`
export RMAN_DIR=/backup/archivelog/rman/$ORACLE_SID/$TODAY-$RMAN_LEVEL




mkdir -p $RMAN_DIR
cd $RMAN_DIR
LogFile=ora_rman_bk_$ORACLE_SID-L$RMAN_LEVEL-`date "+%Y%m%d"`.log


# rman backup 
rman target /  msglog=$RMAN_DIR/$LogFile<<EOF
delete noprompt obsolete; 
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "$RMAN_DIR/cf%F";
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup as compressed backupset incremental level $RMAN_LEVEL filesperset 3 tag "dbL$RMAN_LEVEL" format "$RMAN_DIR/ora_o_%d_%t%s%p%u"
 database skip readonly include current controlfile;
sql "alter system archive log current" ;
backup(archivelog all format "$RMAN_DIR/ora_a_%d_%t%s%p%u" delete input);
release channel c1;
release channel c2;
}


list backup;
exit;
EOF


#mail backup log
mail -s "$ORACLE_SID rman L$RMAN_LEVEL backup log $TODAY"  [email protected] < $RMAN_DIR
/$LogFile

delete noprompt obsolete与delete obsolete区分