1,数据库环境: Windows 2000 server + Oracle 9.2.0.1
2,数据库为归档模式,事务量每天日志切换数在15个左右
3,每天定时运行RMAN的脚本如下:
run{
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
backup
format = 'd:\Dbbackup\RmanBK\shsf_db_%u.bus'
filesperset = 5
database include current controlfile;
sql 'alter system archive log current';
change archivelog all crosscheck;
backup archivelog until time 'sysdate -3'
format = 'd:\Dbbackup\RmanBK\shsf_arch_del_%u.bus'
filesperset = 5
delete input;
backup archivelog all
filesperset = 5
format = 'd:\dbbackup\RmanBK\shsf_arch_%u.bus';
release channel d1;
release channel d2;
release channel d3;
release channel d4;
}
但最近发现RMAN备份片越来越大,我用100G的磁带都装不下了,大家有何建议?能否帮我改改RMAN备份脚本,我不建议用多级备份,因为现在数据总量还是不很大,
可不可以每次不用重复备份归档日志呢?
|