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

Cause : The log given to recovery is a backup of the online version from the time it was the current log. The archived version of the log would not be marked as end of thread. This error can also be caused by failing to list the current log of an enabled thread in a CREATE CONTROLFILE command.
Action : Find the archived version of the log and supply its name. If this is media recovery immediately following a CREATE CONTROLFILE, be sure the current log for this thread was included.

Popularity: 11% [?]

Share This

Cause : Recovery was given a log that was created before the last ALTER DATABASE OPEN RESETLOGS command. There should be another log created since then that contains the correct redo.
Action : Supply the correct log file.

Popularity: 14% [?]

Share This

Cause : The archived log is not the correct log. It is a copy of a log file that has never been used for redo generation, or was an online log being prepared to be the current log.
Action : Restore the correct log file.

Popularity: 12% [?]

Share This

Cause : This message reports the file name involved with other errors.
Action : See associated error messages.

Popularity: 8% [?]

Share This

Cause : The log is smaller than the space allocated in it. May be the result of a SHUTDOWN ABORT while it was being written by the archiver.
Action : Get a complete version of this log and use it for recovery. There should either be an online version of it or a copy that was successfully archived.

Popularity: 12% [?]

Share This

Cause : The archived log is not the correct log. A later log is needed.
Action : Restore the correct log file.

Popularity: 12% [?]

Share This

Cause : The archived log is not the correct log. An earlier log is needed.
Action : Restore the correct log file.

Popularity: 12% [?]

Share This

Cause : The archived log supplied for recovery was generated before the log that is needed. Cannot use the log for applying redo.
Action : Find the correct archived log.

Popularity: 10% [?]

Share This

Cause : The archived log supplied for recovery was generated after the log that is needed. Cannot yet use the log for applying redo.
Action : Find the correct archived log.

Popularity: 8% [?]

Share This

Cause : The archived log is corrupted or for another thread. Cannot use the log for applying the redo.
Action : Find the correct archived log.

Popularity: 9% [?]

Share This