ORA-01861: literal does not match format string

作者：菜鸟追梦旅行 | 2024-05-17 01:29:27

踩

ora-01861: literal does not match format string

系统：AnolisOS7.9

数据库：Oracle11.2.0.4

问题描述：执行TSPITR时，报错ORA-01861，如下所示：

[oracle@liujun~]$ export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

[oracle@liujun~]$ export NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

[oracle@liujun~]$ rman target /

RecoveryManager: Release 11.2.0.4.0 - Production on Fri Sep 9 14:53:13 2022

connectedto target database: ORCL (DBID=1642676218)

RMAN>recover tablespace dptest until time '2022-09-09 14:16:50' auxiliarydestination '/home/oracle/backup';

Startingrecover at 2022-09-09 14:53:19

usingtarget database control file instead of recovery catalog

allocatedchannel: ORA_DISK_1

channelORA_DISK_1: SID=201 device type=DISK

RMAN-00571:===========================================================

RMAN-00569:=============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571:===========================================================

RMAN-03002:failure of recover command at 09/09/2022 14:53:19

ORA-01861:literal does not match format string

异常原因为数据库时间和设置的数据格式不一致导致.

按如下进行修改：

recovertablespace dptt until time "to_date('2022-09-09 21:00:11','yyyy-mm-ddhh24:mi:ss')" auxiliary destination '/home/oracle/backup';

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/菜鸟追梦旅行/article/detail/581304