Index

A B C D E F H I L M N O P Q R S T U V W

A

ADD DATABASE command, 7.2

Add Standby Database wizard

creating a broker configuration, 2.4, 5.2

creating a standby database, 5.2

definition, 1.5.1

introduction, 1.5.1

adding

an existing RAC standby database, 5.3

standby database to the broker configuration, 6.2

ALTER SYSTEM statement

starting the broker, 6.1

altering

properties

database, 6.6.1.1

states

database, 6.6.1.2, 6.6.1.3

AlternateLocation property, 8.2.1

setting log apply services, 3.4.3

application integration, 1.2

apply errors

managing, 3.5.6

apply instance, 3.5.8

and the PreferredApplyInstance property, 3.5.8.1

of standby database, 3.2.1

selecting, 3.5.8.1

apply instance failover, 3.5.8

and log apply services, 3.5.8.2

ApplyInstanceTimeout property, 3.5.8.2, 8.2.2

ApplyNext property, 3.5.2, 8.2.3

restriction, 3.5.2

ApplyNoDelay property, 3.5.2, 8.2.4

ApplyParallel property, 3.5.3, 8.2.5

ARCH log transport mode, 3.4.1

architecture

Data Guard broker, 1.4

ARCHIVE_LAG_TARGET initialization parameter

setting in a broker configuration, 8.2.6

archived redo logs

destination and configuration parameters, 2.1

in a Data Guard configuration, 2.1

primary database setup, 1.7.5

ArchiveLagTarget property, 8.2.6

ASYNC log transport mode, 3.4.1

AsyncBlocks property, 8.2.7

B

background processes

DMON, 1.6.1

banners

suppressing from DGMGRL command-line interface output, 7.1.1

before you perform a failover, 4.2.1

before you perform a switchover, 4.1.1

before you use DGMGRL, 6.1

benefits

Data Guard broker, 1.2

high availability, 1.2

scalability, 1.2

with Real Application Clusters, 1.2

binary configuration file, 1.6.2

Binding property, 8.2.8

broker

components, 1.4

Data Guard configuration file, 1.6.2

failover, 4.2.3

immediate failover, 4.2.4

installation, 1.7.5

introduction, 1.1.2

log transport services verification, 1.2

managing databases, 3.1

performing a complete failover, 4.2.3

performing a switchover, 4.1.3

user interfaces, 1.1.2, 1.5

broker configurations, 3.6.2.5

add an existing RAC standby database, 5.3

benefits, 1.2

changing roles, 2.4

components, 2.1

creating, 5.2, 6.2, 6.2, 7.2

Data Guard configuration file, 1.6.1

database objects, 1.3

disabling databases, 2.5, 7.2

enabling, 6.4

enabling databases, 2.4, 2.5, 6.4, 7.2

health, 1.6.1, 2.6

instance objects, 1.3

life cycle, 2.4

management, 1.3, 1.5.1, 1.5.2, 1.6.2

monitoring, 5.7, 6.9

objects, 1.3

Oracle Net Services configuration, 1.2, 1.5.1

overview, 2.1

properties, 3.3

protection modes, 7.2

removing, 5.9.2

setting protection mode, 3.6.1

status modes, 2.6

supported, 1.3, 2.1, 2.1

verifying, 5.7.1

C

CFS

See cluster file system

changed features, A

changing

properties

databases in a broker configuration, 2.4, 3.3.2

of a database in a broker configuration, 5.4.2

protection mode

of a database in a broker configuration, 5.4.3

roles

within the broker configuration, 2.4

states

databases in a broker configuration, 2.4, 3.2.1

of a standby database in a broker configuration, 5.4.1

of databases in a broker configuration, 6.6

See also editing

CLI

See Data Guard command-line interface

cluster file system

broker configuration files, 2.2

Cluster Ready Services

and instances of a RAC database, 1.2

recover failed instances, 1.2

command prompts

suppressing from DGMGRL command-line interface output, 7.1.1

