Oracle9i Data Guard Broker -- Index

Add Site wizard, 1-7, 5-21

adding

existing standby database to a broker configuration, 5-10

standby site to the broker configuration, 6-5

alert logs

displaying, 7-46

ALTER CONFIGURATION command, 7-7, 7-10

example, 6-9

ALTER RESOURCE (property) command, 7-11

example, 6-10

ALTER RESOURCE (state) command, 7-14

example, 6-10

ALTER SITE command, 7-16

example, 6-10

ALTER SYSTEM statement

starting the broker, 2-6, 6-2

altering

properties

database resource, 6-10, 7-11

protection modes

configuration, 7-7

states

configuration, 6-9, 7-7, 7-10

resource, 6-10, 7-14

site, 6-10

See also each ALTER command

Alternate property, 8-9

application integration, 1-4

Apply Off substate

logical standby databases, 4-3

physical standby databases, 4-3

ApplyNext property, 8-10

ApplyNoDelay property, 8-10

ApplyParallel property, 8-11

ARCH log transport mode, 4-11

architecture

Data Guard broker, 1-6

ARCHIVE_LAG_TARGET initialization parameter

setting in a broker configuration, 8-12

archived redo logs

default database resource substates, 2-11, 4-2

destination and configuration parameters, 2-2

in a Data Guard configuration, 2-2

primary database setup, 1-15

ASYNC log transport mode, 4-11

AsyncBlocks property, 8-12

background processes

DMON, 1-10

banners

suppressing from DGMGRL command-line interface output, 7-1

before you perform a switchover operation, 3-4

benefits

Data Guard broker, 1-2

binary configuration file, 1-10, 1-12

Binding property, 8-13

broker

components, 1-6

configuration dependencies, 3-2

Data Guard configuration file, 1-12

forced failover operations, 3-10

graceful failover operations, 3-9

installation, 1-15

introduction, 1-1

log transport services verification, 1-3

managing database resources, 4-1

managing site resources, 3-1

performing failover operations, 3-9

performing switchover operations, 3-5

user interfaces, 1-2, 1-7

broker configurations, 2-22

benefits, 1-2

components, 2-1

creating, 5-6 to 5-17, 5-18, 6-3, 7-21

Data Guard configuration file, 1-10

dependencies, 1-5, 4-1

disabling a database resource, 7-27, 7-28, 7-29

displaying dependencies, 7-44

enabling, 2-8, 6-14, 7-30, 7-31, 7-33

health, 1-10, 2-15

importing standby databases, 1-7

life cycle, 2-6

management, 1-4, 1-7, 1-9, 1-12

objects, 1-4, 2-3

Oracle Net configuration, 1-3, 1-8

overview, 2-1

properties, 2-12, 2-15

protection modes, 7-7

state transitions, 2-12, 7-10

states, 7-10, 7-25

status modes, 2-14

supported, 1-5, 2-1

changing

properties

database resources in a broker configuration, 4-6

states

database resources in a broker configuration, 4-3, 7-11, 7-14

of a standby site in a broker configuration, 5-26

of objects in a broker configuration, 6-9

See also altering

command prompts

suppressing from DGMGRL command-line interface output, 7-1

common properties, 2-16

COMPATIBLE initialization parameter

requirements for setting, 1-15

components

broker, 1-6

Data Guard configuration, 2-2

configurable properties, 2-15

database, 4-6, 8-7

related to initilaization parameters, 4-7

related to log apply services, 4-7

related to log transport services, 4-7

related to SQL apply services, 4-8

configuration file

See Data Guard configuration file

configurations

dedicated server process, 7-5

types of objects, 1-5

configuring

database resource properties, 7-11

Oracle Net for a broker configuration, 6-2

properties, 2-15

CONNECT command, 6-3

connecting

privileges required for Data Guard broker configurations, 7-5

to the primary database, 6-3

console log

displaying, 7-46

controlling

configuring log transport services for data protection, 4-10

CREATE CONFIGURATION command, 6-4, 7-21

Create Configuration wizard

definition, 1-7

introduction, 1-7

