Skip Headers
Oracle® Data Guard Broker
11
g
Release 2 (11.2)
Part Number E10702-01
Home
Book List
Contents
Master Index
Contact Us
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 Standby Database wizard
creating a broker configuration,
3.4
definition,
1.5.1
introduction,
1.5.1
adding
standby database to the broker configuration,
6.2
ALTER SYSTEM statement
starting the broker,
6.1
altering
properties
database,
6.7.1.1
states
database,
6.7.1.2
,
6.7.1.3
AlternateLocation property,
8.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
PreferredApplyInstance property,
4.5.7.1
selecting,
4.5.7.1
ApplyInstanceTimeout property,
4.5.7.2
,
8.2.2
ApplyParallel property,
4.5.2
,
8.2.3
architecture
Data Guard broker,
1.4
ARCHIVE_LAG_TARGET initialization parameter
setting in a broker configuration,
8.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,
8.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,
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
binary configuration file,
1.6.2
Binding property,
8.2.5
broker
components,
1.4
configuration,
1.1.1
Data Guard configuration file,
1.6.2
drc* log files,
9.1
installation,
2.2
introduction,
1.1.2
managing databases,
4.1
user interfaces,
1.5
broker configurations
benefits,
1.2
changing roles,
3.4
components,
3.1
creating,
6.2
,
6.2
,
7.2
Data Guard configuration file,
1.6.1
database objects,
1.3
database profiles,
1.3
disabling databases,
3.5
,
7.2
effects of removing metadata from,
7.2
enabling,
6.4
,
7.2
enabling databases,
3.4
,
3.5
,
6.4
,
7.2
enabling fast-start failover,
7.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.12
objects,
1.3
Oracle Net Services configuration,
1.2
,
1.5.1
overview,
3.1
properties,
4.3
protection modes,
7.2
setting protection mode,
4.6.1
status modes,
3.6
supported,
1.3
,
3.1
,
3.1
bystander standby databases,
5.3
reintegrating into configuration,
5.4.2.1
BystandersFollowRoleChange property,
8.2.6
C
CFS
See
cluster file system
changed features,
A
changing
properties
databases in a broker configuration,
3.4
,
4.3.2
roles
within the broker configuration,
3.4
states
databases in a broker configuration,
4.2.1
of databases in a broker configuration,
6.7
See also
editing
cluster file system (CFS)
broker configuration files,
3.2.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.2.7
COMPATIBLE initialization parameter
requirements for setting,
2.2
complete failover,
5.4.1
,
7.2
components
broker,
1.4
Data Guard configuration,
3.1
configurable properties,
4.3
AlternateLocation,
8.2.1
ApplyInstanceTimeout,
8.2.2
ApplyParallel,
8.2.3
ArchiveLagTarget,
8.2.4
Binding,
8.2.5
CommunicationTimeout,
8.2.7
database,
4.3.2
,
4.3.2
,
8.2
DbFileNameConvert,
8.2.8
DelayMins,
8.2.9
DGConnectIdentifier,
8.2.10
FastStartFailoverAutoReinstate,
8.2.11
FastStartFailoverLagLimit,
8.2.12
FastStartFailoverPmyShutdown,
8.2.13
FastStartFailoverTarget,
8.2.14
FastStartFailoverThreshold,
8.2.15
LogArchiveFormat,
8.2.17
LogArchiveMaxProcesses,
8.2.18
LogArchiveMinSucceedDest,
8.2.19
LogArchiveTrace,
8.2.20
LogFileNameConvert,
8.2.21
LogShipping,
8.2.22
LogXptMode,
8.2.23
LsbyASkipCfgPr,
8.2.24
LsbyASkipErrorCfgPr,
8.2.25
LsbyASkipTxnCfgPr,
8.2.26
LsbyDSkipCfgPr,
8.2.27
LsbyDSkipErrorCfgPr,
8.2.28
LsbyDSkipTxnCfgPr,
8.2.29
LsbyMaxEventsRecorded,
8.2.30
LsbyMaxServers,
8.2.32
LsbyMaxSga,
8.2.31
LsbyPreserveCommitOrder,
8.2.33
LsbyRecordAppliedDdl,
8.2.34
LsbyRecordSkipDdl,
8.2.35
LsbyRecordSkipErrors,
8.2.36
managing redo transport services,
4.4
MaxConnections,
8.2.37
MaxFailure,
8.2.38
NetTimeout,
8.2.39
PreferredApplyInstance,
8.2.41
RedoCompression,
8.2.42
ReopenSecs,
8.2.43
SidName,
8.2.44
StandbyArchiveLocation,
8.2.45
StandbyFileManagement,
8.2.46
StaticConnectIdentifier,
8.2.47
TopWaitEvents,
8.1.11
configuration files
fast-start failover configuration (fsfo.dat) file,
5.5.7.6
See Also
Data Guard configuration file
configuration properties
BystandersFollowRoleChange,
8.2.6
CONNECT command,
6.2
,
7.2
connecting
privileges required for Data Guard broker configurations,
7.1.3
starting the observer,
6.6
to the primary database,
6.2
controlling
available SGA memory,
4.5.3
transaction commit order,
4.5.3
CREATE CONFIGURATION command,
6.2
,
7.2
creating
a broker configuration,
6.2
,
6.2
,
6.2
,
7.2
with the Add Standby Database wizard,
3.4
a standby database,
3.4
D
Data Guard
troubleshooting,
9
Data Guard broker
changed features,
A
deprecated features,
A
See Also
broker
Data Guard command-line interface
commands
ENABLE FAST_START FAILOVER,
7.2
SET STATE,
4.5.7.1
DG_BROKER_START initialization parameter,
2.2
enabling a database,
6.4
introduction,
1.1.2
,
1.5.2
Data Guard command-line interface (DGMGRL)
banners from output,
7.1.1
commands
CONNECT,
7.2
CREATE CONFIGURATION,
7.2
DISABLE CONFIGURATION,
7.2
DISABLE DATABASE,
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 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
ENABLE FAST_START FAILOVER CONDITION,
7.2
EXIT,
7.2
FAILOVER,
6.9
HELP,
7.2
QUIT,
7.2
REMOVE CONFIGURATION,
7.2
REMOVE DATABASE,
7.2
REMOVE INSTANCE,
7.2
SHOW CONFIGURATION,
7.2
SHOW DATABASE,
7.2
SHOW FAST_START FAILOVER,
7.2
SHOW INSTANCE,
7.2
SHUTDOWN,
7.2
STARTUP,
7.2
SWITCHOVER,
6.8
,
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.12
performing routine management tasks,
6.7
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.2.2
in a CFS area,
3.2.2.1
inconsistent values from server parameter file,
8.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 monitor (DMON),
1.6
interaction with the Oracle database,
1.6.1
maintaining configuration data,
1.6.2
managing objects,
3.1
,
3.4
,
6.4
Oracle database background processes,
1.6.1
overview,
1.6.1
removing objects,
6.7.3
starting with the DG_BROKER_START parameter,
3.3
two-way network communication,
1.6.1
data protection modes
See
protection modes
database resources
monitoring,
1.2
databases
changing the state of,
6.7
connecting to,
6.2
creating and adding to a broker configuration,
1.5.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.9
installation for broker management,
2.2
monitorable database properties,
4.3.1
,
8.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
,
8.2
property management,
1.6.3
reenabling after a role transition,
5.4.3
removing
from a broker configuration,
6.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,
8.2.8
DBA_LOGSTDBY_EVENTS table
managing,
4.5.6
DbFileNameConvert property,
8.2.8
delaying
application of redo data with DelayMins property,
4.5.1
DelayMins property,
8.2.9
delaying log apply services,
4.5.1
deprecated features,
A
destinations
archived redo log file parameters,
3.1
viewing the LogXptStatus property,
8.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
,
6.1
,
7.1.3
DGConnectIdentifier property,
8.2.10
DGMGRL
reinstating a database,
5.4.3.1
DGMGRL commands
FAILOVER,
7.2
SWITCHOVER,
7.2
diagnostic information
sources,
9.1
DISABLE CONFIGURATION command,
7.2
example,
6.7.2.1
DISABLE DATABASE command,
7.2
example,
6.7.2.2
DISABLE FAST_START FAILOVER command,
5.5.5
,
7.2
DISABLE FAST_START FAILOVER CONDITION command,
7.2
disabling
broker configuration,
6.7.2
,
7.2
broker management of standby database,
7.2
databases,
3.5
,
6.7.2.1
,
6.7.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,
B.3
Oracle Enterprise Manager,
B.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 DATABASE (property) command,
7.2
example,
6.7.1.1
EDIT DATABASE (rename) command,
7.2
EDIT DATABASE (state) command,
7.2
example,
6.7.1.2
EDIT INSTANCE (AUTO PFILE) command,
7.2
EDIT INSTANCE (property) command,
7.2
editing
configurable properties,
7.2
database instance,
7.2
,
7.2
database name,
7.2
database properties,
7.2
database state,
7.2
protection modes,
7.2
effect of switchovers on,
5.3.3
e-mail
reporting events,
1.5.1
ENABLE CONFIGURATION command,
6.4
,
7.2
ENABLE DATABASE command,
7.2
ENABLE FAST_START FAILOVER command,
7.2
ENABLE FAST_START FAILOVER CONDITION command,
7.2
enabling
broker configuration,
3.4
,
6.4
,
6.4
,
6.4
databases in a broker configuration,
3.5
fast-start failover,
5.5.1
,
5.5.2
See also
each ENABLE command
Enterprise Edition database
installation,
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.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,
7.2
See also
QUIT command
F
failover
failing over to a standby database,
7.2
Oracle Enterprise Manager,
1.5.1
FAILOVER command,
6.9
,
7.2
failovers
and FastStartFailoverTarget property,
6.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
starting manually,
5.4.2
using DGMGRL,
6.9
failures
observer,
5.5.7.3
fast-start failover,
5.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
,
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.6
setting the FastStartFailoverThreshold property,
5.5.2
shutdown abort,
5.5.2.1
,
5.5.2.3
shutting down databases,
5.5.9
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.2.11
FastStartFailoverLagLimit property,
8.2.12
FastStartFailoverPmyShutdown property,
8.2.13
FastStartFailoverTarget property,
8.2.14
setting,
5.5.2
,
5.5.2
,
6.6
FastStartFailoverThreshold property,
8.2.15
setting,
5.5.2
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
,
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.6
START OBSERVER command,
7.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,
7.2
high availability
benefits,
1.2
levels of data protection,
4.6
,
8.2.23
LogXptMode property,
8.2.23
restoring after fast-start failover,
5.5.8
I
immediate failover,
5.4.1
,
7.2
InconsistentProperties property,
8.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
,
6.1
dynamic,
4.3.2
inconsistent,
8.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
,
7.2
prerequisites,
2.2
instances
failures,
5.5.2.1
objects
in a broker configuration,
1.3
removing,
7.2
,
7.2
,
7.2
restarting during the course of broker operations,
2.2
shutting down,
7.2
starting,
7.2
intended state
configuration health check,
3.6
invoking
the Data Guard command-line interface,
6.2
L
life cycle of a broker configuration,
3.4
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.5.1
Data Guard configuration,
3.1
delayed application of redo data,
4.5.1
delaying,
8.2.9
in an Oracle 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,
7.2
LOG_ARCHIVE_DEST_n initialization parameter
setting redo transport services,
4.4.5
setting the DELAY attribute,
8.2.9
setting the ENABLE and DEFER attributes,
8.2.22
setting the MANDATORY or OPTIONAL attributes,
8.2.5
LOG_ARCHIVE_FORMAT initialization parameter,
8.2.17
LOG_ARCHIVE_MAX_PROCESSES initialization parameter,
8.2.18
LOG_ARCHIVE_MIN_SUCCEED initialization parameter,
8.2.19
LOG_ARCHIVE_TRACE initialization parameter
setting LogArchiveTrace property,
8.2.20
LOG_FILE_NAME_CONVERT initialization parameter
setting LogFileNameConvert property,
8.2.21
LogArchiveFormat property,
8.2.17
LogArchiveMaxProcesses property,
8.2.18
LogArchiveMinSucceedDest property,
8.2.19
LogArchiveTrace property,
8.2.20
LogFileNameConvert property,
8.2.21
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,
8.2.22
LogXptMode property,
8.2.23
LogXptStatus property,
8.1.3
LsbyASkipCfgPr property,
8.2.24
LsbyASkipErrorCfgPr property,
4.5.5
,
8.2.25
LsbyASkipTxnCfgPr property,
8.2.26
LsbyDSkipCfgPr property,
8.2.27
LsbyDSkipErrorCfgPr property,
4.5.5
,
8.2.28
LsbyDSkipTxnCfgPr property,
8.2.29
LsbyFailedTxnInfo property,
8.1.4
LsbyMaxEventsRecorded property,
8.2.30
LsbyMaxServers property,
8.2.32
LsbyMaxSga property,
4.5.3
,
8.2.31
LsbyParameters property,
8.1.5
LsbyPreserveCommitOrder property,
4.5.3
,
8.2.33
LsbyRecordAppliedDdl property,
8.2.34
LsbyRecordSkipDdl property,
8.2.35
LsbyRecordSkipErrors property,
8.2.36
LsbySkipTable property,
8.1.6
LsbySkipTxnTable property,
8.1.7
M
management
benefits,
1.2
model,
1.3
Oracle Enterprise Manager,
1.5.1
managing
a broker configuration,
3
,
6
apply errors,
4.5.5
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,
8.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,
8.2.37
MaxFailure property,
8.2.38
maximize availability,
1.2
,
3.4
,
8.2.23
maximize data protection,
1.2
,
3.4
,
8.2.23
maximize performance,
1.2
,
3.4
,
8.2.23
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
database,
4.3.1
InconsistentProperties,
8.1.2
LogXptStatus,
8.1.3
,
8.1.3
LsbyFailedTxnInfo,
8.1.4
,
8.1.4
LsbyParameters,
8.1.5
LsbySkipTable,
8.1.6
LsbySkipTxnTable,
8.1.7
RecvQEntries,
8.1.8
SendQEntries,
8.1.9
StatusReport,
8.1.10
monitoring
broker configurations,
1.6.1
,
6
,
6.12
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,
8.2.39
networks
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,
6.7.2
properties for databases,
1.6.3
relationship,
1.3
observer,
5.5
and FastStartFailoverThreshold property,
5.5.2
connecting to the configuration,
6.6
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.6
monitoring,
5.5.2.1
,
5.5.2.1
shutting down,
5.5.9
using Oracle Wallet for connection credentials,
7.2
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.9
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
OPTIONAL attribute
set with the Binding property,
8.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,
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.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
,
7.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 Real Application Clusters
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
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.5.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
,
8.2.41
prerequisites
installation,
2.2
switchover,
5.3.1
primary database
ARCHIVELOG mode,
2.2
configuration,
3.1
connecting to,
6.2
,
6.2
constructing a standby database,
3.4
,
6.1
Data Guard configuration,
3.1
during failover,
1.5.1
during switchover,
5.3.3
Flashback Database,
5.4.3.1
health check,
4.9
preparing for switchover,
5.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,
7.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.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,
7.2
downgrading,
4.6.2.1
redo transport services setup,
8.2.23
setting for a broker configuration,
4.6
updating,
3.4
upgrading,
4.6.2.1
Q
QUIT command,
7.2
See also
EXIT command
R
raw devices
and broker configuration files,
3.2.2.3
sizing,
3.2.2.3
RecvQEntries property,
8.1.8
Redo Apply,
3.1
,
5.3.3
redo transport services
ASYNC mode,
4.4.2
,
8.2.23
configuring,
1.5.1
data protection modes,
8.2.23
Data Guard configuration,
3.1
LogShipping property,
8.2.22
managing,
4.4
SYNC mode,
4.4.2
,
8.2.23
tuning,
4.4.5
turning off,
4.4.3
turning on,
4.4.3
verifying,
1.2
RedoCompression property,
8.2.42
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
relationship
objects in a broker configuration,
1.3
REMOVE CONFIGURATION command,
7.2
example,
6.7.3
REMOVE DATABASE command,
7.2
REMOVE INSTANCE command,
7.2
removing
a standby database,
4.6.2.5
See
each REMOVE command
ReopenSecs property,
8.2.43
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
S
scripts
using Data Guard command-line interface (DGMGRL),
7
selecting the apply instance,
4.5.7.1
SendQEntries property,
8.1.9
server parameter file
broker property management,
1.6.3
,
2.2
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,
4.5.7.1
setting
configuration protection mode,
4.6.1
database properties,
6.3
log apply services,
4.4.4
redo transport services,
4.4.5
SGA memory
and SQL Apply,
4.5.3
SHOW CONFIGURATION command,
6.2
,
6.2
,
6.4
,
7.2
SHOW CONFIGURATION VERBOSE
example,
5.5.4
SHOW DATABASE command,
7.2
SHOW DATABASE VERBOSE command
displaying properties,
4.3
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.2.44
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
error handling
and logical standby databases,
4.5.5
filters
and logical standby databases,
4.5.4
standby databases
choosing a target standby database,
5.2
constructing from backups,
3.4
,
6.1
creating,
1.5.1
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
removing,
4.6.2.5
,
7.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,
7.2
standby redo log files
setting up,
4.6.1
setting up with DGMGRL,
4.6.1
StandbyArchiveLocation property,
8.2.45
setting log apply services,
4.4.4
StandbyFileManagement property,
8.2.46
START OBSERVER command
fast-start failover configuration file (fsfo.dat),
5.5.7.6
starting
Data Guard command-line interface (DGMGRL),
6.2
,
7.1
Data Guard monitor (DMON),
3.3
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.5
changing,
6.7
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.2.47
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
status messages
ORA-16661,
5.4.3
,
5.4.3
ORA-16795,
5.4.3
StatusReport property,
4.9
,
8.1.10
string values
Data Guard command-line interface,
7.1.3
supported broker configuration,
1.3
SWITCHOVER command,
6.8
,
7.2
switchovers
benefits,
1.2
broker tasks,
5.3.3
choosing a target standby database,
5.2
DGMGRL SWITCHOVER command,
6.8
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.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
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,
6.2
to connect to the database,
7.1.3
T
target standby database
choosing,
5.2
disabling fast-start failover on,
5.5.5
setting with the FastStartFailoverTarget property,
5.5.2
,
6.6
TopWaitEvents property,
8.1.11
transaction commit order
controlling,
4.5.3
TRANSPORT-OFF state
LogShipping property setting,
8.2.22
TRANSPORT-ON state
setting LogShipping property,
8.2.22
troubleshooting
Data Guard,
9
diagnostics logged in broker drc* log files,
9.1
tuning
redo transport services,
4.4.5
two-way communication channel,
1.6.1
U
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
fast-start failover environment,
5.5.2
viewing
property information about databases,
4.3.1
,
8.1
W
warning status,
3.6
wizards
Add Standby Database,
1.5.1
Scripting on this page enhances content navigation, but does not change the content in any way.