Index

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

A

ADD DATABASE command, 8.2

Add Standby Database wizard

creating a broker configuration, 3.4, 6.2

creating a standby database, 6.2

definition, 1.5.1

introduction, 1.5.1

adding

an existing RAC standby database, 6.3

standby database to the broker configuration, 7.2

ALTER SYSTEM statement

starting the broker, 7.1

altering

properties

database, 7.7.1.1

states

database, 7.7.1.2, 7.7.1.3

AlternateLocation property, 9.2.1

setting log apply services, 4.4.3

application integration, 1.2

apply errors

managing, 4.5.5

apply instance, 4.5.7

failover, 4.5.7

of standby database, 4.2.1

PreferredApplyInstance property, 4.5.7.1

selecting, 4.5.7.1

ApplyInstanceTimeout property, 4.5.7.2, 9.2.2

ApplyParallel property, 4.5.2, 9.2.3

ARCH redo transport service, 4.4.1

architecture

Data Guard broker, 1.4

ARCHIVE_LAG_TARGET initialization parameter

setting in a broker configuration, 9.2.4

archived redo logs

destination and configuration parameters, 3.1

in a Data Guard configuration, 3.1

primary database setup, 2.2

ArchiveLagTarget property, 9.2.4

ASYNC redo transport service, 4.4.1

Automatic Storage Management (ASM)

creating a standby database that uses, 2.2

B

background processes

DMON, 1.6.1

banners

suppressing from DGMGRL command-line interface output, 8.1.1

before you perform a switchover, 5.3.1

before you use DGMGRL, 7.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, 9.2.5

broker

components, 1.4

configuration, 1.1.1

Data Guard configuration file, 1.6.2

drc* log files, 10.1

installation, 2.2

introduction, 1.1.2

managing databases, 4.1

user interfaces, 1.5

broker configurations, 4.6.2.5

add an existing RAC standby database, 6.3

benefits, 1.2

changing roles, 3.4

components, 3.1

creating, 6.2, 7.2, 7.2, 8.2

Data Guard configuration file, 1.6.1

database objects, 1.3

database profiles, 1.3

disabling databases, 3.5, 8.2

effects of removing metadata from, 8.2

enabling, 7.4, 8.2

enabling databases, 3.4, 3.5, 7.4, 8.2

enabling fast-start failover, 8.2

health, 1.6.1, 3.6

instance objects, 1.3

life cycle, 3.4

management, 1.3, 1.5.1, 1.5.2, 1.6.2

monitoring, 6.8, 7.10

objects, 1.3

Oracle Net Services configuration, 1.2, 1.5.1

overview, 3.1

properties, 4.3

protection modes, 8.2

removing, 6.10.2

setting protection mode, 4.6.1

status modes, 3.6

supported, 1.3, 3.1, 3.1

using SHOW CONFIGURATION to verify fast-start failover, 7.6

verifying, 6.8.1

C

CFS

See cluster file system

changed features, A

changing

properties

databases in a broker configuration, 3.4, 4.3.2

of a database in a broker configuration, 6.5.2

protection mode

of a database in a broker configuration, 6.5.3

roles

within the broker configuration, 3.4

states

databases in a broker configuration, 3.4, 4.2.1

of a standby database in a broker configuration, 6.5.1

of databases in a broker configuration, 7.7

D

Data Guard

troubleshooting, 10

Data Guard broker

changed features, A

deprecated features, A

integration with Oracle Enterprise Manager, 6.1

E

EDIT CONFIGURATION (Property) command, 8.2

EDIT CONFIGURATION (protection mode) command, 8.2

EDIT DATABASE (property) command, 8.2

example, 7.7.1.1

EDIT DATABASE (rename) command, 8.2

EDIT DATABASE (state) command, 8.2

example, 7.7.1.2

EDIT INSTANCE (AUTO PFILE) command, 8.2

EDIT INSTANCE (property) command, 8.2

editing

configurable properties, 8.2

database instance, 8.2, 8.2

database name, 8.2

database properties, 8.2

database state, 8.2

protection modes, 8.2

effect of switchovers on, 5.3.3

e-mail

reporting events, 1.5.1

ENABLE CONFIGURATION command, 7.4, 8.2

ENABLE DATABASE command, 8.2

ENABLE FAST_START FAILOVER command, 8.2

enabling

broker configuration, 3.4, 7.4, 7.4, 7.4

databases in a broker configuration, 3.5

fast-start failover, 5.5.1, 5.5.2, 6.4

F

failover

database restarts and, 8.2

failing over to a standby database, 8.2

Oracle Enterprise Manager, 1.5.1

FAILOVER command, 7.9, 8.2

manual failover, 5.4.2

failovers

and FastStartFailoverTarget property, 7.6

benefits, 1.2

broker tasks, 5.4.2.1

choosing a target standby database, 5.2

complete, 5.4.2, 5.4.2.1

defined, 5.1

fast-start failover, 5.5.2.2

effect on data protection mode, 5.5.1

V$DATABASE, 5.5.3

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, 5.4.3

scenario

fast-start failover, 6.4

manual failover, 6.7

starting manually, 5.4.2

to a RAC database, 5.4.2

troubleshooting, 10.4

using DGMGRL, 7.9

failures

observer, 5.5.6.3

primary database, 5.1

fast-start failover, 5.1

broken network connections, 5.5.2.1

conditions resulting in, 5.5.2.1

configuration information in the fsfo.dat file, 5.5.6.6

defined, 5.5

DGMGRL client as the observer, 1.5.2

disabling, 5.5.4, 5.5.4

to perform manual failover, 5.5.4

enabling, 5.5.2, 6.4, 8.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

offline data files, 5.5.2.1

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.7

requirements, 5.5.1

restarting databases after shut down, 5.5.8

setting the FastStartFailoverTarget property, 5.5.2, 5.5.2, 5.5.2, 7.6

setting the FastStartFailoverThreshold property, 5.5.2, 6.4

shutdown abort, 5.5.2.1, 5.5.2.3

shutting down databases, 5.5.8

starting the observer, 5.5.2

to RAC database instances, 5.5.2.1

unobserved, 5.5.6.3

using SHOW CONFIGURATION to verify, 7.6

using SHOW CONFIGURATION VERBOSE, 5.5.3

verifying the environment, 5.5.2

viewing failover configuration statistics, 5.5.3

FastStartFailoverTarget property, 9.2.9

setting, 5.5.2, 5.5.2, 5.5.2, 7.6

FastStartFailoverThreshold property, 9.2.10

conditions causing fast-start failover, 5.5.2.1

configurable property, 8.2

setting, 5.5.2, 6.4

files

naming the server parameter file, 1.6.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.4, 8.2

performing a manual failover, 5.5.4

FS_FAILOVER_OBSERVER_HOST column

of V$DATABASE view, 5.5.6.2

FS_FAILOVER_OBSERVER_PRESENT column

of V$DATABASE view, 5.5.6.2

FS_FAILOVER_STATUS column

of V$DATABASE view

failed reinstatement, 5.5.3

FSFO.DAT file

overview, 5.5.6.6

START OBSERVER command, 8.2

G

global service names

registering, 2.2

GLOBAL_DBNAME attribute

setting, 2.2

H

health check, 1.2

monitoring, 1.6.1, 1.6.1

on primary database, 4.7

on standby database, 4.7

revealed by configuration status, 3.6

StatusReport property, 4.7

HELP command, 8.2

high availability

benefits, 1.2

levels of data protection, 4.6, 9.2.20

LogXptMode property, 9.2.20

restoring after fast-start failover, 5.5.7

HostName property, 9.2.11

I

immediate failover, 5.4.1, 8.2

InconsistentProperties property, 9.1.2

increased scalability

benefits, 1.2

InitialConnectIdentifier property, 9.2.12

initialization parameters

COMPATIBLE, 2.2

database configurable properties, 4.3.2

DB_UNIQUE_NAME, 4.4.6

DG_BROKER_CONFIG_FILEn, 3.2.2

DG_BROKER_START, 2.2, 7.1

dynamic, 4.3.2

inconsistent, 9.1.2

