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!

Flashback Recovery Area Usage near 100% - what happens next?

741847May 23 2011 — edited May 23 2011

Hello,

I am fairly new to Oracle flashback. I have a database which is nearing 100% usage of the flashback area. Until now, I've just been increasing the size to delay the inevitable. I've also gone and pruned archivelogs (using OS commands) from the fra, but this does not seem to have any effect. What I wanted to know is, what will happen if I let it reach 100%. Will the database cease functioning or will it prune files that it no longer needs and free space on its own?

Thanks for any insight you can provide.

This post has been answered by Aman.... on May 23 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 20 2011

Added on May 23 2011

#general-database-discussions

8 comments

1,958 views