11.2.0.3/RHEL 6
In one of our DBs , because of archiver error , we want to increase the space in file system which host the archive logs.
This DB uses FRA, so it is showing USE_DB_RECOVERY_FILE_DEST. So , how do i find the actual filesystem which stores the archive logs?
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string location=USE_DB_RECOVERY_FILE_
DEST
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 12350
Next log sequence to archive 12350
Current log sequence 12354
SQL>
SQL>
SQL> show parameter db_recover_file_dest
SQL>
SQL>
SQL> show parameter db_r
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 50G
db_recycle_cache_size big integer 0
dbwr_io_slaves integer 0
A related question:
Would you configure Flash recovery Area for your DB? None of the engineering teams in my old shops before liked/approved FRA ,
so I never got to work on FRA .