Oracle - Errores y soluciones

Oracle

Ratio: 4 / 5 - (72 Votos)

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01139: RESETLOGS option only valid after an incomplete database recoverybases_datos_2

 


 

Cause: The RESETLOGS option was given in ALTER DATABASE OPEN, but there has been no incomplete recovery session.

 

Action: Retry the ALTER DATABASE OPEN without specifying RESETLOGS.

Oracle

Ratio: 4 / 5 - (56 Votos)

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01140: cannot end online backup - all files are offline or readonlybases_datos_2

 


 

Cause: All the files were found to be offline or readonly when attempting to end an online backup.

 

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

Oracle

Ratio: 4 / 5 - (68 Votos)

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01149: cannot shutdown - file string has online backup setbases_datos_2

 


 

Cause: An attempt to shutdown normally found that an online backup is still in progress.

 

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

Oracle

Ratio: 4 / 5 - (72 Votos)

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01152: file string was not restored from a sufficiently old backupbases_datos_2

 


 

Cause: An incomplete recovery session was started, but an insufficient number of logs were applied to make the database consistent. This file is still in the future of the last log applied. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery.

 

Action: Either apply more logs until the database is consistent or restore the database file from an older backup and repeat recovery.

Oracle

Ratio: 4 / 5 - (73 Votos)

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01156: recovery or flashback in progress may need access to filesbases_datos_2

 


 

Cause: Either media recovery, instance recovery, or flashback was in progress. The recovery or flashback in progress may need the files to which this operation is being applied .

 

Action: Wait for recovery or flashback to complete.

Oracle

Ratio: 4 / 5 - (55 Votos)

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 - (67 Votos)

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.

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