Oracle ASM Implementation and Administration


Course Length: 3 days
Delivery Options: Onsite or Instructor-Led Virtual (ILT)
Maximum # Students: 12
Lecture/Lab Work: 50% / 50%

This 3-day class is designed to quickly and efficiently teach an Oracle DBA the fundamentals of Oracle Automatic Storage Management. This class will be hands on and assume that the student is an Oracle DBA or System Administrator and understands the fundamentals of database administration.


Course Overview

Oracle ASM has become the foundation of Oracle storage management for Oracle 10g and 11g. The flexibility and performance characteristics have made ASM extremely popular in a very short time. This course is designed to quickly and efficiently introduce the student to ASM and its features and nuances. This class includes both lectures and class labs, based on Oracle Database 11g Release 2.

Topics covered include:

  • ASM Overview
  • Installing Oracle Database 11g Grid Infrastructure and configuring ASM
  • ASM scalability enhancements in Oracle 11g
  • Backing up and restoring a database in an ASM environment
  • Migrating a non-ASM database to ASM
  • ASM Cluster File System (ACFS)

 

Curriculum

  • Intro to the Class
  • Overview of Oracle ASM
    • History
    • What is it?
    • Architecture
    • Tools
  • ASM New Features in 11g R2
    • ASM and the Grid Infrastructure
    • ASM Cluster File System (ACFS)
  • Architecting an ASM Solution
    • RAC
    • Non-RAC
  • Oracle Home considerations for ASM
    • Oracle Home considerations for 11gR1 and earler
    • Oracle Home considerations for 11gR2 and beyond
  • Best practices for configuring Oracle ASM
    • ASM Disk Configuration and redundancy
    • ASM and SAN / NAS
    • Oracle Data File Placement
    • Fast Recovery Area
    • Redo Log and Archive Log Placement
    • ASM Disks and Diskgroups
  • ASM Cluster File Systems
    • ASM Dynamic Volume Manager
    • Managing ASM Volumes
    • Implementing ASM Cluster File System
    • Managing ASM Cluster File System (ACFS)
    • ACFS Snapshots
  • ASM Administration
    • Managing the ASM instances using srvctl, ASMCA, and ASMCMD
    • Administering ASM Disk Group
    • ASM Files, Directories, and Templates
    • Managing ASM ACL (access control lists)
  • Migrating to ASM
    • from an 11gR1 and older environment
    • from an non-ASM database to an ASM database
  • Backup and Restore with ASM
  • Q&A

 

Labs and Hands-On Experience

The following labs are performed as part of the ASM training class.

  • Installation
    • Install ASM (11gR2)
  • Configuration
    • Configuring ASM Disk Groups
    • Creating a database in ASM
  • Migration
    • Migrating a non-ASM database to ASM
  • ASM Cluster File Systems
    • Create an ASM Cluster File System
    • Administer ASM Cluster File System
      • Using ASMCA
      • Using Command Line Tools
  • Administration
    • Administering ASM Instances
      • Administer ASM using srvctl
      • Administer ASM using ASMCA
      • Administer ASM using ASMCMD
    • Administering ASM Disk Groups
      • Adding disks to an ASM disk group
      • Removing disks from an ASM disk group
      • Moving database datafiles from one disk group to another
    • Administering ASM Files, Directories, and Templates
      • Creating and Managing ASM files, Directories, and Aliases
      • Managing Disk Group Templates
    • Monitoring ASM
  • Backup
    • Backing up an ASM database
    • Restoring an ASM database