Today one of our developer accidentally dropped some of application base tables from development instance instead of uat environment. So there was a request re-clone development database from one month old backup which was used for cloning earlier.
Simple!! everything was in proper place including datafile backups, archivelog backups, controlfile backups & cloning scripts too 🙂
I was using following clause for point in time recovery:
SET UNTIL TIME “to_date(’22-07-2014 02:10:00′,’DD-MM-YYYY HH24:MI:SS’)”;
While restoring backup I got following error:
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time 😦
As error suggests until time was definitely before last resetlogs which was done on 24th July. But from where its getting that information , as I restored controlfile which was definitely before last resetlog.
So definitely database incarnation is the issue:
RMAN> list incarnation; using target database control file instead of recovery catalog List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 FIN1 3024510604 PARENT 2704716842 07-JUL-14 2 2 FIN1 3024510604 PARENT 2704717919 07-JUL-14 3 3 FIN1 3024510604 CURRENT 6007342103534 24-JUL-14
So we need to set earlier incarnation in my case ‘2’ to proceed with the restore 🙂
RMAN> reset database to incarnation 2; database reset to incarnation 2 RMAN> list incarnation; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 FIN1 3024510604 PARENT 2704716842 07-JUL-14 2 2 FIN1 3024510604 CURRENT 2704717919 07-JUL-14 3 3 FIN1 3024510604 ORPHAN 6007342103534 24-JUL-14
So here restore proceeded without any issues.
Hope so u will find this post very useful 🙂
Cheers
Regards,
Adityanath
Categories: backup & recovery, ORA errors
Adityanath's Oracle Blog 
It helped thanks a lot.
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
I visited a lot of website but I conceive this one has something extra in it in it
bookmarked!!, I like your site!
some really interesting info , well written and broadly speaking user genial.
Hi there, I enjoy reading through your article. I like to write a little comment
to support you.
Appreciating the hard work you put into your blog and detailed information you present.
It’s awesome to come across a blog every once in a while that isn’t the same old rehashed
information. Fantastic read! I’ve bookmarked your
site and I’m adding your RSS feeds to my Google account.
Thank you so much for this! This helped me out. I had done a restore (incomplete recover) on a DB, and then needed to do it again. I got the error, and found this blog, and it solved the probem. Thank you!
Aaron
Hello There,
Appreciate the feedback!!!
Regards,
Adi
Like!! Thank you for publishing this awesome article.
Hi there mates, its enormous post about educationand fully explained, keep it up all the time.
Greetings! Very helpful advice in this particular post! It’s the little changes which will make the largest changes. Many thanks for sharing!
Hello there! Do you use Twitter? I’d like to follow
you if that would be ok. I’m undoubtedly enjoying your blog
and look forward to new posts.