RMAN recover - how to start recovery again after an Open resetlogs
Oracle EE 12.1.0.2
Linux 2.6.32-754.23.1.el6.x86_64
What happened: There is an interval partitioned table (year long partitions) that was mistakenly purged by dropping the current years partition. The process was put into place every night that dropped the current partition. So, every night, prior to the drop partition, we would have had the current days worth of data. I know the exact time when the drop partition job juns.
In order to get the data back I need to restore from the backup to the point in time just prior to the time the partition is dropped, export the days worth of data and then somehow recover until the point in time just prior to the next days drop partition time. I need to do this for about 14 days worth of data. I had planned on setting a restore point prior to opening the database , opening the database, reading the data and then flashing back to the restore point in order to recover until just before the