Skip Headers
Oracle® Data Guard Broker
11g Release 1 (11.1)

Part Number B28295-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

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

A

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.4
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
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.2
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
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.12
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
verifying, 6.8.1
BystandersFollowRoleChange property, 9.2.6

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, 4.2.1
of a standby database in a broker configuration, 6.5.1
of databases in a broker configuration, 7.7
See also editing
cluster file system (CFS)
broker configuration files, 3.2.2.1
Cluster Ready Services (CRS), 1.2
command prompts
suppressing from DGMGRL command-line interface output, 8.1.1
command-line interface
See Data Guard command-line interface (DGMGRL)
COMPATIBLE initialization parameter
requirements for setting, 2.2
complete failover, 5.4.1, 8.2
reinstating disabled databases, 5.4.3.1
components
broker, 1.4
Data Guard configuration, 3.1
configurable properties, 4.3
AlternateLocation, 9.2.1
ApplyInstanceTimeout, 9.2.2
ApplyParallel, 9.2.3
ArchiveLagTarget, 9.2.4
Binding, 9.2.5
database, 4.3.2, 4.3.2, 9.2
DbFileNameConvert, 9.2.7
DelayMins, 9.2.8
DGConnectIdentifier, 9.2.9
FastStartFailoverAutoReinstate, 9.2.10
FastStartFailoverLagLimit, 9.2.11
FastStartFailoverPmyShutdown, 9.2.12
FastStartFailoverTarget, 9.2.13
FastStartFailoverThreshold, 9.2.14
LogArchiveFormat, 9.2.16
LogArchiveMaxProcesses, 9.2.17
LogArchiveMinSucceedDest, 9.2.18
LogArchiveTrace, 9.2.19
LogFileNameConvert, 9.2.20
LogShipping, 9.2.21
LogXptMode, 9.2.22
LsbyASkipCfgPr, 9.2.23
LsbyASkipErrorCfgPr, 9.2.24
LsbyASkipTxnCfgPr, 9.2.25
LsbyDSkipCfgPr, 9.2.26
LsbyDSkipErrorCfgPr, 9.2.27
LsbyDSkipTxnCfgPr, 9.2.28
LsbyMaxEventsRecorded, 9.2.29
LsbyMaxServers, 9.2.31
LsbyMaxSga, 9.2.30
LsbyPreserveCommitOrder, 9.2.35
LsbyRecordAppliedDdl, 9.2.32
LsbyRecordSkipDdl, 9.2.33
LsbyRecordSkipErrors, 9.2.34
managing redo transport services, 4.4
MaxConnections, 9.2.36
MaxFailure, 9.2.37
NetTimeout, 9.2.38
PreferredApplyInstance, 9.2.40
RedoCompression, 9.2.41
ReopenSecs, 9.2.42
SidName, 9.2.43
StandbyArchiveLocation, 9.2.44
StandbyFileManagement, 9.2.45
TopWaitEvents, 9.1.11
configuration files
fast-start failover configuration (fsfo.dat) file, 5.5.7.6
See Also Data Guard configuration file
configuration properties
BystandersFollowRoleChange, 9.2.6
CONNECT command, 7.2, 8.2
connecting
privileges required for Data Guard broker configurations, 8.1.3
starting the observer, 7.6
to the primary database, 7.2
controlling
available SGA memory, 4.5.3
transaction commit order, 4.5.3
CREATE CONFIGURATION command, 7.2, 8.2
creating
a broker configuration, 6.2, 7.2, 7.2, 7.2, 8.2
with the Add Standby Database wizard, 3.4
a standby database, 3.4, 6.2, 6.2

D

