Oracle - Errores y soluciones

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01167: two files are the same file/group number or the same filebases_datos_2

 

 

Cause: There is an overlap of file numbers in the files specified on the command line or the same file is specified twice. If they are not the exact same file then one is likely to be a backup of the other. If they are two members of the same log they must be specified together in a group file spec. This message will also appear if the same control file appears more than once in the control_files parameter in the init.ora file. If this happens, check for additional error messages.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

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

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

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

 

 

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.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

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

 

 

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

 

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

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

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

 

 

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

 

Action: Recreate the control file with a larger MAXDATAFILES.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

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

 

 

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.