CREATE SITE command, 7-24

creating

a broker configuration, 5-6, 5-18, 6-3, 6-4, 7-21

a standby database, 2-7, 5-6, 6-1

standby sites, 5-10, 7-24

Data Guard broker

See broker

Data Guard command-line interface

banners from output, 7-1

commands

ALTER RESOURCE (property), 7-11

ALTER RESOURCE (state), 7-14

ALTER SITE, 7-16

CREATE CONFIGURATION, 7-21

CREATE SITE, 7-24

DISABLE CONFIGURATION, 7-27

DISABLE RESOURCE, 7-28

DISABLE SITE, 7-29

ENABLE CONFIGURATION, 7-30

ENABLE RESOURCE, 7-31

ENABLE SITE, 7-33

EXIT, 7-34

HELP, 7-37

QUIT, 7-39

REMOVE CONFIGURATION, 7-40

REMOVE SITE, 7-41

SHOW CONFIGURATION, 7-42

SHOW DEPENDENCY TREE, 7-44

SHOW LOG, 7-46

SHOW RESOURCE, 7-49

SHOW SITE, 7-52

creating

a standby database, 5-6, 6-1

and adding a primary database resource object, 7-21

database resource substates, 2-11, 7-14, 7-31

DG_BROKER_START initialization parameter, 1-15, 7-4

introduction, 1-2, 1-9

sample help output, 1-9

setting critical database properties, 6-6

starting, 6-3, 7-1

string values, 7-5

summary of commands, 7-2

suppressing command prompts, 7-1

Data Guard configuration file

deleting, 7-41

inconsistent values from SPFILE parameter file, 8-3

relationship to DMON process, 1-10

renaming, 1-12

Data Guard configurations

background, 2-2

supported, 2-2

Data Guard Manager, 1-7

Add Site wizard, 1-7

console, 1-8

Create Configuration wizard, 1-7

database property pages, 1-8

discovering primary and standby nodes, 5-2

integration with Oracle Enterprise Manager, 1-7, 5-1

introduction, 1-2, 1-6

making Oracle Net configuration changes, 1-3, 1-8

performance tools and graphs, 1-7

quick tour, 5-5

setting Preferred Credentials, 5-3

starting, 5-3

upgrading, 1-14

wizards

automate standby database creation, 2-5

creating standby databases, 1-7

Data Guard monitor (DMON), 1-9

in a broker configuration, 2-3

in a Data Guard configuration, 2-3

interaction with the Oracle database server, 1-10

maintaining configuration data, 1-12

managing objects, 2-3, 2-8, 5-19, 6-14

Oracle database server background processes, 1-10

overview, 1-10

removing objects, 6-13

running on each site, 2-3

starting with the DG_BROKER_START parameter, 2-6

two-way network communication, 1-11

data protection modes

See protection modes

database resource properties

definition, 4-5

setting values for switchover operations, 4-10

database resources

connecting to, 6-3

creating and adding to a broker configuration, 1-7

dependencies, 4-1

discovering, 5-2

installation for broker management, 1-15

logical object, 1-4

monitoring, 1-4

objects

definition, 1-5

in a broker configuration, 1-5

overview, 4-1

prerequisites for broker configurations, 1-15

properties

configurable, 4-6

definition, 4-5

property management, 1-13

property pages, 1-8

restarting after a failover, 7-36

starting the standby database instance, 6-2

states, 4-1

dependencies, 4-1

online substates, 2-11

transitions, 2-12, 4-3

substates, 4-2

database sites

See sites

DB_FILE_NAME_CONVERT initialization parameter

initialization parameters

setting DB_FILE_NAME_CONVERT in a broker configuration, 8-14

DbFileNameConvert property, 8-14

dedicated server link, 7-5

dedicated server process, 7-5

default values

database resource substates, 2-11

properties, 4-9

See also states

DelayMins property, 8-14

dependencies

displaying for a configuration, 7-44

hierarchy of objects in a broker configuration, 3-2, 4-1

object, 2-3

dependency tree, 7-44

destinations

archived redo log parameters, 2-2

viewing the LogXptStatus property, 8-4

DG_BROKER_CONFIG_FILEn file, 1-12

DG_BROKER_CONFIG_FILEn initialization parameter, 1-15

DG_BROKER_START initialization parameter, 1-13, 1-15, 2-6, 7-4

DGMGRL commands

FAILOVER, 7-35

SWITCHOVER, 7-60

diagrams of database state transitions, 4-4

DISABLE CONFIGURATION command, 7-27

example, 6-11

DISABLE RESOURCE command, 7-28

example, 6-12

DISABLE SITE command, 7-29

example, 6-12

disabling

broker configuration, 6-11, 7-27

database resources, 6-12, 7-28

sites, 6-11, 6-12, 7-29

See also each DISABLE command

disaster protection

benefits, 1-2

discovering

primary and standby nodes, 5-2

discovering primary and standby nodes, 5-2

Discovery wizard, 5-2

displaying

alert log, 7-46

Data Guard configuration log, 7-46

Data Guard Manager quick tour, 5-5

help for CLI commands, 7-37

help for Data Guard Manager, 5-5

properties, 2-16

states, 2-13

summary information

configuration, 7-42

database resource, 7-49

site, 7-52

distributed management framework, 1-1

DMON

See Data Guard monitor (DMON)

downgrading

protection mode, 2-21

e-mail

reporting events, 1-8

ENABLE CONFIGURATION command, 6-14, 7-30, 7-31, 7-33

enabling

broker configuration, 2-8, 6-14

See also each ENABLE command

Enterprise Edition database server

installation, 1-13

error status, 2-15

event management system, 1-7

events

monitoring with Oracle Enterprise Manager, 2-5

Oracle Enterprise Manager, 1-4, 1-7

reporting, 1-8

responding to, 1-4

starting Oracle Intelligent Agent, 5-2

EXIT command, 7-34

See also QUIT command

failover

database restarts and, 7-36

FAILOVER command

DGMGRL command-line interface, 7-35

failover operations

affect on data protection mode, 3-9

benefits, 1-3

broker tasks, 3-9

completing, 3-11

failing over to a standby database, 7-35

forced, 3-8

graceful, 3-9

managing, 3-8

role management overview, 3-2

scenario, 5-34

starting, 3-9

troubleshooting, 3-12

using Data Guard Manager, 1-7

using the FAILOVER command, 7-35

Failover wizard, 1-7, 5-34

failures

primary site, 3-2

files

naming SPFILE, 1-13

forced failover operations

broker tasks, 3-10

overview, 3-8

graceful failover operations

broker tasks, 3-9

overview, 3-8

health check, 1-4

monitoring, 1-10, 1-11

revealed by configuration status, 2-14

HELP command, 7-37

sample, 1-9

hierarchy

objects in a broker configuration, 1-5, 2-3, 3-1, 4-1

high availability

benefits, 1-2

grades of data protection, 2-17, 8-19

log transport services

ARCH mode, 8-20

ASYNC mode, 8-20

SYNC mode, 8-19

LogXptMode property, 8-19

InconsistentProperties property, 8-3

initial default online states

See states

initialization parameters

COMPATIBLE, 1-15

database configurable properties, 4-6

DG_BROKER_CONFIG_FILEn, 1-15

DG_BROKER_START, 1-15

dynamic, 4-9

inconsistent, 8-3

LOG_ARCHIVE_DEST_STATE_n, 8-9

static, 4-9

See also SPFILE, 1-15

installation

archivelog mode setup, 1-15

Data Guard, 1-13

Data Guard Manager, 1-14

prerequisites, 1-13

remote login password file, 1-15

intended state

configuration health check, 2-14

definition, 2-12

invoking

the Data Guard command-line interface, 6-3

life cycle of a broker configuration, 2-6

log apply services

configuring, 1-3, 1-8, 4-7

configuring for logical standby databases, 4-8

Data Guard configuration, 2-2

delaying, 8-14

standby database online mode, 2-11, 4-2

verifying, 1-3

log transport services

ARCH mode, 4-11, 8-20

