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



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

Answer / guest

Cause: 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 controlfile,
possibly because this is the converted datafile.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00572: set|show save_config_interval [<seconds>] [<server_list>] : set time of next config save

1 Answers  


ORA-32104: cannot retrieve OCI error message

1 Answers  


ORA-13342: an arc geometry has fewer than three coordinates

1 Answers  


PCC-02103: Password:

1 Answers  


ORA-29506: invalid query derived from USING clause

1 Answers  






RMAN-08511: piece handle=string tag=string

1 Answers  


TNS-01079: Attempted to bequeath: string

1 Answers  


ORA-23304: malformed deferred rpc at arg string of string in call string, in tid string

1 Answers  


ORA-25278: grantee name cannot be NULL

1 Answers  


QSM-02057: ROWNUM referenced in mv

1 Answers  


RMAN-06146: changes found for file number beyond offline SCN

1 Answers  


ORA-01166: file number string is larger than string (string)

1 Answers  


Categories