Four Advanced Oracle Classes

Oracle Database 10g:Data Guard Administration

What you will learn:

In this course, students learn how to use Oracle Data Guard to help protect their Oracle Database against planned and unplanned downtimes. Data Guard architecture is discussed, as well as the creation of physical and logical standby databases. In addition, the course examines the performance implications of using various Data Guard features and offers some troubleshooting tips. Students use Enterprise Manager Grid Control to create and manage their Data Guard configuration in the classroom. The course includes a workshop where students have the opportunity to apply what they have learned to meet stated business requirements.

• Prepare the primary database for a Data Guard Configuration
• Monitor a Standby configuration
• Create a Physical Standby database
• Create a Logical Standby database

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Instruction Language
View Schedule	Instructor-Led Training	US$ 1,800	3 Days	English	English

Audience:
Technical Consultant
Database Administrators
Support Engineer

Prerequisites:

Required Prerequisites:
Oracle Database 10g: Administration Workshop I Release 2

Suggested Prerequisites:
Oracle Enterprise Manager 10g Grid Control

Course Objectives:
Configure Primary Database
Create physical Standby
Create logical standby
Manage Data Guard configuration with Enterprise Manager Grid Control
Use Data Guard with Real Application Clusters

---

Course Topics:
Oracle Data Guard: Overview
Factors affecting planned and unplanned down time
Components of Oracle Data Guard
Differences between physical and logical standby databases
Benefits of creating a Data Guard environment
Use of Data Guard in high availability architecture

Understanding the Oracle Data Guard Architecture
Data Guard architecture
Operational requirements of Data Guard
Data Guard processes, transports, and redo log apply
Standby database mode

Data Guard Broker and Enterprise Manager
Data Guard broker architecture
Data Guard broker components
benefits of the Data Guard broker
Data Guard broker configurations
Enterprise Manager to manage your Data Guard configuration
DGMGRL to manage your Data Guard configuration

Creating a Configuration with Enterprise Manager
FORCE LOGGING
create a broker configuration
monitor the broker configuration

Creating a Physical Standby Database by Using SQL
SQL commands to create a physical standby database

Data Protection Modes and Log Transport Services
Data protection modes
Changing the data protection mode of your configuration
Modify log transport services

Data Guard SQL Apply Architecture
Advantages of SQL Apply
When to use a logical standby database
Creating a logical standby database by using Enterprise Manager

Creating a Logical Standby Database by Using SQL
Use SQL commands to create a logical standby database

Switchover and Failover
Database roles
Switchover
Failover
Flashback Database after a failover

Using Data Guard with RAC
Data Guard in a Real Application Clusters environment
Assign threads to standby redo logs
Switchovers and failovers with RAC

Other Considerations for Oracle Data Guard
Back up the primary database with a physical standby database
Back up a logical standby database
Flashback Database features in a Data Guard configuration
Encrypt redo information
Cascaded redo log destinations

Oracle Database 10g: Real Application Clusters

What you will learn

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 1 for Oracle Real Application Clusters (RAC).

Students learn how to configure and administer a database for use with Real Application Clusters. The course also explains how to setup and use Automatic Storage Management (ASM) in a Real Application Clusters environment. Lectures are reinforced with hands-on practices designed to walk the student through the RAC administration

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Instruction Language
View Schedule	Instructor-Led Training	US$ 3,750	5 Days	English	English

Audience:
Database Administrators

Prerequisites:

Required Prerequisites:
Oracle Database 10g: New Features for Administrators
Oracle Database 10g: Administration Workshop I Release 2

Course Objectives:
Identify Real Application Clusters components
Install, create, administer, and monitor a Real Application Clusters database
Use configuration and management tools for Real Application Clusters databases
Migrate your database storage to Automatic Storage Management
Setup services for workloads management, and applications high availability
Develop a backup and recovery strategy for Real Application Clusters databases
Review high availability best practices

---

Course Topics:
Introduction
Define a cluster
Define Oracle Real Application Clusters
List the advantages of using RAC
Define scalability
High availability and RAC

Architecture and Concepts
List the various components of Cluster Ready Services (CRS) and Real Application Clusters (RAC)
Describe the various types of files used by a RAC database
Describe the various techniques used to share database files across a cluster
Describe the purpose of using services with RAC

RAC Installation and Configuration Part I
Outline Oracle 10g RAC Installation
Preinstallation Tasks
Cluster Setup Tasks
Installing OCFS
Installing Cluster Ready Services

RAC Installation and Configuration Part II
Install Database Software
Launching VIPCA with root.sh
Database Precreation Tasks
Creating the Cluster Database
Database Postinstallation Tasks
Administering Enterprise Manager Jobs in Real Application Clusters
Node Addition and Deletion and the SYSAUX Tablespace
AWR snapshots in RAC

