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!

Fast Recovery Area Size

scottjhnJun 22 2014 — edited Jun 22 2014

Oracle 11g r2 on Linux.

System Setup:

+DATA (ASM diskgroup for data file multiplexed online logs and control files total capacity of 300 GB)

FRA (cooked file system such as ext3 on separate disk /u01/oradata capacity of 300 GB)

Now create the database using the dbca:

On the screen for "Multiplex Redo Logs and Control Files", I specified /u01/oradata (located on the FRA disk) and another copy on the default location of the +DATA diskgroup.

On the Fast Recovery Area screen:

Fast Recovery Area: /u01/oradata
Fast Recovery Area Size: 4122 M Bytes
Enable Archiving --> Archive Log Destinations: /u01/oradata


This FRA will hold the following files at the runtime:

1. multiplexed online redo logs and control files

2. archived redo logs

3. backup set of the data files (full and incrementals)

Given the the fact the +DATA's capacity is 300 GB and the FRA will hold all the files shown above, can I change the default 4122 MB to a number close to the 300 GB, such as 290000 M Bytes?  or any other number (less than the FRA disk's size).

Thanks

Scott

This post has been answered by JohnWatson on Jun 22 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2014
Added on Jun 22 2014
4 comments
553 views