Recovery catalog

[alexandre]

I had to start my database with resetlogs option. After that when i run the command "resync catalog" on rman, i get the following error:

RMAN-03014: implicit resync of recovery catalog failed
RMAN-06038: recovery catalog package detected an error
RMAN-20003: target database incarnation not found in recovery catalog
How can i drop & recreate the catalog and register the database again?


Regards
Alexandre

[Zamial]

Now that you have reset the logs.

Taking another full backup may fix this error for you.

[rohitsn]

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

Issue: reset database;

This will give the database a new incarnation and the pre-resetlogs backups are not usable. Immediately back up the database.

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.

In case of any help please be free to ask me at rohitsn@altavista.com

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

[