Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Data Guard Broker?

• New Features in Data Guard Broker 11.1

1 Oracle Data Guard Broker Concepts

• 1.1 Overview of Oracle Data Guard and the Broker
  • 1.1.1 Data Guard Configurations and Broker Configurations
  • 1.1.2 Oracle Data Guard Broker
• 1.2 Benefits of Data Guard Broker
• 1.3 Data Guard Broker Management Model
• 1.4 Data Guard Broker Components
• 1.5 Data Guard Broker User Interfaces
  • 1.5.1 Oracle Enterprise Manager
  • 1.5.2 Data Guard Command-Line Interface (DGMGRL)
• 1.6 Data Guard Monitor
  • 1.6.1 Data Guard Monitor (DMON) Process
  • 1.6.2 Configuration Management
  • 1.6.3 Database Property Management

2 Oracle Data Guard Installation

• 2.1 Oracle Data Guard Installation
• 2.2 Prerequisites

3 Managing Broker Configurations

• 3.1 Configuration Support
• 3.2 Setting Up the Broker Configuration Files
  • 3.2.1 Renaming the Broker Configuration Files
  • 3.2.2 Managing Broker Configuration Files in an Oracle RAC Environment
    • 3.2.2.1 Using Cluster File System (CFS) for Configuration Files
    • 3.2.2.2 Using ASM Disk Groups for Configuration Files
    • 3.2.2.3 Using Raw Devices for Configuration Files
• 3.3 Starting the Data Guard Broker
• 3.4 Management Cycle of a Broker Configuration
• 3.5 Enable and Disable Operations
• 3.6 Configuration Status

4 Managing Databases

• 4.1 Database Objects
• 4.2 Database States
  • 4.2.1 Database State Transitions
• 4.3 Database Properties
  • 4.3.1 Monitorable (Read-Only) Properties
  • 4.3.2 Configurable (Changeable) Database Properties
• 4.4 Managing Redo Transport Services
  • 4.4.1 Setting Up For Redo Transport
  • 4.4.2 Managing Redo Transport Services for Data Protection Modes
  • 4.4.3 Turning Redo Transport Services On and Off
  • 4.4.4 Specifying Locations for Archived Redo Log Files
  • 4.4.5 Other Redo Transport Settings
  • 4.4.6 Redo Transport Services in an Oracle RAC Database Environment
• 4.5 Managing Log Apply Services
  • 4.5.1 Managing Delayed Apply
  • 4.5.2 Managing Parallel Apply with Redo Apply
  • 4.5.3 Allocating Resources to SQL Apply
  • 4.5.4 Managing SQL Apply Filtering
  • 4.5.5 Managing SQL Apply Error Handling
  • 4.5.6 Managing the DBA_LOGSTDBY_EVENTS Table
  • 4.5.7 Apply Services in an Oracle RAC Database Environment
    • 4.5.7.1 Selecting the Apply Instance
    • 4.5.7.2 Apply Instance Failover
• 4.6 Managing Data Protection Modes
  • 4.6.1 Setting the Protection Mode for Your Configuration
  • 4.6.2 How the Protection Modes Influence Broker Operations
    • 4.6.2.1 Upgrading or Downgrading the Current Protection Mode
    • 4.6.2.2 Switchover Operations
    • 4.6.2.3 Failover Operations
    • 4.6.2.4 Disable and Enable Operations
    • 4.6.2.5 Requirements For Removing a Database from the Configuration
    • 4.6.2.6 Requirements On Other Operations
• 4.7 Managing Fast-Start Failover
  • 4.7.1 Configure Properties to Tune Fast-Start Failover
  • 4.7.2 Configure Conditions for Fast-start Failover
  • 4.7.3 Application Initiated Fast-Start Failover
• 4.8 Managing Database Conversions
• 4.9 Database Status

5 Switchover and Failover Operations

• 5.1 Overview of Switchover and Failover in a Broker Environment
• 5.2 Choosing a Target Standby Database
  • 5.2.1 Choosing a Target Standby Database for Switchover
  • 5.2.2 Choosing a Target Standby Database for Failover
• 5.3 Switchover
  • 5.3.1 Before You Perform a Switchover Operation
  • 5.3.2 Starting a Switchover
  • 5.3.3 How the Broker Performs a Switchover
• 5.4 Manual Failover
  • 5.4.1 Complete and Immediate Manual Failovers
  • 5.4.2 Performing a Manual Failover Operation
    • 5.4.2.1 How the Broker Performs a Complete Failover Operation
    • 5.4.2.2 How the Broker Performs an Immediate Failover Operation
  • 5.4.3 Reenabling Disabled Databases After Failover or Switchover
    • 5.4.3.1 How to Reinstate a Database
    • 5.4.3.2 How to Re-create and Reenable a Disabled Database
• 5.5 Fast-Start Failover
  • 5.5.1 Prerequisites for Enabling Fast-Start Failover
  • 5.5.2 Enabling Fast-Start Failover
    • 5.5.2.1 When Fast-Start Failover Is Enabled and the Observer Is Running
    • 5.5.2.2 Restrictions When Fast-Start Failover is Enabled
    • 5.5.2.3 Shutting Down the Primary Database When Fast-Start Failover Is Enabled
    • 5.5.2.4 Performing Manual Role Changes When Fast-Start Failover Is Enabled
  • 5.5.3 Directing a Fast-Start Failover From an Application
  • 5.5.4 Viewing Fast-Start Failover Configuration Statistics and Status
    • 5.5.4.1 V$DATABASE View
    • 5.5.4.2 V$FS_FAILOVER_STATS View
  • 5.5.5 Disabling Fast-Start Failover
  • 5.5.6 Performance Considerations for Fast-Start Failover
  • 5.5.7 Managing the Observer
    • 5.5.7.1 Installing and Starting the Observer
    • 5.5.7.2 Viewing Information About the Observer
    • 5.5.7.3 What Happens if the Observer Fails?
    • 5.5.7.4 Stopping the Observer
    • 5.5.7.5 Moving the Observer to Another Computer
    • 5.5.7.6 How the Observer Maintains Fast-Start Failover Configuration Information
  • 5.5.8 Reinstating the Former Primary Database in the Broker Configuration
    • 5.5.8.1 Requirements
    • 5.5.8.2 Restrictions on Reinstatement
    • 5.5.8.3 How the Broker Handles a Failed Reinstatement
  • 5.5.9 Shutting Down Databases In a Fast-Start Failover Environment

6 Scenarios Using Oracle Enterprise Manager

• 6.1 Scenario 1: Accessing the Data Guard User Interface
• 6.2 Scenario 2: Creating a Configuration or Adding an Additional Standby Database
• 6.3 Scenario 3: Adding an Existing RAC Standby Database
• 6.4 Scenario 4: Enabling Fast-Start Failover and the Observer
• 6.5 Scenario 5: Performing Routine Maintenance
  • 6.5.1 Changing the State of a Database
  • 6.5.2 Changing the Properties of a Database
  • 6.5.3 Changing the Database Protection Mode
• 6.6 Scenario 6: Performing a Switchover Operation
• 6.7 Scenario 7: Invoking a Failover Manually
• 6.8 Scenario 8: Monitoring a Data Guard Configuration
  • 6.8.1 Verifying a Broker Configuration
  • 6.8.2 Viewing Log File Details
  • 6.8.3 Monitoring Configuration Performance
• 6.9 Scenario 9: Using Metrics
  • 6.9.1 Understanding the Data Guard Metrics
    • 6.9.1.1 Fast-Start Failover Metrics
    • 6.9.1.2 Data Guard Performance Metrics
    • 6.9.1.3 Data Guard Status
  • 6.9.2 Managing Data Guard Metrics
• 6.10 Scenario 10: Removing a Standby Database and Configuration
  • 6.10.1 Remove a Standby Database
  • 6.10.2 Remove the Data Guard Configuration

7 Scenarios Using the DGMGRL Command-Line Interface

