ORA-19909: datafile 1 belongs to an orphan incarnation on the Standby Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-19909: datafile 1 belongs to an orphan incarnation on the Standby Database

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    ORA-19909: datafile 1 belongs to an orphan incarnation on the Standby Database

    Hi Guys
    I need your help resolving this issue please.
    I have create a standby database that has issue appling log from primary to standby. The issue was related to the controlfile so I have recreated the standby controlfile.

    Standby database was mounted
    SQL>alter database mount standby database;
    database altered.

    NOW
    Logs are shippped but not applied and alert log is showing the following error:

    ORA-19909: datafile 1 belongs to an orphan incarnation
    ORA-01110: data file 1: '/opt/app/p5m2d2/oradata01/PS21DM/dbf/system_01.dbf'

    SQL> recover standby database using backup controlfile until cancel;
    ORA-00283: recovery session canceled due to errors
    ORA-19909: datafile 1 belongs to an orphan incarnation
    ORA-01110: data file 1:
    '/opt/app/p5m2d2/oradata01/PS21DM/dbf/system_01.dbf'



    Any help is appreciated.
    Thanks
    Last edited by Ablakios; 09-11-2009 at 04:55 PM.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Did you do a point in time recovery of the primary database ?

    regards
    Hrishy

  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    I have attempted recovery but no luck.
    Anybody experience this error before..please help
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  4. #4
    Join Date
    Aug 2009
    Posts
    21
    what is the version?

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