ASYNC mode, 4-11, 8-19

configuring, 1-3, 1-8, 4-7

data protection modes, 4-10, 8-19

Data Guard configuration, 2-2

LogShipping property, 8-18

primary database online mode, 2-11, 4-2

SYNC mode, 4-11, 8-19

verifying, 1-3

LOG_ARCHIVE_DEST_n initialization parameter

setting the ALTERNATE attribute, 8-9

setting the ASYNC attribute, 8-12

setting the DELAY attribute, 8-14

setting the DEPENDENCY attribute, 8-15

setting the ENABLE and DEFER attributes, 8-18

setting the MANDATORY or OPTIONAL attributes, 8-13

LOG_ARCHIVE_DEST_STATE_n initialization parameter

automatic update, 8-9

LOG_ARCHIVE_FORMAT initialization parameter, 8-16

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 8-16

LOG_ARCHIVE_MIN_SUCCEED initialization parameter, 8-16

LOG_ARCHIVE_TRACE initialization parameter

setting LogArchiveTrace property, 8-17

LOG_FILE_NAME_CONVERT initialization parameter

setting LogFileNameConvert property, 8-18

LogArchiveFormat property, 8-16

LogArchiveMaxProcesses property, 8-16

LogArchiveMinSucceedDest property, 8-16

LogArchiveTrace property, 8-17

LogFileNameConvert property, 8-18

logical standby databases

default online state, 2-11

online state, 4-2

LOGICAL-APPLY-ON substate, 2-11, 4-3

LOGICAL-APPLY-READY substate, 4-3

login password file, 1-15

LogShipping property, 8-18

LogXptMode property, 4-10

LogXptStatus property, 8-4

LsbyASkipCfgPr property, 8-21

LsbyASkipErrorCfgPr property, 8-21

LsbyASkipTxnCfgPr property, 8-22, 8-24

LsbyDSkipCfgPr property, 8-23

LsbyDSkipErrorCfgPr property, 8-23

LsbyFailedTxnInfo property, 8-4, 8-5

LsbyMaxEventsRecorded property, 8-25

LsbyMaxServers property, 8-26

LsbyMaxSga property, 8-25

LsbyRecordAppliedDdl property, 8-26

LsbyRecordSkipDdl property, 8-27

LsbyRecordSkipErrors property, 8-28

LsbyTxnConsistency property, 8-28

management

benefits, 1-3

Data Guard Manager, 1-7

model, 1-4

managing

a broker configuration, 2-1, 6-1

a remote standby database, 1-15

database resources, 4-1

failover operations, 3-8

local operations, 1-2

objects in a broker configuration, 1-5

remote operations, 1-2

site objects, 3-1

site resources, 3-1

switchover operations, 3-3

MANDATORY attribute

set with the Binding property, 8-13

MaxFailure property, 8-29

maximize availability, 1-3, 2-9, 8-19

maximize data protection, 1-3, 2-9, 8-19

maximize performance, 1-3, 2-9, 8-19

Maximum Availability data protection mode, 2-18

Maximum Performance data protection mode, 2-18

Maximum Protection data protection mode, 2-17

monitorable properties, 2-15

database, 4-6

InconsistentProperties, 8-3

LogXptStatus, 8-4

LsbyFailedTxnInfo, 8-4, 8-5

SbyLogQueue, 8-6

SendQEntries, 8-4, 8-5, 8-6

monitoring

broker configurations, 1-10, 6-1

Data Guard Manager performance page, 2-9

local and remote databases, 1-4

through the command-line interface, 1-9

networks

Data Guard configuration, 2-2

setting up files, 1-15

two-way communication, 1-11

normal status, 2-14

objects

broker configuration, 1-4, 2-3

changing the state of, 6-9

connected in a hierarchy, 1-6

default online database resource substates, 2-11

dependencies, 2-3, 3-2, 4-1

disabling, 6-11

enabling, 6-14

hierarchy, 1-5

properties for database resources, 1-13

state transitions, 2-12

states, 2-10

taking offline, 6-9

oemapp console command, 5-2

