自已在用的Oracle DB Rman Script

rman_mes_full_backup.sh

ORACLE_HOSTNAME=mes; export ORACLE_HOSTNAME
ORACLE_BASE=/orames; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/11.2.0; export ORACLE_HOME
ORACLE_SID=MES; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

backupdir="/backup/mes/"
today=`date +%Y-%m-%d`
fpath=$backupdir$today
if [ ! -d $fpath ];then
mkdir $fpath
fi
find $backupdir -mtime +3 -exec /bin/rm {} \;
#rm -irf `find $backupdir -mtime +3`

rman target / nocatalog LOG=/backup/mes/log/`date +%Y_%m_%d_%-k_%M`_full_rman.log append <<EOF
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEVICE TYPE DISK CLEAR;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$fpath/FULL_%F';
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
run {
allocate channel t1 type disk;
backup full format '$fpath/FULL_MES_%T_%u_%s_%p' database include current controlfile filesperset = 5;
sql 'alter system archive log current';
backup
    format '$fpath/FULL_ARCH_MES_%T_%u_%s_%p' archivelog all not backed up 1 times;
    delete noprompt archivelog all completed before 'sysdate-1' backed up 1 times to disk;
backup current controlfile;
release channel t1;
crosscheck backup;
delete noprompt obsolete;
}
exit
EOF
exit