Archive Log Free Space for optional (ArchFreeSpaceOptional)

A consumer parameter that provides the total number of archive logs that can be created in this optional destination.

Parameter value calculation

The number of archive logs that can be generated at given location is given by
ArchFreeSpaceOptional (Archive) = (Arch_file_avail/Arch_file_total) * 100.
ARCH_FILE_AVAIL is the free space available at a given location. This value changes as per the destination. The Arch_file_total is the total space available.

• For an ASM destination, the ARCH_FILE_AVAIL value is obtained from the V$ASM_DISKGROUP_STAT view
• For a Flash Recovery Area destination, the ARCH_FILE_AVAIL is equal to the minimum value between OS_ARCH_FILE_AVAIL and FRA_FILE_AVAIL
• The FRA_FILE_AVAIL value is equal to the ((SPACE_LIMIT - SPACE_USED) + SPACE_RECLAIMABLE) value obtained from the V$RECOVERY_FILE_DEST view. If the FRA_FILE_AVAIL value is negative set it to 0.
• The OS_ARCH_FILE_AVAIL is equal to the free space available at given location (file system location or ASM location)

This parameter is supported if the instance uses ASM storage.

In case of an Instance that uses ASM storage, the ARCHIVE_SPEC application class uses V$ASM_DISKGROUP_STAT view to get the free space for disk groups those are used for storing the archive log files. The free space is considered only for the disk groups those are in mounted /connected state when the query is performed from the monitored instance.

Default parameter attributes

• Mandatory and optional destinations must be defined in the init.ora file.
• For a service= <destination name> destination type, the parameter goes into the offline status. For example, for the log_archive_dest_1=SERVICE=FIR920km destination type, the archive parameters [ArchFreeSpace and ArchFreeSpaceOptional] will go offline.

BMC ProactiveNet Performance Management properties