Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Documentation Accessibility

Related Documentation

What's New in Oracle Data Guard Broker?

Oracle Database Release 10.1 New Features in Data Guard Broker

1 Oracle Data Guard Broker Concepts

1.1 Oracle Data Guard Overview

1.1.1 Oracle Data Guard Configuration Overview

1.1.2 Oracle Data Guard Broker Overview

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 Data Guard GUI

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

1.7 Oracle Data Guard Installation, Upgrade, Downgrade, and First Use

1.7.1 Installation

1.7.2 Upgrade from Release 9.0.n to Release 10.1

1.7.3 Upgrade from Release 9.2.0 to Release 10.1

1.7.4 Downgrade from Release 10.1

1.7.5 Prerequisites for First Use

2 Managing Broker Configurations

2.1 Configuration Support

2.2 Setting Up the Broker Configuration Files

2.2.1 Sizing for Raw Devices

2.3 Starting the Data Guard Broker

2.4 Management Cycle of a Broker Configuration

2.5 Enable and Disable Operations

2.6 Configuration Status

3 Managing Databases

3.1 Database Objects

3.2 Database States

3.2.1 Database State Transitions

3.3 Database Properties

3.3.1 Monitorable (Read-Only) Properties

3.3.2 Configurable (Changeable) Database Properties

3.4 Managing Log Transport Services

3.4.1 Managing Log Transport Services for Data Protection Modes

3.4.2 Turning On and Off Log Transport Services

3.4.3 Managing Standby Locations to Archive the Online Redo Log Files From the Primary Database

3.4.4 Setting a Dependent Standby Database

3.4.5 Other Log Transport Settings

3.4.6 Managing Connections to the Standby Databases for Log Transport Services

3.4.7 Log Transport Services in a RAC Database Environment

3.5 Managing Log Apply Services

3.5.1 Managing Real-Time Apply

3.5.2 Managing Delayed Apply

3.5.3 Managing Parallel Apply in Physical Standby Databases

3.5.4 Allocating Resources to SQL Apply in Logical Standby Databases

3.5.5 Managing SQL Apply Filtering in Logical Standby Databases

3.5.6 Managing SQL Apply Error Handling in Logical Standby Databases

3.5.7 Managing the DBA_LOGSTDBY_EVENTS Table in Logical Standby Databases

3.5.8 Log Apply Services in a RAC Database Environment

3.5.8.1 Selecting the Apply Instance

3.5.8.2 Apply Instance Failover

3.6 Managing Data Protection Modes

3.6.1 Setting the Protection Mode for Your Configuration

3.6.2 How Broker Operations Affect Protection Modes

3.6.2.1 Upgrading or Downgrading the Current Protection Mode

3.6.2.2 Switchover Operations

3.6.2.3 Failover Operations

3.6.2.4 Disable and Enable Operations

3.6.2.5 Requirements When Removing a Database from the Configuration

3.6.2.6 Requirements On Other Operations

3.7 Database Status

4 Role Management

4.1 Managing Switchover Operations

4.1.1 Before You Perform a Switchover Operation

4.1.2 Starting a Switchover Operation

4.1.3 How the Broker Performs a Switchover Operation

4.2 Managing Failover Operations

4.2.1 Considerations When Selecting the Failover Target

4.2.2 Starting a Failover Operation

4.2.3 How the Broker Performs a Complete Failover Operation

4.2.4 How the Broker Performs an Immediate Failover Operation

4.2.5 Re-creating a Viable Disaster Recovery Solution After Failover

5 Data Guard Scenarios - Using Oracle Enterprise Manager

5.1 Scenario 1: Starting the Data Guard GUI

5.2 Scenario 2: Creating a Configuration or Adding an Additional Standby Database

5.3 Scenario 3: Adding an Existing RAC Standby Database

5.4 Scenario 4: Performing Routine Maintenance

5.4.1 Changing the State of a Database

5.4.2 Changing the Properties of a Database

5.4.3 Changing the Database Protection Mode

5.5 Scenario 5: Performing a Switchover Operation

5.6 Scenario 6: Performing a Failover Operation

5.7 Scenario 7: Monitoring a Data Guard Configuration

5.7.1 Verifying a Broker Configuration

5.7.2 Viewing Log File Details

5.7.3 Monitoring Configuration Performance

5.8 Scenario 8: Using Metrics

5.8.1 Understanding the Data Guard Metrics

5.8.1.1 Data Guard Status

5.8.1.2 Data Not Applied (MB)

5.8.1.3 Data Not Applied (Log Files)

5.8.1.4 Data Not Received (MB)

5.8.1.5 Data Not Received (Log Files)

5.8.2 Managing Data Guard Metrics

5.9 Scenario 9: Removing a Standby Database and Configuration

5.9.1 Remove a Standby Database

5.9.2 Remove the Data Guard Configuration

