ASM init.ora Parameters

PARAMETER DESCRIPTION DB_CREATE_FILE_DEST This parameter allows the specification of the ASM disk groups using a format similar to: +diskgroup1, where diskgroup1 is an existing ASM disk group mounted in the nodes ASM instance. DB_RECOVERY_FILE_DEST This parameter allows the specification of ASM disk groups for recovery files location using a format similar to: +dgroup4, where dgroup4 is an existing ASM disk group mounted in the nodes ASM instance. DB_RECOVERY_FILE_DEST_SIZE This parameter specifies the size area to reserve in the db_recovery_file_dest specified disk group for recovery files. An example setting would be: 5G where 5 is the integer size and “G” in this setting tells Oracle this is Gigabytes. The use of K and M are also valid for kilobytes and megabytes. DB_CREATE_ONLINE-LOG_DEST_N This parameter (where “n” is replaced with 1-5), allows you to specify the disk group where redo logs will be created. For example specifying: +dgroup8, places the log files in the ASM disk group dgroup8. PARAMETER DESCRIPTION INSTANCE_TYPE In order to set the ASM parameters, this parameter must be set to instance_type = ASM. Note: This is the only required parameter. All other parameters take suitable defaults for most environments. DB_UNIQUE_NAME This parameters specifies the unique name for this group of ASM instances within the cluster or on a node. This parameter defaults to +ASM and only needs to be modified if you are trying to run multiple ASM instances on the same node. ASM_POWER_LIMIT This parameter determines the maximum power on an ASM instance for disk rebalancing operations. The default is 1, which is also the most intrusive to database operations, a higher setting makes the rebalancing operations less intrusive. ASM_DISKSTRING The purpose of this parameter is to limit the set of disks that Automatic Storage Management considers for discovery. If not specified the entire system is searched for compatible volumes which can lengthen the startup time. The Parameter default value is NULL. (This default causes ASM to find all of the disks in a platform-specific location to which it has read/write access).