各位大哥，小弟在做
RMAN基于时间的不完全恢复时在recover database时报错
RMAN-03002: failure of recover command at 11/20/2010 12:13:06
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until time 'NOV 20 2010 10:13:48'
ORA-01841: (full) year must be between -4713 and +9999, and not be 0


我首先在操作系统设置了时间格式Export NLS_DATE_FORMAT="YYYY.MM.DD HH24:MI:SS"
然后又在rman内部设置了时间格式sql "alter session set nls_date_format=''YYYY.MM.DD HH24:MI:SS'' "
都执行成功
接着又执行
run
{
set until time='2010.11.20 10:13:48';
restore database;
recover database;
}
但是在执行到media recovery时候报错

下面我试验的结果，请各位大哥看一下到底怎么回事
D、        转储数据库
RMAN> run
2> {set until time='2010.11.20 10:13:48';
3> restore database;
4> recover database;
5> }

executing command: SET until clause

Starting restore at 2010.11.20 12:11:49
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/ora10g/oradata/inomc/system01.dbf
restoring datafile 00002 to /opt/ora10g/oradata/inomc/undotbs01.dbf
restoring datafile 00003 to /opt/ora10g/oradata/inomc/sysaux01.dbf
restoring datafile 00004 to /opt/ora10g/oradata/inomc/users01.dbf
restoring datafile 00005 to /opt/ora10g/oradata/inomc/text01-1.dbf
channel ORA_DISK_1: reading from backup piece /opt/ora10g/flash_recovery_area/INOMC/backupset/2010_11_20/o1_mf_nnndf_TAG20101120T055037_6gfw9gm5_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/opt/ora10g/flash_recovery_area/INOMC/backupset/2010_11_20/o1_mf_nnndf_TAG20101120T055037_6gfw9gm5_.bkp tag=TAG20101120T055037
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
Finished restore at 2010.11.20 12:13:05

Starting recover at 2010.11.20 12:13:05
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/20/2010 12:13:06
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until time 'NOV 20 2010 10:13:48'
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

[ 本帖最后由 dnd_lishangyun 于 2010-11-23 19:23 编辑 ]