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 12.2.0.1 we add a tiny change which prevents you from accidentally changing COMPATIBLE
while your fallback …