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;

No comments: