Oracle9i Data Guard Broker -- Index

adding

existing standby database to a broker configuration, 4-10

standby site to the broker configuration, 5-5

alert logs

displaying, 6-38

ALTER CONFIGURATION command, 6-7

example, 5-8

ALTER RESOURCE (property) command, 6-8

example, 5-8

ALTER RESOURCE (state) command, 6-10

example, 5-9

ALTER SITE command, 6-12

example, 5-9

ALTER SYSTEM statement

starting the broker, 2-5

stopping the broker, 5-12

altering

properties

database resource, 5-8, 6-8

states

configuration, 5-8, 6-7

resource, 5-8, 6-10

site, 5-9

See also each ALTER command

architecture

Data Guard broker, 1-4

ARCHIVE_LAG_TARGET initialization parameter

setting in a broker configuration, 3-7

archived redo logs

default database resource substates, 2-9, 3-2

destination and configuration parameters, 2-1

in a Data Guard configuration, 2-2

primary database setup, 1-10

ArchiveDestDependency property, 3-7

ArchiveLagTarget property, 3-7

background processes

DMON, 1-6

banners

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

binary configuration file, 1-7, 1-9

broker

architecture, 1-4

components, 1-4

Data Guard configuration file, 1-9

installation, 1-10

introduction, 1-1

log transport services verification, 1-2

managing database resources, 3-1

user interfaces, 1-2, 1-4

broker configurations

components, 2-2

creating, 4-6 to 4-17, 4-18, 5-2, 6-16

Data Guard configuration file, 1-7

dependencies, 1-3, 3-1

disabling a database resource, 6-22, 6-23, 6-24

displaying dependencies, 6-36

enabling, 2-7, 4-19, 5-6, 6-25, 6-26, 6-28

health, 1-7, 2-12

importing standby databases, 1-5

life cycle, 2-5

management, 1-2, 1-4, 1-5, 1-9

objects, 1-2, 2-2

Oracle Net configuration, 1-2

overview, 2-2

properties, 2-9, 2-12

state transitions, 2-9, 2-10, 6-7

states, 6-7, 6-20

status modes, 2-11

supported, 1-2, 2-1, 2-2

changing

properties

database resources in a broker configuration, 3-6

states

database resources in a broker configuration, 3-4, 6-8, 6-10

of a standby site in a broker configuration, 4-22

of objects in a broker configuration, 5-7

See also altering

CLI

See Data Guard command-line interface

command prompts

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

command-line interface

See Data Guard command-line interface

common properties, 2-12

components

broker, 1-4

Data Guard configuration, 2-1

configurable properties, 2-12

ArchiveDestDependency, 3-7

ArchiveLagTarget, 3-7

critical, 3-9

database, 3-6

FalClient, 3-8

FalServer, 3-7

LogArchiveDestOptions, 3-7

LogArchiveTrace, 3-7

noncritical, 3-9

StandbyArchiveDest, 3-8

configuration file

See Data Guard configuration file

configuration object

definition, 1-3

configuring

database resource properties, 3-6, 6-8

critical, 3-9

noncritical, 3-9

Oracle Net for a broker configuration, 5-2

properties, 2-12

CONNECT command, 5-3

connecting

privileges required for Data Guard broker configurations, 6-4

to the primary database, 5-3

console log

displaying, 6-38

CREATE CONFIGURATION command, 5-3, 6-16

CREATE SITE command, 6-19

creating

a broker configuration, 1-1, 4-5, 4-18, 5-2, 5-3, 6-16

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

standby sites, 4-10, 6-19

critical properties, 3-9

setting database, 4-23, 5-6

Data Guard broker

See broker

Data Guard command-line interface

banners from output, 6-1

commands

ALTER RESOURCE (property), 6-8

ALTER RESOURCE (state), 6-10

ALTER SITE, 6-12

CREATE CONFIGURATION, 6-16

CREATE SITE, 6-19

DISABLE CONFIGURATION, 6-22

DISABLE RESOURCE, 6-23

DISABLE SITE, 6-24

ENABLE CONFIGURATION, 6-25

ENABLE RESOURCE, 6-26

ENABLE SITE, 6-28

EXIT, 6-29

HELP, 6-30

QUIT, 6-31

REMOVE CONFIGURATION, 6-32

REMOVE SITE, 6-33

SHOW CONFIGURATION, 6-34

