Bases de Datos

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.

Subcategorías