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

ORA-31409: one or more values for input parameters are incorrect

1 Answers  


ORA-29928: duplicate default selectivity specified

1 Answers  


ORA-29325: SET COMPATIBILITY release number lower than string

1 Answers  


ORA-13632: The user cancelled the current operation.

1 Answers  


ORA-09769: osnmbr: cannot send break message

1 Answers  






RMAN-04006: error from auxiliary database: string

1 Answers  


PCC-00040: Unable to open listing file "string"

1 Answers  


NNO-00074: downloading region from server string

1 Answers  


TNS-00018: INTCTL: TNS_ADMIN not defined

1 Answers  


ORA-06121: NETTCP: access failure

1 Answers  


ORA-32587: Cannot drop nonexistent string supplemental logging

1 Answers  


DRG-12408: invalid variable reference: string.string

1 Answers  


Categories