Oracle9i Data Guard Broker -- Contents

Audience

Documentation Accessibility

Organization

Related Documentation

Conventions

Oracle9i Release 2 (9.2) New Features in Data Guard Broker

1.1 Oracle9i 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 Oracle9i Data Guard 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

1.7 Oracle9i Data Guard Installation, Upgrade, and First Use

1.7.1 Installation

1.7.2 Upgrade

1.7.3 Prerequisites for First Use

2.1 Configuration Support

2.2 Starting the Data Guard Broker

2.3 Management Cycle of a Broker Configuration

2.4 Enable and Disable Operations

2.5 States

2.6 State Transitions

2.7 Status

2.8 Properties

2.9 Protection Modes

2.9.1 Setting the Protection Mode for Your Configuration

2.9.2 How Broker Operations Affect Protection Modes

2.9.2.1 Upgrading or Downgrading the Current Protection Mode

2.9.2.2 Switchover Operations

2.9.2.3 Failover Operations

2.9.2.4 Disable and Enable Operations

2.9.2.5 Requirements When Removing an Object in the Configuration

2.9.2.6 Requirements On Other Operations

3.1 Site Objects

3.2 Role Management

3.2.1 Managing Switchover Operations

3.2.1.1 Before You Perform a Switchover Operation

3.2.1.2 Starting a Switchover Operation

3.2.1.3 How the Broker Performs a Switchover Operation

3.2.1.4 Troubleshooting Switchover Operations

3.2.2 Managing Failover Operations

3.2.2.1 Starting a Failover Operation

3.2.2.2 How the Broker Performs a Graceful Failover Operation

3.2.2.3 How the Broker Performs a Forced Failover Operation

3.2.2.4 Completing the Failover Operation

3.2.2.5 Troubleshooting Failover Operations

4.1 Database Resources

4.2 Database Resource States

4.2.1 Offline State

4.2.2 Online State and Substates

4.2.3 Database State Transitions

4.3 Database Resource Properties

4.3.1 Monitorable (Read-Only) Properties

4.3.2 Configurable (Changeable) Database Resource Properties

4.3.2.1 Verifying and Updating Properties

4.3.2.2 Default Property Values

4.3.2.3 Preparing for Switchover Operations

4.3.2.4 Configuring Log Transport Services for Data Protection

5.1 Scenario 1: Starting Data Guard Manager

5.2 Scenario 2: Creating a Configuration

5.3 Scenario 3: Connecting to a Configuration

5.4 Scenario 4: Verifying the Configuration

5.5 Scenario 5: Adding Sites to a Broker Configuration

5.6 Scenario 6: Performing Routine Maintenance

5.6.1 Changing the State of a Database Resource

5.6.2 Changing the Database Protection Mode and LogXptMode Database Property

5.7 Scenario 7: Performing a Switchover Operation

5.8 Scenario 8: Performing a Failover Operation

5.9 Scenario 9: Monitoring a Data Guard Configuration

5.9.1 Verifying a Broker Configuration

5.9.2 Viewing Alert Log and Data Guard Log Information

5.9.3 Monitoring Configuration Performance

5.10 Scenario 10: Using Event Tests

5.10.1 Creating and Registering Data Guard Events

5.11 Scenario 11: Removing a Configuration and Exiting Data Guard Manager

5.11.1 Remove the Data Guard Configuration

5.11.2 Exit from Data Guard Manager

5.11.3 Stop the Data Guard Monitor

5.12 Scenario 12: Re-Creating a Configuration with Data Guard Manager

6.1 Scenario 1: Creating a Physical Standby Database on a Remote Site

6.2 Scenario 2: Creating a Configuration

6.3 Scenario 3: Setting Database Properties

6.4 Scenario 4: Setting the Configuration Protection Mode

6.5 Scenario 5: Performing Routine Management Tasks

6.5.1 Changing States and Properties

6.5.1.1 Alter the State of the Broker Configuration

6.5.1.2 Alter a Database Resource Property

6.5.1.3 Alter the State of a Database Resource

6.5.1.4 Alter the State of a Site

6.5.2 Disabling the Configuration, Sites, and Database Resources

6.5.2.1 Disable a Configuration

6.5.2.2 Disable a Database Resource

6.5.2.3 Disable a Standby Site

6.5.3 Removing the Configuration or a Standby Site

6.6 Scenario 6: Enabling the Configuration, Sites, and Resources

6.7 Scenario 7: Performing a Switchover Operation

6.8 Scenario 8: Performing a Failover Operation

6.9 Scenario 9: Monitoring a Data Guard Configuration

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

ALTER CONFIGURATION (protection mode)

ALTER CONFIGURATION (state)

ALTER RESOURCE (property)

ALTER RESOURCE (state)

ALTER SITE (state)

ALTER SITE (AUTO PFILE)

CONNECT

CREATE CONFIGURATION

CREATE SITE

DISABLE CONFIGURATION

8.1 Monitorable (Read-Only) Properties for Database Resources

8.1.1 InconsistentLogXptProps (Inconsistent Log Transport Properties)

8.1.2 InconsistentProperties (Inconsistent Database Properties)

8.1.3 LogXptStatus (Log 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 (Logical Standby Skip Transaction Table)

8.1.8 SbyLogQueue (Standby Log Queue)

8.1.9 SendQEntries (Send Queue Entries)

8.2 Configurable Properties for Database Resources

Contents

Title and Copyright Information

List of Examples

List of Figures

List of Tables

Send Us Your Comments

Preface

What's New in Data Guard Broker?

1 Oracle9i Data Guard Broker Concepts

2 Managing Broker Configurations

3 Managing Site Objects

4 Managing Database Resources

5 Data Guard Manager Scenarios

6 Data Guard Command-Line Interface Scenarios

7 Data Guard Command-Line Interface Reference

8 Database Resource Properties

Glossary

Index