19/19

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 FAR_SYNC command, 7.2

Add Standby Database wizard

creating a broker configuration, 3.5

definition, 1.4.1

introduction, 1.4.1

adding

standby database to the broker configuration, 6.2

ALTER SYSTEM statement

starting the broker, 6.1

altering

properties

database, 6.9.1.1

states

database, 6.9.1.3, 6.9.1.4

AlternateLocation property, 8.3.1

setting log apply services, 4.4.5

application continuity

support in Oracle Data Guard broker, 5.6.1.4

application integration, 1.2

apply instance, 4.5.5

failover, 4.5.5

PreferredApplyInstance property, 4.5.5.1

selecting, 4.5.5.1

ApplyInstanceTimeout property, 8.3.2

ApplyLagThreshold property, 8.3.3

ApplyParallel property, 8.3.4

architecture

Data Guard broker, 1.3

ARCHIVE_LAG_TARGET initialization parameter

setting in a broker configuration, 8.3.5

archived redo logs

destination and configuration parameters, 3.1

in a Data Guard configuration, 3.1

primary database setup, 2.2

ArchiveLagTarget property, 8.3.5

ASYNC redo transport service, 4.4.2

Automatic Storage Management (ASM)

creating a standby database that uses, 2.2

---

B

background processes

DMON, 1.5.1

banners

suppressing from DGMGRL command-line interface output, 7.1.1

before you perform a switchover, 5.3.1

before you use DGMGRL, 6.1

benefits

Data Guard broker, 1.2

high availability, 1.2

scalability, 1.2

with Oracle Real Application Clusters, 1.2

Binding property, 8.3.6

broker

components, 1.3

configuration, 1.1.1

Data Guard configuration file, 1.5.2

drc* log files, 9.1

installation, 2.2

introduction, 1.1.2

user interfaces, 1.4

broker configurations

benefits, 1.2

changing roles, 3.5

creating, 6.2, 6.2

Data Guard configuration file, 1.5.1

disabling databases, 3.6, 7.2

effects of removing metadata from, 7.2

enabling, 6.4, 7.2

enabling databases, 3.5, 3.6, 6.4, 7.2

enabling fast-start failover, 7.2

health, 1.5.1, 3.7

life cycle, 3.5

management, 1.4.1, 1.4.2, 1.5.2

monitoring, 6.14

Oracle Net Services configuration, 1.2, 1.4.1

properties, 4.3

protection modes, 7.2

setting protection mode, 4.6.1

status modes, 3.7

supported, 3.1

bystander standby databases, 5.3

reintegrating into configuration, 5.4.2.1

BystandersFollowRoleChange property, 8.1.1

---

C

CDBs

Data Guard broker support, 1.1.3

CFS

See cluster file system

changing

properties

databases in a broker configuration, 3.5, 4.3.2

roles

within the broker configuration, 3.5

states

databases in a broker configuration, 4.2.1

of databases in a broker configuration, 6.9

See also editing

cluster file system (CFS)

broker configuration files, 3.3.2.1

command prompts

suppressing from DGMGRL command-line interface output, 7.1.1

command-line interface

See Data Guard command-line interface (DGMGRL)

CommunicationTimeout property, 8.1.2

COMPATIBLE initialization parameter

requirements for setting, 2.2

complete failover, 5.4.1, 7.2

components

broker, 1.3

Data Guard configuration, 3.1

configurable properties, 4.3

AlternateLocation, 8.3.1

ApplyInstanceTimeout, 8.3.2

ApplyLagThreshold, 8.3.3

ApplyParallel, 8.3.4

ArchiveLagTarget, 8.3.5

Binding, 8.3.6

database, 4.3.2, 4.3.2, 8.3

DbFileNameConvert, 8.3.7

DelayMins, 8.3.8

DGConnectIdentifier, 8.3.9

FastStartFailoverTarget, 8.3.10

LogArchiveFormat, 8.3.11

LogArchiveMaxProcesses, 8.3.12

LogArchiveMinSucceedDest, 8.3.13

LogArchiveTrace, 8.3.14

LogFileNameConvert, 8.3.15

LogShipping, 8.3.16

LogXptMode, 8.3.17

LsbyMaxEventsRecorded, 8.3.18

LsbyMaxServers, 8.3.19

LsbyMaxSga, 8.3.20

LsbyPreserveCommitOrder, 8.3.21

LsbyRecordAppliedDdl, 8.3.22

LsbyRecordSkipDdl, 8.3.23

LsbyRecordSkipErrors, 8.3.24

