Find Oracle Error Code Ora- and Pl/SQL Tips and Tricks

Cause : The redo block indicated by the accompanying error, is not valid. It has a checksum that does not match the block contents.
Action : Perform recovery with a good version of the log or do time-based recovery up to the indicated time. If this happens when archiving, archiving of the problem log can be skipped by clearing the log with the UNARCHIVED option. This must be followed by a backup of every datafile to insure recoverability of the database. Restore the correct file or reset logs.

Popularity: 14% [?]

Share This

Cause : The block header on the redo block indicated by the accompanying error is not valid. The block number and time-stamp are given in an accompanying message.
Action : Perform recovery with a good version of the redo log or perform cancel-based recovery up to, but not including, the corrupted redo log file. If this happens when archiving, archiving of the problem log can be skipped by clearing the log with the UNARCHIVED option. This must be followed by a backup of every datafile to insure recoverability of the database.

Popularity: 17% [?]

Share This

Cause : The command cannot be done because the log has not been archived, and media recovery has been enabled.
Action : Archive the log or disable media recovery. If the command supports an UNARCHIVED option, then it can be used. However, this may result in making backups unusable, and forcing the drop of some offline files.

Popularity: 23% [?]

Share This