Oracle - Errores y soluciones 1u1e3b

ORA-01169: DATAFILE number 1 not found. Must be present

Leer más: Error ORA-01169

ORA-01171: datafile string going offline due to error advancing checkpoint

 

---

 

Cause: The checkpoint in the file header could not be advanced. See accompanying errors for the reason. The datafile will be taken offline the same as for a write error of a data block.

 

Action: See accompanying errors for details. Restore access to the file, do media recovery, and bring it back online.

ORA-01175: data dictionary has more than the string files allowed by the instance

 

---

 

Cause: The data dictionary is found to have more files than that which can be ed by this instance.

 

Action: Shutdown the instance and restart with a larger number of db_files.

ORA-01176: data dictionary has more than the string files allowed by the controlfie

 

---

 

Cause: After a CREATE CONTROLFILE, the data dictionary was found to have more datafiles than that ed by the control file.

 

Action: Recreate the control file with a larger MAXDATAFILES.

ORA-01177: data file does not match dictionary - probably old incarnation

 

---

 

Cause: When comparing the control file with the data dictionary after a CREATE CONTROLFILE or OPEN RESETLOGS, it was noted that this datafile was inconsistent with the dictionary. Most likely the file is a backup of a file that was dropped from the database, and the same file number was reused for a new file. It may also be that an incomplete recovery stopped at a time when this file number was used for another datafile.

 

Action: Do a CREATE CONTROLFILE with the correct file or none at all.