Oracle - Errores y soluciones

Ratio: 4 / 5

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.

Ratio: 4 / 5

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.

Ratio: 4 / 5

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.

Ratio: 4 / 5

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.

Ratio: 4 / 5

ORA-01120: cannot remove online database file string

Cause: Attempting to drop a datafile when it is online.

Action: Take file offline before dropping.

Ratio: 4 / 5

ORA-01121: fetch out of sequence

Cause: Attempted to use ALTER DATABASE RENAME to rename a datafile that is online in an open instance or is being recovered.

Action: Close database in all instances and end all recovery sessions.