ORA-01861: literal does not match format string (Limuxrman/recover)

RMAN> recover database until time '2012-02-29:21:30:00';

Starting recover at 2012-02-29:22:47:33
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/29/2012 22:47:34
ORA-01861: literal does not match format string

解决方法：

[oracle@ggx ~]$ export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

[oracle@ggx ~]$ export NLS_DATE_FORMAT=YYYY_MM_DD:HH24:MI:SS

[oracle@ggx ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Feb 29 22:54:37 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1304066861, not open)

RMAN>

RMAN>

RMAN> recover database until time '2012_02_29:21:30:00';

Starting recover at 2012_02_29:22:54:42
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

starting media recovery
media recovery complete, elapsed time: 00:00:06

Finished recover at 2012_02_29:22:54:50

RMAN>

OK了。

如果是windows：

set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
set NLS_DATE_FORMAT=YYYY_MM_DD：HH24:MI:SS

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25517773/viewspace-730313/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25517773/viewspace-730313/