Data Guard
troubleshooting, 10
Data Guard broker
changed features, A
deprecated features, A
integration with Oracle Enterprise Manager, 6.1
See Alsobroker
Data Guard command-line interface
commands, 1.5.2
ENABLE FAST_START FAILOVER, 8.2
SET STATE, 4.5.7.1
DG_BROKER_START initialization parameter, 2.2
enabling a database, 7.4
introduction, 1.1.2, 1.5.2
Data Guard command-line interface (DGMGRL)
banners from output, 8.1.1
commands
CONNECT, 8.2
CREATE CONFIGURATION, 8.2
DISABLE CONFIGURATION, 8.2
DISABLE DATABASE, 8.2
DISABLE FAST_START FAILOVER, 5.5.5, 8.2
DISABLE FAST_START FAILOVER CONDITION, 8.2
EDIT CONFIGURATION (property), 8.2
EDIT CONFIGURATION (protection mode), 8.2
EDIT DATABASE (property), 8.2
EDIT DATABASE (rename), 8.2
EDIT DATABASE (state), 8.2
EDIT INSTANCE (AUTO PFILE), 8.2
EDIT INSTANCE (property), 8.2
ENABLE CONFIGURATION, 8.2
ENABLE DATABASE, 8.2
ENABLE FAST_START FAILOVER CONDITION, 8.2
EXIT, 8.2
FAILOVER, 7.9
HELP, 8.2
QUIT, 8.2
REMOVE CONFIGURATION, 8.2
REMOVE DATABASE, 8.2
REMOVE INSTANCE, 8.2
SHOW CONFIGURATION, 8.2
SHOW DATABASE, 8.2
SHOW FAST_START FAILOVER, 8.2
SHOW INSTANCE, 8.2
SHUTDOWN, 8.2
STARTUP, 8.2
SWITCHOVER, 7.8, 8.2
creating a configuration, 7.2
DG_BROKER_START initialization parameter, 8.1.3
enabling the configuration, 7.4
FSFO.DAT file creation, 8.2
monitoring broker configurations, 7.12
performing routine management tasks, 7.7
prerequisites, 7.1
setting critical database properties, 7.3
setting up standby redo log files, 4.6.1
single command mode, 8.1.1
starting, 7.2, 8.1
stopping, 8.2
string values, 8.1.3
summary of commands, 8.1.2
suppressing command prompts, 8.1.1
Data Guard configuration file
for a RAC database, 3.2.2
in a CFS area, 3.2.2.1
inconsistent values from server parameter file, 9.1.2
on a raw device, 3.2.2.3
relationship to DMON process, 1.6.1
renaming, 1.6.2
setting up, 3.2
Data Guard configurations
automated creation of, 1.2
background, 3.1
supported, 3.1
Data Guard Fast-Start Failover metrics
understanding, 6.9.1.1
Data Guard monitor (DMON), 1.6
interaction with the Oracle database, 1.6.1
maintaining configuration data, 1.6.2
managing objects, 3.1, 3.4, 7.4
Oracle database background processes, 1.6.1
overview, 1.6.1
removing objects, 7.7.3
starting with the DG_BROKER_START parameter, 3.3
two-way network communication, 1.6.1
Data Guard Performance metric
understanding, 6.9.1.2
Data Guard Status metric
understanding, 6.9.1.3
data protection modes
See protection modes
database resources
monitoring, 1.2
databases
changing the state of, 7.7
connecting to, 7.2
creating and adding to a broker configuration, 1.5.1
dependencies, 4.2
disabling management of, 8.2
during
fast-start failover, 5.5
manual failover, 5.4
switchover, 5.3
enabling, 7.4
health, 4.9
installation for broker management, 2.2
monitorable database properties, 4.3.1, 9.1
network setup, 1.6.1, 2.2
objects, 1.3
definition, 1.3
in a broker configuration, 1.3
prerequisites for broker configurations, 2.2
properties, 1.5.1, 4.3.2, 9.2
property management, 1.6.3
reenabling after a role transition, 5.4.3
removing
from a broker configuration, 7.7.3
restarting
after fast-start failover, 5.5.9
shutting down
effect on fast-start failover, 5.5.2.1, 5.5.2.3, 5.5.9
states, 4.2
dependencies, 4.2
transitions, 4.2.1
status, 4.9
DB_FILE_NAME_CONVERT initialization parameter
initialization parameters
setting DB_FILE_NAME_CONVERT in a broker configuration, 9.2.7
DB_ROLE_CHANGE system event, 5.1
db_unique_name_DGMGRL static service name
registering, 2.2
DBA_LOGSTDBY_EVENTS table
managing, 4.5.6
DbFileNameConvert property, 9.2.7
delaying
application of redo data with DelayMins property, 4.5.1
DelayMins property, 9.2.8
delaying log apply services, 4.5.1
deprecated features, A
destinations
archived redo log file parameters, 3.1
viewing the LogXptStatus property, 9.1.3
DG_BROKER_CONFIG_FILEn file, 1.6.2, 3.2.2
in a CFS area, 3.2.2.1
on a raw device, 3.2.2.3
DG_BROKER_START initialization parameter, 2.2, 7.1, 8.1.3
DGConnectIdentifier property, 9.2.9
DGMGRL commands
FAILOVER, 8.2
SWITCHOVER, 8.2
diagnostic information
sources, 10.1
DISABLE CONFIGURATION command, 8.2
example, 7.7.2.1
DISABLE DATABASE command, 8.2
example, 7.7.2.2
DISABLE FAST_START FAILOVER command, 5.5.5, 8.2
DISABLE FAST_START FAILOVER CONDITION command, 8.2
disabling
broker configuration, 7.7.2, 8.2
broker management of standby database, 8.2
databases, 3.5, 7.7.2.1, 7.7.2.2
fast-start failover, 5.5.5, 8.2
on a standby database, 5.5.5
See also each DISABLE command
disaster protection
benefits, 1.2
displaying
configuration information, 8.2
help for DGMGRL commands, 8.2
help for Enterprise Manager, 6.1
properties, 4.3
distributed management framework, 1.1.2
DMON
See Data Guard monitor (DMON)
downgrading
Data Guard, B.3
Oracle Enterprise Manager, B.3
protection mode, 4.6.2.1
drc* log files
broker diagnostic information, 10.1
during reinstatement, 5.5.4.1
recording failed reinstatment, 5.5.8.3

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
ENABLE FAST_START FAILOVER CONDITION 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
See also each ENABLE command
Enterprise Edition database
installation, 2.1
Enterprise Manager
adding an existing RAC standby database, 6.3
changing
database properties, 6.5.2
database protection mode, 6.5.3
database state, 6.5.1
creating
a configuration, 6.2
a standby database, 6.2
Fast-Start Failover wizard
disabling fast-start failover, 5.5.5
managing metrics, 6.9.2
monitoring
broker configurations, 6.8
configuration performance, 6.8.3
performing
fast-start failover, 6.4
manual failover, 6.7
routine maintenance, 6.5
switchover, 6.6
removing
broker configuration, 6.10.2
standby database, 6.10.1
starting, 6.1
using metrics, 6.9
verifying a broker configuration, 6.8.1
viewing log file details, 6.8.2
wizards
automate standby database creation, 1.1.2
error messages
ORA-16795, 5.4.3, 5.4.3
error status, 3.6
events
managing
in a logical standby database, 4.5.6
monitoring with Oracle Enterprise Manager, 1.1.2
Oracle Enterprise Manager, 1.2
reporting, 1.5.1
responding to, 1.2
EXIT command, 8.2
See also QUIT command

