Home >Database >Mysql Tutorial >RMAN中通过时间点不完全恢复报ORA-01841的解决办法
RMAN中通过时间点不完全恢复报ORA-01841的解决办法
- WBOYOriginal
- 2016-06-07 17:08:062984browse
在Linux中，对数据库进行RMAN不完全恢复。执行recover database until time
在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.
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：catalog 配置 成功笔记Next article：Linux下删除大数据文件中部分字段重复的行