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 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 Database Properties

• 8.1 Monitorable (Read-Only) Database Properties
  • 8.1.1 InconsistentLogXptProps (Inconsistent Redo Transport Properties)
  • 8.1.2 InconsistentProperties (Inconsistent Database Properties)
  • 8.1.3 LogXptStatus (Redo Transport Status)
  • 8.1.4 LsbyFailedTxnInfo (Logical Standby Failed Transaction Information)
  • 8.1.5 LsbyParameters (Logical Standby Parameters)
  • 8.1.6 LsbySkipTable (Logical Standby Skip Table)
  • 8.1.7 LsbySkipTxnTable (SQL Apply Skip Transaction Table)
  • 8.1.8 RecvQEntries (Receive Queue Entries)
  • 8.1.9 SendQEntries (Send Queue Entries)
  • 8.1.10 StatusReport (Status Report)
  • 8.1.11 TopWaitEvents
• 8.2 Configurable Database Properties
  • 8.2.1 AlternateLocation
  • 8.2.2 ApplyInstanceTimeout
  • 8.2.3 ApplyParallel
  • 8.2.4 ArchiveLagTarget
  • 8.2.5 Binding
  • 8.2.6 BystandersFollowRoleChange
  • 8.2.7 CommunicationTimeout
  • 8.2.8 DbFileNameConvert
  • 8.2.9 DelayMins
  • 8.2.10 DGConnectIdentifier
  • 8.2.11 FastStartFailoverAutoReinstate
  • 8.2.12 FastStartFailoverLagLimit
  • 8.2.13 FastStartFailoverPmyShutdown
  • 8.2.14 FastStartFailoverTarget
  • 8.2.15 FastStartFailoverThreshold
  • 8.2.16 HostName
  • 8.2.17 LogArchiveFormat
  • 8.2.18 LogArchiveMaxProcesses
  • 8.2.19 LogArchiveMinSucceedDest
  • 8.2.20 LogArchiveTrace
  • 8.2.21 LogFileNameConvert
  • 8.2.22 LogShipping
  • 8.2.23 LogXptMode
  • 8.2.24 LsbyASkipCfgPr
  • 8.2.25 LsbyASkipErrorCfgPr
  • 8.2.26 LsbyASkipTxnCfgPr
  • 8.2.27 LsbyDSkipCfgPr
  • 8.2.28 LsbyDSkipErrorCfgPr
  • 8.2.29 LsbyDSkipTxnCfgPr
  • 8.2.30 LsbyMaxEventsRecorded
  • 8.2.31 LsbyMaxSga
  • 8.2.32 LsbyMaxServers
  • 8.2.33 LsbyPreserveCommitOrder
  • 8.2.34 LsbyRecordAppliedDdl
  • 8.2.35 LsbyRecordSkipDdl
  • 8.2.36 LsbyRecordSkipErrors
  • 8.2.37 MaxConnections
  • 8.2.38 MaxFailure
  • 8.2.39 NetTimeout
  • 8.2.40 ObserverConnectIdentifier
  • 8.2.41 PreferredApplyInstance
  • 8.2.42 RedoCompression
  • 8.2.43 ReopenSecs
  • 8.2.44 SidName
  • 8.2.45 StandbyArchiveLocation
  • 8.2.46 StandbyFileManagement
  • 8.2.47 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.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.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.2
• B.2 Upgrade from Release 10.n and 11.1 to Release 11.2
• B.3 Downgrade from Release 11.2

Glossary

Index