managing redo transport services, 4.4

MaxConnections, 8.3.25

MaxFailure, 8.3.26

NetTimeout, 8.3.27

ObserverConnectIdentifier, 8.3.28

PreferredApplyInstance, 8.3.29

RedoCompression, 8.3.30

RedoRoutes, 8.3.31

ReopenSecs, 8.3.32

SidName, 8.3.33

StandbyArchiveLocation, 8.3.34

StandbyFileManagement, 8.3.35

StaticConnectIdentifier, 8.3.36

TransportDisconnectedThreshold, 8.3.37

TransportLagThreshold, 8.3.38

configuration files

fast-start failover configuration (fsfo.dat) file, 5.5.7.7

See Also Data Guard configuration file

configuration properties

BystandersFollowRoleChange, 8.1.1

CommunicationTimeout, 8.1.2

FastStartFailoverAutoReinstate, 8.1.5

FastStartFailoverLagLimit, 8.1.6

FastStartFailoverPmyShutdown, 8.1.7

FastStartFailoverThreshold, 8.1.8

ObserverOverride, 8.1.9

ObserverReconnect, 8.1.10

OperationTimeout, 8.1.11

PrimaryLostWriteAction, 8.1.12

Tracelevel, 8.1.13

CONNECT command, 6.2, 7.2

connecting

privileges required for Data Guard broker configurations, 7.1.3

starting the observer, 6.7

to the primary database, 6.2

controlling

available SGA memory, 4.5.3

CONVERT DATABASE command, 7.2

CREATE CONFIGURATION command, 6.2, 7.2

creating

a broker configuration, 6.2, 6.2, 6.2

with the Add Standby Database wizard, 3.5

a standby database, 3.5

---

D

Data Guard

troubleshooting, 9

Data Guard broker

See Also broker

Data Guard command-line interface

commands

ENABLE FAST_START FAILOVER, 7.2

SET STATE, 4.5.5.1

DG_BROKER_START initialization parameter, 2.2

enabling a database, 6.4

introduction, 1.4.2

Data Guard command-line interface (DGMGRL)

banners from output, 7.1.1

commands

ADD DATABASE, 7.2

ADD FAR_SYNC, 7.2

CONNECT, 7.2

CONVERT DATABASE, 7.2

CREATE CONFIGURATION, 7.2

DISABLE CONFIGURATION, 7.2

DISABLE DATABASE, 7.2

DISABLE FAR_SYNC, 7.2, 7.2

DISABLE FAST_START FAILOVER, 5.5.5, 7.2

DISABLE FAST_START FAILOVER CONDITION, 7.2

EDIT CONFIGURATION (property), 7.2

EDIT CONFIGURATION (protection mode), 7.2

EDIT CONFIGURATION (RENAME), 7.2, 7.2

EDIT CONFIGURATION RESET (Property), 7.2, 7.2

EDIT DATABASE (Property), 7.2, 7.2

EDIT DATABASE (rename), 7.2

EDIT DATABASE (state), 7.2

EDIT DATABASE RESET (Property), 7.2

EDIT FAR_SYNC, 7.2

EDIT FAR_SYNC RESET (Property), 7.2

EDIT INSTANCE (AUTO PFILE), 7.2

EDIT INSTANCE (property), 7.2, 7.2

EDIT INSTANCE RESET (Property), 7.2

ENABLE CONFIGURATION, 7.2

ENABLE DATABASE, 7.2

ENABLE FAR_SYNC, 7.2

ENABLE FAST_START FAILOVER, 7.2

ENABLE FAST_START FAILOVER CONDITION, 7.2

EXIT, 7.2

FAILOVER, 6.11

HELP, 7.2

QUIT, 7.2

REINSTATE DATABASE, 7.2

REMOVE CONFIGURATION, 7.2

REMOVE DATABASE, 7.2

REMOVE FAR_SYNC, 7.2

REMOVE INSTANCE, 7.2

SHOW CONFIGURATION, 7.2, 7.2

SHOW DATABASE, 7.2

SHOW FAR_SYNC, 7.2

SHOW FAST_START FAILOVER, 7.2

SHOW INSTANCE, 7.2

SHUTDOWN, 7.2

SQL, 7.2

START OBSERVER, 7.2

STARTUP, 7.2

STOP OBSERVER, 7.2

SWITCHOVER, 6.10, 7.2

VALIDATE DATABASE, 7.2

VALIDATE FAR_SYNC, 7.2

creating a configuration, 6.2

DG_BROKER_START initialization parameter, 7.1.3

