1.添加一个crontab的自动任务，每天23:30分执行一个备份脚本backup.txt


crontab -e
 
30 23 * * *  sh /xebest/u01/backup.txt


2. 编辑backup.txt脚本，内容如下


#!/bin/sh
export ORACLE_BASE=/xebest/u01/app/oracle
 export ORACLE_HOME=/xebest/u01/app/oracle/product/11.2.0/db_1
 export ORACLE_SID=xedb
 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
 export PATH=$ORACLE_HOME/bin:$PATH
 PATH=$PATH:$HOME/bin
 export PATHrman target / nocatalog log /tmp/rman_full.log append << EOF
run
 {allocate channel c1 type disk;
 allocate channel c2 type disk;
 backup  filesperset 2 database format '/xebest/u01/backup/full_data_%d_%T_%s_%p';
 sql 'alter system archive log current'; 
 sql 'alter system archive log current';
 sql 'alter system archive log current';
 backup archivelog all format '/xebest/u01/backup/arch_%d_%T_%s_%p' delete input;
 backup current controlfile format '/xebest/u01/backup/ctl_%d_%T_%s_%p';
 }EOF
rman target / nocatalog log /tmp/rman_delete.log append << EOF
allocate channel  for maintenance type disk;
 allocate channel  for maintenance type disk;  
 crosscheck backup;  
 crosscheck archivelog all;  
 crosscheck copy;     
 delete noprompt expired backup device type disk;
 delete noprompt obsolete device type disk;
 delete noprompt expired archivelog all device type disk;EOF


3. 定期查看 /tmp/rman_full.log 和 /tmp/rman_delete.log， 看看日志有没有报错信息！