Oracle Data Guard: Overview
- What Is Oracle Data Guard?
- Types of Standby Databases
- Data Guard Broker Framework
- Types of Services
- Benefits of Implementing Oracle Data Guard
Understanding the Oracle Data Guard Architecture
- Oracle Data Guard Architecture
- Data Guard Redo Apply Architecture
- Data Guard SQL Apply Architecture
- Specifying Role-based Destinations
- Configuring Standby Redo Logs
- Standby Database Modes
Using Oracle Data Guard Broker and Enterprise Manager
- Oracle Data Guard Broker Features
- Data Guard Broker Configurations
- Benefits of Using the Data Guard Broker
- Data Guard Broker Interfaces
- Using Enterprise Manager 10g Grid Control
Creating a Configuration and Physical Standby Database by Using Enterprise Manager
- Using Enterprise Manager to Create a Broker Configuration
- Using the Add Standby Database Wizard
- Creating a Physical Standby Database
- Verifying a Configuration
- Creating Standby Redo Logs
- Viewing the Data Guard Configuration Status
- Viewing Data Guard Performance
Creating a Physical Standby Database by Using SQL
- Preparing the Primary Database
- Setting Initialization Parameters on the Primary Database
- Backing Up the Primary Database Using RMAN
- Creating a Control File for the Standby Database
- Setting Initialization Parameters on the Standby Database
- Setting Up the Environment to Support the Standby Database
- Starting the Physical Standby Database
- Performing Additional Configuration Tasks
Configuring Data Protection Modes and Log Transport Services
- Setting the Log Transport Mode
- Setting the Data Protection Mode
- Delaying the Application of Redo
- Using Flashback Database as an Alternative to Apply Delay
- Additional Attributes that Affect Log Transport Services
Creating a Logical Standby Database by Using Enterprise Manager
- Benefits of Implementing a Logical Standby Database
- Preparing to Create a Logical Standby Database
- Checking for Unsupported Objects and Data Types
- Enabling Supplemental Logging
- Creating a Logical Standby Database by using Enterprise Manager
- Using the Add Standby Database Wizard
- Enabling and Disabling the Auto-Delete Feature
Creating a Logical Standby Database by Using SQL
- Preparing to Create a Logical Standby Database
- Creating a Physical Standby Database
- Preparing the Primary Database
- Transitioning to a Logical Standby Database
- Opening the Logical Standby Database
- Verifying the Logical Standby Database
- Performing Additional Configuration Tasks
Performing Switchover and Failover
- Choosing the Best Role Transition Operation
- Performing a Switchover by Using Enterprise Manager
- Performing a Switchover by Using SQL
- Performing a Failover by Using Enterprise Manager
- Performing a Failover by Using SQL
- Restoring Databases After a Role Transition
- Flashback Through Standby Database Role Transitions
Enabling Fast-Start Failover
- When Will Fast-Start Failover Occur?
- Configuring Fast-Start Failover
- Prohibited Operations After Enabling Fast-Start Failover
- Managing the Observer
- Performing Role Changes
- Using Enterprise Manager to Enable Fast-Start Failover
Using Data Guard in a Real Application Clusters Configuration
- Real Application Clusters and Data Guard
- Configuration Considerations with RAC
- Configuring a Primary Database with RAC
- Configuring a Standby Database with RAC
- Apply Instance Failover
- Role Transitions with RAC
Other Considerations for Oracle Data Guard
- Using a Physical Standby Database for Read/Write Testing and Reporting
- Offloading Backups to a Physical Standby Database
- Using Flashback Database and Real-time Apply
- Using Flashback Database After RESETLOGS
- Enabling Redo Encryption
- Configuring Cascaded Redo Log Destinations
Workshop
- Workshop Premise
- Workshop Flow
- Workshop Scenarios