enabling the configuration, 6.4

FSFO.DAT file creation, 7.2

monitoring broker configurations, 6.14

performing routine management tasks, 6.9

prerequisites, 6.1

setting critical database properties, 6.3

setting up standby redo log files, 4.6.1

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 an Oracle RAC database, 3.3.2

in a CFS area, 3.3.2.1

inconsistent values from server parameter file, 8.2.2

relationship to DMON process, 1.5.1

setting up, 3.3

Data Guard configurations

automated creation of, 1.2

background, 3.1

Data Guard monitor (DMON), 1.5

interaction with the Oracle database, 1.5.1

managing objects, 3.1, 3.5, 6.4

Oracle database background processes, 1.5.1

overview, 1.5.1

starting with the DG_BROKER_START parameter, 3.4

two-way network communication, 1.5.1

data protection modes

See protection modes

database resources

monitoring, 1.2

databases

changing the state of, 6.9

connecting to, 6.2

creating and adding to a broker configuration, 1.4.1

dependencies, 4.2

disabling management of, 7.2

during

fast-start failover, 5.5

manual failover, 5.4

switchover, 5.3

enabling, 6.4

health, 4.10

installation for broker management, 2.2

monitorable properties, 4.3.1

network setup, 1.5.1, 2.2

prerequisites for broker configurations, 2.2

properties, 1.4.1, 4.3.2, 8.3

property management, 1.5.3

reenabling after a role transition, 5.4.3

removing

from a broker configuration, 6.9.3

restarting

after fast-start failover, 5.5.9

shutting down

effect on fast-start failover, 5.5.2.1, 5.5.2.3

states, 4.2

dependencies, 4.2

transitions, 4.2.1

status, 4.10

DB_FILE_NAME_CONVERT initialization parameter

initialization parameters

setting DB_FILE_NAME_CONVERT in a broker configuration, 8.3.7

DBA_LOGSTDBY_EVENTS table

managing, 4.5.4

DbFileNameConvert property, 8.3.7

DBMS_DG package

using to direct fast-start failover, 5.5.3

delaying

application of redo data with DelayMins property, 4.5.1

DelayMins property, 8.3.8

destinations

archived redo log file parameters, 3.1

viewing the LogXptStatus property, 8.2.3

DG_BROKER_CONFIG_FILEn file, 3.3.2

in a CFS area, 3.3.2.1

DG_BROKER_START initialization parameter, 2.2, 6.1, 7.1.3

DGConnectIdentifier property, 8.3.9

DGMGRL

reinstating a database, 5.4.3.1

diagnostic information

sources, 9.1

DISABLE CONFIGURATION command, 7.2

example, 6.9.2.1

DISABLE DATABASE command, 7.2

example, 6.9.2.2

DISABLE FAR_SYNC command, 7.2, 7.2

DISABLE FAST_START FAILOVER command, 5.5.5, 7.2

DISABLE FAST_START FAILOVER CONDITION command, 7.2

disabling

broker configuration, 6.9.2, 7.2

broker management of standby database, 7.2

databases, 3.6, 6.9.2.1, 6.9.2.2

fast-start failover, 5.5.5, 7.2

on a standby database, 5.5.5

See also each DISABLE command

disaster protection

benefits, 1.2

displaying

configuration information, 7.2

help for DGMGRL commands, 7.2

properties, 4.3

distributed management framework, 1.1.2

DMON

See Data Guard monitor (DMON)

downgrading

Data Guard, A.3

Oracle Enterprise Manager, A.3

protection mode, 4.6.2.1

drc* log files

broker diagnostic information, 9.1

during reinstatement, 5.5.4.1

recording failed reinstatement, 5.5.8.3

---

E

EDIT CONFIGURATION (Property) command, 7.2

EDIT CONFIGURATION (protection mode) command, 7.2

EDIT CONFIGURATION (RENAME) command, 7.2, 7.2

EDIT CONFIGURATION RESET (Property) command, 7.2, 7.2

EDIT DATABASE (property) command

example, 6.9.1.1

EDIT DATABASE (Property) command, 7.2, 7.2

EDIT DATABASE (rename) command, 7.2

EDIT DATABASE RESET (Property) command, 7.2

EDIT DATABASE (state) command, 7.2

example, 6.9.1.3

EDIT FAR_SYNC command, 7.2

EDIT FAR_SYNC RESET (Property) command, 7.2

EDIT INSTANCE (AUTO PFILE) command, 7.2

EDIT INSTANCE (property) command, 7.2, 7.2

