List of Tables

2-1  Standby Database Location and Directory Options

3-1  Preparing the Primary Database for Physical Standby Database Creation

3-2  Creating a Physical Standby Database

4-1  Preparing the Primary Database for Logical Standby Database Creation

4-2  Creating a Logical Standby Database

5-1  LOG_ARCHIVE_DEST_STATE_n Initialization Parameter Attributes

5-2  Minimum Requirements for Data Protection Modes

5-3  Wait Events for Destinations Configured with the ARCH Attribute

5-4  Wait Events for Destinations Configured with the LGWR SYNC Attributes

5-5  Wait Events for Destinations Configured with the LGWR ASYNC Attributes

5-6  Wait Events for LGWR ASYNC or LGWR SYNC=PARALLEL Attributes

8-1  Actions Required on a Standby Database After Changes to a Primary Database

8-2  Location Where Common Actions on the Primary Database Can Be Monitored

9-1  Procedures of the DBMS_LOGSTDBY PL/SQL Package

10-1  Data Guard Scenarios

10-2  Identifiers for the Physical Standby Database Example

10-3  Identifiers for Logical Standby Database Example

11-1  Initialization Parameters for Instances in a Data Guard Configuration

12-1  Changing Destination Attributes Using SQL

12-2  Directives for the TEMPLATE Attribute

12-3  VALID_FOR Attribute Values

12-4  LOG_ARCHIVE_DEST_n Attribute Compatibility

13-1  ALTER DATABASE Statements Used in Data Guard Environments

13-2  ALTER SESSION Statement Used in Data Guard Environments

14-1  Views That Are Pertinent to Data Guard Configurations

A-1  Common Processes That Prevent Switchover

A-2  Fixing Typical SQL Apply Errors

B-1  Directives for the LOG_ARCHIVE_FORMAT Initialization Parameter

D-1  Standby Database Preparation Using RMAN

D-2  Order of Precedence for Naming Datafiles in Standby Database

D-3  Using Image Copies to Create a Standby Database: Scenario