Oracle - Errores y soluciones

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.

Página 3 de 29

© 2010-2017 Tu Informática F@cil
Subir

Las cookies de este sitio se usan para personalizar el contenido y los anuncios, para ofrecer funciones de medios sociales y para analizar el tráfico. Además, compartimos información sobre el uso que haga del sitio web con nuestros partners de medios sociales, de publicidad y de análisis web. Si se continúa navegando, consideramos que se acepta su uso. Es posible cambiar la configuración u obtener más información haciendo clic en el botón - Mas Información -