Oracle Error ORA-19735: wrong creation SCN – control file expects initial plugged-in datafile

Oracle Error Message

ORA-19735: wrong creation SCN – control file expects initial plugged-in datafile

Reason for the Error

When a tablespace is plugged into a database, the tablespace is initially read-only. Oracle converts the header of the plugged-in datafiles (assign them a new creation SCN) when the tablespace is first made read-write. This error occurs when the creation SCN in the file header is different from the creation SCN in the control file, possibly because this is the converted datafile.

Solution

Either restore the initial version of the plugged-in datafile, or continue database recovery, which will recover the control file.