This discussion is archived
4 Replies Latest reply: Nov 22, 2012 7:21 PM by mseberg RSS

Standby Database and Database Incarnations

SimonTann Newbie
Currently Being Moderated
Hi

I had an interesting error this morning with our standby database. The database has been running stable and consistently for at least 12 months when this morning the sync errored due to the standby database incarnation being different to the primary database. I reset the standby back to the same incarnation as the primary and the sync was able to complete successfully.

Primary Incarnations:
List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TAPSPROD 354190830        PARENT  5823718    10-FEB-09
2       2       TAPSPROD 354190830        PARENT  67378822   05-MAY-09
3       3       TAPSPROD 354190830        ORPHAN  69228223   11-JUN-09
4       4       TAPSPROD 354190830        PARENT  69228223   12-JUN-09
5       5       TAPSPROD 354190830        PARENT  95671230   02-OCT-09
6       6       TAPSPROD 354190830        PARENT  139559918  16-NOV-09
7       7       TAPSPROD 354190830        CURRENT 345282702  19-FEB-10
8       8       TAPSPROD 354190830        ORPHAN  5967488196141 31-OCT-12
Standby Incarnations:
List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TAPSPROD 354190830        PARENT  5823718    10-FEB-09
2       2       TAPSPROD 354190830        PARENT  67378822   05-MAY-09
3       3       TAPSPROD 354190830        ORPHAN  69228223   11-JUN-09
4       4       TAPSPROD 354190830        PARENT  69228223   12-JUN-09
5       5       TAPSPROD 354190830        PARENT  95671230   02-OCT-09
6       6       TAPSPROD 354190830        PARENT  139559918  16-NOV-09
7       7       TAPSPROD 354190830        CURRENT 345282702  19-FEB-10
8       8       TAPSPROD 354190830        ORPHAN  5965363573721 15-MAY-10
9       9       TAPSPROD 354190830        ORPHAN  5965392953600 29-MAY-10
10      10      TAPSPROD 354190830        ORPHAN  5967488196141 31-OCT-12
Note that the standby incarnations shown are post reset.

I know that the incarnation is reset during a resetlogs but I am wondering if there is any other instance where this might be the case?

The only thing that happened yesterday that I can think could possible make this happen is that I performed a Datapump Export from the Primary database and imported it into a new 11gR2 database.

Edited by: Simon Tann on Nov 22, 2012 5:35 PM
  • 1. Re: Standby Database and Database Incarnations
    mseberg Guru
    Currently Being Moderated
    Hello;

    RMAN can reset database incarnation.
    RESET DATABASE TO INCARNATION <incarnation#>
    There's also a MOS note regarding a standby an this : ( it might not be the same as yours )

    OERR: ORA-19906 recovery target incarnation changed during recovery [ID 288197.1]     



    Best Regards

    mseberg
  • 2. Re: Standby Database and Database Incarnations
    SimonTann Newbie
    Currently Being Moderated
    Hi mseberg

    Thanks for the response. Yes I was able to reset the incarnation and sync the database.

    The note you linked indicated that this could happen if resetlogs was performed on the primary or if a catalog was performed. Neither of these things happened.

    Any other thoughts?

    Cheers
  • 3. Re: Standby Database and Database Incarnations
    SimonTann Newbie
    Currently Being Moderated
    Hi mseberg

    I have found what caused the issue thanks, in part to your post, and it was a result of a combination of errors.

    We had performed a database refresh into a test database a couple of weeks ago. The first error was that at this time the person doing the refresh forgot to unmount the NFS share from the primary database. This would normally not be a problem because we rarely take backups from our test environments.

    The second error was that (you guessed it) I was asked to take a backup of the test environment, and I forgot to change the parameters in RMAN that direct the backup files to the correct location. Consequently two files were saved to the backup folder on the primary database. When the next backup job ran yesterday a catalog was performed in RMAN that found those two backup files and caused it to automatically increment the database incarnation.

    This morning the sync job ran and failed with the reported error.

    So, thanks for the help!

    Cheers

    Simon
  • 4. Re: Standby Database and Database Incarnations
    mseberg Guru
    Currently Being Moderated
    Thanks for the information and follow up!!

    Best Regards

    mseberg

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points