EDIT INSTANCE RESET (Property) command, 7.2

editing

configurable properties, 7.2

database instance, 7.2, 7.2, 7.2

database name, 7.2

database state, 7.2

protection modes, 7.2

effect of switchovers on, 5.3.3

e-mail

reporting events, 1.4.1

ENABLE CONFIGURATION command, 6.4, 7.2

ENABLE DATABASE command, 7.2

ENABLE FAR_SYNC command, 7.2

ENABLE FAST_START FAILOVER command, 7.2, 7.2

ENABLE FAST_START FAILOVER CONDITION command, 7.2

enabling

broker configuration, 3.5, 6.4, 6.4, 6.4

databases in a broker configuration, 3.6

fast-start failover, 5.5.1, 5.5.2

See also each ENABLE command

Enterprise Edition database

installation, 2.1, 2.1

Enterprise Manager

Fast-Start Failover wizard

disabling fast-start failover, 5.5.5

wizards

automate standby database creation, 1.1.2

error messages

ORA-16795, 5.4.3, 5.4.3

error status, 3.7

events

managing

in a logical standby database, 4.5.4

monitoring with Oracle Enterprise Manager, 1.1.2

Oracle Enterprise Manager, 1.2

reporting, 1.4.1

responding to, 1.2

EXIT command, 7.2

See also QUIT command

---

F

failover

failing over to a standby database, 7.2

Oracle Enterprise Manager, 1.4.1

FAILOVER command, 6.11, 7.2

failovers

and FastStartFailoverTarget property, 6.7

benefits, 1.2

broker tasks, 5.4.2.1

choosing a target standby database, 5.2

complete, 5.4.2.1

fast-start failover, 5.5.2.2

effect on data protection mode, 5.5.1

V$DATABASE, 5.5.4.1

immediate, 5.4.2.2

managing, 5

fast-start, 5.5

manual, 5.4

manual

complete option, 5.4.1

effect on data protection mode, 5.4.2

immediate option, 5.4.1

reenabling disabled databases after, 5.4.2.1

starting manually, 5.4.2

using DGMGRL, 6.11

failures

observer, 5.5.7.3

far sync instances

managing, 4.7

fast-start failover, 5.1

configuration information in the fsfo.dat file, 5.5.7.7

defined, 5.5

DGMGRL client as the observer, 1.4.2

directed from an application, 5.5.3

disabling, 5.5.5, 5.5.5

to perform manual failover, 5.5.5

enabling, 5.5.2, 7.2

instance failures, 5.5.2.1

monitoring by the observer, 5.5.2.1

observer monitoring, 5.5.2.1

observer overview, 5.5

performing manual failovers when enabled, 5.5.2.4

performing switchover when enabled, 5.5.2.4

querying V$DATABASE, 5.5.2.2

reinstating the former primary database, 5.5.8

requirements, 5.5.1

restarting databases after shut down, 5.5.9

setting the FastStartFailoverTarget property, 5.5.2, 5.5.2, 6.7

setting the FastStartFailoverThreshold property, 5.5.2

shutdown abort, 5.5.2.1, 5.5.2.3

to Oracle RAC database instances, 5.5.2.1

unobserved, 5.5.7.3

verifying the environment, 5.5.2

viewing failover configuration statistics, 5.5.4.1

FastStartFailoverAutoReinstate property, 8.1.5

FastStartFailoverLagLimit property, 8.1.6

FastStartFailoverPmyShutdown property, 8.1.7

FastStartFailoverTarget property, 8.3.10

setting, 5.5.2, 5.5.2, 6.7

FastStartFailoverThreshold property, 8.1.8

setting, 5.5.2

FASTSYNC redo transport mode, 8.3.17

FASTSYNC redo transport service, 4.4.2

files

naming the server parameter file, 1.5.3

Flashback Database

reinstating databases, 5.4.3.1

use after failover, 5.4.2.1

flashback logs

reinstating a failed primary database, 5.4.3.1

FORCE option

disabling fast-start failover, 5.5.5, 7.2

performing a manual failover, 5.5.5

FS_FAILOVER_OBSERVER_HOST column

of V$DATABASE view, 5.5.7.2

FS_FAILOVER_OBSERVER_PRESENT column

of V$DATABASE view, 5.5.7.2

FS_FAILOVER_STATUS column

of V$DATABASE view

failed reinstatement, 5.5.4.1

FSFO.DAT file

overview, 5.5.7.7

START OBSERVER command, 7.2

---

H

health check, 1.2

monitoring, 1.5.1, 1.5.1

