Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Guarantee restore point

LauryMay 11 2017 — edited May 11 2017

Hi,

I am working with Oracle RDBMS 12cR1.
I use restore points to recover a test database to prior points depending of the testst regarding data loads.
Usually it works good enought, but I am sometimes faced with the following error message:

ORA-38729: Not enough flashback
database log data to do FLASHBACK.

I know it is possible to create a guarantee restore point, but is it wise to do so?

What is the impact on the value for db_recovery_file_dest_size?

Kind Regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2017
Added on May 11 2017
3 comments
542 views