A while ago I blogged about Fallback Strategy: Flashback Database to Guaranteed Restore Points. I included a recommendation that you must not change the
COMPATIBLE setting. But I should have been a bit more clear and precise about Guaranteed Restore Points and
COMPATIBLE parameter settings.
Guaranteed Restore Points and COMPATIBLE parameter
First of all, you can’t use
FLASHBACK DATABASE to a Guaranteed Restore Point when you changed to COMPATIBLE parameter. This was a common pitfall in older Oracle releases.
But with Oracle Database 18.104.22.168 we add a tiny change which prevents you from accidentally changing
COMPATIBLE while your fallback …