| Oracle
11gR1 DBA: Automatic Storage Management |
| |
| Duration:
2 Days |
| |
| Description: |
This course of ASM will enlighten and educate students on how to build and maintain a dynamic, highly available Oracle database storage environment. Course will look into how the storage tier is configured for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance. Learn how to ensure consistency across server and storage platforms, maximize data redundancy, and administer Oracle ASM from the command line.
The course will discuss how extent management works in ASM, ASM structures and how it interacts with the RDBMS instance. Implementing ASM in a RAC and non-RAC environments will be discussed.
In this hands-on course the students will learn to configure and manage a ASM in a RAC and non-RAC environment. The course also includes discussions on Oracle's Clustered File System (OCFS), Oracle ClusterWare and Oracle RAC.
|
| |
|
|
Audience:
|
 |
Database Administrators |
| |
|
Required Prerequisites:
|
|
Oracle 11g DBA: Architecture and Administration |
| |
|
Suggested Prerequisites:
|
|
Oracle 11g DBA: Performance Tuning |
| |
|
Course Objectives:
|
|
Managing Oracle ASM Instances and Configuring Oracle RDBMS to leverage Oracle ASM |
|
Managing disk storage under Oracle ASM |
|
Understanding how Oracle ASM provides even I/O distribution |
|
Improving storage performance and integirty using the ASMlib API |
|
Simplify system administration with the Oracle ASM command line interface |
|
Overview of the key internal Oracle ASM structures and Algorithms |
| |
|
Course Topics
|
|
Part I: Storage Concepts |
| |
|
Storage types RAID 1, RAID 10, RAID 5, SAME |
| |
|
Storage System Architectures |
| |
|
|
DAS, SAN, NAS, iSCSI |
| |
|
|
Types of File Access |
| |
|
|
RAW |
| |
|
|
Volume Manager |
| |
|
|
File Systems |
| |
|
I/O Access
|
| |
|
|
IO Access Patterns |
| |
|
|
Variables Affecting IO |
| |
|
Multipathing
|
| |
|
Protecting Storage Stack Failures/b>
|
| |
|
Oracle Concepts
|
| |
|
|
Oracle Architecture |
| |
|
|
Background Processes |
| |
|
|
Foreground Processes |
| |
|
|
SGA |
| |
|
|
Clustering Concepts |
|
Part II: Architecture |
| |
|
ASM Architecture
|
| |
|
|
S.A.M.E |
| |
|
|
Oracle Managed Files |
| |
|
|
Background Processes |
| |
|
|
Foreground Processes |
| |
|
|
Cluster Synchronization Services (CSS) |
| |
|
|
Interaction between ASM and RDBMS Instances |
| |
|
Installation and Configuration
|
| |
|
|
Install ASMLib |
| |
|
|
ASMLib Concepts and Overview |
| |
|
|
ASM Installation and Configuration |
| |
|
|
Migrating to ASM |
| |
|
Parameters and Views
|
|
Part III: Create, Alter and Manage |
| |
|
ASM Intances
|
| |
|
ASM Disks, Disk Groups and Failure Groups |
| |
|
ASM Allocation Units and Rebalance |
| |
|
ASM Files, Alias and Templates |
| |
|
ASM Command Line Interface (asmcmd) |
| |
|
ASM Database Relationships |
| |
|
Metadata Backup and Restore |
|
Part IV: Performance Optimization |
| |
|
Storage Benchmarking
|
| |
|
|
ORION |
| |
|
|
OSWATCHER |
| |
|
|
Enterprise Manager |
| |
|
Performance Tuning
|
| |
|
|
Parameters |
| |
|
|
Views V$,GV$,X$ |
| |
|
|
Global Updates in a Clustered Environmenty |
|
|
