One of the principle designs of Oracle Database 10g is ease of management of the database freeing the DBA to perform other tasks. In this light, Oracle introduced Automated Storage Management (ASM) in Oracle Database 10g to simplify database file administration. Database environments have become more and more complex, with large number of data files, SAN's, JBODs and high availability requirements. Like a logical volume manager, Oracle allows you to reduce the management of Oracle files into ASM disk groups.
ASM stores files in disk groups, which are logical entities made up of one or more physical disk drives assigned to that disk group. You can store datafiles, online redo logs, archived redo logs and control files. Additionally Oracle Database 10g allows you to create the flash recovery area on an ASM disk group, so your backups to disk can be made to ASM.
Oracle touts several features associated with ASM including:
ASM fits perfectly into a RAC environment, but you can use ASM in a non-RAC environment too. The topics in this section cover the following ASM related subjects:
The ASM Instance
Configuring and Managing ASM Disks:
Accessing ASM from the Database
ASM Data Dictionary Views
Note that this article does not cover system level administrative issues, such as configuring a cluster, setting up a SAN or partitioning disks. In this article we assume that these tasks have been done already.
What about ASM limitations? There are a few that you may want to consider:
You can have up to a maximum of 10,000 ASM disks in a given storage system.
Each ASM disk can be up to a maximum of 4 petabytes in size.
Each ASM instance can manage up to 40 Exabytes of storage.
Each disk group can contain up to one million files
Maximum file sizes vary on the type of disk group:
Driving ASM is the ASM instance. The ASM instance is a separate instance, that is mounted but never has a database associated with it. You will only create one ASM instance per node. The Oracle Database Configuration Assistant (DBCA) can be used to create the ASM instance for you, or you can choose to create the ASM instance yourself. See the following topics for detailed information on the ASM Instance: