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 Oracle Data Guard Broker 11.2
• New Features in Oracle 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 Oracle 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.4.7 Transport Lag
• 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.5.8 Apply Lag
• 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 a Role Change
    • 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
• 5.6 Database Client Considerations
  • 5.6.1 Data Guard Specific FAN and FCF Configuration Requirements
    • 5.6.1.1 Oracle Net Configuration Requirements
    • 5.6.1.2 Database Service Configuration Requirements
    • 5.6.1.3 ONS Configuration Requirements

6 Scenarios Using the DGMGRL Command-Line Interface

• 6.1 Prerequisites for Getting Started
• 6.2 Scenario 1: Creating a Configuration
• 6.3 Scenario 2: Setting Database Properties
• 6.4 Scenario 3: Enabling the Configuration and Databases
• 6.5 Scenario 4: Setting the Configuration Protection Mode
• 6.6 Scenario 5: Enabling Fast-Start Failover and Starting the Observer
• 6.7 Scenario 6: Performing Routine Management Tasks
  • 6.7.1 Changing Properties and States
    • 6.7.1.1 Alter a Database Property
    • 6.7.1.2 Alter the State of a Standby Database
    • 6.7.1.3 Alter the State of a Primary Database
  • 6.7.2 Disabling the Configuration and Databases
    • 6.7.2.1 Disable a Configuration
    • 6.7.2.2 Disable a Standby Database
  • 6.7.3 Removing the Configuration or a Standby Database
• 6.8 Scenario 7: Performing a Switchover Operation
• 6.9 Scenario 8: Performing a Manual Failover Operation
• 6.10 Scenario 9: Reinstating a Failed Primary Database
• 6.11 Scenario 10: Converting a Physical Standby to a Snapshot Standby
• 6.12 Scenario 11: Monitoring a Data Guard Configuration

7 Data Guard Command-Line Interface Reference

• 7.1 Starting the Data Guard Command-Line Interface
  • 7.1.1 DGMGRL Optional Parameters
  • 7.1.2 DGMGRL Command Format and Parameters
  • 7.1.3 DGMGRL Command Usage Notes
• 7.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

8 Data Guard Broker Properties

• 8.1 Configuration Properties
  • 8.1.1 BystandersFollowRoleChange
  • 8.1.2 CommunicationTimeout
  • 8.1.3 FastStartFailoverAutoReinstate
  • 8.1.4 FastStartFailoverLagLimit
  • 8.1.5 FastStartFailoverPmyShutdown
  • 8.1.6 FastStartFailoverThreshold
  • 8.1.7 OperationTimeout
• 8.2 Monitorable (Read-Only) Database Properties
  • 8.2.1 InconsistentLogXptProps (Inconsistent Redo Transport Properties)
  • 8.2.2 InconsistentProperties (Inconsistent Database Properties)
  • 8.2.3 LogXptStatus (Redo Transport Status)
  • 8.2.4 LsbyFailedTxnInfo (Logical Standby Failed Transaction Information)
  • 8.2.5 LsbyParameters (Logical Standby Parameters)
  • 8.2.6 LsbySkipTable (Logical Standby Skip Table)
  • 8.2.7 LsbySkipTxnTable (SQL Apply Skip Transaction Table)
  • 8.2.8 RecvQEntries (Receive Queue Entries)
  • 8.2.9 SendQEntries (Send Queue Entries)
  • 8.2.10 TopWaitEvents
