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?

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 for First Use

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 a Real Application Clusters 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 Managing Redo Transport Services for Data Protection Modes
  • 4.4.2 Turning On and Off Redo Transport Services
  • 4.4.3 Specifying Locations for Archived Redo Log Files
  • 4.4.4 Setting a Dependent Standby Database
  • 4.4.5 Other Redo Transport Settings
  • 4.4.6 Managing Connections to the Standby Databases for Redo Transport Services
  • 4.4.7 Redo Transport Services in a 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 Log Apply Services in a 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 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 What Happens When Fast-Start Failover and the Observer Are 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 Viewing Fast-Start Failover Configuration Statistics and Status
  • 5.5.4 Disabling Fast-Start Failover
  • 5.5.5 Performance Considerations for Fast-Start Failover
  • 5.5.6 Managing the Observer
    • 5.5.6.1 Installing and Starting the Observer
    • 5.5.6.2 Viewing Information About the Observer
    • 5.5.6.3 What Happens if the Observer Fails?
    • 5.5.6.4 Stopping the Observer
    • 5.5.6.5 Moving the Observer to Another Computer
    • 5.5.6.6 How the Observer Maintains Fast-Start Failover Configuration Information
  • 5.5.7 Reinstating the Former Primary Database in the Broker Configuration
    • 5.5.7.1 Requirements
    • 5.5.7.2 Restrictions on Reinstatement
    • 5.5.7.3 How the Broker Handles a Failed Reinstatement
  • 5.5.8 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 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: 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 Stopping the Data Guard Command-Line Interface
• ADD DATABASE
• CONNECT
• CREATE CONFIGURATION
• DISABLE CONFIGURATION
• DISABLE DATABASE
• DISABLE FAST_START FAILOVER
• 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
• EXIT
• FAILOVER
• HELP
• QUIT
• REINSTATE DATABASE
• REMOVE CONFIGURATION
• REMOVE DATABASE
• REMOVE INSTANCE
• SHOW CONFIGURATION
• SHOW DATABASE
• 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 DbFileNameConvert
  • 9.2.7 DelayMins
  • 9.2.8 Dependency
  • 9.2.9 FastStartFailoverTarget
  • 9.2.10 FastStartFailoverThreshold
  • 9.2.11 HostName
  • 9.2.12 InitialConnectIdentifier
  • 9.2.13 LocalListenerAddress
  • 9.2.14 LogArchiveFormat
  • 9.2.15 LogArchiveMaxProcesses
  • 9.2.16 LogArchiveMinSucceedDest
  • 9.2.17 LogArchiveTrace
  • 9.2.18 LogFileNameConvert
  • 9.2.19 LogShipping
  • 9.2.20 LogXptMode
  • 9.2.21 LsbyASkipCfgPr
  • 9.2.22 LsbyASkipErrorCfgPr
  • 9.2.23 LsbyASkipTxnCfgPr
  • 9.2.24 LsbyDSkipCfgPr
  • 9.2.25 LsbyDSkipErrorCfgPr
  • 9.2.26 LsbyDSkipTxnCfgPr
  • 9.2.27 LsbyMaxEventsRecorded
  • 9.2.28 LsbyMaxSga
  • 9.2.29 LsbyMaxServers
  • 9.2.30 LsbyRecordAppliedDdl
  • 9.2.31 LsbyRecordSkipDdl
  • 9.2.32 LsbyRecordSkipErrors
  • 9.2.33 LsbyTxnConsistency
  • 9.2.34 MaxConnections
  • 9.2.35 MaxFailure
  • 9.2.36 NetTimeout
  • 9.2.37 PreferredApplyInstance
  • 9.2.38 ReopenSecs
  • 9.2.39 SidName
  • 9.2.40 StandbyArchiveLocation
  • 9.2.41 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 10.2
    • A.1.1.2 Changed Features in Release 10.1
  • A.1.2 Changed Properties
    • A.1.2.1 Changed Properties in Release 10.2
    • A.1.2.2 Changed Properties in Release 10.1
  • A.1.3 Changed State Names in Release 10.1
  • A.1.4 Changed DGMGRL Features in Release 10.2
  • A.1.5 Changed DGMGRL Features in Release 10.1
  • A.1.6 Changed Enterprise Manager Features in Release 10.1
• A.2 Deprecated and Obsolete Features
  • A.2.1 Deprecated and Obsolete Features in Release 10.2
    • A.2.1.1 Deprecated and Obsolete Properties in Release 10.2
  • A.2.2 Deprecated and Obsolete Features in Release 10.1
    • A.2.2.1 Deprecated and Obsolete Properties in Release 10.1
    • A.2.2.2 Deprecated and Obsolete DGMGRL Commands in Release 10.1
    • A.2.2.3 Obsolete Enterprise Manager Feature in Release 10.1

B Data Guard Broker Upgrading and Downgrading

• B.1 Upgrade from Release 9.0.n to Release 10.n
• B.2 Upgrade from Release 9.2.0 to Release 10.n
• B.3 Upgrade from Release 10.1 to Release 10.2
• B.4 Downgrade from Release 10.2

Glossary

Index