INSTANCE_TYPE - Set to ASM or RDBMS depending on the instance type.The initialization parameters that are of specific interest for an ASM instance are: Initialization Parameters and ASM Instance Creation Recommendations for Storage Preparation.It is worth taking a quick look at the following section of the documentation to familiarize yourself with the basic requirements recommendations for ASM. Enables management of database objects without specifying mount points and filenames.Provides near-optimal I/O balancing without any manual tuning.Manages disk redundancy within a disk group.Manages groups of disks, called disk groups.In summary ASM provides the following functionality: For two-way mirroring you would expect a disk group to contain two failure groups so individual files are written to two locations. Default templates are provided for each file type stored by ASM, but additional templates can be defined as needed.įailure groups are defined within a disk group to support the required level of redundancy. The level of redundancy and the granularity of the striping can be controlled using templates. The locations and names for the files are controlled by ASM, but user-friendly aliases and directory structures can be defined for ease of reference. The physical disks are known as ASM disks, while the files that reside on the disks are know as ASM files. The main components of ASM are disk groups, each of which comprise of several physical disks that are controlled as a single unit.

This is not a full database instance, just the memory structures and as such is very small and lightweight. The ASM functionality is controlled by an ASM instance. The new ASM functionality can be used in combination with existing raw and cooked file systems, along with OMF and manually managed files. The ASM functionality is an extention of the Oracle Managed Files (OMF) functionality that also includes striping and mirroring to provide balanced and secure storage. Overview of Automatic Storage Management (ASM)Īutomatic Storage Management (ASM) simplifies administration of Oracle related files by allowing the administrator to reference disk groups rather than individual disks and files, which are managed by ASM. Automatic Storage Manager (ASM) Enhancements in Oracle Database 11g Release 1.Initialization Parameters and ASM Instance Creation.Overview of Automatic Storage Management (ASM).Home » Articles » 10g » Here Automatic Storage Management (ASM) in Oracle Database 10gĪutomatic Storage Management (ASM) is a new feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfiles and logfiles.

Oracle 10g default database name