6 Data Guard Scenarios - Using DGMGRL CLI

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: Performing Routine Management Tasks

6.6.1 Changing States and Properties

6.6.1.1 Alter a Database Property

6.6.1.2 Alter the State of a Standby Database

6.6.1.3 Alter the State of a Primary Database

6.6.2 Disabling the Configuration and Databases

6.6.2.1 Disable a Configuration

6.6.2.2 Disable a Standby Database

6.6.3 Removing the Configuration or a Standby Database

6.7 Scenario 6: Performing a Switchover Operation

6.8 Scenario 7: Performing a Failover Operation

6.9 Scenario 8: 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 Stopping the Data Guard Command-Line Interface

CREATE CONFIGURATION

DISABLE CONFIGURATION

DISABLE DATABASE

EDIT CONFIGURATION (Protection Mode)

EDIT DATABASE (Property)

EDIT DATABASE (Rename)

EDIT DATABASE (State)

EDIT INSTANCE (AUTO PFILE)

EDIT INSTANCE (Property)

ENABLE CONFIGURATION

ENABLE DATABASE

REMOVE CONFIGURATION

REMOVE DATABASE

REMOVE INSTANCE

SHOW CONFIGURATION

8 Database Properties

8.1 Monitorable (Read-Only) Database Properties

8.1.1 InconsistentLogXptProps (Inconsistent Log Transport Properties)

8.1.2 InconsistentProperties (Inconsistent Database Properties)

8.1.3 LatestLog

8.1.4 LogXptStatus (Log Transport Status)

8.1.5 LsbyFailedTxnInfo (Logical Standby Failed Transaction Information)

8.1.6 LsbyParameters (Logical Standby Parameters)

8.1.7 LsbySkipTable (Logical Standby Skip Table)

8.1.8 LsbySkipTxnTable (Logical Standby Skip Transaction Table)

8.1.9 RecvQEntries (Receive Queue Entries)

8.1.10 SendQEntries (Send Queue Entries)

8.1.11 StatusReport (Status Report)

8.1.12 TopWaitEvents

8.2 Configurable Database Properties

8.2.1 AlternateLocation

8.2.2 ApplyInstanceTimeout

8.2.3 ApplyNext

8.2.4 ApplyNoDelay

8.2.5 ApplyParallel

8.2.6 ArchiveLagTarget

8.2.7 AsyncBlocks

8.2.9 DbFileNameConvert

8.2.10 DelayMins

8.2.11 Dependency

8.2.12 HostName

8.2.13 InitialConnectIdentifier

8.2.14 LocalListenerAddress

8.2.15 LogArchiveFormat

8.2.16 LogArchiveMaxProcesses

8.2.17 LogArchiveMinSucceedDest

8.2.18 LogArchiveTrace

8.2.19 LogFileNameConvert

8.2.20 LogShipping

8.2.21 LogXptMode

8.2.22 LsbyASkipCfgPr

8.2.23 LsbyASkipErrorCfgPr

8.2.24 LsbyASkipTxnCfgPr

8.2.25 LsbyDSkipCfgPr

8.2.26 LsbyDSkipErrorCfgPr

8.2.27 LsbyDSkipTxnCfgPr

8.2.28 LsbyMaxEventsRecorded

8.2.29 LsbyMaxSga

8.2.30 LsbyMaxServers

8.2.31 LsbyRecordAppliedDdl

8.2.32 LsbyRecordSkipDdl

8.2.33 LsbyRecordSkipErrors

8.2.34 LsbyTxnConsistency

8.2.35 MaxFailure

8.2.36 NetTimeout

8.2.37 PreferredApplyInstance

8.2.38 RealTimeApply

8.2.39 ReopenSecs

8.2.41 StandbyArchiveLocation

8.2.42 StandbyFileManagement

9 Troubleshooting Data Guard

9.1 Sources of Diagnostic Information

9.2 General Problems and Solutions

9.2.1 ORA-16596: Database is Not a Member of the Data Guard Configuration

9.2.2 Log Files Are Being Accumulated on the Primary and Not Archived to Some Standby Databases

9.2.3 Many Log Files Are Received on a Standby Database But Not Applied

9.2.4 The Primary Database is Flashed Back

9.3 Troubleshooting Problems During a Failover Operation

9.4 Troubleshooting Problems During a Switchover Operation

A Data Guard Broker Changed and Deprecated Features

A.1 Data Guard Broker Changed Features

A.1.1 General Features That Changed

A.1.2 Changed Properties

A.1.3 Changed State Names

A.1.4 Changed CLI Features

A.1.5 Changed Data Guard GUI Features

A.2 Data Guard Broker Deprecated Features

A.2.1 Deprecated Properties

A.2.2 Deprecated CLI Commands and Keywords

A.2.3 Data Guard GUI Features That Are Deprecated

Glossary

Index