6.High availability

 

1 Warehouse

Partitioning Basics

• Partitioned Tables and Indexes
• Partitioning Methods
• Partitioning Types
• Partition Pruning and Star queries

Parallelism Concepts

• Operations That Can Be Parallelized
• How Parallel Execution Works
• Degree of Parallelism
• Parallel execution plan

Parallel Operations in Data Warehouses

• Parallel Query
• Parallel DDL
• Parallel DML
• Tuning Parameters for Parallel Execution
• Balancing the Workload

ETL: Extraction and Transportation

• Extraction Methods
• Capturing Data With Change Data Capture
• Sources and Modes of Change Data Capture
• Publish and Subscribe Model: The Publisher and the Subscriber
• Synchronous and Asynchronous CDC
• Asynchronous AutoLog Mode and Asynchronous HotLog Mode
• Transportation in a Data Warehouse
• Transportable Tablespaces

ETL: Loading

• Loading Mechanisms
• Applications of External Tables
• Defining external tables with SQL*Loader
• Populating external tables with Data Pump
• Other Loading Methods

ETL: Transformation

• Data transformation
• Transformation Mechanisms
• Transformation Using SQL
• Table Functions
• DML error logging

Materialized Views

• The Need for Summary Management
• Types of Materialized Views
• Using Materialized Views for Summary Management
• Materialized View Dictionary views

Refreshing Materialized Views

• Refresh Options
• Refresh Modes
• Conditions That Effect Possibility of Fast Refresh
• Materialized View Logs
• Partition Change Tracking (PCT) Refresh
• Refresh Performance Improvements

Query Rewrite

• Query Rewrite: Overview
• What Can be Rewritten
• Conditions Required for Oracle to Rewrite a Query
• Query Rewrite guidelines
• Setting Initialization Parameters for Query Rewrite
• Query Rewrite Methods
• Partition Change Tracking (PCT) and Query Rewrite
• Query Rewrite Enhancement to Support Queries Containing Inline Views

Using the SQL Access Advisor, Compression, and Resumable Sessions

• SQL Access Advisor: Usage Model
• Setting Initial Options
• Specifying the Workload Source
• Recommendation Options
• Schedule and Review
• PL/SQL Procedure Flow
• Tuning Materialized Views for Fast Refresh and Query Rewrite
• Table Compression and Resumable Sessions

2 Oracle Data Guard

Introduction to Oracle Data Guard

• Causes of Data Loss
• Oracle Data Guard Architecture
• Data Protection Modes

Creating a Physical Standby Database by Using SQL and RMAN Commands

• Preparing the Primary Database
• Creating a Physical Standby Database

Overview of the Data Guard Broker

• Oracle Data Guard Broker Features
• Oracle Data Guard Broker Configurations

Using DGMGRL to Create a Data Guard Broker Configuration

• Creating the Broker Configuration
• Adding the Standby Database to the Configuration

Creating a Physical Standby Database by Using Enterprise Manager Grid Control

• Using the Add Standby Database Wizard
• Verifying a Configuration
• Viewing the Data Guard Configuration Status

Monitoring a Data Guard Broker Configuration

• Monitoring the Data Guard Configuration
• Verifying the Configuration
• Using Enterprise Manager Data Guard Metrics
• Viewing Log File Details

Managing Data Protection Modes

• Determining Which Data Protection Mode to Use
• Setting Up Standby Redo Logs
• Setting the Data Protection Mode

Optimizing a Data Guard Configuration

• Monitoring Configuration Performance
• Optimizing Network Configuration
• Implementing Cascaded Destinations

Using Flashback Database in a Data Guard Configuration

• Using Flashback Database and Real-time Apply
• Using Flashback Database Instead of Apply Delay
• Recovering Data from the Standby Database From a Past Point-in-time

Performing Role Transitions

• Understanding Roles in an Oracle Data Guard Configuration
• Performing a Switchover to a Physical Standby Database
• Performing a Failover to a Physical Standby Database
• Re-enabling a Disabled Database After a Role Transition

Enabling Fast-Start Failover

• Configuring Fast-Start Failover
• Viewing Fast-Start Failover Information
• Performing Role Changes
• Reinstating the Database

Implementing Client Failover Procedures

• Configuring Your Database to Automate Failover for OCI Clients
• Configuring Your Database to Automate Failover for JDBC Clients
• Troubleshooting Client Failover

Creating and Managing a Snapshot Standby Database