oemapp dataguard command, 5-3

oemctl start oms command, 5-2

offline state

transitioning objects, 6-9

online paths

displaying for a broker configuration, 7-44

online states

database resource, 4-2

substates, 4-2

online substate

logical standby database, 4-3

physical standby database, 4-3

operations

performing on broker objects, 1-6

OPTIONAL attribute

set with the Binding property, 8-13

Oracle Enterprise Manager

Discovery wizard, 5-2

event management system, 1-4

integration, 1-7

monitoring events, 2-5

setting Preferred Credentials, 5-3

starting, 5-2

starting Data Guard Manager, 5-3

Oracle Intelligent Agent

starting, 5-2

Oracle Management Server

starting, 5-2

Oracle Net networks

configuration changes, 1-3, 1-8

configuring, 6-2

installation prerequisites, 1-15

service name, 7-5

supported configuration, 2-2

two-way communication, 1-11

pagers

reporting events, 1-8

password file

remote, 1-15, 7-5

performance

Data Guard Manager tools, 1-7, 2-9

log transport services

ARCH mode, 8-20

ASYNC mode, 8-20

SYNC mode, 8-19

Personal Edition database server

installation, 1-13

physical standby databases

online state, 4-2

PHYSICAL-APPLY-ON substate, 4-3

default online state, 2-11

state transitions, 4-4

PHYSICAL-APPLY-READY substate, 4-3

state transitions, 4-4

planned transitions

sites, 3-2

Preferred Credentials, 5-3

prerequisites

installation, 1-13

switchover operation, 3-4

primary database

archivelog mode, 1-15

connecting to, 6-3

constructing a standby database, 2-7, 6-2

Data Guard configuration, 2-2

default online state, 2-11

online state, 4-2

online substate, 4-3

online substates, 4-3

READ-WRITE-XPTON substate, 4-3

state transitions, 4-4

transport off substate, 4-3

primary site

configuration, 2-2

during failover operations, 1-7, 7-35

role, 3-2

switching over to the standby role, 7-60

processes

DMON, 1-10

Oracle database server, 1-10

properties

common, 2-16

configurable, 2-15

configuration, 2-12

database resource, 4-5

default values, 4-9

managing, 1-13

monitorable, 2-15

overview, 2-15

updating in SPFILE, 1-13, 1-15

property pages

configuration, 1-8

database resource, 1-8

protection modes

after a failover operation, 3-9

benefits, 1-3

configuration, 7-7

configuring log transport services, 4-10

downgrading, 2-21

log transport services setup, 8-19

setting for a broker configuration, 2-17

updating, 2-9

upgrading, 2-21

quick tour, 5-5

QUIT command, 7-39

See also EXIT command

READ-ONLY substate

physical standby database, 4-3

state transitions, 4-4

read/write mode, 2-11, 4-2

READ-WRITE substate, 4-3

LogShipping property setting, 8-19

state transitions, 4-4

READ-WRITE-XPTON substate, 4-3

CLI default value, 2-11

setting LogShipping property, 8-19

state transitions, 4-4

remote login password file, 1-15, 7-5

REMOVE CONFIGURATION command, 7-40

example, 6-13

REMOVE SITE command, 7-41

example, 6-13

removing, 2-22

a standby database resource object, 2-22

broker configuration, 2-22

See each REMOVE command

ReopenSecs property, 8-30

requests

passing between sites, 1-11

resources

altering properties for, 7-11

altering states for, 7-14

configurable database properties, 4-6, 8-7 to 8-31

disabling management of objects, 7-27, 7-28, 7-29

displaying summary information for, 7-49

enabling, 6-14, 7-30, 7-31, 7-33

monitorable database properties, 4-6, 8-1 to 8-7

roles

effect on database resource substates, 2-11

managing during failover operations, 3-2

SbyLogQueue property, 8-6

scripts

using Data Guard command-line interface, 7-1

SendQEntries property, 8-6

server initialization parameter file

See SPFILE

server-side software, 1-9

setting

database properties, 6-6

SHOW CONFIGURATION command, 6-4, 7-42

