Oracle 11g Release 2 Data Guard Online class

                                      Oracle 11g Release2 Data Guard Online Course

Course: Oracle 11g Data Guard
Plaform: OEL 5.4
Pre-requisites: OCP Knowledge
Duration: 30 hrs

Conact:enquiry@amktechs.com
Contact:91-8553162006


Syllabus:

1 Introduction to Oracle Data Guard

·        1.1 Data Guard Configurations

·        1.2 Data Guard Services

·        1.3 Data Guard Broker

·        1.4 Data Guard Protection Modes

·        1.5 Client Failover

2 Getting Started with Data Guard

·        2.1 Standby Database Types

·        2.2 User Interfaces for Administering Data Guard Configurations

·        2.3 Data Guard Operational Prerequisites

·        2.4 Standby Database Directory Structure Considerations

3 Creating a Physical Standby Database

·        3.1 Preparing the Primary Database for Standby Database Creation

·        3.2 Step-by-Step Instructions for Creating a Physical Standby Database

·        3.3 Post-Creation Steps

4 Creating a Logical Standby Database

·        4.1 Prerequisite Conditions for Creating a Logical Standby Database

·        4.2 Step-by-Step Instructions for Creating a Logical Standby Database

·        4.3 Post-Creation Steps

5 Data Guard Protection Modes

·        5.1 Data Guard Protection Modes

·        5.2 Setting the Data Protection Mode of a Primary Database

6 Redo Transport Services

·        6.1 Introduction to Redo Transport Services

·        6.2 Configuring Redo Transport Services

·        6.3 Cascaded Redo Transport Destinations

·        6.4 Monitoring Redo Transport Services

·        6.5 Tuning Redo Transport

7 Apply Services

·        7.1 Introduction to Apply Services

·        7.2 Apply Services Configuration Options

·        7.3 Applying Redo Data to Physical Standby Databases

·        7.4 Applying Redo Data to Logical Standby Databases

8 Role Transitions

·        8.1 Introduction to Role Transitions

·        8.2 Role Transitions Involving Physical Standby Databases

·        8.3 Role Transitions Involving Logical Standby Databases

·        8.4 Using Flashback Database After a Role Transition

9 Managing Physical and Snapshot Standby Databases

·        9.1 Starting Up and Shutting Down a Physical Standby Database

·        9.2 Opening a Physical Standby Database

·        9.3 Primary Database Changes That Require Manual Intervention at a Physical Standby

·        9.4 Recovering Through the OPEN RESETLOGS Statement

·        9.5 Monitoring Primary, Physical Standby, and Snapshot Standby Databases

·        9.6 Tuning Redo Apply

·        9.7 Managing a Snapshot Standby Database

10 Using RMAN to Back Up and Restore Files

·        10.1 About RMAN File Management in a Data Guard Configuration

·        10.2 About RMAN Configuration in a Data Guard Environment

·        10.3 Recommended RMAN and Oracle Database Configurations

·        10.4 Backup Procedures

·        10.5 Registering and Unregistering Databases in a Data Guard Environment

·        10.6 Reporting in a Data Guard Environment

·        10.7 Performing Backup Maintenance in a Data Guard Environment

·        10.8 Recovery Scenarios in a Data Guard Environment

·        10.9 Additional Backup Situations

·        10.10 Using RMAN Incremental Backups to Roll Forward a Physical Standby Database

11 Data Guard Scenarios

·        11.1 Converting a Failed Primary Into a Standby Database Using Flashback Database

·        11.2 Using Flashback Database After Issuing an Open Resetlogs Statement

·        11.3 Recovering After the NOLOGGING Clause Is Specified

·        11.4 Creating a Standby Database That Uses OMF or Oracle ASM

·        11.5 Recovering From Lost-Write Errors on a Primary Database

·        11.6 Converting a Failed Primary into a Standby Database Using RMAN Backups

·        11.7 Changing the Character Set of a Primary Without Re-Creating Physical Standbys

A Troubleshooting Data Guard

·        A.1 Common Problems

·        A.2 Log File Destination Failures

·        A.3 Problems Switching Over to a Physical Standby Database

·        A.4 What to Do If SQL Apply Stops

·        A.5 Network Tuning for Redo Data Transmission

·        A.6 Slow Disk Performance on Standby Databases

·        A.7 Log Files Must Match to Avoid Primary Database Shutdown

B Data Guard and Oracle Real Application Clusters

·        1 Configuring Standby Databases in an Oracle RAC Environment

·        2 Configuration Considerations in an Oracle RAC Environment

·        3 Troubleshooting

C Creating a Standby Database with Recovery Manager

·        1 Prerequisites

·        2 Overview of Standby Database Creation with RMAN

·        3 Using the DUPLICATE Command to Create a Standby Database