ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-01861: literal does not match format string (Limuxrman/recover)

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

原创 Linux操作系统 作者:gaiguoxiang 时间:2012-05-20 13:41:59 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: flashback闪回删除
请登录后发表评论 登录
全部评论

注册时间:2011-06-22

  • 博文量
    41
  • 访问量
    105599