ASM Hands-On Training

Early this year I developed an ASM training that was implemented on Madrid and Tel Aviv.

The idea was to have a set of exercises that will provide lots of hands-on experience to the participants, in a few days.

On this and the following posts I will present the labs of the training.

The training was implemented using the student’s laptops. A Virtual Machine containing a Linux 5 environment setup with Oracle 10g and 11g, ready for implementing the labs, was distributed to the participants.

The requirements were :

· Laptop with a minimum of 30 GB free space on the hard disk or an external disk
· 2 / 4 GB Memory
· Sun Virtualbox 2.2 installed on the laptop

On the first lab included here : Lab1 Configuration of Devices for ASM. we created devices to be used by ASM in several different ways, the idea was to provide many examples and train the fingers on how to build ASM disks on top of them; that also provided some insights about how the discovery process works.

The whole program cover these subjects

ASM Hands-On Training Program

Training Program

DAY 1

· Getting around on the system
· ASM Architecture
· Preparing storage devices for ASM
· Preparing storage for ASM
· Loop devices,
· File system,
· Raw devices,
· Block devices
· ASMLib
· Install ASMLib,
· Create the ASM Instance
· Create the ASM instance,
· Managing diskgroups
· Kfed
· Using kfed to identify ASM Headers
· Using kfed to dump the headers of a physical device
· ORION
· Installing, configuring and running ORION simple test
· Using RMAN for Restoring a Database Into ASM
· Configure Diskgroups for restoring a database into ASM,
· Restore Database from Backup
· Normal Redundancy
· PST table
· 10g ASM Normal Redundancy Resilience test
· Drop database,
· Create Normal Redundancy Disk Group,
· Restore Database,
· Resilience test
· Additional Means for Managing ASM
· Configure XDB
· Using FTP with ASM
· Browsing ASM Directories with HTML
· Migrating Devices to ASMLib
· Migrate raw devices and block devices to ASMLib

DAY 2

· Migration to 11g
· 10g ASM migration to 11g
· Create an 11g Database in ASM
· ASM Backup, Crash, Restore and Recovery Scenarios
· Backup and Restore ASM Metadata
· ASM and Rman Crash, Restore and Recovery Scenarios Hands-On - Part I
· ASM and Rman Crash, Restore and Recovery Scenarios Hands On – Part II
· 11g ASM New Features
· Setting up 11g Compatibility Parameters
· Resilience Tests
· ASM Cloning
· Cloning a Disk group on the same server
· Bringing Up a copy of the databases on a cloned Disk Group
· Benchmarking, Monitoring and Troubleshooting
· Configure and Run Swingbench
· Configure and run OSWatcher
· Resilience Tests While Running a Benchmark Load

DAY 3

· ASM Storage Sizing
· Measuring throughput
· Defining Infrastructure requirements for Optimal Performance with ASM
· Hardware
· ASM on SAN, NAS
· ASM Metadata
· ASM Directories
· COD and ACD
· Block Dump,
· DbVerify,
· Header Dumps,
· dd
· Storage Consolidation
· Plugging ASM to a 2nd Node,
· Open the database on the 2nd Node,
· ASMCMD
· Using ASMCMD commands and options
· ASM on Extended Clusters
· Normal Redundancy
· Preferred Mirror Read
· Fast Mirror Resync
· DWDM
· Buffer Credits
· ASM on Exadata
· Frequent SR Issues on ASM


Comments:

Hi Alejandro. That seems to be an interesting training. Are you planning to extend it to other countries ? Could it be possible to have more info about its contents. Thanks, Gilles

Posted by Gilles Haro on July 03, 2009 at 04:16 AM IDT #

Gilles, We planned a second training to be held on Munchen but there is no date for it yet. Alejandro

Posted by Alejandro Vargas on July 04, 2009 at 05:22 AM IDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

bocadmin_ww

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today