Oracle DBA Database Administrator Online for beginners by AMK Technologies

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