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