List of Figures

1-1 Typical Data Guard Configuration

1-2 Automatic Updating of a Physical Standby Database

1-3 Automatic Updating of a Logical Standby Database

1-4 Data Guard Overview Page in Oracle Enterprise Manager

2-1 Possible Standby Configurations

5-1 Transmitting Redo Data

5-2 Primary Database Archiving When There Is No Standby Database

5-3 Archiving to Local Destinations Before Archiving to Remote Destinations

5-4 Archiving to Local and Remote Destinations at the Same Time

5-5 LGWR SYNC Archival to a Remote Destination with Standby Redo Log Files

5-6 LGWR ASYNC Archival with Network Server (LNSn) Processes

5-7 Data Guard Configuration with Dependent Destinations

6-1 Applying Redo Data to a Standby Destination Using Real-Time Apply

7-1 Role Transition Decision Tree

7-2 Data Guard Configuration Before Switchover

7-3 Standby Databases Before Switchover to the New Primary Database

7-4 Data Guard Environment After Switchover

7-5 Failover to a Standby Database

8-1 Standby Database Open for Read-Only Access

9-1 SQL Apply Processing

9-2 Data Guard Configuration Before Upgrade

9-3 Upgrade the Logical Standby Database Version

9-4 Running Mixed Versions

9-5 After a Switchover

9-6 Both Databases Upgraded

9-7 Example of Transaction Consistency with SQL Apply

10-1 Primary and Physical Standby Databases Before a Role Transition

10-2 Primary and Physical Standby Databases After a Role Transition

10-3 Configuring Destinations for a Primary Database and a Logical Standby Database

10-4 Primary and Logical Standby Databases After a Role Transition

10-5 Configuring a Primary Database with Physical and Logical Standby Databases

10-6 Primary, Physical, and Logical Standby Databases After a Role Transition

10-7 Manual Recovery of Archived Redo Log Files in an Archive Gap

12-1 Archival Operation to an Alternate Destination Device

12-2 Specifying Disk Quota for a Destination

B-1 Transmitting Redo Data from a Multi-Instance Primary Database

B-2 Standby Database in Real Application Clusters

C-1 Cascaded Redo Log Destination Configuration Example