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 to find the actual filesystem which stores the archive logs?
Code: Select all
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 18138
Next log sequence to archive 18141
Current log sequence 18141
To check the actual location of the FRA:
Code: Select all
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FLASH
db_recovery_file_dest_size big integer 100G
The following uses the OS file system as the storage, which is /u01/oracle/data/db1/arch:
Code: Select all
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/oracle/data/db1/arch
db_recovery_file_dest_size big integer 100G
Use the query below to check the size of ASM:
Code: Select all
SET lines 200
col total_mb for 999,999,999.99
col free_mb for 999,999,999.99
col "% Free" for 999.99
SELECT GROUP_NUMBER,name,
type,
total_mb,
free_mb,
free_mb/total_mb*100 "% Free"
FROM V$ASM_DISKGROUP;
Code: Select all
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB % Free
------------ ------------------------------ ------ --------------- --------------- -------
1 DATA EXTERN 6,105,270.00 1,362,515.00 22.32
2 FLASH EXTERN 1,045,740.00 948,431.00 90.69