RMAN备份两天前产生的日志并删除源文件怎么写

king3171

我的定时备份脚本如下：备份正常，我想备份两天前的所有归档日志到带库，备份完成后删除原文件，这个脚本该怎么改
connect target sys/password@orcl;
connect rcvcat rman/rman@rman;
run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
allocate channel t3 type 'SBT_TAPE';
allocate channel t4 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=ultra45,NSR_DATA_VOLUME_POOL=default)';
backup filesperset 2
format '/full_%d_%U/'
(archivelog  all );
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}

[ 本帖最后由 king3171 于 2008-1-30 23:59 编辑 ]

mrbooky

有必要吗？为什么不像现在这样全备呢？

nbrr

backup archivelog  from time 'sysdate - 2' delete input;

king3171

原帖由 nbrr 于 2008-1-31 11:18 发表
backup archivelog  from time 'sysdate - 2' delete input;

这个我试过，备份和删除的是两天内的，而不是两天前的

king3171

connect target sys/password@orcl;
connect rcvcat rman/rman@rman;
run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
allocate channel t3 type 'SBT_TAPE';
allocate channel t4 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=ultra45,NSR_DATA_VOLUME_POOL=default)';
backup filesperset 2
format '/full_%d_%U/'
(archivelog  until time 'sysdate-2' delete input );
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}
这样写应该可以，不过执行时报错，很奇怪
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/01/2008 15:02:03
ORA-19563:  header validation failed for file

Recovery Manager complete.

[ 本帖最后由 king3171 于 2008-2-1 15:23 编辑 ]

babyyellow

backup  archivelog  until time ='SYSDATE-2'  delete input