Tuesday 19 June 2012

ORA-38861: flashback recovery stopped before reaching recovery target

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.

No comments:

Post a Comment