谢谢刘大,是我语法和里头函数位置写错了,现在可以了,谢谢!
但现在又有个问题了,就是有些会重复备份,是什么原因?
如下:我备昨天12-18点,和备18-0点的,在备18-0点时发现二个节点813 510都会又重复备一次,这是什么原因?
这个time是指v$archived_log中COMPLETION_TIME?还是RESETLOGS_TIME? FIRST_TIME ?
RMAN> backup archivelog from time "to_date(to_char(sysdate-1,'yyyy-mm-dd')||' 12:00:00','yyyy-mm-dd hh24:mi:ss')" until time "to_date(to_char(sysdate-1,'yyyy-mm-dd')||' 17:59:59','yyyy-mm-dd hh24:mi:ss')" format '/home/oracle/arch_%d_%T_%u.dat';
Starting backup at 17-AUG-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=813 RECID=1267 STAMP=791494187
input archived log th