SHOW CONFIGURATION VERBOSE command, 6-5, 6-14

SHOW DEPENDENCY TREE command, 7-44

SHOW LOG command, 7-46

SHOW RESOURCE command, 7-49

SHOW SITE command, 7-52

SHOW SITE VERBOSE command, 6-6

displaying properties, 2-16

showing

See each SHOW command

sites

adding with Add Site wizard, 1-7

creating, 7-24

deleting

Data Guard configuration file, 7-41

dependencies, 3-2, 4-1

during failover operations, 3-8

during switchover operations, 3-3

effects of removing metadata from, 7-40, 7-41

enabling, 6-14

logical object, 1-4

network setup, 1-11, 1-15

object

definition, 1-5

overview, 3-1

removing

from a broker configuration, 6-13

roles, 3-2

showing summary information, 7-52

states

online and offline, 3-1

transitions, 2-12

SPFILE

broker property management, 1-13, 1-15, 4-8

filenames, 1-13

inconsistent values from Data Guard configuration file, 8-3

standby databases

Apply Off substate, 4-3

constructing from backups, 2-7, 6-2

copying datafiles, 5-12

creating, 1-7, 5-6, 5-11, 6-1

Data Guard configuration, 2-2

discovering, 5-2

management, 1-15

online state, 2-11

online substate, 4-3

online substates, 4-3

read-only mode substate, 4-3

READ-ONLY substate, 4-3

removing from a broker configuration, 2-22

starting, 6-2

state transitions, 4-4

standby sites

changing the state of, 5-26

creating, 7-24

roles, 3-2

switching over to the primary role, 7-60

STANDBY_ARCHIVE_DEST initialization parameter

setting in a broker configuration, 8-30

STANDBY_FILE_MANAGEMENT initialization parameter

setting in a broker configuration, 8-31

StandbyArchiveDest property, 8-30

StandbyFileManagement property, 8-31

starting

Create Configuration wizard, 5-6

Data Guard command-line interface, 6-3, 7-1

Data Guard Manager, 5-3

Data Guard monitor (DMON), 2-6

failover operations, 3-9

Oracle Enterprise Manager Console, 5-2

Oracle Intelligent Agent, 5-2

Oracle Management Server, 5-2

standby databases, 6-2

switchover operations, 3-5

state transitions, 2-12

effect on database resource substates, 4-3

overview, 2-12

states, 2-10

changing, 6-9

configuration, 2-12, 7-10

database, 4-1

database transitions, 4-3

displaying, 2-13

initial default online, 2-12

transitioning, 2-12

status

configuration, 2-14

intended state of a configuration, 2-14

string values

Data Guard command-line interface, 7-5

substates

database resource, 4-2, 7-31

default, 2-11

effect on archived redo logs, 2-11

primary database, 4-4

standby databases, 4-4

supported broker configuration, 1-5

SWITCHOVER command

DGMGRL command-line interface, 7-60

switchover operations, 3-2

benefits, 1-3

broker tasks, 3-5

effect on database startup, 7-60

managing, 3-3

prerequisites, 3-4

setting up database property values, 4-10

starting, 3-5

troubleshooting, 3-6

using Data Guard Manager, 1-7

using the SWITCHOVER command, 7-60

Switchover wizard, 1-7, 5-32

SYNC log transport mode, 4-11

SYSDBA privileges, 6-3

to connect to the database, 7-5

test applications

tuning the broker configuration, 2-9

transport off substate, 4-3

troubleshooting

failover operations, 3-12

switchover operations, 3-6

tuning

using the Data Guard Manager, 2-9

two-way communication channel, 1-11

updating configuration properties, 2-15

upgrading

Data Guard, 1-14

Data Guard Manager, 1-14

protection mode, 2-21

user interfaces

overview, 1-7

viewing property information about database resources, 4-6, 8-1

warning status, 2-15

wizards

Add Site, 1-7, 5-21

Create Configuration, 1-7, 5-2, 5-6

Discovery, 5-2, 5-9

Failover, 1-7, 5-34

Switchover, 1-7, 5-32