Oracle - Errores y soluciones

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01138: database must either be open in this instance or not at all.bases_datos_2

 


 

Cause: The requested operation can not be done when the database is mounted but not open in this instance, and another instance has the database open.

 

Action: Execute the operation in an open instance, open the datbase in this instance, or close the database in the other instances.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01148: cannot refresh file size for datafile stringbases_datos_2

 


 

Cause: An operating system or device error occurred when retrieving the file's size. The device on which the file resides may have been offline.

 

Action: Restore access to the device.

Oracle

Ratio: 4 / 5

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

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

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

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

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.