Database Error Messages

ORA-38861

flashback recovery stopped before reaching recovery target

Cause

Flashback recovery on the standby ended early because the user attempted to flashback to an SCN or time for which there were no redo logs. Most likely, the user is trying to flashback to a future time in the database that the database has never recovered through. Check the alert log to find out which SCN the database recovered to.


Action

Flashback to an older SCN or acquire the necessary redo logs.