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?

1 Answer 1

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
  • Thank you! Here I found also select * from v$recovery_file_dest; that I think it's the same.
    – sgargel
    Commented Mar 2, 2017 at 9:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.