F

failover
failing over to a standby database, 8.2
Oracle Enterprise Manager, 1.5.1
FAILOVER command, 7.9, 8.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.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, 5.4.3
scenario
fast-start failover, 6.4
manual failover, 6.7
starting manually, 5.4.2
troubleshooting, 10.4
using DGMGRL, 7.9
failures
observer, 5.5.7.3
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.7.6
defined, 5.5
DGMGRL client as the observer, 1.5.2
disabling, 5.5.5, 5.5.5
to perform manual failover, 5.5.5
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
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, 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.9
to 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, 9.2.10
FastStartFailoverLagLimit property, 9.2.11
FastStartFailoverPmyShutdown property, 9.2.12
FastStartFailoverTarget property, 9.2.13
setting, 5.5.2, 5.5.2, 7.6
FastStartFailoverThreshold property, 9.2.14
conditions causing fast-start failover, 5.5.2.1
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.5, 8.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.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.9
on standby database, 4.9
revealed by configuration status, 3.6
StatusReport property, 4.9
HELP command, 8.2
high availability
benefits, 1.2
levels of data protection, 4.6, 9.2.22
LogXptMode property, 9.2.22
restoring after fast-start failover, 5.5.8

I

immediate failover, 5.4.1, 8.2
InconsistentProperties property, 9.1.2
increased scalability
benefits, 1.2
initialization parameters
COMPATIBLE, 2.2
database configurable properties, 4.3.2
DG_BROKER_CONFIG_FILEn, 3.2.2
DG_BROKER_START, 2.2, 7.1
dynamic, 4.3.2
inconsistent, 9.1.2
LOG_ARCHIVE_DEST_n, 4.4.5
static, 4.3.2
See also server parameter file, 2.2
installation
ARCHIVELOG mode setup, 2.2
Data Guard, 2.1
Oracle Enterprise Manager, 2.1
Oracle Instant Client, 2.1, 8.2
prerequisites, 2.2
instances
failures, 5.5.2.1
objects
in a broker configuration, 1.3
removing, 8.2, 8.2, 8.2
restarting during the course of broker operations, 2.2
shutting down, 8.2
starting, 8.2
intended state
configuration health check, 3.6
invoking
the Data Guard command-line interface, 7.2

