I posted this question two or three weeks ago and said I'd follow up with
the resolution I got from Oracle Support.
Recap of the problem:
Had to do a resetlogs on a prod database owing to a recovery but needed to
recover the database to a point in time before the resetlogs (back into the
There is a way in RMAN to duplicate a database from just the backup
At first I had the backup files up to the resetlogs in E:\TEMP_BACKUPS and
backups after the resetlogs in E:\TEMP_BACKUPS2.
I connected to RMAN and connected to the database I wanted to copy as the
Allocated the channel and issued: duplicate database to testdb until time
to_date(blah blah) backup location e:\temp_backups;
This is documented in the RMAN documentation (duplicating a database with
target or recovery catalog) but I was still getting errors.
Turns out that the Backup Location is a wildcard mask and the files in
TEMP_BACKUPS2 were also being picked up. Renamed that directory and tried
again and it sort of worked.
I then discovered that in 18.104.22.168 (this server hasn't been patched yet)
there is a bug in RMAN DUPLICATE honoring UNTIL TIME parameters - it gets to
midnight at the start of the day and stops there. This bug is patched in
22.214.171.124 or patch 14 for 126.96.36.199.
So, if anyone else ever finds themselves in this very particular set of
circumstances, now you know.