COMPATIBLE initialization parameter

requirements for setting, 1.7.5

complete failover, 7.2

components

broker, 1.4

Data Guard configuration, 2.1

configurable properties, 3.3

AlternateLocation, 8.2.1

ApplyInstanceTimeout, 8.2.2

ApplyNext, 8.2.3

ApplyNoDelay, 8.2.4

ApplyParallel, 8.2.5

ArchiveLagTarget, 8.2.6

AsyncBlocks, 8.2.7

Binding, 8.2.8

database, 3.3.2, 3.3.2, 8.2

DbFileNameConvert, 8.2.9

DelayMins, 8.2.10

Dependency, 8.2.11

HostName, 8.2.12

InitialConnectIdentifier, 8.2.13

LatestLog, 8.1.3

LocalListenerAddress, 8.2.14

LogArchiveFormat, 8.2.15

LogArchiveMaxProcesses, 8.2.16

LogArchiveMinSucceedDest, 8.2.17

LogArchiveTrace, 8.2.18

LogFileNameConvert, 8.2.19

LogShipping, 8.2.20

LogXptMode, 8.2.21

LsbyASkipCfgPr, 8.2.22

LsbyASkipErrorCfgPr, 8.2.23

LsbyASkipTxnCfgPr, 8.2.24

LsbyDSkipCfgPr, 8.2.25

LsbyDSkipErrorCfgPr, 8.2.26

LsbyDSkipTxnCfgPr, 8.2.27

LsbyMaxEventsRecorded, 8.2.28

LsbyMaxServers, 8.2.30

LsbyMaxSga, 8.2.29

LsbyRecordAppliedDdl, 8.2.31

LsbyRecordSkipDdl, 8.2.32

LsbyRecordSkipErrors, 8.2.33

LsbyTxnConsistency, 8.2.34

managing log transport services, 3.4

MaxFailure, 8.2.35

NetTimeout, 8.2.36

PreferredApplyInstance, 8.2.37

RealTimeApply, 8.2.38

ReopenSecs, 8.2.39

SidName, 8.2.40

StandbyArchiveLocation, 8.2.41

StandbyFileManagement, 8.2.42

TopWaitEvents, 8.1.12

configuration

effects of removing metadata from, 7.2

enabling, 7.2

configuration file

See Data Guard configuration file

configurations

database profiles, 1.3

CONNECT command, 6.2, 7.2

connecting

privileges required for Data Guard broker configurations, 7.1.3

to the primary database, 6.2

to the standby database, 3.4.6

controlling

available SGA memory, 3.5.4

transaction consistency level, 3.5.4

CREATE CONFIGURATION command, 6.2, 7.2

creating

a broker configuration, 5.2, 6.2, 6.2, 6.2, 7.2

with the Add Standby Database wizard, 2.4

a standby database, 2.4, 5.2, 5.2, 7.2

CRS

See Cluster Ready Services

D

Data Guard

troubleshooting, 9

Data Guard broker

changed features, A

deprecated features, A

See broker

Data Guard command-line interface

banners from output, 7.1.1

commands

ADD DATABASE, 7.2

CONNECT, 7.2

CREATE CONFIGURATION, 7.2

DISABLE CONFIGURATION, 7.2

DISABLE DATABASE, 7.2

EDIT CONFIGURATION (protection mode), 7.2

EDIT DATABASE (property), 7.2

EDIT DATABASE (rename), 7.2

EDIT DATABASE (state), 7.2

EDIT INSTANCE (AUTO PFILE), 7.2

EDIT INSTANCE (property), 7.2

ENABLE CONFIGURATION, 7.2

ENABLE DATABASE, 7.2

EXIT, 7.2

FAILOVER, 6.8

HELP, 7.2

QUIT, 7.2

REMOVE CONFIGURATION, 7.2

REMOVE DATABASE, 7.2

REMOVE INSTANCE, 7.2

SET STATE, 3.5.8.1

SHOW CONFIGURATION, 7.2

