1/19

Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle Data Guard Broker

• Changes in Oracle Database 12c Release 1 (12.1.0.2)
• Changes in Oracle Database 12c Release 1 (12.1.0.1)

1 Oracle Data Guard Broker Concepts

• 1.1 Overview of Oracle Data Guard and the Broker
  • 1.1.1 Oracle Data Guard Configurations and Broker Configurations
  • 1.1.2 Oracle Data Guard Broker
  • 1.1.3 Oracle Data Guard Broker and CDBs
  • 1.1.4 Oracle Data Guard Broker and Oracle Global Data Services
• 1.2 Benefits of Oracle Data Guard Broker
• 1.3 Oracle Data Guard Broker Components
• 1.4 Oracle Data Guard Broker User Interfaces
  • 1.4.1 Oracle Enterprise Manager Cloud Control
  • 1.4.2 Oracle Data Guard Command-Line Interface (DGMGRL)
• 1.5 Oracle Data Guard Monitor
  • 1.5.1 Oracle Data Guard Monitor (DMON) Process
  • 1.5.2 Configuration Management
  • 1.5.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 Configuration Properties
• 3.3 Setting Up the Broker Configuration Files
  • 3.3.1 Renaming the Broker Configuration Files
  • 3.3.2 Managing Broker Configuration Files in an Oracle RAC Environment
    • 3.3.2.1 Using Cluster File System (CFS) for Configuration Files
    • 3.3.2.2 Using Oracle ASM Disk Groups for Configuration Files
• 3.4 Starting the Data Guard Broker
• 3.5 Management Cycle of a Broker Configuration
• 3.6 Enable and Disable Operations
• 3.7 Configuration Status

4 Managing the Members of a Broker Configuration

• 4.1 Managing Broker Configuration Members
• 4.2 Managing States of Broker Configuration Members
  • 4.2.1 Database State Transitions
• 4.3 Managing Database Properties
  • 4.3.1 Monitorable (Read-Only) Properties
  • 4.3.2 Configurable (Changeable) Properties
    • 4.3.2.1 Resetting Broker Configurable Properties to Default Values
• 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 Advanced Redo Transport Settings
  • 4.4.4 Turning Redo Transport Services On and Off
  • 4.4.5 Specifying Locations for Archived Redo Log Files
  • 4.4.6 Other Redo Transport Settings
  • 4.4.7 Redo Transport Services in an Oracle RAC Database Environment
  • 4.4.8 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 the DBA_LOGSTDBY_EVENTS Table
  • 4.5.5 Apply Services in an Oracle RAC Database Environment
    • 4.5.5.1 Selecting the Apply Instance
    • 4.5.5.2 Apply Instance Failover
  • 4.5.6 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 Far Sync Instances
• 4.8 Managing Fast-Start Failover
  • 4.8.1 Configure Properties to Tune Fast-Start Failover
  • 4.8.2 Configure Conditions for Fast-start Failover
  • 4.8.3 Application Initiated Fast-Start Failover
• 4.9 Managing Database Conversions
• 4.10 Database Status
  • 4.10.1 Querying Database Status
  • 4.10.2 Validating a Database Before a Role Change

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 Managing Observer's Connection to the Primary
    • 5.5.7.5 Stopping the Observer
    • 5.5.7.6 Moving the Observer to Another Computer
    • 5.5.7.7 How the Observer Maintains Fast-Start Failover Configuration Information
    • 5.5.7.8 Patching an Environment When the Observer Is Running and Fast-start Failover Is Enabled
  • 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 Oracle 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
    • 5.6.1.4 Application Continuity

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: Setting up Maximum Availability Mode with a Far Sync Instance
• 6.7 Scenario 6: Enabling Fast-Start Failover and Starting the Observer
• 6.8 Scenario 7: Enabling Fast-Start Failover When a Far Sync Instance Is In Use
• 6.9 Scenario 8: Performing Routine Management Tasks
  • 6.9.1 Changing Properties and States
    • 6.9.1.1 Alter a Database Property
    • 6.9.1.2 Reset a Property to Its Default Value
    • 6.9.1.3 Alter the State of a Standby Database
    • 6.9.1.4 Alter the State of a Primary Database
  • 6.9.2 Disabling the Configuration and Databases
    • 6.9.2.1 Disable a Configuration
    • 6.9.2.2 Disable a Standby Database
    • 6.9.2.3 Disabling a Far Sync Instance
  • 6.9.3 Removing the Configuration, a Standby Database, or a Far Sync Instance
• 6.10 Scenario 9: Performing a Switchover Operation
• 6.11 Scenario 10: Performing a Manual Failover Operation
• 6.12 Scenario 11: Reinstating a Failed Primary Database
• 6.13 Scenario 12: Converting a Physical Standby to a Snapshot Standby
• 6.14 Scenario 13: Monitoring a Data Guard Configuration

