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!

Question about changing DB_RECOVERY_FILE_DEST_SIZE parameter.

Thomas MorganJul 27 2015 — edited Jul 27 2015

Over the weekend I saw our Flash Recovery Area nearing 100% and after reading following thread db_recovery_file_dest_size of 37580963840 bytes is 98.29% used and has 6442 I've decided I need to increase the size from 12TB to 14TB.  I believe following command will work:

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 14T SCOPE=BOTH;

My questions: Can this be done at anytime?  Can the database be online?  Do I have to do any special if we are using ASM?

FYI, I've already verified that ASM has enough space to support the 14TB.

Thanks,

Thomas

This post has been answered by EdStevens on Jul 27 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2015
Added on Jul 27 2015
2 comments
3,817 views