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

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

11-1 Step-by-Step Procedure to Upgrade Oracle Database Software

12-1 Data Guard Scenarios

12-2 Initialization Parameter Settings for Primary and Physical Standby Databases

12-3 Initialization Parameter Settings for Primary and Logical Standby Databases

12-4 Initialization Parameters for Primary, Physical, and Logical Standby Databases

12-5 Identifiers for the Physical Standby Database Example

12-6 Identifiers for Logical Standby Database Example

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

14-1 Directives for the TEMPLATE Attribute

15-1 ALTER DATABASE Statements Used in Data Guard Environments

15-2 ALTER SESSION Statement Used in Data Guard Environments

16-1 Views That Are Pertinent to Data Guard Configurations

A-1 Common Processes That Prevent Switchover

A-2 Fixing Typical SQL Apply Errors

C-1 Values for stmt Parameter of the DBMS_LOGSTDBY.SKIP procedure

C-2 Statement Options for Skipping SQL DDL Statements

D-1 Directives for the LOG_ARCHIVE_FORMAT Initialization Parameter

E-1 Initialization Parameters for Primary, Physical, and Logical Standby Databases

F-1 Standby Database Preparation Using RMAN

F-2 Order of Precedence for Naming Data Files in Standby Database

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