oracle 归档日期,请教rman关于备份指定时间段归档日志报错问题

谢谢刘大，是我语法和里头函数位置写错了，现在可以了，谢谢！

但现在又有个问题了,就是有些会重复备份，是什么原因？

如下：我备昨天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 thread=2 sequence=510 RECID=1268 STAMP=791497762

channel ORA_DISK_1: starting piece 1 at 17-AUG-12

channel ORA_DISK_1: finished piece 1 at 17-AUG-12