Hi Beefstu!

Still need help on WHICH field to use in order to derive the accurate "until time" value for autoamted duplication.

I've tried using the options below to automate duplicate, but duplication each time aborted with error:

RMAN-05501: aborting duplication of target database
RMAN-06457: UNTIL SCN (5877516207484) is ahead of last SCN in archived logs (5877516207437)

select the MAX of RC_BACKUP_SET_SUMMARY.newest_backup_time
(OR)

select max(to_char(completion_time,'YYYY-MM-DD:hh24:mi:ss'))
from RMAN.rc_backup_datafile where db_name='&DB';
(OR)

SELECT MAX(COMPLETION_TIME)
FROM RMAN.RC_BACKUP_SET_SUMMARY
WHERE DB_NAME='&DB';

Joy