SHOW DEPENDENCY TREE, 6-36

SHOW LOG, 6-38

SHOW RESOURCE, 6-43

SHOW SITE, 6-46

creating

a standby database, 4-6, 5-1

and adding a primary database resource object, 6-16

database resource substates, 2-9, 3-3, 6-10, 6-26

DR_START initialization parameter, 1-10, 6-4

introduction, 1-2, 1-5, 6-1

sample help output, 1-6

setting critical database properties, 5-6

setting noncritical database properties, 5-8

starting, 5-3, 6-1

string values, 6-5

summary of commands, 6-2

suppressing command prompts, 6-1

Data Guard configuration file

definition, 1-9

deleting, 6-33

relationship to DMON process, 1-7

Data Guard configurations

background, 2-2

supported, 2-1

Data Guard Manager, 1-4

console, 1-5

discovering primary and standby nodes, 4-2

integration with Oracle Enterprise Manager, 1-4, 4-1

introduction, 1-2, 1-9

making Oracle Net configuration changes, 1-2

quick tour, 4-5

setting critical database properties, 4-23

setting Preferred Credentials, 4-2

starting, 4-3

wizard

creating standby databases, 1-2

Data Guard monitor (DMON), 1-6

in a broker configuration, 2-2

in a Data Guard configuration, 2-2

interaction with the Oracle database server, 1-6

maintaining configuration data, 1-9

managing objects, 2-2, 2-6, 4-19, 5-6

Oracle database server background processes, 1-7

overview, 1-6

removing objects, 5-11

running on each site, 2-2

starting with the DRS_START parameter, 2-5

stopping, 5-12

two-way network communication, 1-8

using database properties, 3-9

using database resource objects, 3-1

database resources

connecting to, 5-3

creating and adding to a broker configuration, 1-5

dependencies, 3-1

discovering, 4-2

installation for broker management, 1-10

monitoring, 1-2

objects

definition, 1-3

in a broker configuration, 1-3

overview, 3-1

prerequisites for broker configurations, 1-10

properties

configurable, 3-6

critical, 3-9

noncritical, 3-9

starting the standby database instance, 5-2

states, 3-1

dependencies, 3-1

online and offline, 3-2

online substates, 2-9

transitions, 2-10, 3-4

substates, 3-3

database sites

See sites

default values

database resource substates, 2-9

See also states

dependencies

displaying for a configuration, 6-36

hierarchy of objects in a broker configuration, 3-1

object, 2-2

dependency attribute

setting in a broker configuration, 3-7

dependency tree, 6-36

destinations

archived redo log parameters, 2-1

viewing the LogXptStatus property, 3-12

diagrams of database state transitions, 3-5

DISABLE CONFIGURATION command, 6-22

example, 5-10

DISABLE RESOURCE command, 6-23

example, 5-10

DISABLE SITE command, 6-24

example, 5-10

disabling

broker configuration, 5-9, 6-22

database resources, 5-10, 6-23

sites, 5-10, 6-24

See also each DISABLE command

discovering

primary and standby nodes, 4-2

Discovery wizard, 4-2

displaying

alert log, 6-38

Data Guard configuration log, 6-38

Data Guard Manager quick tour, 4-5

help for CLI commands, 6-30

help for Data Guard Manager, 4-5

properties, 2-13

states, 2-10

summary information

configuration, 6-34

database resource, 6-43

site, 6-46

distributed management framework, 1-1

DMON

See Data Guard monitor (DMON)

DRS_START initialization parameter, 1-10, 2-5, 5-12, 6-4

e-mail

reporting events, 1-5

ENABLE CONFIGURATION command, 5-7, 6-25, 6-26, 6-28

enabling

broker configuration, 2-7, 4-19, 4-20, 5-6, 5-7

See also each ENABLE command

Enterprise Edition database server

installation, 1-10

error messages, A-1 to A-28

error status, 2-12

event management system, 1-4

events

Oracle Enterprise Manager, 1-2, 1-4

reporting, 1-5

responding to, 1-2

starting Oracle Intelligent Agent, 4-2

EXIT command, 6-29

See also QUIT command

FAL_CLIENT initialization parameter

setting in a broker configuration, 3-8

FAL_SERVER initialization parameter

setting in a broker configuration, 3-8

FalClient property, 3-8

FalServer property, 3-7

health check, 1-2

