Datafile belongs to orphan incarnation [message #490710] |
Wed, 26 January 2011 21:33 |
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 #493720 is a reply to message #490730] |
Wed, 09 February 2011 09:03 |
|
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.
|
|
|