Home » Server Options » Data Guard » Datafile belongs to orphan incarnation (Oracle 10g,Sun 5.10)
Datafile belongs to orphan incarnation [message #490710] Wed, 26 January 2011 21:33 Go to next message
karthickbab
Messages: 16
Registered: November 2009
Location: India
Junior Member
Hi,
When i try to execute 'Alter database recover managed standby database disconnect from session', it gives the following error. Can anyone resove this.

Error:
MRP0: Background Managed Standby Recovery process started (oradg)

Managed Standby Recovery not using Real Time Apply

MRP0: Background Media Recovery terminated with error 19909

Thu Jan 27 08:52:36 2011

Errors in file /Oracle/oracle/oradata/data/admin/bdump/oradg_mrp0_28834.trc:

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: '/Oracle/oracle/oradata/data/oradata/system01.dbf'

Thu Jan 27 08:52:36 2011

Errors in file /Oracle/oracle/oradata/data/admin/bdump/oradg_mrp0_28834.trc:

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: '/Oracle/oracle/oradata/data/oradata/system01.dbf'

Thu Jan 27 08:52:36 2011

MRP0: Background Media Recovery process shutdown (oradg)

Thu Jan 27 08:52:37 2011

Completed: alter database recover managed standby database disconnect from session


Re: Datafile belongs to orphan incarnation [message #490730 is a reply to message #490710] Thu, 27 January 2011 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-19909: datafile %s belongs to an orphan incarnation
 *Cause: Either the specified datafile was restored from a backup that was
         taken during a period of time that has already been discarded by
         a resetlogs operation, or Oracle cannot identify which database
         incarnation the file belongs to.  The alert log contains more
         information.
 *Action: Restore a backup of this file that belongs to either the current
          or a prior incarnation of the database.  If you are using RMAN
          to restore, RMAN will automatically select a correct backup.

Regards
Michel
Re: Datafile belongs to orphan incarnation [message #493720 is a reply to message #490730] Wed, 09 February 2011 09:03 Go to previous message
kvjoy79
Messages: 1
Registered: February 2011
Junior Member
It seems you have performed cloning of the database,
best way to rectify this is to use:

rman > list incarnation of database;

rman > reset database to incarnation <key>

this key should be the one matching your production database incarnation key.
Previous Topic: Clarification Regarding File Growth in Physical Standby
Next Topic: UPGRADE ORACLE 9i R2 single instance to 11G R2 RAC
Goto Forum:
  


Current Time: Wed Aug 12 05:17:24 CDT 2020