SHOW DATABASE, 7.2

SHOW INSTANCE, 7.2

SHUTDOWN, 7.2

STARTUP, 7.2

SWITCHOVER, 6.7, 7.2

creating

a standby database, 7.2

and adding a primary database, 7.2

creating a configuration, 6.2

DG_BROKER_START initialization parameter, 1.7.5, 7.1.3

enabling a database, 6.4

enabling the configuration, 6.4

introduction, 1.1.2, 1.5.2

monitoring broker configurations, 6.9

performing routine management tasks, 6.6

prerequisites, 6.1

sample help output, 1.5.2

setting critical database properties, 6.3

single command mode, 7.1.1

starting, 6.2, 7.1

stopping, 7.2

string values, 7.1.3

summary of commands, 7.1.2

suppressing command prompts, 7.1.1

Data Guard configuration file

for a RAC database, 2.2

in a CFS area, 2.2

inconsistent values from server parameter file, 8.1.2

on a raw device, 2.2

relationship to DMON process, 1.6.1

renaming, 1.6.2

setting up, 2.2

Data Guard configurations

automated creation of, 1.2

background, 2.1

supported, 2.1

Data Guard GUI, 1.5.1

Add Standby Database wizard, 1.5.1

adding an existing RAC standby database, 5.3

changing the database protection mode, 5.4.3

changing the properties of a database, 5.4.2

changing the state of a database, 5.4.1

creating

a configuration, 5.2

a standby database, 5.2

database property pages, 1.5.1

downgrading, 1.7.4

integration with Oracle Enterprise Manager, 1.5.1, 5.1

introduction, 1.1.2, 1.4

making Oracle Net Services configuration changes, 1.2, 1.5.1

managing metrics, 5.8.2

monitoring broker configurations, 5.7

monitoring configuration performance, 5.7.3

Overview page, 1.5.1

performance tools and graphs, 1.5.1

performing a failover, 5.6

performing a switchover, 5.5

performing routing maintenance, 5.4

removing a configuration, 5.9.2

removing a standby database, 5.9.1

starting, 5.1

upgrading, 1.7.2, 1.7.3

using metrics, 5.8

verifying a broker configuration, 5.7.1

viewing log file details, 5.7.2

wizards

automate standby database creation, 2.1

creating standby databases, 1.5.1

Data Guard monitor (DMON)

in a broker configuration, 2.1

in a Data Guard configuration, 2.1

interaction with the Oracle database, 1.6.1

maintaining configuration data, 1.6.2

managing objects, 2.1, 2.4, 6.4

Oracle database background processes, 1.6.1

overview, 1.6.1

removing objects, 6.6.3

running on each location, 2.1

starting with the DG_BROKER_START parameter, 2.3

two-way network communication, 1.6.1

Data Guard Status metric

understanding, 5.8.1.1

Data Not Applied (log files) metric

understanding, 5.8.1.3

Data Not Applied (MB) metric

understanding, 5.8.1.2

Data Not Received (log files) metric

understanding, 5.8.1.5

Data Not Received (MB) metric

understanding, 5.8.1.4

data protection modes

See protection modes

database resources

monitoring, 1.2

databases

changing the state of, 6.6

configurable database properties, 3.3.2, 8.2

connecting to, 6.2

creating and adding to a broker configuration, 1.5.1

dependencies, 3.2

disabling management of, 7.2

during failover, 4.2

during switchover, 4.1

enabling, 6.4

health, 3.7

installation for broker management, 1.7.5

monitorable database properties, 3.3.1, 8.1

network setup, 1.6.1, 1.7.5

objects, 1.3

definition, 1.3

in a broker configuration, 1.3

prerequisites for broker configurations, 1.7.5

properties

configurable, 3.3.2

property management, 1.6.3

property pages, 1.5.1

removing

from a broker configuration, 6.6.3

restarting after a failover, 7.2

states, 3.2

dependencies, 3.2

transitions, 3.2.1

