Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

Documentation Accessibility

Related Documentation

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.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 Performing a Manual Failover Operation

5.4.1.1 How the Broker Performs a Complete Failover Operation

5.4.1.2 How the Broker Performs an Immediate Failover Operation

5.4.2 Reenabling Disabled Databases After Failover or Switchover

5.4.2.1 How to Reinstate a Database

5.4.2.2 How to 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

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

REINSTATE DATABASE

REMOVE CONFIGURATION

REMOVE DATABASE

REMOVE INSTANCE

SHOW CONFIGURATION

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.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.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