Oracle DB Error ORA-01206 file is not part of this database - wrong database id

The following is the cause of this error:

The database ID in the file header does not match the database ID in the control file. 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 you can take to resolve this issue: Restore a copy of the correct datafile and do recovery as needed.

Tags: Database, Education, Software

Related