status, 3.7

DB_BROKER_START initialization parameter, 6.1

DB_FILE_NAME_CONVERT initialization parameter

initialization parameters

setting DB_FILE_NAME_CONVERT in a broker configuration, 8.2.9

DB_UNIQUE_NAME initialization parameter, 3.4.6

DBA_LOGSTDBY_EVENTS table

managing, 3.5.7

DbFileNameConvert property, 8.2.9

delayed apply

and log apply services, 3.5.2

managing, 3.5.2

DelayMins property, 8.2.10

delaying log apply services, 3.5.2

Dependency property, 3.4.4, 8.2.11

deprecated features, A

destinations

archived redo log file parameters, 2.1

viewing the LogXptStatus property, 8.1.4

DG_BROKER_CONFIG_FILEn file, 1.6.2, 2.2

in a CFS area, 2.2

on a raw device, 2.2

DG_BROKER_START initialization parameter, 1.7, 1.7.5, 7.1.3

DGMGRL

See Data Guard command-line interface

DGMGRL commands

FAILOVER, 7.2

SWITCHOVER, 7.2

diagnostic information

sources, 9.1

diagrams of database state transitions, 3.2.1

DISABLE CONFIGURATION command, 7.2

example, 6.6.2.1

DISABLE DATABASE command, 7.2

example, 6.6.2.2

disabling

broker configuration, 6.6.2, 7.2

broker management of standby database, 7.2

databases, 6.6.2.1, 6.6.2.2

databases in a broker configuration, 2.5

See also each DISABLE command

disaster protection

benefits, 1.2

displaying

help for CLI commands, 7.2

help for Data Guard GUI, 5.1

properties, 3.3

summary information

configuration, 7.2

distributed management framework, 1.1.2

DMON

See Data Guard monitor (DMON)

downgrading

Data Guard, 1.7.4

Data Guard GUI, 1.7.4

protection mode, 3.6.2.1

E

EDIT CONFIGURATION (protection mode) command

EDIT DATABASE (property) command, 7.2

example, 6.6.1.1

EDIT DATABASE (rename) command, 7.2

EDIT DATABASE (state) command, 7.2

example, 6.6.1.2

EDIT INSTANCE (AUTO PFILE) command, 7.2

EDIT INSTANCE (property) command, 7.2

editing

protection modes

configuration, 7.2

e-mail

reporting events, 1.5.1

ENABLE CONFIGURATION command, 6.4, 7.2

ENABLE DATABASE command, 7.2

enabling

broker configuration, 2.4, 6.4, 6.4, 6.4

databases in a broker configuration, 2.5

See also each ENABLE command

Enterprise Edition database

installation, 1.7

error status, 2.6

event management system, 1.5.1

events

managing

in a logical standby database, 3.5.7

monitoring with Oracle Enterprise Manager, 2.1

Oracle Enterprise Manager, 1.2, 1.5.1

reporting, 1.5.1

responding to, 1.2

EXIT command, 7.2

See also QUIT command

F

failover, 4.2, 4.2.3

benefits, 1.2

broker tasks, 4.2.3

complete, 4.2

broker tasks, 4.2.3

database restarts and, 7.2

effect on data protection mode, 4.2

failing over to a standby database, 7.2

immediate, 4.2

broker tasks, 4.2.4

introduction, 1.5.1

managing, 4.2

overview, 4.2, 4.2

performing recovery steps, 4.2.5

prerequisites, 4.2.1

role management overview, 4

scenario, 5.6

starting, 4.2.2

troubleshooting, 9.3

using the CLI, 6.8

using the FAI, 7.2

FAILOVER command, 6.8, 7.2

failures

primary database, 4

files

naming the server parameter file, 1.6.3

H

health check, 1.2

monitoring, 1.6.1, 1.6.1

on primary database, 3.7

on standby database, 3.7

revealed by configuration status, 2.6

StatusReport property, 3.7

HELP command, 7.2

high availability

benefits, 1.2