INSTANCE_NAME, 4.4.6

LOCAL_LISTENER, 2.2, 4.4.6, 4.4.6

LOG_ARCHIVE_DEST_n, 4.4.5

static, 4.3.2

L

life cycle of a broker configuration, 3.4

listener

address, 4.4.6

LISTENER.ORA file

registering global service names, 2.2

local listener

for RAC databases, 2.2

statically registering services with, 2.2

LOCAL_LISTENER initialization parameter, 2.2, 4.4.6, 4.4.6, 4.4.6, 9.2.13

for standby instances, 4.4.6

LocalListenerAddress property, 9.2.13

log apply services

and apply instance failover, 4.5.7, 4.5.7.2

and parallel apply, 4.5.2

apply instance, 4.5.7

configuring, 1.2, 1.5.1

Data Guard configuration, 3.1

delayed application of redo data, 4.5.1

delaying, 9.2.7

in a RAC database, 4.5.7

managing, 4.5

selecting the apply instance, 4.5.7.1

verifying, 1.2

log files

broker, 5.5.7.3

FSFO.DAT

creating, 8.2

viewing, 6.8.2

LOG_ARCHIVE_DEST_n initialization parameter

SERVICE attribute, 4.4.6

setting redo transport services, 4.4.5

setting the DELAY attribute, 9.2.7

setting the DEPENDENCY attribute, 9.2.8

setting the ENABLE and DEFER attributes, 9.2.19

setting the MANDATORY or OPTIONAL attributes, 9.2.5

LOG_ARCHIVE_FORMAT initialization parameter, 9.2.14

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 9.2.15

LOG_ARCHIVE_MIN_SUCCEED initialization parameter, 9.2.16

LOG_ARCHIVE_TRACE initialization parameter

setting LogArchiveTrace property, 9.2.17

LOG_FILE_NAME_CONVERT initialization parameter

setting LogFileNameConvert property, 9.2.18

LogArchiveFormat property, 9.2.14

LogArchiveMaxProcesses property, 9.2.15

LogArchiveMinSucceedDest property, 9.2.16

LogArchiveTrace property, 9.2.17

LogFileNameConvert property, 9.2.18

logical standby databases

and SQL Apply error handling, 4.5.5

and SQL Apply filters, 4.5.4

during switchovers, 5.3.3

managing events, 4.5.6

SQL Apply, 4.5.3

state transitions, 4.2.1

switchover to the primary role, 5.3

LogShipping property, 9.2.19

LOG-TRANSPORT-OFF state

LogShipping property setting, 9.2.19

LogXptMode property, 9.2.20

LogXptStatus property, 9.1.3

LsbyASkipCfgPr property, 9.2.21

LsbyASkipErrorCfgPr property, 4.5.5, 9.2.22

LsbyASkipTxnCfgPr property, 9.2.23

LsbyDSkipCfgPr property, 9.2.24

LsbyDSkipErrorCfgPr property, 4.5.5, 9.2.25

LsbyDSkipTxnCfgPr property, 9.2.26

LsbyFailedTxnInfo property, 9.1.4

LsbyMaxEventsRecorded property, 9.2.27

LsbyMaxServers property, 9.2.29

LsbyMaxSga property, 4.5.3, 9.2.28

LsbyParameters property, 9.1.5

LsbyRecordAppliedDdl property, 9.2.30

LsbyRecordSkipDdl property, 9.2.31

LsbyRecordSkipErrors property, 9.2.32

LsbySkipTable property, 9.1.6

LsbySkipTxnTable property, 9.1.7

LsbyTxnConsistency property, 4.5.3, 9.2.33

M

management

benefits, 1.2

model, 1.3

Oracle Enterprise Manager, 1.5.1

managing

a broker configuration, 3, 7

apply errors, 4.5.5

Data Guard metrics, 6.9.2

databases, 4

DBA_LOGSTDBY_EVENTS table, 4.5.6

events

in a logical standby database, 4.5.6

fast-start failover, 5.5

local operations, 1.1.2

log apply services, 4.5

manual failover, 5.4

objects in a broker configuration, 1.3

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

