Find USE_DB_RECOVERY_FILE_DEST archive location in Oracle

Check the USE_DB_RECOVERY_FILE_DEST in Archive list command

USE_DB_RECOVERY_FILE_DEST to indicate the Fast Recovery Area filesystem path which used to store the archive log when its set in archive log command.

SQL> archive log list
Database log mode                Archive Mode
Automatic archival               Enabled
Archive destination              USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence       38
Next log sequence to archive     40
Current log sequence             40 

Check the location of USE_DB_RECOVER_FILE_DEST parameter

USE_DB_RECOVERY_FILE_DEST point the location of DB_RECOVERY_FILE_DEST.

SQL>Show parameter DB_RECOVERY_FILE_DEST
NAME                        TYPE         VALUE
--------------------------  ----------  -----------------------------------
db_recovery_file_dest       string      /u01/app/oracle/fast_Recovery_area
db_recovery_file_dest_size  big integer 20G

You can go to the path and check the archivelog directory for your archive location.

Reset the USE_DB_RECOVERY_FILE_DEST if you want to configure it again.

alter system reset log_archive_dest_1 scope=spfile;
--Restart the database

Snapshot show the exact location of FRA as:

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply