Oracle: Relocate Fast-Recovery-Area (FRA)

Note placeholder for relocating FRA before backing up to Oracle Cloud for client testing


As our database grows and grows, here especially in respect of backupsize and daily generated archive-logs, we may sometime get to a point when we have to relocate our FRA to another device with more free space. This could also be the case in a situation when we have run out of FRA-space because of an unexpected sudden massive increase of archived redologs. I just had the latter when some developers had run an upgrade of their application.

Luckily it is no big fuss to change the FRAs destination directory. It’s just a matter of changing the location with

alter system set db_recovery_file_dest='/usr4/oracle/fast_recovery_area' scope=both;

and increasing the FRAs size with

alter system set db_recovery_file_dest_size=100g scope=both;

To test the new settings we can initiate a redolog-archiving:

alter system switch logfile;
alter system checkpoint;

After this we should see a new subdirectory in the new FRA-Location with our DB’s SID as name…

View original post 141 more words

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s