MANDATORY attribute

set with the Binding property, 9.2.5

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.4

starting, 5.4.2

to a RAC database, 5.4.2

manual role changes

performing when fast-start failover is enabled, 5.5.2.4

MaxConnections property, 9.2.34

MaxFailure property, 9.2.35

maximize availability, 1.2, 3.4, 9.2.20

maximize data protection, 1.2, 3.4, 9.2.20

maximize performance, 1.2, 3.4, 9.2.20

maximum availability

data protection mode, 4.6.1

maximum performance

data protection mode, 4.6.1

maximum protection

data protection mode, 4.6.1

metrics

Data Guard Fast-Start Failover, 6.9.1.1

Data Guard Performance, 6.9.1.2

Data Guard Status, 6.9.1.3

managing, 6.9.2

using, 6.9

monitorable properties, 4.3

database, 4.3.1

InconsistentProperties, 9.1.2

LogXptStatus, 9.1.3, 9.1.3

LsbyFailedTxnInfo, 9.1.4, 9.1.4

LsbyParameters, 9.1.5

LsbySkipTable, 9.1.6

LsbySkipTxnTable, 9.1.7

RecvQEntries, 9.1.8

SendQEntries, 9.1.9

StatusReport, 9.1.10

monitoring

broker configurations, 1.6.1, 6.8, 7, 7.10

configuration performance, 6.8.3

local and remote databases, 1.2

observer

fast-start failover environment, 5.5.2.1

Oracle Enterprise Manager performance page, 3.4

through the command-line interface, 1.5.2

N

NetTimeout property, 9.2.36

networks

broken connections, 5.5.2.1

Data Guard configuration, 3.1

setting up files, 2.2

two-way communication, 1.6.1

normal status, 3.6

O

objects

broker configuration, 1.3, 3.1

disabling, 7.7.2

properties for databases, 1.6.3

relationship, 1.3

observer, 5.5

and FastStartFailoverThreshold property, 5.5.2, 6.4

connecting to the configuration, 7.6

connection to the local computer, 5.5.6.2

detecting

broken network connections, 5.5.2.1

database shutdown, 5.5.2.1, 5.5.2.3

instance failures, 5.5.2.1

offline data files, 5.5.2.1

failures, 5.5.6.3

finding host machine name, 5.5.6.2

installing Oracle Instant Client kit, 2.1, 8.2

lost connection, 5.5.6.3

maintaining fast-start failover configuration information, 5.5.6.6

monitoring, 5.5.2.1, 5.5.2.1

shutting down, 5.5.8

starting, 5.5.2

using Oracle Wallet for connection credentials, 7.6, 8.2, 8.2

offline data files

broken, 5.5.2.1

ONLINE state

setting LogShipping property, 9.2.19

operations

complete failover, 8.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, 7.9

troubleshooting, 10.4

fast-start failover scenario, 6.4

immediate failover, 8.2

manual failover

effect on protection modes, 4.6.2.3

manual failover scenario, 6.7

removing a database from the configuration

effect on protection modes, 4.6.2.5

upgrade

effect on protection modes, 4.6.2.1

OPTIONAL attribute

set with the Binding property, 9.2.5

ORA-16649 message, 5.5.2.2

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 Cluster Repository (OCR)

setting START_OPTIONS, 2.2

Oracle Clusterware

and instances of a RAC database, 1.2

integration with Data Guard broker, 1.2

recover failed instances, 1.2

Oracle Enterprise Manager, 1.5.1

Add Standby Database wizard, 1.5.1

database property pages, 1.5.1

downgrading, B.4

event management system, 1.2

integration, 1.5.1

integration with the Data Guard monitor, 1.5.1

introduction, 1.1.2, 1.4

making Oracle Net Services configuration changes, 1.2, 1.5.1

monitoring events, 1.1.2

Overview page, 1.5.1

performance tools and graphs, 1.5.1

setting up standby redo log files, 4.6.1

upgrading, B.1, B.2

wizards

creating standby databases, 1.5.1

Oracle Instant Client

installing, 2.1, 8.2

Oracle Managed Files (OMF)

