标题: RMAN DUPLICATE not honoring TIME portion of date for "UNTIL TIME" [打印本页] 作者: 刘泽宇 时间: 2023-10-22 10:57 标题: RMAN DUPLICATE not honoring TIME portion of date for "UNTIL TIME" Bug 11694127 RMAN DUPLICATE not honoring TIME portion of date for "UNTIL TIME"
描述：
UNTIL TIME is truncated when NLS_DATE_FORMAT does not contain TIME
specification during DUPLICATE . Hence the duplicate DB may be
built at the wrong point in time to that expected.
eg:
Assume the RMAN duplicate uses:
set until time "to_date('Jan 27 2011 17:05:00','Mon DD YYYY HH24:MI:SS')";
The alert.log file will show:
start until time 'JAN 27 2011 00:00:00' using backup controlfile
Rediscovery Notes
DUPLICATE fails during recovery due to a truncated date specification when
using UNTIL TIME and NLS_DATE_FORMAT does not have a time portion.
可采用的方法：
Set NLS_DATE_FORMAT to a format with time precision and then
execute the RMAN duplicate command with UNTIL TIME.
eg:
setenv NLS_DATE_FORMAT 'DD-MON-YYYY HH24:MI:SS'
setenv NLS_LANG 'AMERICAN_AMERICA.UTF8'
connect to target and auxiliary instances using RMAN
execute RMAN duplicate command with UNTIL TIME