HomeOracleOracle Error ORA-38796: Not enough flashback database log data to undo FLASHBACK.

Oracle Error ORA-38796: Not enough flashback database log data to undo FLASHBACK.

Oracle Error Message

ORA-38796: Not enough flashback database log data to undo FLASHBACK.

Reason for the Error

There was not enough flashback log data to undo the flashback so a flashback was not started.

Solution

It is still possible to get to the restore target by doing a flashback until the resetlogs branch point of the restore target is reached. This can be done by executing multiple “flashback to before resetlogs” commands, or by doing a flashback to the exact time or SCN of the desired resetlogs branch point. Note that this flashback cannot be undone should an error occur. The only option is to complete the flashback.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...