Database Administration (MOSC)

MOSC Banner

Flashback & restore point question

Hi,

Env: Oracle 19c database single instance on linux with a Standby

For application upgrade, I enabled flashback & created guaranteed restore point. I am monitoring the flashback logs & see that the FRA/recovery area may run out of space in few hours.

Question:

Can I change the FRA location & size while the database is up & running and app upgrade is going on(data gets modified during app upgrade)?

If I change the FRA location, will the flashback logs created so far be useless & I cannot flashback the DB to the time when I had created the restore point ?

If I change the FRA location, do I have to manually copy the flashback logs, in case I want to flashback the DB to the time when I had created the restore point ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center