Bases de Datos

Ratio: 4 / 5

ORA-01111: name for data file string is unknown - rename to correct file

Cause: The data file was missing from a CREATE CONTROLFILE command or backup control file recovery was done with a control file that was saved before the file was created.

Action: Rename the MISSING file to the name of the real file.

Ratio: 4 / 5

ORA-01112: media recovery not started

Cause: An attempt to continue media recovery is being made but media recovery was not started.

Action: None.

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.