L

life cycle of a broker configuration, 3.4
LISTENER.ORA file
registering global service names, 2.2
local listener
statically registering services with, 2.2
log apply services
and apply instance failover, 4.5.7
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.8
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.8.3
FSFO.DAT
creating, 8.2
viewing, 6.8.2
LOG_ARCHIVE_DEST_n initialization parameter
setting redo transport services, 4.4.5
setting the DELAY attribute, 9.2.8
setting the ENABLE and DEFER attributes, 9.2.21
setting the MANDATORY or OPTIONAL attributes, 9.2.5
LOG_ARCHIVE_FORMAT initialization parameter, 9.2.16
LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 9.2.17
LOG_ARCHIVE_MIN_SUCCEED initialization parameter, 9.2.18
LOG_ARCHIVE_TRACE initialization parameter
setting LogArchiveTrace property, 9.2.19
LOG_FILE_NAME_CONVERT initialization parameter
setting LogFileNameConvert property, 9.2.20
LogArchiveFormat property, 9.2.16
LogArchiveMaxProcesses property, 9.2.17
LogArchiveMinSucceedDest property, 9.2.18
LogArchiveTrace property, 9.2.19
LogFileNameConvert property, 9.2.20
logical standby databases
and SQL Apply error handling, 4.5.5
and SQL Apply filters, 4.5.4
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.21
LogXptMode property, 9.2.22
LogXptStatus property, 9.1.3
LsbyASkipCfgPr property, 9.2.23
LsbyASkipErrorCfgPr property, 4.5.5, 9.2.24
LsbyASkipTxnCfgPr property, 9.2.25
LsbyDSkipCfgPr property, 9.2.26
LsbyDSkipErrorCfgPr property, 4.5.5, 9.2.27
LsbyDSkipTxnCfgPr property, 9.2.28
LsbyFailedTxnInfo property, 9.1.4
LsbyMaxEventsRecorded property, 9.2.29
LsbyMaxServers property, 9.2.31
LsbyMaxSga property, 4.5.3, 9.2.30
LsbyParameters property, 9.1.5
LsbyPreserveCommitOrder property, 4.5.3, 9.2.35
LsbyRecordAppliedDdl property, 9.2.32
LsbyRecordSkipDdl property, 9.2.33
LsbyRecordSkipErrors property, 9.2.34
LsbySkipTable property, 9.1.6
LsbySkipTxnTable property, 9.1.7

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
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.5
starting, 5.4.2
manual role changes
performing when fast-start failover is enabled, 5.5.2.4
MaxConnections property, 9.2.36
MaxFailure property, 9.2.37
maximize availability, 1.2, 3.4, 9.2.22
maximize data protection, 1.2, 3.4, 9.2.22
maximize performance, 1.2, 3.4, 9.2.22
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.12
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.38
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.7.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
failures, 5.5.7.3
finding host machine name, 5.5.7.2
installing Oracle Instant Client kit, 2.1, 8.2
lost connection, 5.5.7.3
maintaining fast-start failover configuration information, 5.5.7.6
monitoring, 5.5.2.1, 5.5.2.1
shutting down, 5.5.9
using Oracle Wallet for connection credentials, 8.2
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
OPTIONAL attribute
set with the Binding property, 9.2.5
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
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.3
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
performance tools and graphs, 1.5.1
setting up standby redo log files, 4.6.1
upgrading, B.1
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

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
managing parallel apply, 4.5.2
state transitions, 4.2.1
switchover to the primary role, 5.3
PreferredApplyInstance property, 4.5.7.1, 9.2.40
prerequisites
installation, 2.2
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.9
preparing for switchover, 5.3.1
reinstating
REINSTATEMENT command, 5.4.3.1
reinstating after a fast-start failover, 5.5.8
shutting down when fast-start failover is enabled, 5.5.9
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.4
ApplyInstanceTimeout, 4.5.7.2
ApplyParallel, 4.5.2
configurable, 4.3
database, 4.3
DelayMins, 4.5.1
LsbyASkipErrorCfgPr, 4.5.5
LsbyDSkipErrorCfgPr, 4.5.5
LsbyMaxSga, 4.5.3
LsbyPreserveCommitOrder, 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.4
StatusReport, 4.9
property pages
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.22
setting for a broker configuration, 4.6
updating, 3.4
upgrading, 4.6.2.1