on primary database, 4.10

on standby database, 4.10

revealed by configuration status, 3.7

HELP command, 7.2

high availability

benefits, 1.2

levels of data protection, 4.6, 8.3.17

LogXptMode property, 8.3.17

restoring after fast-start failover, 5.5.8

---

I

immediate failover, 5.4.1, 7.2

InconsistenLogXptProps property, 8.2.1

InconsistentProperties property, 8.2.2

increased scalability

benefits, 1.2

initialization parameters

COMPATIBLE, 2.2

database configurable properties, 4.3.2

DG_BROKER_CONFIG_FILEn, 3.3.2

DG_BROKER_START, 2.2, 6.1

dynamic, 4.3.2

inconsistent, 8.2.2

LOG_ARCHIVE_DEST_n, 4.4.6

static, 4.3.2

See also server parameter file,

installation

ARCHIVELOG mode setup, 2.2

Data Guard, 2.1

Oracle Enterprise Manager, 2.1

Oracle Instant Client, 2.1, 7.2

prerequisites, 2.2

instances

failures, 5.5.2.1

removing, 7.2, 7.2

shutting down, 7.2

starting, 7.2

intended state

configuration health check, 3.7

invoking

the Data Guard command-line interface, 6.2

---

L

life cycle of a broker configuration, 3.5

log apply services

and apply instance failover, 4.5.5

and parallel apply, 4.5.2

apply instance, 4.5.5

configuring, 1.4.1

Data Guard configuration, 3.1

delayed application of redo data, 4.5.1

delaying, 8.3.8

in an Oracle RAC database, 4.5.5

managing, 4.5

selecting the apply instance, 4.5.5.1

verifying, 1.2

log files

broker, 5.5.8.3

FSFO.DAT

creating, 7.2

LOG_ARCHIVE_DEST_n initialization parameter

setting redo transport services, 4.4.6

setting the DELAY attribute, 8.3.8

setting the ENABLE and DEFER attributes, 8.3.16

setting the MANDATORY or OPTIONAL attributes, 8.3.6

LOG_ARCHIVE_FORMAT initialization parameter, 8.3.11

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 8.3.12

LOG_ARCHIVE_MIN_SUCCEED initialization parameter, 8.3.13

LOG_ARCHIVE_TRACE initialization parameter

setting LogArchiveTrace property, 8.3.14

LOG_FILE_NAME_CONVERT initialization parameter

setting LogFileNameConvert property, 8.3.15

LogArchiveFormat property, 8.3.11

LogArchiveMaxProcesses property, 8.3.12

LogArchiveMinSucceedDest property, 8.3.13

LogArchiveTrace property, 8.3.14

LogFileNameConvert property, 8.3.15

logical standby databases

managing events, 4.5.4

SQL Apply, 4.5.3

state transitions, 4.2.1

switchover to the primary role, 5.3

LogShipping property, 8.3.16

LogXptMode property, 8.3.17

LogXptStatus property, 8.2.3

LsbyFailedTxnInfo property, 8.2.4

LsbyMaxEventsRecorded property, 8.3.18

LsbyMaxServers property, 8.3.19

LsbyMaxSga property, 8.3.20

LsbyParameters property, 8.2.5

LsbyPreserveCommitOrder property, 8.3.21

LsbyRecordAppliedDdl property, 8.3.22

LsbyRecordSkipDdl property, 8.3.23

LsbyRecordSkipErrors property, 8.3.24

---

M

management

benefits, 1.2

Oracle Enterprise Manager, 1.4.1

managing

a broker configuration, 3, 6

databases, 4

DBA_LOGSTDBY_EVENTS table, 4.5.4

events

in a logical standby database, 4.5.4

fast-start failover, 5.5

local operations, 1.1.2

log apply services, 4.5

manual failover, 5.4

parallel apply in a physical standby database, 4.5.2

remote operations, 1.1.2

roles, 5

fast-start failover, 5.5

manual failover, 5.4

switchover, 5.3

switchover, 5.3

MANDATORY attribute

set with the Binding property, 8.3.6

manual failover, 1.2, 5.1

complete option, 5.4.1

effect on protection modes, 4.6.2.3

immediate option, 5.4.1

performing when fast-start failover is enabled, 5.5.2.4, 5.5.5

starting, 5.4.2

manual role changes

performing when fast-start failover is enabled, 5.5.2.4

MaxConnections property, 8.3.25

MaxFailure property, 8.3.26

maximize availability, 1.2, 3.5, 8.3.17

maximize data protection, 1.2, 3.5, 8.3.17

