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 Data Guard
|
|
The purpose of Oracle Data
Guard is:
- Disaster recovery
- Off-site replication
- Offload backups from
production servers
- Load a reporting server
And our class teaches
hands-on skills for:
- duplicating databases
with RMAN
- Building Physical
Standbys
- Building Logical
Standbys
- Failover and Switchover
|
|
The PSOUG's .... The syllabus, below,
shows the topics covered as well as the fact that this
class is hands-on: Not slow death by PowerPoint.
$900/student.
|
|
Day 1
|
| 8:30-9:00am |
Registration |
Join us for coffee and pastries while you register. |
| 9:00-10:00am |
Discussion 1 |
Data
Guard Concepts and Architecture
A discussion of Data Guard and high availability concepts and
architecture, the potential for data loss, types
of standby databases, |
| 10:00-11:00am |
Lab 1 |
Operating System Installation and Configuration
Working with Oracle Unbreakable Linux 4 each student will perform a hands-on
installation of the operating system on their own server.
The Linux operating system normally requires configuration for the Oracle database. This lab includes the standard
kernel configurations plus those configurations specific to Data
Guard.
We will also NFS mount our lab's NetApp 270c. |
| 11:00-12:00pm |
Lab 2 |
Primary
Database Installation and Configuration
In this lab each student installs Oracle the
10.2.0.1 database and patches it to 10.2.0.3. |
|
1:00-1:30pm
|
Lab
3 |
Primary
Database Preparation
Students in this lab gain hands-on experience
creating PFILES, IFILES, and SPFILES. A
custom IFILE will be created that supports best
practice for Physical Data Guard implementation. |
| 1:30-2:00pm |
Lab
4 |
RMAN
Backup For Duplication
In this lab each student will learn to start RMAN,
create a repository catalog, register their
database with the catalog, and create a backup of
their database, archive logs, and control files
for duplication. |
| 2:00-2:30pm |
Lab
5 |
Standby
Preparation
In this lab we SCP backup, initialization, and
SQLNET files to the standby host server and, using
vi, modify each file to be ready for standby
creation. Other preparatory tasks such as
directory and password file creation will also be
done. |
| 2:30-3:00pm |
Lab
6 |
Standby
Creation
Using RMAN the Standby Database will be created. |
| 3:00-4:30pm |
Lab
7 |
Physical
Switchover and Failover Testing
Students, working as teams, will use this lab to
perfect their skills performing ping-pong
switchovers and failovers from their primary
production databases to their standbys. Activate
their standbys and repeat the exercise testing out
different protection modes. |
|
|
Day 2 |
| 9:00-10:30am |
Lab
8 |
Standby
Creation
Students will learn best practice for creating
logical standby databases from physical standbys |
| 10:30-12:00pm |
Lab
9 |
Logical
Standby Management
This lab will allow teams time to work with the
instructor on managing their logical standby
databases. |
| 1:00-2:00am |
Discussion
2 |
Data
Guard Broker
This discussion focuses on the Data Guard Broker,
its capabilities, and commands. |
| 2:00-3:00pm |
Lab
10 |
Data
Guard Broker Management
This lab will allow teams the time to work with
the instructor on using the Data Guard Broker to
manage their Data Guard implementations. |
| 3:00-4:00pm |
Lab
11 |
Open
Lab
This lab is an opportunity for students to
practice theirs skills and further explore Data
Guard with the instructor. |
| 4:00-4:30pm |
Discussion
3 |
Data
Guard and RAC
This discussion will cover the intricacies and
considerations when implementing Data Guard on RAC
clusters. |
|
|
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 Data Guard
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).
|
|
