Create the Fast Recovery Area

Currently my backups are stored on the same filegroup as data. It is not a good practice because of a bunch of reasons. Some of them are:

  1. Restore and recovery in a case of a media failure might be impossible. As backups and data are located on the same disks, a media disaster affects both at the same time.
  2. Automatic space management: alerting, deleting not needed backups are accessible when using the Fast Recovery Area. It is a functionality that makes the administration a lot easier.
  3. Separating datafiles and backups improves performance of backups creation. If they are located on the same disks, making a backup reads datafiles and writes backup files from and to the same disks. If they are separated, a part of the transfer is moved to the backup disks.
  4. If backups are stored separately, a risk of rapidly reaching disk space limit is reduced. If backups are stored with datafiles, it may happen that by making a backup, all the space is fully consumed. As the same disks are also used for datafiles, the database crashes due to a lack of space.

Giving the above reasons, I want to enable the Fast Recovery Area to store recovery data.

 

Disable log_archive_dest and log_archive_duplex_dest

First, I make sure log_archive_dest and log_archive_duplex_dest parameters are disabled.

select name, value
from v$parameter
where name in ('log_archive_dest', 'log_archive_duplex_dest')

logArchiveDest

In my case the parameters are already disabled (VALUE is NULL). If yours are not, you can do that by running the following:

alter system set log_archive_duplex_dest = '';
alter system set log_archive_dest = '';

 

Configure the Fast Recovery Area

Set db_recovery_file_dest to FRA diskgroup.

alter system set db_recovery_file_dest = '+FRA';

Do not miss valuable content. You will receive a monthly summary email. You can unsubscribe anytime.

Set size

Set the Fast Recovery Area size. Oracle will not consume more than the defined value even if there is more space on disk. Make sure the value you set does not exceed real space available.

select g.name, sum(d.total_mb), sum(d.free_mb)
from v$asm_disk d
     join v$asm_diskgroup g on d.group_number = g.group_number
where g.name = 'FRA'
group by g.name

spaceAvailableInFra

It shows there is 10 172 MB of free space on FRA. I will set space to 10 000 MB.

alter system set db_recovery_file_dest_size = '10000M';

 

Verification

select name, value
from v$parameter
where name in ('db_recovery_file_dest', 'db_recovery_file_dest_size')

fraConfigured

It is done. The Fast Recovery Area is enabled.

 

We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.