Is flashback really needed for upgrade — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Is flashback really needed for upgrade

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

Content

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.

Register

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