grades of data protection, 3.6, 8.2.21

LogXptMode property, 8.2.21

HostName property, 8.2.12

I

immediate failover, 7.2

InconsistentProperties property, 8.1.2

increased scalability

benefits, 1.2

InitialConnectIdentifier property, 8.2.13

initialization parameters

COMPATIBLE, 1.7.5

database configurable properties, 3.3.2

DB_BROKER_START, 6.1

DB_UNIQUE_NAME, 3.4.6

DG_BROKER_CONFIG_FILEn, 2.2

DG_BROKER_START, 1.7.5

dynamic, 3.3.2

inconsistent, 8.1.2

INSTANCE_NAME, 3.4.6

LOCAL_LISTENER, 1.7.5, 3.4.6

LOG_ARCHIVE_DEST_n, 3.4.5

static, 3.3.2

See also server parameter file, 1.7.5

installation

ARCHIVELOG mode setup, 1.7.5

Data Guard, 1.7

Data Guard GUI, 1.7.1

prerequisites, 1.7

instance

removing, 7.2

shutting down, 7.2

starting, 7.2

INSTANCE_NAME initialization parameter, 3.4.6

instances

objects

in a broker configuration, 1.3

intended state

configuration health check, 2.6

invoking

the Data Guard command-line interface, 6.2

L

LatestLog property, 8.1.3

life cycle of a broker configuration, 2.4

LOCAL_LISTENER initialization parameter, 1.7.5, 3.4.6, 8.2.14

LocalListenerAddress property, 8.2.14

log apply services

and apply instance failover, 3.5.8, 3.5.8.2

and delayed apply, 3.5.2

and parallel apply, 3.5.3

and real-time apply, 3.5.1

apply instance, 3.5.8

configuring, 1.2, 1.5.1

Data Guard configuration, 2.1

delaying, 8.2.10

in a RAC database, 3.5.8

managing, 3.5

selecting the apply instance, 3.5.8.1

verifying, 1.2

log file details

viewing, 5.7.2

log transport services

and connections to the standby database, 3.4.6

ARCH mode, 3.4.1, 8.2.21

ASYNC mode, 3.4.1, 8.2.21

configuring, 1.2, 1.5.1

data protection modes, 8.2.21

Data Guard configuration, 2.1

in a RAC environment, 3.4.7

LogShipping property, 8.2.20

managing, 3.4

SYNC mode, 3.4.1, 8.2.21

tuning, 3.4.5

turning off, 3.4.2

turning on, 3.4.2

verifying, 1.2

LOG_ARCHIVE_DEST_n initialization parameter

SERVICE attribute, 3.4.6

setting log transport services, 3.4.5

setting the ASYNC attribute, 8.2.7

setting the DELAY attribute, 8.2.10

setting the DEPENDENCY attribute, 8.2.11

setting the ENABLE and DEFER attributes, 8.2.20

setting the MANDATORY or OPTIONAL attributes, 8.2.8

LOG_ARCHIVE_FORMAT initialization parameter, 8.2.15

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 8.2.16

LOG_ARCHIVE_MIN_SUCCEED initialization parameter, 8.2.17

LOG_ARCHIVE_TRACE initialization parameter

setting LogArchiveTrace property, 8.2.18

LOG_FILE_NAME_CONVERT initialization parameter

setting LogFileNameConvert property, 8.2.19

LogArchiveFormat property, 8.2.15

LogArchiveMaxProcesses property, 8.2.16

LogArchiveMinSucceedDest property, 8.2.17

LogArchiveTrace property, 8.2.18

LogFileNameConvert property, 8.2.19

logical standby database

and SQL apply error handling, 3.5.6

and SQL apply filters, 3.5.5

managing events, 3.5.7

SQL apply service, 3.5.4

state transitions, 3.2.1

LogShipping property, 8.2.20

LogXptMode property, 8.2.21

LogXptStatus property, 8.1.4

LsbyASkipCfgPr property, 8.2.22