RAC Database Instances Administration
Understand the EM Cluster Database Home Page
Starting and Stopping RAC Instances
RAC Initialization Parameter Files
Adding a Node to a Cluster
Deleting Instances from a RAC Database
Quiescing RAC Databases
Administering Alerts with Enterprise Manager

Administering Storage in RAC Part I
Describe automatic storage management (ASM)
Install the ASM software
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Add ASM instances to the target list of Database Control
Use Database Control to administer ASM in a RAC environment

Administering Storage in RAC Part II
Manage redo log groups in a RAC environment
Manage undo tablespaces in a RAC environment
Use SRVCTL to manage ASM instances
Migrate database files to ASM
Manage and recover the OCR file and voting disk

Services
Configure and manage services in a RAC environment
Use services with client applications
Use services with the Database Resource Manager
Use services with the Scheduler
Set performance-metric thresholds on services
Configure services aggregation and tracing

High Availability of Connections
Configure client side connect-time load balancing
Configure client side connect-time failover
Configure server side connect-time load balancing
Benefit from Fast Application Notification (FAN)
Configure server-side callouts
Configure the server and client-side ONS
Configure Transparent Application Failover (TAF)

Managing Backup and Recovery in RAC
Configure RAC Recovery Settings with EM
Configure RAC Backup Settings with EM
Initiate Archiving
Configuring RMAN
RAC Backup and Recovery Using EM

RAC Performance Tuning
Determine RAC specific tuning components
Tune instance recovery in RAC
Determine RAC specific wait events, global enqueues, and system statistics
Implement most common RAC tuning tips
Use the Cluster Database Performance pages
Use Automatic Workload Repository and Automatic Database Diagnostic Monitor in RAC

Design for High Availability
Design a Maximum Availability Architecture in your environment
Determine the best RAC and Data Guard topologies for your environment
Configure the Data Guard Broker configuration files in a RAC environment
Patch your RAC system in a rolling fashion

Oracle Enterprise Manager 10g Grid Control

What you will learn

This course introduces students to Oracle Enterprise Manager 10g Grid Control. Students learn how to use Grid Control to install the management agent, configure administrators and groups, manage targets and jobs and establish security of the environment. Hands-on practice sessions give students an opportunity to examine many of the Grid Control capabilities for themselves.

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Instruction Language
View Schedule	Instructor-Led Training	US$ 3,750	5 Days	English	English

Audience:
Support Engineer
Technical Consultant
Database Administrators

Prerequisites:

Suggested Prerequisites:

Familiarity with Oracle Application Server 10g
Familiarity with Oracle Database 10g
Oracle Application Server 10g: New Features for Administrators
Oracle Database 10g: New Features for Administrators
Oracle Database 10g: Administration Workshop I Release 2

Course Objectives:
Install and configure Oracle Enterprise Manager 10g Grid Control
Administer Oracle Enterprise Manager 10g Grid Control
Use the Oracle Enterprise Manager Grid Control job system
Monitor Web Applications using Application Service Level Monitoring (ASLM)
Secure Oracle Enterprise Manager 10g Grid Control

Return to top

---

Course Topics:
Understanding Grid Control's Architecture
Grid Control Components
Grid Control Console

Installing the Management Framework
Oracle Management Repository Installation
Oracle Management Service Installation

Managing Grid Control
EMCTL Utility
Grid Control Component Stop and Start

Configuring Groups and Grid Control Administrators
Groups
Roles
Administrator Creation and Configuration

Monitoring Grid Control
Problem Area Detection
Individual Component Monitoring

Monitoring the Grid
Metrics and Thresholds
Metric Baselines
Response Actions
Metric Comparisons
Blackouts

Using the Job System
Job Creation and Scheduling
Job Results
Jobs Search

Host Monitoring and Management with Grid Control
Metric Threshold Values
Host Configuration Comparisons

Database Monitoring and Management with Grid Control
Database Groups
Oracle8i/Oracle9i Target Configurations

Application Server Monitoring and Management with Grid Control
Application Server Control Tasks
Application Server Grid Control Tasks
J2EE Application deployment
Historical Performance Data
Performance Comparisons

Application Service Level Monitoring
Web Application Creation
Web Application Configuration
Web Application Monitoring

Oracle Collaboration Suite Monitoring and Management with Grid Control
OCS Configuration Tasks in Grid Control
OCS Groups
OCS Component Monitoring

Managing Your Configuration
Configuration Tasks
Change Tracking
Patching
Policy Violations
Oracle Home and Database Cloning

Grid Control Security
Secure Communications
Proxy Server Configuration
Grid Control Administrator Authentication
Enterprise User Security Configuration Tasks