creating a standby database that uses, 2.2

Oracle Net Services

configuration changes, 1.2, 1.5.1

installation prerequisites, 2.2

supported configuration, 3.1

two-way communication, 1.6.1

Oracle Universal Installer

installing Oracle Instant Client, 2.1, 8.2

Oracle Wallet

starting the observer, 8.2, 8.2

when starting the observer, 7.6

P

parallel apply

and log apply services, 4.5.2

managing in a physical standby database, 4.5.2

performance

Enterprise Manager tools, 6.8.3

Oracle Enterprise Manager tools, 1.5.1

Personal Edition database

installation, 2.1

physical standby databases

during switchovers, 5.3.3

managing parallel apply, 4.5.2

state transitions, 4.2.1

switchover to the primary role, 5.3

port numbers

setting nondefault, 2.2, 4.4.6

PreferredApplyInstance property, 4.5.7.1, 9.2.37

prerequisites

installation, 2.2

setting a nondefault port number, 2.2, 4.4.6

switchover, 5.3.1

primary database

ARCHIVELOG mode, 2.2

configuration, 3.1

connecting to, 7.2, 7.2

constructing a standby database, 3.4, 7.1

Data Guard configuration, 3.1

during failover, 1.5.1

during switchover, 5.3.3

failed

reenabling, 5.4.3

Flashback Database, 5.4.3.1

health check, 4.7

preparing for switchover, 5.3.1

reinstating

REINSTATEMENT command, 5.4.3.1

reinstating after a fast-start failover, 5.5.7

shutting down when fast-start failover is enabled, 5.5.8

standby redo log files on, 4.6.1

state transitions, 4.2.1

switching over to the standby role, 8.2

processes

DMON, 1.6.1

Oracle database, 1.6.1

properties, 4.3.2

AlternateLocation, 4.4.3

ApplyInstanceTimeout, 4.5.7.2

ApplyParallel, 4.5.2

configurable, 4.3, 8.2

database, 4.3

DelayMins, 4.5.1

Dependency, 4.4.4

LsbyASkipErrorCfgPr, 4.5.5

LsbyDSkipErrorCfgPr, 4.5.5

LsbyMaxSga, 4.5.3

LsbyTxnConsistency, 4.5.3

managing, 1.6.3

monitorable, 4.3

PreferredApplyInstance, 4.5.7.1

setting, 3.4, 6.5.2, 7.3

in server parameter file, 1.6.3, 2.2

StandbyArchiveLocation, 4.4.3

StatusReport, 4.7

property pages

configuring, 1.5.1

database, 1.5.1

protection modes

after a failover, 4.6.2.3, 5.4.2, 5.5.1

benefits, 1.2

configuration, 8.2

downgrading, 4.6.2.1

of a database

changing in a broker configuration, 6.5.3

redo transport services setup, 9.2.20

setting for a broker configuration, 4.6

updating, 3.4

upgrading, 4.6.2.1

Q

QUIT command, 8.2

R

RAC databases

during switchovers, 5.3.3

registering services with the local listener, 2.2

raw devices

and broker configuration files, 3.2.2.3

configuration files located on, 3.2.1

sizing, 3.2.2.3

Real Application Clusters

adding to a broker configuration, 6.3

and apply instance failover, 4.5.7.2

and log apply services, 4.5.7

and redo transport services, 4.4.7

and setting the apply instance, 4.5.7.1

availability of instances with Oracle Clusterware, 1.2

benefits, 1.2

Cluster Ready Services (CRS), 1.2

effect of switchover on databases, 5.3.3

failing over to a database in, 5.4.2

fast-start failover, 5.5.2.1

observer behavior in, 5.5.2.1

observer connection to instances, 5.5.6.2

setting START_OPTIONS in OCR, 2.2

RecvQEntries property, 9.1.8

Redo Apply, 3.1, 5.3.3

redo transport services

and connections to the standby database, 4.4.6

ARCH mode, 4.4.1, 9.2.20

ASYNC mode, 4.4.1, 9.2.20

configuring, 1.2, 1.5.1

data protection modes, 9.2.20