maximize performance, 1.2, 3.5, 8.3.17

maximum availability

data protection mode, 4.6.1

maximum performance

data protection mode, 4.6.1

maximum protection

data protection mode, 4.6.1

monitorable properties, 4.3, 4.3.1, 8.2

InconsistentLogXptProps, 8.2.1

InconsistentProperties, 8.2.2

LogXptStatus, 8.2.3, 8.2.3

LsbyFailedTxnInfo, 8.2.4, 8.2.4

LsbyParameters, 8.2.5

RecvQEntries, 8.2.6

SendQEntries, 8.2.7

TopWaitEvents, 8.2.8

monitoring

broker configurations, 1.5.1, 6, 6.14

local and remote databases, 1.2

observer

fast-start failover environment, 5.5.2.1

Oracle Enterprise Manager performance page, 3.5

through the command-line interface, 1.4.2

multitenant container databases

See CDBs

---

N

NetTimeout property, 8.3.27

networks

Data Guard configuration, 3.1

setting up files, 2.2

two-way communication, 1.5.1

normal status, 3.7

---

O

objects

broker configuration, 3.1

disabling, 6.9.2

properties for databases, 1.5.3

observer, 5.5

and FastStartFailoverThreshold property, 5.5.2

connecting to the configuration, 6.7

connection to the local computer, 5.5.7.2

detecting

database shutdown, 5.5.2.1, 5.5.2.3

instance failures, 5.5.2.1

failures, 5.5.7.3

finding host machine name, 5.5.7.2

installing Oracle Instant Client kit, 2.1, 7.2

lost connection, 5.5.7.3

maintaining fast-start failover configuration information, 5.5.7.7

monitoring, 5.5.2.1, 5.5.2.1

shutting down, 5.5.9

using Oracle Wallet for connection credentials, 7.2

ObserverConnectIdentifier property, 8.3.28

ObserverOverride property, 8.1.9

ObserverReconnect property, 8.1.10

operations

complete failover, 7.2

disable broker management

effect on protection modes, 4.6.2.4

downgrade

effect on protection modes, 4.6.2.1

effect on protection modes, 4.6.2

enable broker management

effect on protection modes, 4.6.2.4

failover, 6.11

immediate failover, 7.2

manual failover

effect on protection modes, 4.6.2.3

removing a database from the configuration

effect on protection modes, 4.6.2.5

OperationTimeout property, 8.1.11

OPTIONAL attribute

set with the Binding property, 8.3.6

ORA-16661 message

reinstating a database, 5.4.3, 5.4.3, 5.4.3.1

ORA-16795 message

re-creating a database, 5.4.3

Oracle Clusterware, 1.2

and instances of an Oracle RAC database, 1.2

integration with Data Guard broker, 1.2

recover failed instances, 1.2

Oracle Enterprise Manager, 1.4.1

Add Standby Database wizard, 1.4.1

database property pages, 1.4.1

downgrading, A.3

event management system, 1.2

integration, 1.4.1

integration with the Data Guard monitor, 1.4.1

introduction, 1.1.2, 1.3

making Oracle Net Services configuration changes, 1.2, 1.4.1

monitoring events, 1.1.2

performance tools and graphs, 1.4.1

setting up standby redo log files, 4.6.1

upgrading, A.1

wizards

creating standby databases, 1.4.1

Oracle Instant Client

installing, 2.1, 7.2

Oracle Managed Files (OMF)

creating a standby database that uses, 2.2

Oracle Net Services

configuration changes, 1.2, 1.4.1

installation prerequisites, 2.2

supported configuration, 3.1

two-way communication, 1.5.1

Oracle RAC One Node

supported by Oracle Data Guard broker, 1.1

Oracle Real Application Clusters

and log apply services, 4.5.5

and setting the apply instance, 4.5.5.1

availability of instances with Oracle Clusterware, 1.2

benefits, 1.2

fast-start failover, 5.5.2.1

observer behavior in, 5.5.2.1

observer connection to instances, 5.5.7.2

Oracle Clusterware, 1.2

Oracle Universal Installer

installing Oracle Instant Client, 2.1, 7.2

Oracle Wallet

starting the observer, 7.2

---

P

parallel apply

and log apply services, 4.5.2

managing in a physical standby database, 4.5.2

performance

Oracle Enterprise Manager tools, 1.4.1

physical standby databases

managing parallel apply, 4.5.2

state transitions, 4.2.1

switchover to the primary role, 5.3

PreferredApplyInstance property, 8.3.29

prerequisites

