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
• 14-2 VALID_FOR Attribute Values
• 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 Datafiles in Standby Database
• F-3 Using Image Copies to Create a Standby Database: Scenario