OCI-01173
data dictionary indicates missing data file from a system tablespace
Cause
One of the following occurred:
- The database was recovered to a point-in-time in the future of the control file.
- A data file from a system tablespace (SYSTEM or SYSAUX) was omitted from the CREATE CONTROL FILE command previously issued.
- Recover the database from a more recent control file.
- Re-create the control file and check to ensure that all of the data files in the system tablespaces are included.
Action
Choose one of the following actions that corresponds with the
OCI-01173
data dictionary indicates missing data file from system tablespace
Cause
Either the database has been recovered to a point in time in the future of the control file or a datafile from the system tablespace was omitted from the create control file command previously issued.
Action
For the former problem you need to recover the database from a more recent control file. For the latter problem, simply recreate the control file checking to be sure that you include all the datafiles in the system tablespace.
OCI-01173
data dictionary indicates missing data file from system tablespace
Cause
Either the database has been recovered to a point in time in the future of the control file or a datafile from the system tablespace was omitted from the create control file command previously issued.
Action
For the former problem you need to recover the database from a more recent control file. For the latter problem, simply recreate the control file checking to be sure that you include all the datafiles in the system tablespace.