Oracle USE_DB_RECOVERY_FILE_DEST Filesystem Path – Configuration Guide

archive-logoracleoracle-12crman

As stated in oracle doc

  • The keyword USE_DB_RECOVERY_FILE_DEST to indicate the Fast Recovery Area

I know it's setted during dbca but how can identify the Fast Recovery Area filesystem path on a running Oracle12c instance?

Best Answer

SQL> show parameter db_recovery_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +O71_FRA
db_recovery_file_dest_size           big integer 8G