Showing posts with label incarnation. Show all posts
Showing posts with label incarnation. Show all posts

Wednesday, January 31, 2007

RMAN restore and recover to previous incarnation

(1) Startup the target database in nomount mode
otherwise may encounter: RMAN-20011: target database incarnation is not current in recovery catalog
(2) Find the incarnation key
RMAN> list incarnation;
(3) Reset datatabase
RMAN> reset database to incarnation <inc_key>
(4) Restore and recover database;
Remember to restore control file first;