monitoring, 1-7, 1-8

revealed by configuration status, 2-11

HELP command, 6-30

sample, 1-6

hierarchy

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

importing standby databases, 1-5

initial default online states

See states

installation

archivelog mode setup, 1-10

prerequisites, 1-10

remote login password file, 1-11

installing

Data Guard, 1-10

Data Guard Manager, 1-10

intended state

configuration health check, 2-11

definition, 2-9

invoking

the Data Guard command-line interface, 5-3

jobs

starting Oracle Intelligent Agent, 4-2

life cycle of a broker configuration, 2-5

log apply services

Data Guard configuration, 2-2

effect of database resource online states on underlying components, 3-4

standby database online mode, 2-9, 3-2

verifying, 1-2

log transport services

configuring, 1-2

Data Guard configuration, 2-1

effect of database resource online states on underlying components, 3-4

primary database online mode, 2-9, 3-2

verifying, 1-2

LOG_ARCHIVE_DEST_n initialization parameters

setting in a broker configuration, 3-7

LOG_ARCHIVE_TRACE initialization parameter

setting in a broker configuration, 3-7

LogArchiveDestOptions property, 3-7

LogArchiveTrace property, 3-7

login password file, 1-11

LogXptStatus property, 3-12

management

Data Guard Manager, 1-4

local operations, 1-2

model, 1-2

objects in a broker configuration, 1-3

of a remote standby database, 1-11

remote operations, 1-2

managing

a broker configuration, 5-1

database resources, 3-1

messages

error and status, A-1

monitorable properties, 2-12

database, 3-10

LogXptStatus, 3-12

SbyLogQueue, 3-12

SendQEntries, 3-11

monitoring

broker configurations, 1-7, 5-1

local and remote databases, 1-2

through the command-line interface, 1-6

net service name

uniquely identify the primary site, 5-2

networks

Data Guard configuration, 2-1

setting up files, 1-10

two-way communication, 1-8

noncritical database properties, 3-9

setting, 5-8

normal status, 2-11

objects

broker configuration, 1-2, 2-2

changing the state of, 5-7

connected in a hierarchy, 1-3

default online database resource substates, 2-9

dependencies, 2-2, 3-1

disabling, 5-9

enabling, 4-19, 5-6

hierarchy, 1-3

state transitions, 2-9

states, 2-7

taking offline, 5-8

oemapp console command, 4-1

oemapp dataguard command, 4-4

oemctl start oms command, 4-1

offline state

database resource, 3-2

effect on underlying components, 3-4

transitioning objects, 5-8

online paths

displaying for a broker configuration, 6-36

online state

effect on underlying components, 3-4

online states

database resource, 3-2, 3-3

substates, 3-3

operations

performing on broker objects, 1-3

Oracle Enterprise Manager

Discovery wizard, 4-2

event management system, 1-2

integration, 1-4

setting Preferred Credentials, 4-2

starting, 4-1

starting Data Guard Manager, 4-3

Oracle Intelligent Agent

starting, 4-2

Oracle Management Server

starting, 4-1

Oracle Net networks

configuration changes, 1-2

configuring, 5-2

installation prerequisites, 1-10

supported configuration, 2-1

two-way communication, 1-8

pagers

reporting events, 1-5

parameters

database properties, 3-6

password file, 1-11

paused state

effect on underlying components, 3-4

PHYSICAL-APPLY-ON substate, 3-3

default online state, 2-9

effect of database resource states on underlying components, 3-4

state transitions, 3-5

PHYSICAL-APPLY-READY substate, 3-3

effect of database resource states on underlying components, 3-4

state transitions, 3-5

Preferred Credentials, 4-2

prerequisites for installation, 1-10

primary database

archivelog mode, 1-10

connecting to, 5-3

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

Data Guard configuration, 2-1

default online state, 2-9

online state, 3-2

online substates, 3-3

state transitions, 3-5

states effect on underlying components, 3-4

primary online substate, 3-3

primary paused substate, 3-3

primary site

configuration, 2-1

processes

DMON, 1-7

Oracle database server, 1-7

properties

changing database resources, 3-1

common, 2-12

default values, 2-12

configurable, 2-12

configuration, 2-9

critical, 3-9

database, 3-6

managing database resource, 3-1

monitorable, 2-12

noncritical, 3-9

overview, 2-12

property pages

Data Guard Manager console, 1-5

