Oracle - Errores y soluciones

Error ORA-01113

ORA-01113: file string needs media recovery

 

---

 

Cause: An attempt was made to online or open a database with a file that is in need of media recovery.

 

Action: First apply media recovery to the file.

Error ORA-01114

ORA-01114: IO error writing block to file string (block # string)

 

---

 

Cause: The device on which the file resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.

 

Action: Restore access to the device or remove unnecessary files to free up space.

Error ORA-01115

ORA-01115: IO error reading block from file string (block # string)

 

---

 

Cause: Device on which the file resides is probably offline.

 

Action: Restore access to the device.

Error ORA-01117

ORA-01117: adding file 'string' with illegal block size: string; limit is string

 

---

 

Cause: An attempt was made to add a database file with a block size that is greater than the maximum block size allowed.

 

Action: Retry the DDL command with a smaller block size.

Error ORA-01118

ORA-01118: cannot add any more database files: limit of string exceeded

 

---

 

Cause: There is no more room in the control file for adding database files.

 

Action: Resize the control file or drop other tablespaces.

Error ORA-01119

ORA-01119: error in creating database file 'string'

 

---

 

Cause: Usually due to not having enough space on the device.

 

Action: None.