Go to main content
21/21
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
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.6
DelayMins,
9.2.7
Dependency,
9.2.8
FastStartFailoverTarget,
9.2.9
FastStartFailoverThreshold,
9.2.10
FastStartFailoverThreshold property,
8.2
HostName,
9.2.11
InitialConnectIdentifier,
9.2.12
LocalListenerAddress,
9.2.13
LogArchiveFormat,
9.2.14
LogArchiveMaxProcesses,
9.2.15
LogArchiveMinSucceedDest,
9.2.16
LogArchiveTrace,
9.2.17
LogFileNameConvert,
9.2.18
LogShipping,
9.2.19
LogXptMode,
9.2.20
LsbyASkipCfgPr,
9.2.21
LsbyASkipErrorCfgPr,
9.2.22
LsbyASkipTxnCfgPr,
9.2.23
LsbyDSkipCfgPr,
9.2.24
LsbyDSkipErrorCfgPr,
9.2.25
LsbyDSkipTxnCfgPr,
9.2.26
LsbyMaxEventsRecorded,
9.2.27
LsbyMaxServers,
9.2.29
LsbyMaxSga,
9.2.28
LsbyRecordAppliedDdl,
9.2.30
LsbyRecordSkipDdl,
9.2.31
LsbyRecordSkipErrors,
9.2.32
LsbyTxnConsistency,
9.2.33
managing redo transport services,
4.4
MaxConnections,
9.2.34
MaxFailure,
9.2.35
NetTimeout,
9.2.36
PreferredApplyInstance,
9.2.37
ReopenSecs,
9.2.38
SidName,
9.2.39
StandbyArchiveLocation,
9.2.40
StandbyFileManagement,
9.2.41
TopWaitEvents,
9.1.11
configuration files
fast-start failover configuration (fsfo.dat) file,
5.5.6.6
located on raw devices,
3.2.1
See Also
Data Guard configuration file
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
to the standby database,
4.4.6
connection credentials
using Oracle Wallet,
7.6
controlling
available SGA memory,
4.5.3
transaction consistency level,
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
,
8.2
D
Data Guard
troubleshooting,
10
Data Guard broker
changed features,
A
deprecated features,
A
integration with Oracle Enterprise Manager,
6.1
See Also
broker
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
ADD DATABASE,
8.2
CONNECT,
8.2
CREATE CONFIGURATION,
8.2
DISABLE CONFIGURATION,
8.2
DISABLE DATABASE,
8.2
DISABLE FAST_START FAILOVER,
5.5.4
,
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
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 INSTANCE,
8.2
SHUTDOWN,
8.2
STARTUP,
8.2
SWITCHOVER,
7.8
,
8.2
creating
a standby database,
8.2
and adding a primary database,
8.2
creating a configuration,
7.2
DG_BROKER_START initialization parameter,
8.1.3
enabling the configuration,
7.4
FAILOVER command,
5.4.2
FSFO.DAT file creation,
8.2
monitoring broker configurations,
7.10
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
in a broker configuration,
3.1
in a Data Guard configuration,
3.1
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
running on each location,
3.1
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.7
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.8
after manual failover,
8.2
shutting down
effect on fast-start failover,
5.5.2.1
,
5.5.2.3
,
5.5.8
states,
4.2
dependencies,
4.2
transitions,
4.2.1
status,
4.7
DB_FILE_NAME_CONVERT initialization parameter
initialization parameters
setting DB_FILE_NAME_CONVERT in a broker configuration,
9.2.6
DB_ROLE_CHANGE system event,
5.1
DB_UNIQUE_NAME initialization parameter,
4.4.6
db_unique_name_DGMGRL static service name
registering,
2.2
db_unique_name_XPT static service name,
4.4.6
DBA_LOGSTDBY_EVENTS table
managing,
4.5.6
DbFileNameConvert property,
9.2.6
delaying
application of redo data with DelayMins property,
4.5.1
DelayMins property,
9.2.7
delaying log apply services,
4.5.1
Dependency property,
4.4.4
,
9.2.8
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.1
,
2.2
,
7.1
,
8.1.3
DGMGRL
See
Data Guard command-line interface (DGMGRL)
DGMGRL commands
FAILOVER,
8.2
SWITCHOVER,
8.2
diagnostic information
sources,
10.1
diagrams of database state transitions,
4.2.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.4
,
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.4
,
8.2
on a standby database,
5.5.4
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.4
Oracle Enterprise Manager,
B.4
protection mode,
4.6.2.1
drc* log files
broker diagnostic information,
10.1
during reinstatement,
5.5.3
recording failed reinstatment,
5.5.7.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
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.4
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
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
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
INSTANCE_NAME initialization parameter,
4.4.6
instances
failures,
5.5.2.1
objects
in a broker configuration,
1.3
removing,
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
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
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
See also
EXIT command
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
Scripting on this page enhances content navigation, but does not change the content in any way.