This content has been marked as final. Show 2 replies
In theory it should work.
"DUPLICATE recovers by default up to the last archived redo log generated at the time the command was executed, or until a time specified with a SET UNTIL clause."
Source - Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03
DUPLICATE TARGET DATABASE TO newdb DB_FILE_NAME_CONVERT=('/h1/oracle/dbs/trgt/','/h2/oracle/oradata/newdb/') UNTIL TIME 'SYSDATE-1' # specifies incomplete recovery ...