Oracle RMAN数据库备份脚本

export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin:
#export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export NLS_LANG=AMERICAN_AMERICA.zhs16gbk
export ORACLE_SID=test
rman target / nocatalog log /tmp/rman_full.log append<<EOF
run
{allocate channel c1 type disk;
allocate channel c2 type disk;
backup  filesperset 3 database format '/oracle/full_%d_%T_%s_%p';
sql 'alter system archive log current'; 
backup archivelog all format '/oracle/arch_%d_%T_%s_%p' ;
backup current controlfile format '/oracle/ctl_%d_%T_%s_%p';
}
EOF
rman target / nocatalog log /tmp/rman_delete.log append<<EOF
allocate channel for maintenance type disk;
crosscheck backup;
crosscheck archivelog all;
delete noprompt archivelog until time 'sysdate-1';
delete noprompt  obsolete;
EOF