最美情侣中文字幕电影,在线麻豆精品传媒,在线网站高清黄,久久黄色视频

歡迎光臨散文網(wǎng) 會員登陸 & 注冊

ORA-01861: literal does not match format string

2022-10-29 17:44 作者:夜灬長夢多  | 我要投稿

系統(tǒng):AnolisOS7.9

數(shù)據(jù)庫:Oracle11.2.0.4

問題描述:執(zhí)行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

異常原因為數(shù)據(jù)庫時間和設置的數(shù)據(jù)格式不一致導致.

按如下進行修改:

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


ORA-01861: literal does not match format string的評論 (共 條)

分享到微博請遵守國家法律
南乐县| 乌恰县| 时尚| 吉安市| 临沂市| 文成县| 东港市| 武功县| 平舆县| 赤城县| 屏山县| 望江县| 崇文区| 炉霍县| 玉环县| 伊宁县| 崇仁县| 竹北市| 老河口市| 正定县| 巫溪县| 阿拉善左旗| 牡丹江市| 察雅县| 阜新市| 县级市| 大宁县| 汉寿县| 西宁市| 紫云| 泗洪县| 南充市| 刚察县| 永仁县| 彭水| 营口市| 威宁| 毕节市| 略阳县| 伽师县| 商河县|