Q

QUIT command, 8.2
See also EXIT command

R

raw devices
and broker configuration files, 3.2.2.3
sizing, 3.2.2.3
Real Application Clusters
adding to a broker configuration, 6.3
and log apply services, 4.5.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
fast-start failover, 5.5.2.1
observer behavior in, 5.5.2.1
observer connection to instances, 5.5.7.2
RecvQEntries property, 9.1.8
Redo Apply, 3.1, 5.3.3
redo transport services
ASYNC mode, 4.4.2, 9.2.22
configuring, 1.2, 1.5.1
data protection modes, 9.2.22
Data Guard configuration, 3.1
LogShipping property, 9.2.21
managing, 4.4
SYNC mode, 4.4.2, 9.2.22
tuning, 4.4.5
turning off, 4.4.3
turning on, 4.4.3
verifying, 1.2
RedoCompression property, 9.2.41
reenabling
a database after failover or switchover, 5.4.3
registering
db_unique_name_DGMGRL service name, 2.2
reinstatement, 5.5.8
disabled databases, 5.4.3.1, 5.4.3.1
failiure 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
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
a standby database, 4.6.2.5
broker configurations, 6.10.2
See each REMOVE command
standby databases, 6.10.1
ReopenSecs property, 9.2.42
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.9
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
SET STATE command
and setting the apply instance, 4.5.7.1
setting
configuration protection mode, 4.6.1
database properties, 7.3
log apply services, 4.4.4
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
SHOW CONFIGURATION VERBOSE
example, 5.5.4
SHOW DATABASE command, 8.2
SHOW DATABASE VERBOSE command
displaying properties, 4.3
SHOW FAST-START FAILOVER command
example, 5.5.4
SHOW INSTANCE command, 8.2
SHOW SHOW FAST_START FAILOVER command, 8.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, 8.2
shutting down an Oracle instance, 8.2
SidName property, 9.2.43
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
health check, 4.9
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.9
specifying the location of archived redo logs, 4.4.4
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.44
setting log apply services, 4.4.4
StandbyFileManagement property, 9.2.45
START OBSERVER command
fast-start failover configuration file (fsfo.dat), 5.5.7.6
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
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
changing, 7.7
database, 4.2
database transitions, 4.2.1
logical standby database
APPLY-OFF, 4.2
APPLY-ON, 4.2
of a standby database
changing in a broker configuration, 6.5.1
physical standby database
APPLY-OFF, 4.2
APPLY-ON, 4.2
primary database
TRANSPORT-OFF, 4.2
TRANSPORT-ON, 4.2
status
configuration, 3.6
health check on primary database, 4.9
health check on standby database, 4.9
health of the database, 4.9
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.9, 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
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.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.2
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.5
setting with the FastStartFailoverTarget property, 5.5.2, 7.6
TopWaitEvents property, 9.1.11
transaction commit order
controlling, 4.5.3
TRANSPORT-OFF state
LogShipping property setting, 9.2.21
TRANSPORT-ON state
setting LogShipping property, 9.2.21
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.7.3
updating configuration properties, 4.3
upgrading
Data Guard, B.1, B.2
Oracle Enterprise Manager, B.1
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.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
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