RMAN-20207/RMAN-06026 Perdictimate
RobbRMar 22 2012 — edited Mar 23 2012So last Friday, 16 March 2012, one of the application administrators came to me and told me that a user had deleted ~4 million rows out of a table and we need to recover the database to 15 March 2012 at 1500. So I did, after the restore I opened the database with restlogs. Now they are telling me they need it restored to 15 March 2012 at 1015 but when I do the point in time recovery to that time I get RMAN error "RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time", so I looked at my incarnations and see that I have three (20-JUL-10, 28-OCT-11, and 16-MAR-12 (CURRENT)). And when I set the incarnation back to 2 (28-OCT-11) RMAN errors out "RMAN-06026: some targets not found - aborting restore", obviously because that point in time is earlier than the point in time I'm recovering to.
My question is, did I loose the data from my point in time recovery from 15-MAR-2012 to 28-OCT-2011 because I did the "resetlogs" option when opening the database? If I didn't how can I recover the data from 15-MAR-2012 at 1015? If I did loose my data what can I do to prevent this in the future?
Note: I'm still learning Oracle/RMAN after inheriting this position when the last guy left.