Data Guard configuration, 3.1

in a RAC environment, 4.4.7

LogShipping property, 9.2.19

managing, 4.4

SYNC mode, 4.4.1, 9.2.20

tuning, 4.4.5

turning off, 4.4.2

turning on, 4.4.2

verifying, 1.2

reenabling

a database after failover or switchover, 5.4.3

registering

db_unique_name_DGMGRL service name, 2.2

db_unique_name_XPT service name, 4.4.6

reinstatement, 5.5.7

disabled databases, 5.4.3.1, 5.4.3.1

failiure logged in broker drc* log files, 5.5.3

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.7.3

ORA-16661 message, 5.4.3, 5.4.3, 5.4.3.1

requires standby redo log files, 4.6.1

using DGMGRL

DGMGRL, 5.4.3.1

using Enterprise Manager, 5.4.3.1

REINSTATEMENT command, 5.4.3.1

relationship

objects in a broker configuration, 1.3

REMOVE CONFIGURATION command, 8.2

example, 7.7.3

REMOVE DATABASE command, 8.2

REMOVE INSTANCE command, 8.2

removing, 4.6.2.5

a standby database, 4.6.2.5

broker configurations, 4.6.2.5, 6.10.2

See each REMOVE command

standby databases, 6.10.1

ReopenSecs property, 9.2.38

requests

passing between sites, 1.6.1

requirements

for enabling fast-start failover, 5.5.1

restarting

databases

when fast-start failover is enabled, 5.5.8

instances, 2.2

role transitions

changing, 3.4

managing, 5

fast-start failover, 5.5

manual failover, 5.4

switchover, 5.3

reenabling databases after, 5.4.3, 5.4.3

writing triggers to manage tasks after, 5.1

S

scenarios

switchover, 6.6

scripts

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

selecting the apply instance, 4.5.7.1

SendQEntries property, 9.1.9

server parameter file

broker property management, 1.6.3, 2.2

filenames, 1.6.3

inconsistent values from Data Guard configuration file, 9.1.2

server-side software, 1.6

service names

registering

db_unique_name_DGMGRL, 2.2

db_unique_name_XPT, 4.4.6

SET STATE command

and setting the apply instance, 4.5.7.1

setting

a dependent standby database, 4.4.4

configuration protection mode, 4.6.1

database properties, 7.3

log apply services, 4.4.3

redo transport services, 4.4.5

SGA memory

and SQL Apply, 4.5.3

SHOW CONFIGURATION command, 7.2, 7.2, 7.4, 8.2

verifying fast-start failover configuration, 7.6

SHOW CONFIGURATION VERBOSE command

viewing fast-start failover statistics, 5.5.3

SHOW DATABASE command, 8.2

SHOW DATABASE VERBOSE command

displaying properties, 4.3

SHOW INSTANCE command, 8.2

showing

See each SHOW command

shutdown

FS_FAILOVER_OBSERVER_PRESENT view, 5.5.8

shutdown abort, 5.5.2.1

effect on fast-start failover, 5.5.2.3

SHUTDOWN command, 8.2

shutting down an Oracle instance, 8.2

SidName property, 9.2.39

single command mode

for Data Guard command-line interface, 8.1.1

SQL Apply, 3.1

and logical standby databases, 4.5.3

effect of switchovers on, 5.3.3

error handling

and logical standby databases, 4.5.5

filters

and logical standby databases, 4.5.4

standby databases

apply instance, 4.2.1

changing the state of, 6.5.1

choosing a target standby database, 5.2

constructing from backups, 3.4, 7.1

creating, 1.5.1, 6.2, 6.2

if primary database uses ASM or OMF, 2.2

Data Guard configuration, 3.1

DB_UNIQUE_NAME initialization parameter, 4.4.6

health check, 4.7

LOCAL_LISTENER initialization parameter, 4.4.6

managing connections, 4.4.6

not involved in a switchover, 5.3.3

reenabling after failover, 5.4.2.1

reinstating, 5.4.3.1

removing, 4.6.2.5, 6.10.1, 8.2

require standby redo log files, 4.6.1

