Show parameter recovery

The Flash recovery area(FRA) is an important location in the Oracle database. It stores archivelog, flashback logs, backups etc.

1)Check and confirm Flash Recovery Area is not enabled.

The flash recovery area(FRA) is an Oracle-managed location (it may be FILE SYSTEM or ASM) for centralized backup and recovery files.

Use the following SQL*Plus command to view the settings for all initialization parameters containing "recovery" in the name.

Now the question: is it possible to change the parameter "db_recovery_file_dest" from d:\fra to e:\fra and copy the backup-sets and archive-logs.

Community.spiceworks.com › Databases › discussion.

Here in this post, we will see how to check fra size in Oracle, flash recovery area usage query, and how to increase fra size in Oracle

how to check fra size in oracle

The above query will show the total amount allocated in FRA and the total used space

select * from v$recovery_file_dest;

flash recovery area usage query

set linesize 200 trim pool on
col name form a72
select * from v$flash_recovery_area_usage;

The above will show the division of the size of archive logs, flashback logs, and backup in the total used space.

The above query will be very useful when clearing the FRA

how to increase fra size in oracle

alter system set DB_RECOVERY_FILE_DEST_SIZE=<new size> scope=both;

This is an online activity.

How to check fra location in Oracle

sqlplus / as sysdba
show parameter DB_RECOVERY_FILE_DEST

How to change FRA location in Oracle

sqlplus / as sysdba show parameter DB_RECOVERY_FILE_DEST alter system set db_recovery_file_dest='<new lo

show parameter db_recovery_file_dest_size

show parameter flash recovery area