DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Recovery catalog

  1. #1
    Join Date
    Jun 2000
    Maputo, Maputo-Mozambique
    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?

    In god i trust

  2. #2
    Now that you have reset the logs.

    Taking another full backup may fix this error for you.

  3. #3
    Join Date
    Feb 2001
    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

    Rohit Nirkhe,Oracle DBA,OCP 8i


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width