DBA Series
 
Home

Maximum Availability Series
Automated Storage Management (ASM)
Data Guard
Dynamic Reconfiguration
Flashback
Grid Control
Online Redefinition
Real Application Clusters (RAC)
Resumable Transactions

DBA Series
11g New features for DBAs
Audit Vault
Disaster Prevention and RMAN
Managing Terabyte Databases
Oracle Security Workshop
Sarbanes-Oxley & HIPAA Compliance

Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Oracle Forms
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers

Fusion Middleware Series
Oracle Application Server
Oracle Identity Management

Independent Classes
Interviewing and Hiring Oracle Pros
Oracle for DB2/UDB DBAs & Developers
Oracle for Informix DBAs & Developers
Oracle for SQL Server DBAs & Developers
Oracle for Sybase DBAs & Developers
UNIX, Linux and vi

Evening Workshops
Constraints
Exception Handling
Functions & Pipelined Table Functions
Interviewing
Linux and UNIX Skills
Loops Cursors and Array Processing
Materialized Views
New Objects
Partitioning
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
Disaster Prevention and RMAN
In a sense, if you have to use a backup to recover a database, you have failed. Proper planning and preparation should make it the rarest of occurrences.

That said, if that time comes, you'd better know how to wield the tool with both speed and precision.

This two-day hands-on PSOUG class focuses on exploring what can go wrong, how to prevent it, and then on perfecting the skills required to use RMAN as a complete backup, recovery, and restoration solution.

Most RMAN classes focus on its use without any real understanding on how to integrate it with the many ways to prevent it ever being necessary to do so.

The best backup tape is the one that is never required ... but works perfectly every time it is tested. The syllabus, below, shows the topics covered as well as the fact that this class is taught live in the database: Not slow death by PowerPoint. Only $900/student for this intense two day class.

Students can choose to use 10gR2 or 11gR1.
 
2007-2008 Calendar
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
 
Day 1
8:30-9:00am Registration Join us for coffee and pastries while you register.
9:00-10:00am Discussion 1 Things That Can Break
If the name is a noun ... it can break. That means servers, storage arrays, filer heads, network switches, routers, hubs, cable, fibre, NIC cards, operating systems, software, volume managers, application servers, and drivers ... and then there is user and DBA errors. We cover them all.
10:00-12:00am Discussion 2
and
Instructor
Demos		 DBA and Developer Considerations / Risk Management
This discussion focuses on actions DBAs and developers can take to minimize risks to the integrity and stability of their systems. Topics include identifying single points of failure, monitoring, patching, archive logging, NIC teaming, and live-demos of the following technologies:
 
  • Flashback Database
  • Flashback Archive
  • Flashback Drop
  • Flashback Query
  • Flashback Table
  • Flashback Transaction Query
  • Flashback Version Query
  • Resumable Transactions
  • System Events
  • System Event Triggers
  • DDL Event Triggers
  • Row Dependencies

Students will receive the source code for all instructor demos and have an opportunity to practice them during free-time.
12:00-1:00pm Lunch
1:00-1:30pm Discussion 3 RMAN Concepts and Architecture
A discussion of general RMAN concepts and architecture. The implications of using RMAN with and without a metadata repository.
1:30-2:00pm Lab 1 Oracle Installation and Configuration
 Hands-on installation and configuration of Oracle 11gR1.
2:00-3:00pm Lab 2 Flashback
This lab gives students the opportunity to create a new 11g Flashback Archive and to explore the full range of flashback technologies. All of these skills, except the Archive creation are identical in 10g.
3:00-3:30pm Lab 3 Repository Creation
Each student creates their own RMAN repository and registers their database in the repository. We then explore the repository to better understand the wealth of information that can be mined.
3:30-4:30pm Lab 4 Level 0: Complete Backup
Each student database is backed up using the RMAN repository.
4:30-5:00pm Lab 5 Level 1: Incremental Backup
Students implement Block Change Tracking, make changes to their databases, and perform multiple incremental backups.
 
Day 2
8:30-9:00am Registration Join us for coffee and pastries while you register.
9:00-9:45am Lab 6 Control File Recovery
Each students has multiple opportunities to diagnose and recover from Control File loss and corruption
9:45-10:30am Lab 7 Log File Recovery
Each student has multiple opportunities to diagnose and recover from Log File loss and corruption
10:30-11:15am Lab 8 Data File Recovery
Each student has multiple opportunities to diagnose and recover from Data File loss and corruption including the System Tablespace's data file
11:15-12:00pm Lab 8 Single Block Recovery
This lab focuses on the skill required to restore single blocks in an online tablespace while data is being accessed
12:00-1:00pm Lunch
1:00-2:00pm Discussion 4 The Rest of RMAN
RMAN is a versatile tool that can be used in many environments other than backing up a stand-alone database. This disucssion will focus on the use of RMAN to duplicate a database for standby or Data Guard and how to implement RMAN with RAC.
2:00-3:00pm Lab 10 Database Cloning
In this lab students backup their databases and create a clone suitable for use with Data Guard as a physical standby.
3:00-4:00pm Lab 11 Open Lab
This hour is used so that students can further test their skills against various forms of damage gaining more experience with diagnosis, restoration, and recovery.
4:00-5:00pm Discussion 5 Disaster Planning
An instructor led discussion of additional aspects of disaster prevention and planning.
 
Instructors
Dan Morgan is an Oracle Ace Director, a 10g and 11g Beta tester for Oracle, and the instructor of the Oracle program at the University of Washington since its inception in 1999. He began his IT career in 1969 with an IBM 370/145, punch cards, and Fortran IV, and though he will vigorously deny it, wrote COBOL for a decade before moving into Oracle about when version 6 hit the market.

In addition to Dan's work at the university he is the Education Chair of the Puget Sound Oracle Users Group, a member of UKOUG, and a member of the British-American Chamber of Commerce in Seattle. He is also a frequent lecturer at training events and at conferences and has presented at Oracle OpenWorld on RAC (2005), at Seattle OracleDay (2004-2007), at numerous government and corporate training events including Apple Computer, Argonne National Laboratory, Boeing Commercial Airplane Group, Dow Jones & Company, Lawrence Livermore National Laboratory, NASA, T-Mobile, US Navy at Pearl Harbor, and Weyerhaeuser to name but a few and presented on Streams and Change Data Capture at UKOUG in 2006.

Dan Morgan is the Morgan behind the "Morgan's Library" website that contains the many demos he has  created for his University of Washington classes as well as for his frequent lectures. He is the former publisher of MacTech Journal, has presented Oracle technical lectures in the US, Canada, Great Britain, and Japan. Morgan is also the author of this course.
 
This is site maintained by the Puget Sound Oracle Users Group. Last Updated: