Mastering Automatic Storage Management (ASM)

ASM, introduced in early 2004, has been around the block for several years now; but there is a still a sense of awe and unfamiliarity to even the most seasoned Oracle DBAs. The reason could span from lack of awareness to even myths surrounding the product, such as its yet another database to be managed. In simple terms, its just a volume manager similar to whatever is available in your OS right now with one difference its designed keeping in mind the benefits to the Oracle Database; and that alone. In this session, attendees will learn all there is to know about ASM regardless of their expertise level or exposure to ASM. The course guides the attendees through the concepts of ASM using a live demonstration from building the ASM instance and managing it.
There are no prerequisites for this course.
1 Day/Lecture & Lab
This course is designed for Oracle DBAs or anyone using AMS.
  • Why is Filesystem inadequate for Oracle
  • The Issue of POSIX locking
  • Alternatives to files raw, OCFS, ASM
  • Introduction to Volume Management for DBAs
  • ASM as a volume manager comparison with others
  • Why I/O is faster in ASM
  • Concept of ASM instance and how it is difference from a database instance. Why ASM is not a database
  • Building ASM from devices
  • Cluster Synchronization Service how to configure
  • Compatibility of ASM and database versions
  • How to present disks to ASM
  • How to create diskgroups
  • How to create tablespaces, files on diskgroups
  • Redundancy External/Normal/High
  • Preferred mirror read (in 11g)
  • Extents and Allocation Units
  • Data Dictionary Views for ASM
  • ASM Command Line Interface
  • How to check hotspots and unbalanced disks
  • How to add/drop disks online
  • How to check for rebalance
  • Concept and Management of Striping
  • Backup and restore of metadata of ASM (11g)
  • Moving files in and out of ASM
  • Fast disk resync (11g)
  • ASMLib concepts, configuration and management
  • Using SRVCTL for ASM management in RAC
  • Troubleshooting
  • Real-life tips and technique

Related Scheduled Courses