Datasheet

Exam Essentials
45
Exam Essentials
Enumerate the benefits and characteristics of Automatic Storage Management (ASM).
Understand how ASM can relieve you of manually optimizing I/O across all files in the
tablespace by using ASM disk groups. Show how ASM operations can be performed online
with minimal impact to ongoing database transactions.
Be able to create an ASM instance and configure its initialization parameters. Under-
stand the initialization parameters
INSTANCE_TYPE, ASM_POWER_LIMIT, ASM_DISKSTRING,
and
ASM_DISKGROUPS. Congure DB_UNIQUE_NAME for an ASM instance. Start up and shut
down an ASM instance, noting the dependencies with database instances that are using
the ASM instance’s disk groups.
Understand the architecture of an ASM instance. Enumerate the different states for an
ASM instance. Describe what happens when an ASM instance is shut down normally or
is aborted. Understand and describe the differences between an RDBMS instance and an
ASM instance.
Understand redundancy and resync. Describe what redundancy is and how it’s imple-
mented in ASM. Understand what a failure group is and how it is created. Know what
ASM fast disk resync and preferred mirror read are.
Understand how ASM filenames are constructed and used when creating Oracle objects.
Differentiate how different ASM filename formats are used and how files are created depend-
ing on whether the file is an existing ASM file, whether a new ASM file is being created, or
whether multiple ASM files are being created. Understand the different system templates for
creating ASM files with the associated filename and how the characteristics are applied to the
ASM files. Show how ASM files are used in SQL commands.
Be able to create, drop, and alter ASM disk groups. Dene multiple failure groups for
new disk groups and make sure you understand how the number of failure groups is differ-
ent for two-way and three-way mirroring. Show how disk rebalancing can be controlled or
rolled back. Understand the ASM disk group attributes and how they are used.
Identify the steps involved in converting non-ASM files to ASM files using RMAN. M i g r a t e
a database to ASM disk groups by shutting down the database, running an RMAN script for
each file to be converted, and opening the database with
RESETLOGS.
95134c01.indd 45 1/28/09 9:43:47 AM