Using EM2Go
EM2Go Interface
EM2Go Usage

Extending and Customizing Grid Control
User-Defined Metrics
Custom Targets
Custom Reports

High Availability Options for Grid Control
Describe high availability options for the Oracle Management Service
Describe high availability options for the Oracle Management Repository

Migrating from EMv2 or EMv9 to EM10g
Understand the requirements for migration
Deploy management agents using the legacy job system
Migrate repository data

High Availability Options for Grid Control

Migrating from EMv2 or EMv9 to EM10g

Oracle Database 10g: Implement and Administer a Data Warehouse

What you will learn

This course is intended for database administrators, system administrators, and database application developers who design, maintain, and use data warehouses. Before attending this course, you should be familiar with relational database concepts, basic data warehouse theory, Oracle server concepts including application and server tuning, and the operating system environment under which you are running the Oracle Database Server

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Instruction Language
View Schedule	Instructor-Led Training	US$ 2,400	4 Days	English	English

Audience:
Data Warehouse Administrator
Database Administrators
Database Designers

Prerequisites:

Required Prerequisites:

Knowledge of Database Administration
Oracle Database 10g: Administration Workshop I Release 2
Oracle Database 10g: SQL Tuning Workshop
Oracle Database 10g: Administration Workshop II Rel 2 New
Oracle Database 10g: 2 Day DBA Release 2 NEW

Suggested Prerequisites:
Oracle Database 10g: New Features for Administrators Release 2

Course Objectives:
Understand and describe the features inherent in an Oracle 10g Data Warehouse
Demonstrate how to implement parallel operations
Demonstrate extraction, transformation, and loading processes
Describe and demonstrate effective usage of Materialized Views in a data warehouse
Describe star, snowflake and 3NF schemas
Implement an effective partitioning schema for your data warehouse tables
Develop an effective backup and recovery strategy
Describe security challenges in a data warehouse

Return to top

---

Course Topics:
Data Warehouse Design
Logical Versus Physical Design in Data Warehouses
Data Warehousing Schemas
Data Warehousing Objects
Physical Design in Data Warehouses
Hardware and I/O Considerations

Data Warehousing Schemas
Star Schema Model
Snowflake Schema Model
Tuning Star Queries
Star Transformation Hints
Star Transformation Hints
Static Partition Pruning And Star Query
Dynamic Partition Pruning And Star Query
Dynamic Partition Pruning Determination

Partitioning Basics
Supported partition types
Rolling window operations
Partition pruning
Partitioning Using a Template

Extraction, Transportation, and Loading (Extraction and Transportation)
ETL Tools
Extraction Methods
Logical Extraction Methods
Physical Extraction Methods
Change Data Capture
Transportation Using Transportable Tablespaces
Loading Mechanisms

ETL-Loading
Load a formatted flat file into an existing table with SQL*Loader
Performing basic transformations while loading with SQL*Loader
External tables using oracle_loader driver
External tables using oracle_datapump driver
Loading data with OCI and Direct-path APIs

ETL-Transformation
Transformation Using SQL
Transformation Using PL/SQL
Transformation Using Table Functions
Error Logging and Handling Mechanisms

Parallelism Concepts
Parallel Operations
Degree Of Parallelism
Parallel Execution Plan
Operations That Can Be Parallelized
The PARALLEL Clause
Parallel Query
Parallel DDL
Performance Benefits of Parallel DML

Parallel Operations in Data Warehouses
Automated Parallel Query Tuning
Data Distribution And V$PQ_TQSTAT
Object Statistics And V$PQ_TQSTAT

Materialized Views
Materialized Views Overview
Types Of Materialized Views
Nested Materialized Views
Partitioned Materialized Views
Refresh Methods and Modes
Altering/Dropping Materialized Views
Dimensions and Hierarchies
Dimensions and the Data Dictionary

Dimensions
Creating dimensions
Validate dimensions data
View dimension definition information
Distinguish between dimensions and constraints

Materialized Views Refresh
Refresh Methods and Modes
Identifying Dependent MVs
Conditions For Complete/Fast Refreshes
Materialized View Logs
Parallel Refreshes

Query Rewrite
What Can Be Rewritten?
Enabling Query Rewrite
Join Compatibility Checks
Common Joins
PCT and Query Rewrite
Query Rewrite using Multiple MVs
Index Materialized Views

SQL Access Advisor
DBMS_OLAP Advisory Procedures
Workload Management and Sources
Recommendations
Workload Filters and Attribute Types
Tuning of Manually Created Materialized Views
Fast-Refreshable Materialized Views
RECOMMEND_MVIEW_STRATEGY procedure

Data Warehousing System Management
Statistics Collection
Resumable Sessions
Backup and Recovery
Table Compression
Security