LsbyASkipErrorCfgPr property, 3.5.6, 8.2.23

LsbyASkipTxnCfgPr property, 8.2.24

LsbyDSkipCfgPr property, 8.2.25

LsbyDSkipErrorCfgPr property, 3.5.6, 8.2.26

LsbyDSkipTxnCfgPr property, 8.2.27

LsbyFailedTxnInfo property, 8.1.5

LsbyMaxEventsRecorded property, 8.2.28

LsbyMaxServers property, 8.2.30

LsbyMaxSga property, 3.5.4, 8.2.29

LsbyParameters property, 8.1.6

LsbyRecordAppliedDdl property, 8.2.31

LsbyRecordSkipDdl property, 8.2.32

LsbyRecordSkipErrors property, 8.2.33

LsbySkipTable property, 8.1.7

LsbySkipTxnTable property, 8.1.8

LsbyTxnConsistency property, 3.5.4, 8.2.34

M

management

benefits, 1.2

Data Guard GUI, 1.5.1

model, 1.3

managing

a broker configuration, 2, 6

apply errors, 3.5.6

Data Guard metrics, 5.8.2

databases, 3

DBA_LOGSTDBY_EVENTS table, 3.5.7

delayed apply, 3.5.2

events

in a logical standby database, 3.5.7

failover, 4.2

local operations, 1.1.2

log apply services, 3.5

objects in a broker configuration, 1.3

parallel apply in a physical standby database, 3.5.3

real-time apply, 3.5.1

remote operations, 1.1.2

roles, 4

failover, 4.2

switchover, 4.1

MANDATORY attribute

set with the Binding property, 8.2.8

MaxFailure property, 8.2.35

maximize availability, 1.2, 2.4, 8.2.21

maximize data protection, 1.2, 2.4, 8.2.21

maximize performance, 1.2, 2.4, 8.2.21

maximum availability

data protection mode, 3.6.1

maximum performance

data protection mode, 3.6.1

maximum protection

data protection mode, 3.6.1

metrics

Data Guard Status, 5.8.1.1

Data Not Applied (log files), 5.8.1.3

Data Not Applied (MB), 5.8.1.2

Data Not Received (log files), 5.8.1.5

Data Not Received (MB), 5.8.1.4

managing, 5.8.2

using, 5.8

monitorable properties, 3.3

database, 3.3.1

InconsistentProperties, 8.1.2

LogXptStatus, 8.1.4, 8.1.4

LsbyFailedTxnInfo, 8.1.5, 8.1.5

LsbyParameters, 8.1.6

LsbySkipTable, 8.1.7

LsbySkipTxnTable, 8.1.8

RecvQEntries, 8.1.9

SendQEntries, 8.1.10

StatusReport, 8.1.11

monitoring

broker configurations, 1.6.1, 5.7, 6, 6.9

configuration performance, 5.7.3

Data Guard GUI performance page, 2.4

local and remote databases, 1.2

through the command-line interface, 1.5.2

N

NetTimeout property, 8.2.36

networks

Data Guard configuration, 2.1

setting up files, 1.7.5

two-way communication, 1.6.1

normal status, 2.6

O

objects

broker configuration, 1.3, 2.1

disabling, 6.6.2

properties for databases, 1.6.3

relationship, 1.3

ONLINE state

setting LogShipping property, 8.2.20

operations

complete failover, 7.2

disable broker management

effect on protection modes, 3.6.2.4

downgrade

effect on protection modes, 3.6.2.1

effect on protection modes, 3.6.2

enable broker management

effect on protection modes, 3.6.2.4

failover, 6.8

effect on protection modes, 3.6.2.3

troubleshooting, 9.3

failover scenario, 5.6

immediate failover, 7.2

performing on broker objects, 1.3

removing a database from the configuration

effect on protection modes, 3.6.2.5

switchover, 6.7

effect on protection modes, 3.6.2.2

troubleshooting, 9.4

switchover scenario, 5.5

