Contents

Title and Copyright Information

List of Examples

List of Figures

List of Tables

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

Accessibility of Code Examples in Documentation

1 Oracle9i Data Guard Broker Concepts

1.1 Oracle9i Data Guard Broker Overview

1.2 Data Guard Broker Management Model

1.3 Data Guard Broker Architecture and Components

1.3.1 Data Guard Broker User Interfaces

1.3.1.1 Oracle9i Data Guard Manager

1.3.1.2 Data Guard Command-Line Interface (DGMGRL)

1.3.2 Data Guard Monitor

1.3.2.1 Data Guard Monitor (DMON) Process

1.3.2.2 Configuration Management

1.4 Benefits of the Data Guard Broker

1.5 Oracle9i Data Guard Prerequisites

2 Configuring Oracle9i Data Guard

2.1 Configuration Support

2.2 Starting the Data Guard Monitor

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

3 Database Resources

3.1 Database Resources

3.2 Database Resource States

3.2.1 Database Online and Offline States

3.2.2 Database Substates

3.2.3 Database State Transitions

3.3 Database Resource Properties

3.3.1 Configurable (Changeable) Database Resource Properties

3.3.1.1 Noncritical Database Properties

3.3.1.2 Critical Database Properties

3.3.2 Monitorable (Read-Only) Properties

3.3.2.1 SendQEntries (Send Queue Entries)

3.3.2.2 LogXptStatus (Log Transport Status)

3.3.2.3 SbyLogQueue (Standby Log Queue)

4 Using Oracle9i Data Guard Manager

4.1 Starting Data Guard Manager

4.2 Creating a Configuration

4.3 Connecting to a Configuration

4.4 Enabling the Configuration, Sites, and Resources

4.5 Performing Routine Maintenance

4.5.1 Changing the State of a Database Resource

4.5.2 Changing a Database Property

4.6 Performing a Manual Switchover Outside of Data Guard Manager

4.7 Monitoring a Data Guard Configuration

4.7.1 Using Event Tests

4.7.2 Creating and Registering Data Guard Events

5 Using the Data Guard Command-Line Interface

5.1 Creating a Standby Database

5.2 Creating a Configuration

5.3 Setting Database Critical Properties

5.4 Enabling the Configuration, Sites, and Resources

5.5 Performing Routine Management Tasks

5.5.1 Changing States and Properties

5.5.1.1 Alter the State of the Broker Configuration

5.5.1.2 Alter a Database Resource Property

5.5.1.3 Alter the State of a Database Resource

5.5.1.4 Alter the State of a Site

5.5.2 Disabling the Configuration, Sites, and Database Resources

5.5.2.1 Disable a Configuration

5.5.2.2 Disable a Database Resource

5.5.2.3 Disable the Standby Site

5.5.3 Removing the Configuration or the Standby Site

5.6 Performing Activities Outside of the Broker

5.7 Monitoring a Data Guard Configuration

6 Data Guard Command-Line Interface Reference

6.1 Starting the Data Guard Command-Line Interface

6.1.1 DGMGRL Optional Parameters

6.1.2 DGMGRL Command Format and Parameters

6.1.3 DGMGRL Command Usage Notes

6.2 Stopping the Data Guard Command-Line Interface

ALTER CONFIGURATION

ALTER RESOURCE (property)

ALTER RESOURCE (state)

ALTER SITE

ALTER SITE (AUTO PFILE)

CONNECT

CREATE CONFIGURATION

CREATE SITE

DISABLE CONFIGURATION

DISABLE RESOURCE

DISABLE SITE

ENABLE CONFIGURATION

ENABLE RESOURCE

ENABLE SITE

EXIT

HELP

QUIT

REMOVE CONFIGURATION

REMOVE SITE

SHOW CONFIGURATION

SHOW DEPENDENCY TREE

SHOW LOG

SHOW RESOURCE

SHOW SITE

SHUTDOWN

STARTUP

A Oracle9i Data Guard Error Messages

Glossary

Index