Oracle - Errores y soluciones

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.

Ratio: 4 / 5

ORA-01123: cannot start online backup; media recovery not enabled

Cause: An attempt to start backup of an on-line tablespace failed because media recovery is not enabled.

Action: Enable media recovery and retry this operation.

Ratio: 4 / 5

ORA-01124: cannot recover data file string - file is in use or recovery

Cause: An attempt to do media recovery found that the file was not available for recovery. Either it is online and the database is open in some instance, or another process is curently doing media recovery on the file.

Action: Do not do media recovery.

Ratio: 4 / 5

ORA-01125: cannot disable media recovery - file string has online backup set

Cause: An attempt to disable media recovery found that an online backup is still in progress.

Action: End the backup of the offending tablespace and retry this command.