vi rman_bak.sh

点击(此处)折叠或打开

#!/bin/sh
source /home/oracle/.bash_profile
cd $ORACLE_HOME/bin
rman target / nocatalog msglog=/app/oracle/back/log/rman_bk_`date \'+%Y%m%d%H%M%S\'`.log <<EOF
run{
REPORT OBSOLETE;
DELETE force NOPROMPT OBSOLETE;
allocate channel c1 type disk;//定义通道//
allocate channel c2 type disk;//定义通道//
allocate channel c3 type disk;//定义通道//
backup full database tag \'dbfull\' format \'/app/oracle/back/data/dbfull_%u_%s_%p\' ;
backup current controlfile tag \'ctl\' format \'/app/oracle/oadb_backup/data/ctl_%s_%p_%t\';
sql \'alter system archive log current\';
#crosscheck archivelog all;
backup filesperset 3 archivelog all tag \'arch\' format \'/app/oracle/oadb_backup/data/arch_%u_%s_%p\' delete input;
release channel c1;
release channel c2;
release channel c3;
}
exit;
EOF

脚本实现的是rman 全库备份，
先删除掉无用的备份集，开启三个备份通道。

ITPub博客

rman备份脚本