[20191122]RMAN-03999.txt

[20191122]RMAN-03999.txt

--//同事配置的伺服器存在問題,做一個記錄:

$ rlsql
SP2-0642: SQL*Plus internal error state 2021, context 1:1821:0
Unsafe to proceed
ERROR:
ORA--0001: Message -1 not found;  product=RDBMS; facility=ORA
SP2-0152: ORACLE may not be functioning properly

$ rlrman
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03999: Oracle error occurred while while converting a date: ORA-01821:

--//rman的提示很清楚.日期型別引數存在問題.

$ env  | grep -i nls
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
NLS_TIME_TZ_FORMATx=HH24.MI.SSXFF TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT=YYYY-MM-DD HH24:MI:SS.FF TZH:TZM
NLS_TIMESTAMP_FORMAT=YYYY-MM-DD HH24:MI:SS.FF
NLS_DATE_FORMAT=dd-mmm-yyyy hh24:mi:ss
--//很明顯NLS_DATE_FORMAT配置錯誤,多寫一個m.

$ export NLS_DATE_FORMAT='dd-mm-yyyy hh24:mi:ss'
$ rlrman
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Nov 22 11:31:37 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: BOOK (DBID=1337401710)

RMAN> quit
Recovery Manager complete.

$ rlsql
SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 22 11:31:45 2019
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@book>