shutting down when fast-start failover is enabled, 5.5.8

specifying the location of archived redo logs, 4.4.3

switching over to the primary role, 8.2

standby redo log files

setting up, 4.6.1

setting up with DGMGRL, 4.6.1

StandbyArchiveLocation property, 9.2.40

setting log apply services, 4.4.3

StandbyFileManagement property, 9.2.41

START OBSERVER command

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

START_OPTIONS

setting in the Oracle Cluster Repository (OCR), 2.2

starting

Data Guard command-line interface (DGMGRL), 7.2, 8.1

Data Guard monitor (DMON), 3.3

Data Guard Web pages in Enterprise Manager, 6.1

manual failover, 5.4.2

Oracle instance, 8.2

switchover, 5.3.2

the observer, 5.5.2

STARTUP command, 8.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.5

any type of database

OFFLINE, 4.2

changing, 3.4, 7.7

database, 4.2

database transitions, 4.2.1

logical standby database

LOG-APPLY-OFF, 4.2

ONLINE, 4.2

of a standby database

changing in a broker configuration, 6.5.1

physical standby database

LOG-APPLY-OFF, 4.2

ONLINE, 4.2

READ-ONLY, 4.2

primary database

LOG-TRANSPORT-OFF, 4.2

ONLINE, 4.2

static service name registration, 2.2, 4.4.6, 4.4.6

status

configuration, 3.6

health check on primary database, 4.7

health check on standby database, 4.7

health of the database, 4.7

intended state of a configuration, 3.6

using metrics, 6.9

status messages

ORA-16661, 5.4.3, 5.4.3

ORA-16795, 5.4.3

StatusReport property, 4.7, 9.1.10

string values

Data Guard command-line interface, 8.1.3

supported broker configuration, 1.3

SWITCHOVER command, 7.8, 8.2

switchovers

benefits, 1.2

broker tasks, 5.3.3

choosing a target standby database, 5.2

DGMGRL SWITCHOVER command, 7.8

effect on

database startup, 8.2

logical standby databases, 5.3.3

physical standby databases, 5.3.3

primary database, 5.3.3

protection modes, 4.6.2.2

RAC databases, 5.3.3

standby databases not involved in the switchover, 5.3.3

managing, 5, 5.3

overview, 5.1

Oracle Enterprise Manager, 1.5.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

reinstating a database after, 5.4.3

scenario

Oracle Enterprise Manager, 6.6

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

troubleshooting, 10.3, 10.3

using the DGMGRL SWITCHOVER command, 8.2

SYNC redo transport mode, 4.4.1

SYSDBA privileges, 7.2

to connect to the database, 8.1.3

system events

writing triggers for use DB_ROLE_CHANGE, 5.1

T

target standby database

choosing, 5.2

disabling fast-start failover on, 5.5.4

setting with the FastStartFailoverTarget property, 5.5.2, 5.5.2, 7.6

TopWaitEvents property, 9.1.11

transaction consistency level

controlling, 4.5.3

troubleshooting

Data Guard, 10

diagnostics logged in broker drc* log files, 10.1

tuning

redo transport services, 4.4.5

two-way communication channel, 1.6.1

U

understanding metrics, 6.9.1

unobserved configuration, 5.5.6.3

updating configuration properties, 4.3

upgrading

Data Guard, B.1, B.2, B.3

Oracle Enterprise Manager, B.1, B.2

protection mode, 4.6.2.1

user interfaces

overview, 1.5

V

V$DATABASE view

fast-start failover columns, 5.5.2.2, 5.5.3

FS_FAILOVER_OBSERVER_HOST column, 5.5.6.2

FS_FAILOVER_OBSERVER_PRESENT column, 5.5.6.2

when shutting down databases, 5.5.8

verifying

fast-start failover environment, 5.5.2

viewing

fast-start failover statistics, 5.5.3

verifying

a broker configuration, 6.8.1

fast-start failover environment, 5.5.2

viewing

log file details, 6.8.2

property information about databases, 4.3.1, 9.1

W

warning status, 3.6

wizards

Add Standby Database, 1.5.1, 6.2