upgrade

effect on protection modes, 3.6.2.1

OPTIONAL attribute

set with the Binding property, 8.2.8

Oracle Enterprise Manager

event management system, 1.2

integration, 1.5.1

monitoring events, 2.1

Oracle Net Services

configuration changes, 1.2, 1.5.1

installation prerequisites, 1.7.5

supported configuration, 2.1

two-way communication, 1.6.1

P

parallel apply

and log apply services, 3.5.3

managing in a physical standby database, 3.5.3

performance

Data Guard GUI tools, 1.5.1, 5.7.3

Personal Edition database

installation, 1.7

physical standby database

managing parallel apply, 3.5.3

state transitions, 3.2.1

PreferredApplyInstance property, 3.5.8.1, 8.2.37

prerequisites

failover, 4.2.1

installation, 1.7

switchover, 4.1.1

primary database

ARCHIVELOG mode, 1.7.5

configuration, 2.1

connecting to, 6.2, 6.2

constructing a standby database, 2.4, 6.1

Data Guard configuration, 2.1

during failover, 1.5.1

health check, 3.7

state transitions, 3.2.1

switching over to the standby role, 7.2

processes

DMON, 1.6.1

Oracle database, 1.6.1

properties

AlternateLocation, 3.4.3

ApplyInstanceTimeout, 3.5.8.2

ApplyNext, 3.5.2

restriction, 3.5.2

ApplyNoDelay, 3.5.2

ApplyParallel, 3.5.3

changing, 2.4

configurable, 3.3

database, 3.3

DelayMins, 3.5.2

Dependency, 3.4.4

LsbyASkipErrorCfgPr, 3.5.6

LsbyDSkipErrorCfgPr, 3.5.6

LsbyMaxSga, 3.5.4

LsbyTxnConsistency, 3.5.4

managing, 1.6.3

monitorable, 3.3

of a database

changing in a broker configuration, 5.4.2

PreferredApplyInstance, 3.5.8.1

RealTimeApply, 3.5.1

setting, 6.3

StandbyArchiveLocation, 3.4.3

StatusReport, 3.7

updating in server parameter file, 1.6.3, 1.7.5

property pages

configuring, 1.5.1

database, 1.5.1

protection modes

after a failover, 4.2

benefits, 1.2

configuration, 7.2

downgrading, 3.6.2.1

log transport services setup, 8.2.21

of a database

changing in a broker configuration, 5.4.3

setting for a broker configuration, 3.6

updating, 2.4

upgrading, 3.6.2.1

ProtectionMode property, 8.2.39

Q

QUIT command, 7.2

See also EXIT command

R

raw device

and broker configuration files, 2.2

sizing, 2.2.1

READ-WRITE state

LogShipping property setting, 8.2.20

Real Application Clusters

adding to a broker configuration, 5.3

and apply instance failover, 3.5.8.2

and log apply services, 3.5.8

and log transport services, 3.4.7

and setting the apply instance, 3.5.8.1

benefits, 1.2

real-time apply

and log apply services, 3.5.1

managing, 3.5.1

RealTimeApply property, 3.5.1, 8.2.38

RecvQEntries property, 8.1.9

relationship

objects in a broker configuration, 1.3

REMOVE CONFIGURATION command, 7.2

example, 6.6.3

REMOVE DATABASE command, 7.2

REMOVE INSTANCE command, 7.2

removing, 3.6.2.5

a standby database, 3.6.2.5

broker configurations, 3.6.2.5, 5.9.2

See each REMOVE command

standby databases, 5.9.1

ReopenSecs property, 8.2.39

requests

passing between sites, 1.6.1

roles

changing, 2.4

management of, 4

managing

failover, 4.2

switchover, 4.1

managing during failover, 4

S

scripts

using Data Guard command-line interface, 7

selecting the apply instance, 3.5.8.1

SendQEntries property, 8.1.10

server parameter file

broker property management, 1.6.3, 1.7.5

