Skip Headers

Oracle® Data Guard Broker
10g Release 1 (10.1)

Part Number B10822-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
Feedback

Go to previous page
Previous
View PDF

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