rman增量备份shell脚本

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/oracle/product/10.2.0/db_1/dbs/snapcf_filenet.f'; # default

./home/oracle/.bash_profile

RMAN_LOG_FILE="/file_store_area/ora_bak/log/rman_lv0_`date +%Y"-"%m"-"%d"_"%H":"%M":"%S`.log"
echo ==== started on `date` ==== > $RMAN_LOG_FILE
rman target / nocatalog msglog $RMAN_LOG_FILE append >>$RMAN_LOG_FILE <<EOF
run {

allocate channel c1 type disk;

allocate channel c2 type disk;

backup incremental level 0 database filesperset 4

include current controlfile

format '/file_store_area/ora_bak/db_bak/%T_db_lv0_%t_%s_%p'

plus archivelog delete input

format '/file_store_area/ora_bak/db_bak/%T_ar_%t_%s_%p';

release channel c1;

release channel c2;

}exit;
EOF
echo ==== finished on `date` ==== >> $RMAN_LOG_FILE =========


. /home/oracle/.bash_profile

RMAN_LOG_FILE="/file_store_area/ora_bak/log/rman_lv1_`date +%Y"-"%m"-"%d"_"%H":"%M":"%S`.log"
echo ==== started on `date` ==== > $RMAN_LOG_FILE
rman target / nocatalog msglog $RMAN_LOG_FILE append >>$RMAN_LOG_FILE <<EOF
run {

allocate channel c1 type disk;

allocate channel c2 type disk;

backup incremental level 1 database filesperset 4

include current controlfile

format '/file_store_area/ora_bak/db_bak/%T_db_lv1_%t_%s_%p';

release channel c1;

release channel c2;

crosscheck archivelog all;

ALLOCATE CHANNEL ch00 TYPE DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
BACKUP
filesperset 20
FORMAT '/file_store_area/ora_bak/db_bak/%T_ar_%t_%s_%p'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;

}
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired backup;
exit;
EOF
echo ==== finished on `date` ==== >> $RMAN_LOG_FILE =========
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值