Oracle - Errores y soluciones

Error ORA-01142

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.

Error ORA-01150

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

 

---

 

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.

Error ORA-01143

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.

Error ORA-01144

ORA-01144: File size (string blocks) exceeds maximum of string blocks

 

---

 

Cause: Specified file size is larger than maximum allowable size value.

 

Action: Specify a smaller size.

Error ORA-01155

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.

Error ORA-01145

ORA-01145: offline immediate disallowed unless media recovery enabled

 

---

 

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.