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 ?