Oracle - Errores y soluciones

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01141: error renaming data file string - new file 'string' not found.bases_datos_2

 


 

Cause: An attempt to change a data file's name in the control file failed because no file was found with the new name.

 

Action: Make sure that the data file has been properly renamed by the operating system and retry.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01142: cannot end online backup - none of the files are in backup.bases_datos_2

 


 

Cause: None of the files were found to be in online backup when attempting to end an online backup.

 

Action: None. Online backup does not need to be ended for this tablespace.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01150: cannot prevent writes - file string has online backup setbases_datos_2

 


 

Cause: An attempt to make a tablespace read only or offline normal found that an online backup is still in progress. It will be necessary to write the file header to end the backup, but that would not be allowed if this command succeeded.

 

Action: End the backup of the offending tablespace and retry this command.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01143: cannot disable media recovery - file string needs media recoverybases_datos_2

 


 

Cause: An attempt to disable media recovery found a file that needs media recovery, thus media recovery cannot be disabled.

 

Action: Recover the offending file or drop the tablespace it belongs to and retry this command.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01155: the database is being opened, closed, mounted or dismountedbases_datos_2

 


 

Cause: The requested operation needs the instance to be in a particular state but the state is being changed.

 

Action: Wait for the open, close, mount, or dismount to complete then retry the operation. If necessary, a SHUTDOWN ABORT will always work.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01145: offline immediate disallowed unless media recovery enabledbases_datos_2

 


 

Cause: ALTER TABLESPACE ... OFFLINE IMMEDIATE or ALTER DATABASE DATAFILE ... OFFLINE is only allowed if database is in ARCHIVELOG mode.

 

Action: Take tablespace offline normally or shutdown abort. Reconsider your backup strategy. You could do this if you were archiving your logs.

Página 7 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 -