You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is flashback really needed for upgrade

Received Response
edited Feb 20, 2021 7:10AM in Database 6 comments


Hi guys,

It's a DB System, VM, built on Oracle 12.2.

According to documentation, we must have flashback enabled in the database in order to be able to upgrade the database:

"Your Oracle database must be configured with the following settings in order to upgrade:
The database must be in archivelog mode
The database must have flashback enabled"

I tested upgrading a DB System from 12c R2 to 19c without having the flashback enabled in the database. The upgrade completed successfully and without any issue.

Did I misunderstood anything?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!