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 Create a Logical Standby Database

5-1 LOG_ARCHIVE_DEST_STATE_n Initialization Parameter Attributes

5-2 Requirements for Data Protection Modes

6-1 Task List: Configuring Log Apply Services for Physical Standby Databases

6-2 Task List: Configuring Log Apply Services for Logical Standby Databases

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

12-1 Changing Destination Attributes Using SQL

12-2 LOG_ARCHIVE_DEST_n Attribute Compatibility

13-1 Keywords for the ACTIVATE STANDBY DATABASE Clause

13-2 Keywords for the ADD STANDBY LOGFILE Clause

13-3 Keywords for the ADD STANDBY 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