RSS:
Publications
Comments

RMAN-6038 and RMAN-20003 after Alter Database Open Resetlogs

You must use the reset database command in RMAN to create a new database incarnation record in the recovery catalog.

% rman connect target user/pwd catalog user/pwd
RMAN> reset database;

Immediately back up the database. This will give the database a new incarnation.

Explanation:
If you issue the ALTER DATABASE OPEN RESETLOGS but do not reset the database, then RMAN will not access the recovery catalog because it cannot distinguish between a RESETLOGS command and an accidental restore of an old control file. By resetting the database, you inform RMAN that the database has been opened with the RESETLOGS option


Leave a Reply

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>