• 7.1 Prerequisites for Getting Started
• 7.2 Scenario 1: Creating a Configuration
• 7.3 Scenario 2: Setting Database Properties
• 7.4 Scenario 3: Enabling the Configuration and Databases
• 7.5 Scenario 4: Setting the Configuration Protection Mode
• 7.6 Scenario 5: Enabling Fast-Start Failover and Starting the Observer
• 7.7 Scenario 6: Performing Routine Management Tasks
  • 7.7.1 Changing Properties and States
    • 7.7.1.1 Alter a Database Property
    • 7.7.1.2 Alter the State of a Standby Database
    • 7.7.1.3 Alter the State of a Primary Database
  • 7.7.2 Disabling the Configuration and Databases
    • 7.7.2.1 Disable a Configuration
    • 7.7.2.2 Disable a Standby Database
  • 7.7.3 Removing the Configuration or a Standby Database
• 7.8 Scenario 7: Performing a Switchover Operation
• 7.9 Scenario 8: Performing a Manual Failover Operation
• 7.10 Scenario 9: Reinstating a Failed Primary Database
• 7.11 Scenario 10: Converting a Physical Standby to a Snapshot Standby
• 7.12 Scenario 11: Monitoring a Data Guard Configuration

8 Data Guard Command-Line Interface Reference

• 8.1 Starting the Data Guard Command-Line Interface
  • 8.1.1 DGMGRL Optional Parameters
  • 8.1.2 DGMGRL Command Format and Parameters
  • 8.1.3 DGMGRL Command Usage Notes
• 8.2 Exiting the Data Guard Command-Line Interface
• ADD DATABASE
• CONNECT
• CONVERT DATABASE
• CREATE CONFIGURATION
• DISABLE CONFIGURATION
• DISABLE DATABASE
• DISABLE FAST_START FAILOVER
• DISABLE FAST_START FAILOVER CONDITION
• EDIT CONFIGURATION (Property)
• EDIT CONFIGURATION (Protection Mode)
• EDIT DATABASE (Property)
• EDIT DATABASE (Rename)
• EDIT DATABASE (State)
• EDIT INSTANCE (AUTO PFILE)
• EDIT INSTANCE (Property)
• ENABLE CONFIGURATION
• ENABLE DATABASE
• ENABLE FAST_START FAILOVER
• ENABLE FAST_START FAILOVER CONDITION
• EXIT
• FAILOVER
• HELP
• QUIT
• REINSTATE DATABASE
• REMOVE CONFIGURATION
• REMOVE DATABASE
• REMOVE INSTANCE
• SHOW CONFIGURATION
• SHOW DATABASE
• SHOW FAST_START FAILOVER
• SHOW INSTANCE
• SHUTDOWN
• START OBSERVER
• STARTUP
• STOP OBSERVER
• SWITCHOVER

9 Database Properties

• 9.1 Monitorable (Read-Only) Database Properties
  • 9.1.1 InconsistentLogXptProps (Inconsistent Redo Transport Properties)
  • 9.1.2 InconsistentProperties (Inconsistent Database Properties)
  • 9.1.3 LogXptStatus (Redo Transport Status)
  • 9.1.4 LsbyFailedTxnInfo (Logical Standby Failed Transaction Information)
  • 9.1.5 LsbyParameters (Logical Standby Parameters)
  • 9.1.6 LsbySkipTable (Logical Standby Skip Table)
  • 9.1.7 LsbySkipTxnTable (SQL Apply Skip Transaction Table)
  • 9.1.8 RecvQEntries (Receive Queue Entries)
  • 9.1.9 SendQEntries (Send Queue Entries)
  • 9.1.10 StatusReport (Status Report)
  • 9.1.11 TopWaitEvents
