ORA-01173: data dictionary indicates missing data file from
system tablespace



ORA-01173: data dictionary indicates missing data file from system tablespace..

Answer / guest

Cause: Either the database has been recovered to a point in
time in the future of the controlfile or a datafile from the
system tablespace was omitted from the create controlfile
command previously issued.

Action: For the former problem you need to recover the
database from a more recent controlfile. For the latter
problem, simply recreate the controlfile checking to be sure
that you include all the datafiles in the system tablespace.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-29231: the cryptographic engine failed to initialize

1 Answers  


ORA-13354: incorrect offset in ELEM_INFO_ARRAY

1 Answers  


NZE-28770: Data source is already initialized.

1 Answers  


ORA-07634: smsdbp: $CRETVA failure

1 Answers  


ORA-00280: change string for thread string is in sequence #string

1 Answers  






ORA-13610: The directive string does not exist for task string.

1 Answers  


ORA-09200: sfccf: error creating file

1 Answers  


RMAN-06717: number of source files (string) and destination files (string) does not match

1 Answers  


O2F-00332: A database link may not appear in the name of a user-defined type

1 Answers  


NNO-00306: server shutdown countdown aborted

1 Answers  


ORA-27146: post/wait initialization failed

1 Answers  


QSM-02120: compatibility mode must be 9.0 or higher

1 Answers  


Categories