RMAN中通過時間點不完全恢複報ORA-01841的解決辦法

在Linux中，對資料庫進行RMAN不完全恢複。執行recover database until time 'xxxx' 時報錯：

ORA-01841 (full) year must be between -4713 and +4713 / +9999 and must not be 0

怎麼改格式都無效。

解決方案是，設定作業系統的NLS_LANG環境變數，例如 export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

附上該錯誤的一個相關bug，不過該bug已在Oracle 9i中修複：

• Recovery Manager Tablespace Point in Time Recovery fails if the format used by
• NLS_DATE_FORMAT does not lead with a month.
•
• If NLS_DATE_FORMAT leads with a Year then ORA-01841 is returned.
• If NLS_DATE_FORMAT leads with a Day then ORA-01858 is returned.
•
• This bug only affects the Tablespace Point in Time Recovery feature.