rman的每星期全备份/每日备份

RMAN script
create script. level0backup{
allocate channel d1 type disk;
allocate channel d2 type disk;
backup
incremental level 0
format '/oradata/oradata/rman/con_%d_%s_%p.bak'
tag = sunday_datafile
filesperset 5
(database include current controlfile);
sql 'alter system archive log current';
release channel d1;
release channel d2;}

create script. level2backup{
allocate channel d1 type disk;
allocate channel d2 type disk;
backup
incremental level 2 cumulative
format '/oradata/oradata/rman/con_%d_%s_%p.bak'
tag = every_datafile
filesperset 20
(database include current controlfile);
sql 'alter system archive log current';
release channel d1;
release channel d2;
execute script. archbackup;}

create script. archbackup{
allocate channel d2 type disk ;
backup
format '/oradata/oradata/rman/con_%s_%p_t%t_al.bak'
filesperset 20
archivelog all delete input;
release channel d2;
}

 

unix (compaq true64) shell script

1. rman_con_sunday.rcv
# backup on sunday.

run{execute script. level0backup;}
run{execute script. archbackup;}

2.rman_con_everyday.rcv
# backup on everyday.
run{execute script. level2backup;}

3. rman_sunday.sh
#run on sunday
#define file name
today=`date +"%C%y%m%d"`
export $today
cmdfile=/oradata/oradata/rman_script/rman_con_sunday.rcv
export $cmdfile
msglog=/oradata/oradata/rman_log/rman$today.log
export $msglog
target='target sys/sys '
export $target
rcvcat='catalog rman/rman@rman '
export $rcvcat
# run rman
rman $target $rcvcat cmdfile $cmdfile msglog=$msglog

4. rman_everyday.sh
#run on everyday
#define file name
today=`date +"%C%y%m%d"`
export $today
cmdfile=/oradata/oradata/rman_script/rman_con_everyday.rcv
export $cmdfile
msglog=/oradata/oradata/rman_log/rman$today.log
export $msglog
target='target sys/sys '
export $target
rcvcat='catalog rman/rman@rman '
export $rcvcat
# run rman
rman $target $rcvcat cmdfile $cmdfile msglog=$msglog

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14136468/viewspace-521119/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/14136468/viewspace-521119/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值