• Converting a Physical Standby Database into a Snapshot Standby Database
• Using a Snapshot Standby Database
• Monitoring a Snapshot Standby Database

Using Oracle Active Data Guard

• Opening a Physical Standby Database in Read-only Mode
• Enabling Block Change Tracking on a Physical Standby Database for Fast Incremental Backups

Creating a Logical Standby Database

• Preparing to Create a Logical Standby Database
• Creating a Logical Standby using SQL/RMAN Commands
• Creating a Logical Standby using Grid Control
• Managing SQL Apply Filtering
• Performing Rolling Upgrades

Managing the Data Guard Configuration

• Viewing Data Guard Diagnostic Information
• Troubleshooting

Backup and Recovery Considerations in an Oracle Data Guard Configuration

• Using RMAN to Back Up and Restore Files in a Data Guard Configuration
• Offloading Backups to a Physical Standby Database
• Recovering a Corrupted Datafile on the Primary Database
• Backing Up a Logical Standby Database

Upgrading Databases in a Data Guard Configuration

• Using SQL Apply to Upgrade the Oracle Database
• Using a Physical Standby for Rolling Upgrades
• Upgrading an Oracle Data Guard Release 10.n Configuration to Release 11.1

3.Streams

Introduction and Overview

• Oracle Streams: Basic Elements
• Capture and Event Staging
• Staging Area Propagation
• Rules Engine
• Oracle Streams with Single-Source and Multiple-Source Database
• Oracle Streams Usage: Scenarios
• Using Oracle Streams for Upgrades and Migrations
• Interfaces to Oracle Streams

Database Configuration

• Configuring Database Parameters
• Configuring Archive Logging
• Supplemental Logging
• Database Configuration with Enterprise Manager
• Configuring Communication Between Databases
• Configuring Multiple Streams Sites
• Additional Preparation for File Propagation

Basic Objects of Oracle Streams

• Object Types
• Streams Events
• Logical Change Records (LCRs)
• Creating and Managing a Streams Administrator User
• Staging Area Architecture
• SYS.AnyData Queues
• Creating a Staging Queue
• View Interface to Queue Buffers

System-Created Rules

• Using Rules in Oracle Streams
• Generating System-Created Rules
• Using Subset Rules with Oracle Streams
• Row Subsetting
• Customizing System-Created Rules
• Negative Rule Sets
• Rule Evaluation with Negative Rule Sets
• Monitoring Rules

Enterprise Manager Interface to Oracle Streams

• Oracle Streams Manageability Features
• Configuring Oracle Streams
• Streams Setup Page
• Streams Tablespace Replication Wizard
• Capture Management
• Apply Management
• Propagation Management
• Managing Message Transformations

Simplified Streams Configuration

• Simplified Configuration Procedures
• Replicating a Single Tablespace (MAINTAIN_SIMPLE_TTS) and a Set of Tablespaces (MAINTAIN_TTS)
• Instantiating Database Objects
• Replicating Tables, Schemas, and Entire Database
• Improved Diagnostics for Streams
• Removing a Streams Queue
• Removing All Streams Components

Capture Process Concepts

• Capture
• Implicit Event Capture
• Capture Process Components
• Identifying Changes to Capture
• Logical Change Records (LCRs)
• Data Types, DDL and DML Types Captured
• Commands and DDLs Not Captured
• Streams Tags and Downstream Capture

Configuring a Capture Process

• Creating the Capture Process
• Downstream Capture
• Capture Process Parameters
• Starting and Managing the Capture Process
• Monitoring Log File Availability
• Capture Process Statistics
• Troubleshooting Capture

Instantiation

• Performing Instantiation
• Preparing for Instantiation
• Setting the Instantiation SCN
• Import Instantiation and Creation
• Instantiation Using Data Pump
• Setting the Instantiation SCN Manually
• Instantiating a Database Using RMAN
• Verifying Instantiations at an Apply Site

Propagation Concepts and Configuration

• Directed Networks
• Queue and Forwarding
• Apply Forwarding
• Queue-to-Queue Propagation
• Propagation Job, Rules, and Scheduling
• Creating, Managing, and Monitoring Propagation
• Troubleshooting Propogation Configuration

Apply Concepts and Configuration

• Processing Streams Events
• Applying DDL Events
• Error Queue
• Required Apply User Privileges
• Apply Process Components and Rules
• Enqueue Destination and Execution Directives During Apply
• Virtual Dependency Definition
• Apply Process and Parameters

Transformations

