ORA-01206: file is not part of this database - wrong database id



ORA-01206: file is not part of this database - wrong database id..

Answer / guest

Cause: The database ID in the file header does not match the
database id in the controlfile. The file may be from a
different database, or it may not be a database file at all.
If the database was rebuilt, this may be a file from before
the rebuild. Note that if you see this error when the file
is supposed to be plugged in from another database via the
Transportable Tablespace feature, it means the database ID
in the file header does not match the one expected.

Action: Restore a copy of the correct data file and do
recovery as needed.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36182: (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.

1 Answers  


RMAN-06907: MINIMIZE LOAD option not allowed for the specified input files

1 Answers  


ORA-14195: ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object

1 Answers  


ORA-13600: error encountered in Advisor string

1 Answers  


ORA-15039: diskgroup not dropped

1 Answers  


NCR-04016: NCRR: Last interface instance handle

1 Answers  


NNO-00052: invalid domain description list

1 Answers  


ORA-16804: One or more configuration properties in metadata have invalid values.

1 Answers  


ORA-00201: controlfile version string incompatible with ORACLE version string

1 Answers  


RMAN-06727: could not locate datafilecopy string

1 Answers  


NNO-00802: Error: OCI_NEED_DATA

1 Answers  


ORA-12914: Cannot migrate tablespace to dictionary managed type

2 Answers  


Categories