ORA-19909: datafile string belongs to an orphan incarnation
Answers were Sorted based on User's Feedback
Answer / vijay
Just do following.
1. SQL> alter database create standby controlfile
as 'C:\oracle\product\10.2.0\orad
ata\stan\control.sty';
2. copy the standby control file to standby location and
rename as to what is in the initsid.ora file.
3. starup mount;
Its should able to open the database or put it in recover
managed standby database mode
Hope this helps
Thanks
-Vijay
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / guest
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.
Please add more information about this Error
Is This Answer Correct ? | 1 Yes | 9 No |
ORA-15109: conflicting protection attributes specified
ORA-38463: invalid XML Tag list
ORA-16715: Log transport related property string of standby "string" is inconsistent.
RMAN-06566: target database incarnation not found in control file
ORA-00150: duplicate transaction ID
ORA-14136: ALTER TABLE EXCHANGE restricted by fine-grained security
ORA-22371: Table contains data of type string.string, version string, which does not exist
NNC-00417: name "string" already exists
QSM-01077: materialized view, string, is grouping at a higher level than query
LFI-00006: Invalid parameter to function string.
NNO-00611: disabling request forwarding
ORA-02435: cannot disable unique(string) - unique key not defined for table