Oracle - Errores y soluciones

Ratio: 4 / 5

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

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.

Ratio: 4 / 5

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

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.

Ratio: 4 / 5

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

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.

Ratio: 4 / 5

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

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.

Ratio: 4 / 5

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

Leer más: Error ORA-01150

Ratio: 4 / 5

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

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.