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

Threaded 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 05:55 PM.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

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