7 Oracle 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
• ADD FAR_SYNC
• CONNECT
• CONVERT DATABASE
• CREATE CONFIGURATION
• DISABLE CONFIGURATION
• DISABLE DATABASE
• DISABLE FAR_SYNC
• DISABLE FAST_START FAILOVER
• DISABLE FAST_START FAILOVER CONDITION
• EDIT CONFIGURATION (Property)
• EDIT CONFIGURATION (Protection Mode)
• EDIT CONFIGURATION (RENAME)
• EDIT CONFIGURATION RESET (Property)
• EDIT DATABASE (Property)
• EDIT DATABASE (Rename)
• EDIT DATABASE (State)
• EDIT DATABASE RESET (Property)
• EDIT FAR_SYNC
• EDIT FAR_SYNC RESET (Property)
• EDIT INSTANCE (AUTO PFILE)
• EDIT INSTANCE (Property)
• EDIT INSTANCE RESET (Property)
• ENABLE CONFIGURATION
• ENABLE DATABASE
• ENABLE FAR_SYNC
• ENABLE FAST_START FAILOVER
• ENABLE FAST_START FAILOVER CONDITION
• EXIT
• FAILOVER
• HELP
• QUIT
• REINSTATE DATABASE
• REMOVE CONFIGURATION
• REMOVE DATABASE
• REMOVE FAR_SYNC
• REMOVE INSTANCE
• SHOW CONFIGURATION
• SHOW CONFIGURATION WHEN PRIMARY IS
• SHOW DATABASE
• SHOW FAR_SYNC
• SHOW FAST_START FAILOVER
• SHOW INSTANCE
• SHUTDOWN
• SQL
• START OBSERVER
• STARTUP
• STOP OBSERVER
• SWITCHOVER
• VALIDATE DATABASE
• VALIDATE FAR_SYNC

8 Oracle Data Guard Broker Properties

• 8.1 Configuration Properties
  • 8.1.1 BystandersFollowRoleChange
  • 8.1.2 CommunicationTimeout
  • 8.1.3 ExternalDestination1
  • 8.1.4 ExternalDestination2
  • 8.1.5 FastStartFailoverAutoReinstate
  • 8.1.6 FastStartFailoverLagLimit
  • 8.1.7 FastStartFailoverPmyShutdown
  • 8.1.8 FastStartFailoverThreshold
  • 8.1.9 ObserverOverride
  • 8.1.10 ObserverReconnect
  • 8.1.11 OperationTimeout
  • 8.1.12 PrimaryLostWriteAction
  • 8.1.13 TraceLevel
• 8.2 Monitorable (Read-Only) Properties
  • 8.2.1 InconsistentLogXptProps (Inconsistent Redo Transport Properties)
  • 8.2.2 InconsistentProperties (Inconsistent 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 RecvQEntries (Receive Queue Entries)
  • 8.2.7 SendQEntries (Send Queue Entries)
  • 8.2.8 TopWaitEvents
• 8.3 Configurable Properties
  • 8.3.1 AlternateLocation
  • 8.3.2 ApplyInstanceTimeout
  • 8.3.3 ApplyLagThreshold
  • 8.3.4 ApplyParallel
  • 8.3.5 ArchiveLagTarget
  • 8.3.6 Binding
  • 8.3.7 DbFileNameConvert
  • 8.3.8 DelayMins
  • 8.3.9 DGConnectIdentifier
  • 8.3.10 FastStartFailoverTarget
  • 8.3.11 LogArchiveFormat
  • 8.3.12 LogArchiveMaxProcesses
  • 8.3.13 LogArchiveMinSucceedDest
  • 8.3.14 LogArchiveTrace
  • 8.3.15 LogFileNameConvert
  • 8.3.16 LogShipping
  • 8.3.17 LogXptMode
  • 8.3.18 LsbyMaxEventsRecorded
  • 8.3.19 LsbyMaxServers
  • 8.3.20 LsbyMaxSga
  • 8.3.21 LsbyPreserveCommitOrder
  • 8.3.22 LsbyRecordAppliedDdl
  • 8.3.23 LsbyRecordSkipDdl
  • 8.3.24 LsbyRecordSkipErrors
  • 8.3.25 MaxConnections
  • 8.3.26 MaxFailure
  • 8.3.27 NetTimeout
  • 8.3.28 ObserverConnectIdentifier
  • 8.3.29 PreferredApplyInstance
  • 8.3.30 RedoCompression
  • 8.3.31 RedoRoutes
    • 8.3.31.1 Redo Routing Rules
  • 8.3.32 ReopenSecs
  • 8.3.33 SidName
  • 8.3.34 StandbyArchiveLocation
  • 8.3.35 StandbyFileManagement
  • 8.3.36 StaticConnectIdentifier
  • 8.3.37 TransportDisconnectedThreshold
  • 8.3.38 TransportLagThreshold

9 Troubleshooting Oracle Data Guard

• 9.1 Sources of Diagnostic Information
• 9.2 General Problems and Solutions
  • 9.2.1 ORA-16596: database not part of the Oracle 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 Cloud Control 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.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 Oracle Data Guard Broker Upgrading and Downgrading

• A.1 Upgrading from Oracle Database 9i Release 2 (9.2) to Oracle Database 12c Release 1 (12.1)
• A.2 Upgrading from Oracle Database 10g and Oracle Database 11g to Oracle Database 12c Release 1 (12.1)
• A.3 Downgrading from Oracle Database 12c Release 1 (12.1)
• A.4 Preserving Broker Configurations During Rolling Upgrades

Glossary

Index