ORA-01861: literal does not match format string

denglj

系统：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

Copyright(c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

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';