Oracle - Errores y soluciones

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.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01172: recovery of thread string stuck at block string of file string

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01165: MAXDATAFILES may not exceed string

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01166: file number string is larger than string (string)bases_datos_2

 


 

Cause: File mentioned in CREATE CONTROLFILE has a file number which is larger than that specified for MAXDATAFILES or MAXLOGFILES.

 

Action: Increase the maximum specified on the command line.

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.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01168: physical block size string does not match size string of other members

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

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

 


 

Cause: Datafile number 1 was not specified in a CREATE CONTROLFILE command.

 

Action: Locate datafile number 1 and resubmit the CREATE CONTROLFILE command.