List of Tables

2-1  Primary and Standby Database Configurations

3-1  Task List: Preparing for Managed Recovery

4-1  Checklist of Preparatory Tasks to Create a Logical Standby Database

4-2  Checklist of Tasks to Create a Logical Standby Database

5-1  LOG_ARCHIVE_DEST_n Initialization Parameter Attributes

5-2  LOG_ARCHIVE_DEST_STATE_n Initialization Parameter Attributes

5-3  Changing Destination Attributes Using SQL

5-4  Task List: Configuring Log Transport Services

5-5  Guidelines for Online Redo Log Configuration

5-6  Summary of Data Protection Modes

5-7  Configuring Log Transport Services Protection Modes

5-8  Default PARALLEL and NOPARALLEL Options

5-9  Transmission Mode Attributes

5-10  Comparing Network and Disk I/O Methods

6-1  Procedures of the DBMS_LOGSTDBY PL/SQL Package

6-2  Task List: Configuring Log Apply Services

6-3  Filename Conversion

7-1  Summary of Role Transitions

8-1  Troubleshooting Primary Database Events

10-1  Configuring Standby Database Initialization Parameters

10-2  Identifiers for Logical Standby Database Scenarios

11-1  Initialization Parameters Specific to the Oracle9i Data Guard Environment

12-1  LOG_ARCHIVE_DEST_n Attribute Compatibility

13-1  Keywords for the ACTIVATE STANDBY DATABASE Clause

13-2  Keywords for the ADD LOGFILE Clause

13-3  Keywords for the ADD LOGFILE MEMBER Clause

13-4  Keywords for the ADD SUPPLEMENTAL LOG DATA Clause

13-5  Keywords for the COMMIT TO SWITCHOVER Clause

13-6  Keywords for the CREATE STANDBY CONTROLFILE AS Clause

13-7  Keywords for the DROP [STANDBY] LOGFILE Clause

13-8  Keywords for the DROP LOGFILE MEMBER Clause

13-9  Keywords for the [NO]FORCE LOGGING Clause

13-10  Keywords for the RECOVER MANAGED STANDBY DATABASE Clause

13-11  Keywords for the REGISTER LOGFILE Clause

13-12  Keywords for the SET STANDBY TO MAXIMIZE Clause

13-13  Keywords for the START LOGICAL STANDBY APPLY Clause

13-14  Keywords for the {STOP | ABORT} LOGICAL STANDBY APPLY Clause

A-1  Common Processes That Prevent Switchover

A-2  Fixing Typical SQL Apply Operations Errors

B-1  Task List: Preparing for Manual Recovery