quick tour, 4-5

QUIT command, 6-31

See also EXIT command

READ-ONLY substate, 3-3

effect on underlying components, 3-4

state transitions, 3-5

read/write mode, 2-9, 3-2

READ-WRITE substate, 3-3

effect on underlying components, 3-4

state transitions, 3-5

READ-WRITE-XPTON substate, 3-3

CLI default value, 2-9

effect on underlying components, 3-4

state transitions, 3-5

redo logs

viewing, 1-2

viewing information about, 3-11

remote login password file, 1-11

REMOVE CONFIGURATION command, 6-32

example, 5-11, 5-12

REMOVE SITE command, 6-33

example, 5-11

removing

See each REMOVE command

requests

passing between sites, 1-8

resource guard

definition, 3-1

resources

altering properties for, 6-8

altering states for, 6-10

disabling management of objects, 6-22, 6-23, 6-24

displaying summary information for, 6-43

enabling, 4-19, 5-6, 6-25, 6-26, 6-28

responding to events, 1-2

roles

effect on database resource substates, 2-9

SbyLogQueue property, 3-12

scripts

using Data Guard command-line interface, 6-1

SendQEntries property, 3-11

server-side software, 1-6

setting

critical database properties, 4-23, 5-6

noncritical database properties, 5-8

SHOW CONFIGURATION command, 5-4, 6-34

SHOW CONFIGURATION VERBOSE command, 5-4, 5-7

SHOW DEPENDENCY TREE command, 6-36

SHOW LOG command, 6-38

SHOW RESOURCE command, 6-43

SHOW SITE command, 6-46

SHOW SITE VERBOSE command, 5-5

displaying properties, 2-13

showing

See each SHOW command

sites

creating, 6-19

deleting

Data Guard configuration file, 6-33

dependencies, 3-1

effects of removing metadata from, 6-32, 6-33

enabling, 4-19, 5-6

logical object, 1-2

network setup, 1-8, 1-10

object

definition, 1-3

removing

from a broker configuration, 5-11

showing summary information, 6-46

states

transitions, 2-10

standby databases

constructing from backups, 2-6, 5-2

creating, 1-2, 4-6, 4-10, 5-1

Data Guard configuration, 2-1

discovering, 4-2

effect of database resource online states on underlying components, 3-4

management, 1-11

online state, 2-9, 3-2

online substates, 3-3

starting, 5-2

state transitions, 3-5

standby online substate, 3-3

standby paused substate, 3-3

standby paused, read-only mode substate, 3-3

standby sites

changing the state of, 4-22

creating, 6-19

STANDBY_ARCHIVE_DEST initialization parameter

setting in a broker configuration, 3-8

STANDBY_FILE_MANAGEMENT initialization parameter

setting in a broker configuration, 3-8

StandbyArchiveDest property, 3-8

StandbyPreserveNames property, 3-8

starting

Create Configuration wizard, 4-5

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

Data Guard Manager, 4-3

Data Guard monitor (DMON), 2-5

Oracle Enterprise Manager Console, 4-1

Oracle Intelligent Agent, 4-2

Oracle Management Server, 4-1

standby databases, 5-2

state transitions, 2-9

effect on database resource substates, 3-4

overview, 2-9

states, 2-7

changing, 3-1, 5-7

configuration, 2-9, 6-7

database, 3-1

database transitions, 3-4

displaying, 2-10

effect on underlying components, 3-4

initial default online, 2-9

transitioning, 2-9

status

configuration, 2-11

intended state of a configuration, 2-11

stopping

Data Guard monitor (DMON) process, 5-12

string values

Data Guard command-line interface, 6-5

substates

database resource, 3-3, 6-26

default, 2-9

effect on archived redo logs, 2-9

primary database, 3-5

standby databases, 3-5

supported broker configuration, 1-2

SYSDBA privileges, 5-3

to connect to the database, 6-4

system global area (SGA)

allocated for DMON process, 1-6

two-way communication channel, 1-8

updating configuration properties, 2-12

user interfaces

overview, 1-4

viewing property information about database resources, 3-10

warning status, 2-11

wizards

discovering primary and standby nodes, 4-2

Discovery, 4-2

standby database creation, 1-5

starting Create Configuration, 4-5

Index

A

B

C

D

E

F

H

I

J

L

M

N

O

P

Q

R

S

T

U

V

W