Maximum Availability 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
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers

Applications Series
E-Business Suite

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
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
11g Flashback
Why Flashback?
  • An integral part of a high availability strategy
  • Return a database to a point-in-time
  • Recover a database or database object without resorting to backups
  • Undo changes to a table after commit
The PSOUG's Flashback class is part of our Maximum Availability series and is presented as a 1 day hands-on class.

How is PSOUG's Flashback class different, and we think better, than anyone else's? We minimize the slide-show and maximize practical examples and hands-on experience. All student's learn the material on their own server with Oracle Unbreakable Linux 4 and the 11gR1 database.

During class they learn the concepts, architecture, implications, and how to enable, disable, and leverage the power of Flashback in all of its forms. The syllabus, below, shows the topics covered as well as the fact that this class is hands-on: Not slow death by PowerPoint. $450/student.
 
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-9:45am Discussion 1 Flashback Database Concepts and Architecture
Flashback database allows a database to be returned to an earlier point-in-time.  We will discuss the mechanisms that make this possible, the system requirements, and how to implement the capability, flashback logs and restore points.
9:45-10:15am Lab 1 Flashback Database
Students will make changes to schemas, objects, and data and recover to an SCN, a point-in-time, and a restore point.
10:15-10:45am Discussion 2 Flashback Drop Concepts and Architecture
Flashback table is a mechanism for recovering dropped tables and their contents. We will discuss the mechanisms that make this possible, the system requirements, and how to implement the capability.
10:45-11:15am Lab 2 Flashback Drop
Students examine the recyclebin object, create and drop tables with and without PURGE, query dropped tables, and restore dropped tables to their original name and with new names.
11:45-11:45am Discussion 3 Flashback Query Concepts and Architecture
 Flashback query makes it possible to leverage undo data to view a table's data at a prior point-in-time defined by either a timestamp or system change number (SCN).
11:45-12:15pm Lab 3 Flashback Query Query
This lab will explore and utilize the capabilities of this flashback capability to restore a table's data to a prior point-in-time.
12:15-1:15pm Lunch
1:15-1:45pm Discussion 4 Flashback Table Concepts and Architecture
Flashback Table recovers a table to a point in time in the past without having to restore from a backup. We will discuss the mechanisms and best practices usage of this capability.
1:45-2:15pm Lab 4 Flashback Table
Students will make terrible messes of Oracle tables and restore them using Oracle's Flashback Table capability.
2:15-2:45pm Discussion 5 Flashback Transaction Concepts and Architecture
Flashback transaction uses undo to allow a user to review all changes made by a transaction.. We will discuss this capability, how it is implemented and best practices.
2:45-3:15pm Lab 5 Flashback Transaction
Students will engage in a hands-on lab where single transactions will result in changes to multiple objects. They will learn to view the transaction's changes, after the fact, and recover to the original point-in-time as necessary.
3:15-3:30pm Discussion 6 Flashback Version Concepts and Architecture
Flashback Versions makes it possible to leverage undo data to view a table's data at a prior point-in-time defined by a range of timestamps or a range of system change number (SCN) using the VERSIONS BETWEEN clause.
3:30-4:00pm Lab 6 Flashback Version
This is a hands on lab where students explore the full range of capabilities of the VERSIONS BETWEEN clause and best practices usage.
4:00-4:30pm Discussion 7 Flashback Archive Concepts and Architecture
Flashback Archive is an brand new 11g extension to 10g Flashback technologies extending flashback capabilities to any point-in-time.
4:30-5:00pm Lab 7 Flashback Archive
In this lab where students build a Flashback Archive and get hands on experience managing it.
 
Instructors
Dan Morgan 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.
Caleb Small is the primary instructor for the Oracle Workforce Development program at Camosun College in Victoria BC, and a private consultant with years of experience implementing and teaching Oracle throughout North America. He has over 30 years experience in the IT industry in numerous business areas including both public and private sectors.

Caleb is also active as a director of the Victoria and Puget Sound Oracle User Groups, and has delivered numerous lectures, presentations, live demos and articles to other groups.  He has authored and led many of the PSOUG workshops including RAC, ASM, RMAN and Data Guard.

Caleb was one of the first people to build an 11g RAC cluster and has been a primary consultant on RAC to publicly held corporations including Areva T&D and Montana Dakota Utilities (MDU).
 
This is site maintained by the Puget Sound Oracle Users Group. Last Updated: