Oracle Error ORA-38861: flashback recovery stopped before reaching recovery target

Oracle Error Message

ORA-38861: flashback recovery stopped before reaching recovery target

Reason for the Error

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.

Solution

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