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

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.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...