• Rule-Based Transformations
• Declarative LCR Transformations
• Customized Rule-Based Transformations
• Modifying an LCR
• Using LCR Extra Attributes
• Creating a Rule-Based Transformation
• One-to-many Transformations
• Viewing and Managing Rule-Based Transformations

Apply Handlers

• Creating an Apply Handler Procedure
• Implementing a DML Handler
• Creating an Error Handler
• Implementing a DDL and a Precommit Handler
• Restrictions for Apply Handler Procedures
• Managing Apply Handlers
• Customizing Apply Handler Actions
• Viewing Apply Handler Information

Administering a Streams Environment

• Managing the Capture Process
• Managing Propagations
• Managing Apply Processes
• Starting and Stopping Streams Processes
• Managing Streams Process Rule Sets
• Troubleshooting Apply Failures

Reconfiguring the Streams Environment

• Types of Streams Environments
• Extending a Single-Source System
• Extending a Multiple-Source System
• Using Streams for Upgrades or Migrations
• Removing Sites and Objects

Data Conflicts

• What Is a Replication Conflict?
• Error Queue
• Types of Data Conflicts
• Primary and Substitute Key Columns
• Detecting Conflicts
• Data Consistency and Convergence
• Conflict Avoidance and Resolution Foundation
• Site Ownership

Conflict resolution

• Prebuilt Conflict Handlers
• Resolution Columns
• Column Lists
• Configuring Supplemental Logging
• Resolving Conflicts with Prebuilt and Custom Update Conflict Handlers
• Common Data Conflict Errors
• Print Values from a SYS.AnyData Type
• Managing Errors

Message Queuing Concepts

• Enqueuing Events
• Subscriptions and Recipient List
• Creating a Messaging Client
• Streams Messages with Object Types
• Dequeuing Messages in Streams
• Message Handlers
• Configuring Message Notification and Monitoring Streams Messaging
• Queue Management Page

Enqueuing and Dequeing Events

• Enqueuing a Message in Streams
• Creating User Messages with LCRs
• Enqueuing a User-Created LCR
• Configuring Propagation of Non-LCR Events
• Dequeuing LCRs and Messages
• Applying User-Created LCR Events
• Configuring Rule-Based Apply of Messages
• Purging the Staging Queue

Best Practices and Operational Considerations

• Best Practices for Configuring Streams
• Archive Logging
• Capture Process SCN Values and Checkpoints
• Modifying FIRST_SCN and START_SCN
• Source Queue Growth
• NOLOGGING Operations
• Clock Synchronization
• Integrating Triggers with Streams

Troubleshooting Oracle Streams

• Troubleshooting Capture
• Troubleshooting Propagation
• Troubleshooting Apply
• Common Apply Errors
• Troubleshooting Secure Queue Access

4.Real Application Cluster

Oracle Clusterware Installation

• Oracle RAC 11g Installation
• Cluster Setup Tasks
• Using Raw Partitions
• Cluster Configuration

RAC Installation

• Installing Automatic Storage Management
• Configure ASM Storage
• Install the Database Software

Database Creation

• Management Agent Installation
• Storage Options for Database Files
• Create the Database
• Single Instance to RAC Conversion

RAC DB Administration

• Cluster Database Instance Administration
• Topology Viewer
• Automatic Undo Management and RAC
• Quiescing RAC Databases
• Transparent Data Encryption and Wallets in RAC
• ASM Instance and Crash Recovery in RAC

Backup and Recover a RAC DB

• Protecting Against Media Failure
• Oracle Recovery Manager

RAC DB Monitoring and Tuning

• CPU and Wait Time Tuning Dimensions
• Dynamic Reconfiguration
• ADDM Analysis

Services

• Workload Dispatching
• High Availability of Services in RAC
• Services and Resource Manager with EM
• Change Service Thresholds
• Using Distributed Transactions with RAC

High Availability of Connections

• Fast Application Notification
• Load Balancing Advisory
• Transparent Application Failover

Oracle Clusterware Administration

• Controlling the Oracle Clusterware Stack
• Back Up and Recover Your Voting Disks
• Back Up and Recover Oracle Cluster Registry
• Prevent Automatic Instance Restarts

Diagnosing the Oracle Clusterware components

• Oracle Clusterware Main Log Files
• RAC Diagnostic Infrastructure

Design for High Availability

• Maximum Availability Architecture
• RAC and Data Guard Topologies
• Extended RAC Connectivity
• Extended RAC disk mirroring
• Patch your RAC system in a rolling fashion