installation, 2.2

switchover, 5.3.1

primary database

ARCHIVELOG mode, 2.2

connecting to, 6.2, 6.2

constructing a standby database, 3.5, 6.1

Data Guard configuration, 3.1

during failover, 1.4.1

during switchover, 5.3.3

Flashback Database, 5.4.3.1

health check, 4.10

preparing for switchover, 5.3.1

reinstating after a fast-start failover, 5.5.8

standby redo log files on, 4.6.1

state transitions, 4.2.1

switching over to the standby role, 7.2

PrimaryLostWriteAction property, 8.1.12

processes

DMON, 1.5.1

Oracle database, 1.5.1

properties, 4.3.2

configurable, 4.3

database, 4.3

managing, 1.5.3

monitorable, 4.3

setting, 3.5, 6.3

in server parameter file, 1.5.3, 2.2

property pages

database, 1.4.1

protection modes

after a failover, 4.6.2.3, 5.4.2, 5.5.1

benefits, 1.2

configuration, 7.2, 7.2, 7.2

downgrading, 4.6.2.1

redo transport services setup, 8.3.17

setting for a broker configuration, 4.6

updating, 3.5

upgrading, 4.6.2.1

---

Q

QUIT command, 7.2

See also EXIT command

---

R

RecvQEntries property, 8.2.6

Redo Apply, 3.1, 5.3.3

redo transport services

ASYNC mode, 4.4.2, 8.3.17

configuring, 1.4.1

data protection modes, 8.3.17

Data Guard configuration, 3.1

FASTSYNC mode, 4.4.2, 8.3.17

managing, 4.4

SYNC mode, 4.4.2, 8.3.17, 8.3.17

tuning, 4.4.6

turning off, 4.4.4

turning on, 4.4.4

verifying, 1.2

RedoCompression property, 8.3.30

RedoRoutes property, 8.3.31

REINSTATE DATABASE command, 7.2

reinstatement, 5.5.8

failure logged in broker drc* log files, 5.5.4.1

Flashback Database requirement, 5.4.3.1

flashback logs requirement, 5.4.3.1

how to, 5.4.3.1

logged in broker log files, 5.5.8.3

ORA-16661 message, 5.4.3, 5.4.3, 5.4.3.1

requires standby redo log files, 4.6.1

using DGMGRL, 5.4.3.1

using Enterprise Manager, 5.4.3.1

REMOVE CONFIGURATION command, 7.2

example, 6.9.3

REMOVE DATABASE command, 7.2

REMOVE FAR_SYNC command, 7.2

REMOVE INSTANCE command, 7.2

removing

a standby database, 4.6.2.5

See each REMOVE command

ReopenSecs property, 8.3.32

requests

passing between sites, 1.5.1

requirements

for enabling fast-start failover, 5.5.1

restarting

databases

when fast-start failover is enabled, 5.5.9

role transitions

changing, 3.5

managing, 5

fast-start failover, 5.5

manual failover, 5.4

switchover, 5.3

---

S

scripts

using Data Guard command-line interface (DGMGRL), 7

selecting the apply instance, 4.5.5.1

SendQEntries property, 8.2.7

server parameter file

broker property management, 1.5.3, 2.2

filenames, 1.5.3

inconsistent values from Data Guard configuration file, 8.2.2

server-side software, 1.5

SET STATE command

and setting the apply instance, 4.5.5.1

setting

configuration protection mode, 4.6.1

database properties, 6.3

log apply services, 4.4.5

redo transport services, 4.4.6

SGA memory

and SQL Apply, 4.5.3

SHOW CONFIGURATION command, 6.2, 6.2, 6.4, 7.2, 7.2

SHOW CONFIGURATION VERBOSE

example, 5.5.4

SHOW DATABASE command, 7.2

SHOW DATABASE VERBOSE command

displaying properties, 4.3

SHOW FAR_SYNC command, 7.2

SHOW FAST_START FAILOVER command, 7.2

SHOW FAST-START FAILOVER command

example, 5.5.4

SHOW INSTANCE command, 7.2

showing

See each SHOW command

shutdown

FS_FAILOVER_OBSERVER_PRESENT view, 5.5.9

shutdown abort, 5.5.2.1

effect on fast-start failover, 5.5.2.3

SHUTDOWN command, 7.2

shutting down an Oracle instance, 7.2

SidName property, 8.3.33

single command mode

for Data Guard command-line interface, 7.1.1

SQL Apply, 3.1

and logical standby databases, 4.5.3

effect of switchovers on, 5.3.3

