Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN-20207/RMAN-06026 Perdictimate

RobbRMar 22 2012 — edited Mar 23 2012
So 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2012
Added on Mar 22 2012
5 comments
306 views