filenames, 1.6.3

inconsistent values from Data Guard configuration file, 8.1.2

server-side software, 1.6

SET STATE command

and setting the apply instance, 3.5.8.1

setting

a dependent standby database, 3.4.4

configuration protection mode, 3.6.1

database properties, 6.3

log apply services, 3.4.3

log transport services, 3.4.5

SGA memory

and SQL apply service, 3.5.4

SHOW CONFIGURATION command, 6.2, 6.2, 6.4, 7.2

SHOW DATABASE command, 7.2

SHOW DATABASE VERBOSE command

displaying properties, 3.3

SHOW INSTANCE command, 7.2

showing

See each SHOW command

SHUTDOWN command, 7.2

shutting down an Oracle instance, 7.2

SidName property, 8.2.40

single command mode

for Data Guard command-line interface, 7.1.1

SQL apply

and logical standby databases, 3.5.4

SQL apply error handling

and logical standby databases, 3.5.6

SQL apply filters

and logical standby databases, 3.5.5

standby databases

apply instance, 3.2.1

changing the state of, 5.4.1

constructing from backups, 2.4, 6.1

creating, 1.5.1, 5.2, 5.2

Data Guard configuration, 2.1

health check, 3.7

managing connections, 3.4.6

removing, 5.9.1, 7.2

removing from a broker configuration, 3.6.2.5

setting log apply services, 3.4.3

switching over to the primary role, 7.2

StandbyArchiveLocation property, 8.2.41

setting log apply services, 3.4.3

StandbyFileManagement property, 8.2.42

starting

Data Guard command-line interface, 6.2, 7.1

Data Guard GUI, 5.1

Data Guard monitor (DMON), 2.3

failover, 4.2.2

switchover, 4.1.2

starting an Oracle instance, 7.2

STARTUP command, 7.2

state transitions

effect on database states, 3.2.1

logical standby database, 3.2.1

physical standby database, 3.2.1

primary database, 3.2.1

states, 2.5

any type of database

OFFLINE, 3.2

changing, 2.4, 6.6

database, 3.2

database transitions, 3.2.1

logical standby database

LOG-APPLY-OFF, 3.2

ONLINE, 3.2

of a standby database

changing in a broker configuration, 5.4.1

physical standby database

LOG-APPLY-OFF, 3.2

ONLINE, 3.2

READ-ONLY, 3.2

primary database

LOG-TRANSPORT-OFF, 3.2

ONLINE, 3.2

status

configuration, 2.6

health check on primary database, 3.7

health check on standby database, 3.7

health of the database, 3.7

intended state of a configuration, 2.6

using metrics, 5.8

StatusReport property, 3.7, 8.1.11

string values

Data Guard command-line interface, 7.1.3

supported broker configuration, 1.3

switchover, 4

benefits, 1.2

broker tasks, 4.1.3

effect on database startup, 7.2

introduction, 1.5.1

managing, 4.1

prerequisites, 4.1.1

scenario, 5.5

starting, 4.1.2

troubleshooting, 9.4

using the CLI, 6.7

using the SWITCHOVER command, 7.2

SWITCHOVER command, 6.7, 7.2

SYNC log transport mode, 3.4.1

SYSDBA privileges, 6.2

to connect to the database, 7.1.3

T

TopWaitEvents property, 8.1.12

transaction consistency level

controlling, 3.5.4

troubleshooting

Data Guard, 9

tuning

log transport services, 3.4.5

two-way communication channel, 1.6.1

U

understanding metrics, 5.8.1

updating configuration properties, 3.3

upgrading

Data Guard, 1.7.2, 1.7.3

Data Guard GUI, 1.7.2, 1.7.3

protection mode, 3.6.2.1

user interfaces

overview, 1.5

V

verifying

a broker configuration, 5.7.1

viewing

log file details, 5.7.2

viewing property information about databases, 3.3.1, 8.1

W

warning status, 2.6

wizards

Add Standby Database, 1.5.1, 5.2