SQL command, 7.2

SQL statements

executing from DGMGRL command line, 7.2

standby databases

choosing a target standby database, 5.2

constructing from backups, 3.5, 6.1

creating, 1.4.1

if primary database uses ASM or OMF, 2.2

health check, 4.10

not involved in a switchover, 5.3.3

reenabling after failover, 5.4.2.1

removing, 4.6.2.5

require standby redo log files, 4.6.1

specifying the location of archived redo logs, 4.4.5

switching over to the primary role, 7.2

standby redo log files

setting up, 4.6.1

setting up with DGMGRL, 4.6.1

StandbyArchiveLocation property, 8.3.34

setting log apply services, 4.4.5

StandbyFileManagement property, 8.3.35

START OBSERVER command

fast-start failover configuration file (fsfo.dat), 5.5.7.7

starting

Data Guard command-line interface (DGMGRL), 6.2, 7.1

Data Guard monitor (DMON), 3.4

manual failover, 5.4.2

Oracle instance, 7.2

switchover, 5.3.2

STARTUP command, 7.2

state transitions

effect on database states, 4.2.1

logical standby database, 4.2.1

physical standby database, 4.2.1

primary database, 4.2.1

states, 3.6

changing, 6.9

database, 4.2

database transitions, 4.2.1

logical standby database

APPLY-OFF, 4.2

APPLY-ON, 4.2

physical standby database

APPLY-OFF, 4.2

APPLY-ON, 4.2

primary database

TRANSPORT-OFF, 4.2

TRANSPORT-ON, 4.2

StaticConnectIdentifier property, 8.3.36

status

configuration, 3.7

health check on primary database, 4.10

health check on standby database, 4.10

health of the database, 4.10

intended state of a configuration, 3.7

status messages

ORA-16661, 5.4.3, 5.4.3

ORA-16795, 5.4.3

STOP OBSERVER command, 7.2, 7.2

string values

Data Guard command-line interface, 7.1.3

SWITCHOVER command, 6.10, 7.2

switchovers

benefits, 1.2

broker tasks, 5.3.3

choosing a target standby database, 5.2

DGMGRL SWITCHOVER command, 6.10

effect on

database startup, 7.2

primary database, 5.3.3

protection modes, 4.6.2.2

standby databases not involved in the switchover, 5.3.3

managing, 5, 5.3

overview, 5.1

Oracle Enterprise Manager, 1.4.1

performing when fast-start failover is enabled, 5.5.2.4

preparing the primary database, 5.3.1

prerequisites, 5.3.1

reenabling disabled standby databases, 5.4.3

starting, 5.3.2

transitioning

a logical standby database to the primary role, 5.3

a physical standby database to the primary role, 5.3

using the DGMGRL SWITCHOVER command, 7.2

SYNC redo transport mode, 4.4.2

SYSDBA privileges

to connect to the database, 7.1.3

SYSDG privileges, 6.2

---

T

target standby database

choosing, 5.2

disabling fast-start failover on, 5.5.5

setting with the FastStartFailoverTarget property, 5.5.2, 6.7

TopWaitEvents property, 8.2.8

TraceLevel property, 8.1.13

transaction commit order

controlling, 4.5.3

TransportDisconnectedThreshold property, 8.3.37

TransportLagThreshold property, 8.3.38

TRANSPORT-ON state

setting LogShipping property, 8.3.16

troubleshooting

Data Guard, 9

diagnostics logged in broker drc* log files, 9.1

tuning

redo transport services, 4.4.6

two-way communication channel, 1.5.1

---

U

unobserved configuration, 5.5.7.3

updating configuration properties, 4.3

upgrading

Data Guard, A.1, A.2

Oracle Enterprise Manager, A.1

protection mode, 4.6.2.1

user interfaces

overview, 1.4

---

V

V$DATABASE view

fast-start failover columns, 5.5.2.2, 5.5.4.1

FS_FAILOVER_OBSERVER_HOST column, 5.5.7.2

FS_FAILOVER_OBSERVER_PRESENT column, 5.5.7.2

when shutting down databases, 5.5.9

verifying

fast-start failover environment, 5.5.2

viewing

fast-start failover statistics, 5.5.4.1

V$FS_FAILOVER_STATS view, 5.5.4.2

VALIDATE DATABASE command, 7.2

VALIDATE FAR_SYNC command, 7.2

verifying

fast-start failover environment, 5.5.2

viewing

property information about databases, 4.3.1, 8.2

---

W

warning status, 3.7

wizards

Add Standby Database, 1.4.1