• 9.2 Configurable Database Properties
  • 9.2.1 AlternateLocation
  • 9.2.2 ApplyInstanceTimeout
  • 9.2.3 ApplyParallel
  • 9.2.4 ArchiveLagTarget
  • 9.2.5 Binding
  • 9.2.6 BystandersFollowRoleChange
  • 9.2.7 DbFileNameConvert
  • 9.2.8 DelayMins
  • 9.2.9 DGConnectIdentifier
  • 9.2.10 FastStartFailoverAutoReinstate
  • 9.2.11 FastStartFailoverLagLimit
  • 9.2.12 FastStartFailoverPmyShutdown
  • 9.2.13 FastStartFailoverTarget
  • 9.2.14 FastStartFailoverThreshold
  • 9.2.15 HostName
  • 9.2.16 LogArchiveFormat
  • 9.2.17 LogArchiveMaxProcesses
  • 9.2.18 LogArchiveMinSucceedDest
  • 9.2.19 LogArchiveTrace
  • 9.2.20 LogFileNameConvert
  • 9.2.21 LogShipping
  • 9.2.22 LogXptMode
  • 9.2.23 LsbyASkipCfgPr
  • 9.2.24 LsbyASkipErrorCfgPr
  • 9.2.25 LsbyASkipTxnCfgPr
  • 9.2.26 LsbyDSkipCfgPr
  • 9.2.27 LsbyDSkipErrorCfgPr
  • 9.2.28 LsbyDSkipTxnCfgPr
  • 9.2.29 LsbyMaxEventsRecorded
  • 9.2.30 LsbyMaxSga
  • 9.2.31 LsbyMaxServers
  • 9.2.32 LsbyRecordAppliedDdl
  • 9.2.33 LsbyRecordSkipDdl
  • 9.2.34 LsbyRecordSkipErrors
  • 9.2.35 LsbyPreserveCommitOrder
  • 9.2.36 MaxConnections
  • 9.2.37 MaxFailure
  • 9.2.38 NetTimeout
  • 9.2.39 ObserverConnectIdentifier
  • 9.2.40 PreferredApplyInstance
  • 9.2.41 RedoCompression
  • 9.2.42 ReopenSecs
  • 9.2.43 SidName
  • 9.2.44 StandbyArchiveLocation
  • 9.2.45 StandbyFileManagement

10 Troubleshooting Data Guard

• 10.1 Sources of Diagnostic Information
• 10.2 General Problems and Solutions
  • 10.2.1 ORA-16596: Object Not Part of the Data Guard Broker Configuration
  • 10.2.2 Redo Accumulating on the Primary Is Not Sent to Some Standby Databases
  • 10.2.3 Many Log Files Are Received on a Standby Database But Not Applied
  • 10.2.4 The Request Timed Out or Enterprise Manager Performance Is Sluggish
  • 10.2.5 The Primary Database is Flashed Back
• 10.3 Troubleshooting Problems During a Switchover Operation
• 10.4 Troubleshooting Problems During a Failover Operation
• 10.5 Troubleshooting Problems with the Observer
  • 10.5.1 Problems Starting the Observer
  • 10.5.2 Problems Because the Observer Has Stopped
  • 10.5.3 Capturing Observer Actions in the Observer Log File

A Changed and Deprecated Features

• A.1 Changed Features
  • A.1.1 General Features That Changed
    • A.1.1.1 Changed Features in Release 11.1
    • A.1.1.2 Changed Features in Release 10.2
  • A.1.2 Changed Properties
    • A.1.2.1 Changed Properties in Release 11.1
    • A.1.2.2 Changed Properties in Release 10.2
  • A.1.3 Changed State Names
  • A.1.4 Changed DGMGRL Features in Release 10.2
• A.2 Deprecated and Obsolete Features
  • A.2.1 Deprecated and Obsolete Features in Release 11.1
    • A.2.1.1 Deprecated and Obsolete Properties in Release 11.1
  • A.2.2 Deprecated and Obsolete Features in Release 10.2
    • A.2.2.1 Deprecated and Obsolete Properties in Release 10.2

B Data Guard Broker Upgrading and Downgrading

• B.1 Upgrade from Release 9.2.0 to Release 11.1
• B.2 Upgrade from Release 10.n to Release 11.1
• B.3 Downgrade from Release 11.1

Glossary

Index