Oracle - Errores y soluciones

Ratio: 4 / 5

ORA-01149: cannot shutdown - file string has online backup set

Cause: An attempt to shutdown normally found that an online backup is still in progress.

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

Ratio: 4 / 5

ORA-01152: file string was not restored from a sufficiently old backup

Cause: An incomplete recovery session was started, but an insufficient number of logs were applied to make the database consistent. This file is still in the future of the last log applied. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery.

Action: Either apply more logs until the database is consistent or restore the database file from an older backup and repeat recovery.

Ratio: 4 / 5

ORA-01156: recovery or flashback in progress may need access to files

Cause: Either media recovery, instance recovery, or flashback was in progress. The recovery or flashback in progress may need the files to which this operation is being applied .

Action: Wait for recovery or flashback to complete.

Ratio: 4 / 5

ORA-01137: data file string is still in the middle of going offline

Cause: It was not possible to get the lock for a file that is offline when attempting to bring it online. The most likely cause is that the lock is still held by the instance that is took it offline.

Action: Wait a bit and try to online the file again.

Ratio: 4 / 5

ORA-01138: database must either be open in this instance or not at all.

Cause: The requested operation can not be done when the database is mounted but not open in this instance, and another instance has the database open.

Action: Execute the operation in an open instance, open the datbase in this instance, or close the database in the other instances.

Ratio: 4 / 5

ORA-01148: cannot refresh file size for datafile string

Cause: An operating system or device error occurred when retrieving the file's size. The device on which the file resides may have been offline.

Action: Restore access to the device.