• 8.3 Configurable Database Properties
  • 8.3.1 AlternateLocation
  • 8.3.2 ApplyInstanceTimeout
  • 8.3.3 ApplyParallel
  • 8.3.4 ArchiveLagTarget
  • 8.3.5 Binding
  • 8.3.6 DbFileNameConvert
  • 8.3.7 DelayMins
  • 8.3.8 DGConnectIdentifier
  • 8.3.9 FastStartFailoverTarget
  • 8.3.10 LogArchiveFormat
  • 8.3.11 LogArchiveMaxProcesses
  • 8.3.12 LogArchiveMinSucceedDest
  • 8.3.13 LogArchiveTrace
  • 8.3.14 LogFileNameConvert
  • 8.3.15 LogShipping
  • 8.3.16 LogXptMode
  • 8.3.17 LsbyASkipCfgPr
  • 8.3.18 LsbyASkipErrorCfgPr
  • 8.3.19 LsbyASkipTxnCfgPr
  • 8.3.20 LsbyDSkipCfgPr
  • 8.3.21 LsbyDSkipErrorCfgPr
  • 8.3.22 LsbyDSkipTxnCfgPr
  • 8.3.23 LsbyMaxEventsRecorded
  • 8.3.24 LsbyMaxSga
  • 8.3.25 LsbyMaxServers
  • 8.3.26 LsbyPreserveCommitOrder
  • 8.3.27 LsbyRecordAppliedDdl
  • 8.3.28 LsbyRecordSkipDdl
  • 8.3.29 LsbyRecordSkipErrors
  • 8.3.30 MaxConnections
  • 8.3.31 MaxFailure
  • 8.3.32 NetTimeout
  • 8.3.33 ObserverConnectIdentifier
  • 8.3.34 PreferredApplyInstance
  • 8.3.35 RedoCompression
  • 8.3.36 ReopenSecs
  • 8.3.37 SidName
  • 8.3.38 StandbyArchiveLocation
  • 8.3.39 StandbyFileManagement
  • 8.3.40 StaticConnectIdentifier

9 Troubleshooting Data Guard

• 9.1 Sources of Diagnostic Information
• 9.2 General Problems and Solutions
  • 9.2.1 ORA-16596: database not part of the Data Guard broker configuration
  • 9.2.2 Redo Accumulating on the Primary Is Not Sent to Some Standby Databases
  • 9.2.3 Many Log Files Are Received on a Standby Database But Not Applied
  • 9.2.4 The Request Timed Out or Enterprise Manager Performance Is Sluggish
  • 9.2.5 The Primary Database is Flashed Back
  • 9.2.6 Standby Fails to Automatically Start Up Due to Unknown Service (ORA-12514)
• 9.3 Troubleshooting Problems During a Switchover Operation
  • 9.3.1 Failed Switchovers to Physical Standby Databases
    • 9.3.1.1 Failure to Convert the Original Primary Database
    • 9.3.1.2 Failure to Convert Target Physical Standby Database
    • 9.3.1.3 Failure to Open New Primary Database
  • 9.3.2 Failed Switchovers to Logical Standby Databases
    • 9.3.2.1 Failure to Convert Original Primary Database
    • 9.3.2.2 Failure to Convert Target Logical Standby Database
  • 9.3.3 Additional Problems That May Occur During a Switchover Operation
• 9.4 Troubleshooting Problems During a Failover Operation
  • 9.4.1 Failed Failovers to Physical Standby Databases
    • 9.4.1.1 Failed Broker Complete Physical Failovers
    • 9.4.1.2 Failed Broker Immediate Physical Failovers
  • 9.4.2 Failed Failovers to Logical Standby Databases
• 9.5 Troubleshooting Problems with the Observer
  • 9.5.1 Problems Starting the Observer
  • 9.5.2 Problems Because the Observer Has Stopped
  • 9.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.2
    • A.1.1.2 Changed Features in Release 11.1
    • A.1.1.3 Changed Features in Release 10.2
  • A.1.2 Changed Properties
    • A.1.2.1 Changed Properties in Release 11.2
    • A.1.2.2 Changed Properties in Release 11.1
    • A.1.2.3 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.2
  • A.2.2 Deprecated and Obsolete Features in Release 11.1
    • A.2.2.1 Deprecated and Obsolete Properties in Release 11.1
  • A.2.3 Deprecated and Obsolete Features in Release 10.2
    • A.2.3.1 Deprecated and Obsolete Properties in Release 10.2

B Data Guard Broker Upgrading and Downgrading

• B.1 Upgrading from Release 9.2.0 to Release 11.2
• B.2 Upgrading from Release 10.n and 11.1 to Release 11.2
• B.3 Upgrading from Release 11.2.0.1 to 11.2.0.2 and other Patch Releases
• B.4 Downgrading from Release 11.2

Glossary

Index