ORACLE 一个完整的rman备份脚本

#!/bin/bash
. ~/.bash_profile
export ORACLE_SID=prdrisk
DATE1=`date '+%Y%m%d'_%H%M%S`
mv /dbfile/scripts/log/*.log /dbfile/scripts/logs/.


$ORACLE_HOME/bin/rman log=/dbfile/scripts/log/Rman_prdrisk_$DATE1.log << EOF
connect target /;
crosscheck archivelog all;
run {
    allocate channel ch1 device type disk ;
    report schema;
    crosscheck backup of database;
    crosscheck backup of archivelog all;
    crosscheck backup of controlfile;
    crosscheck backup of spfile;
    crosscheck archivelog all;
    delete noprompt force expired backup;
    delete noprompt force expired archivelog until time 'sysdate-0.5';
    delete noprompt force expired copy;
    delete noprompt force obsolete;
    report need backup;
    report unrecoverable;
    release channel ch1;
}
run{
allocate channel ch1 device type disk maxpiecesize=4096M;
allocate channel ch2 device type disk maxpiecesize=4096M;
allocate channel ch3 device type disk maxpiecesize=4096M;
allocate channel ch4 device type disk maxpiecesize=4096M;
backup  as compressed backupset incremental level 0 
format '/dbfile/rmanbak/prdrisk_%p_%s_%u.ful'
(database);
sql 'alter system archive log current';
backup as compressed backupset 
 format '/dbfile/rmanbak/prdrisk_%p_%s_%u.arb'
(archivelog all);
backup
 format '/dbfile/rmanbak/prdrisk_%p_%s.ctb'
(current controlfile);
backup spfile format '/dbfile/rmanbak/%d_sp_%s_%p_%t.sbk' tag 'spfile_backup';
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
}
exit;
EOF