Go to main content
19/19
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
1
ADD FAR_SYNC command
1
Add Standby Database wizard
creating a broker configuration
1
definition
1
introduction
1
altering
properties
database
1
states
database
1
,
2
AlternateLocation property
setting log apply services
1
application continuity
support in Oracle Data Guard broker
1
application integration
1
apply instance
failover
1
PreferredApplyInstance property
1
selecting
1
ApplyInstanceTimeout property
1
ApplyLagThreshold property
1
ApplyParallel property
1
architecture
Data Guard broker
1
ARCHIVE_LAG_TARGET initialization parameter
setting in a broker configuration
1
archived redo logs
destination and configuration parameters
1
in a Data Guard configuration
1
primary database setup
1
ArchiveLagTarget property
1
ASYNC redo transport service
1
Automatic Storage Management (ASM)
creating a standby database that uses
1
B
background processes
DMON
1
banners
suppressing from DGMGRL command-line interface output
1
before you perform a switchover
1
before you use DGMGRL
1
benefits
Data Guard broker
1
high availability
1
scalability
1
with Oracle Real Application Clusters
1
Binding property
1
broker
components
1
configuration
1
Data Guard configuration file
1
drc* log files
1
installation
1
introduction
1
user interfaces
1
broker configurations
benefits
1
changing roles
1
creating
1
Data Guard configuration file
1
disabling databases
1
,
2
effects of removing metadata from
1
enabling
1
,
2
enabling databases
1
,
2
,
3
,
4
enabling fast-start failover
1
health
1
,
2
life cycle
1
management
1
,
2
,
3
monitoring
1
Oracle Net Services configuration
1
,
2
properties
1
protection modes
1
setting protection mode
1
status modes
1
supported
1
BystandersFollowRoleChange property
1
bystander standby databases
reintegrating into configuration
1
C
CDBs
Data Guard broker support
1
CFS
See:
cluster file system
changing
properties
databases in a broker configuration
1
,
2
roles
within the broker configuration
1
states
databases in a broker configuration
1
of databases in a broker configuration
1
cluster file system (CFS)
broker configuration files
1
command-line interface
See:
Data Guard command-line interface (DGMGRL)
command prompts
suppressing from DGMGRL command-line interface output
1
CommunicationTimeout property
1
complete failover
1
,
2
components
broker
1
Data Guard configuration
1
configurable properties
AlternateLocation
1
ApplyInstanceTimeout
1
ApplyLagThreshold
1
ApplyParallel
1
ArchiveLagTarget
1
Binding
1
database
1
,
3
DbFileNameConvert
1
DelayMins
1
DGConnectIdentifier
1
FastStartFailoverTarget
1
LogArchiveFormat
1
LogArchiveMaxProcesses
1
LogArchiveMinSucceedDest
1
LogArchiveTrace
1
LogFileNameConvert
1
LogShipping
1
LogXptMode
1
LsbyMaxEventsRecorded
1
LsbyMaxServers
1
LsbyMaxSga
1
LsbyPreserveCommitOrder
1
LsbyRecordAppliedDdl
1
LsbyRecordSkipDdl
1
LsbyRecordSkipErrors
1
managing redo transport services
1
MaxConnections
1
MaxFailure
1
NetTimeout
1
ObserverConnectIdentifier
1
PreferredApplyInstance
1
RedoCompression
1
RedoRoutes
1
ReopenSecs
1
SidName
1
StandbyArchiveLocation
1
StandbyFileManagement
1
StaticConnectIdentifier
1
TransportDisconnectedThreshold
1
TransportLagThreshold
1
configuration files
fast-start failover configuration (fsfo.dat) file
1
See Also Data Guard configuration file
1
configuration properties
BystandersFollowRoleChange
1
CommunicationTimeout
1
FastStartFailoverAutoReinstate
1
FastStartFailoverLagLimit
1
FastStartFailoverPmyShutdown
1
FastStartFailoverThreshold
1
ObserverOverride
1
ObserverReconnect
1
OperationTimeout
1
PrimaryLostWriteAction
1
Tracelevel
1
connecting
privileges required for Data Guard broker configurations
1
starting the observer
1
controlling
available SGA memory
1
CONVERT DATABASE command
1
CREATE CONFIGURATION command
1
creating
a broker configuration
with the Add Standby Database wizard
1
a standby database
1
D
database resources
monitoring
1
databases
changing the state of
1
creating and adding to a broker configuration
1
dependencies
1
disabling management of
1
during
fast-start failover
1
manual failover
1
switchover
1
enabling
1
health
1
installation for broker management
1
monitorable properties
1
network setup
1
,
2
prerequisites for broker configurations
1
properties
1
,
2
,
3
property management
1
reenabling after a role transition
1
restarting
after fast-start failover
1
shutting down
effect on fast-start failover
1
,
2
states
dependencies
1
transitions
1
status
1
Data Guard
troubleshooting
1
Data Guard broker
See Also broker
1
Data Guard command-line interface
commands
ENABLE FAST_START FAILOVER
1
SET STATE
1
DG_BROKER_START initialization parameter
1
enabling a database
1
introduction
1
Data Guard command-line interface (DGMGRL)
banners from output
1
commands
ADD DATABASE
1
ADD FAR_SYNC
1
CONVERT DATABASE
1
CREATE CONFIGURATION
1
DISABLE CONFIGURATION
1
DISABLE DATABASE
1
DISABLE FAR_SYNC
1
,
2
DISABLE FAST_START FAILOVER
1
DISABLE FAST_START FAILOVER CONDITION
1
EDIT CONFIGURATION (property)
1
EDIT CONFIGURATION (protection mode)
1
EDIT CONFIGURATION (RENAME)
1
,
2
EDIT CONFIGURATION RESET (Property)
1
,
2
EDIT DATABASE (Property)
1
,
2
EDIT DATABASE (rename)
1
EDIT DATABASE (state)
1
EDIT DATABASE RESET (Property)
1
EDIT FAR_SYNC
1
EDIT FAR_SYNC RESET (Property)
1
EDIT INSTANCE (AUTO PFILE)
1
EDIT INSTANCE (property)
1
,
2
EDIT INSTANCE RESET (Property)
1
ENABLE CONFIGURATION
1
ENABLE DATABASE
1
ENABLE FAR_SYNC
1
ENABLE FAST_START FAILOVER
1
ENABLE FAST_START FAILOVER CONDITION
1
EXIT
1
FAILOVER
1
HELP
1
QUIT
1
REINSTATE DATABASE
1
REMOVE CONFIGURATION
1
REMOVE DATABASE
1
REMOVE FAR_SYNC
1
REMOVE INSTANCE
1
SHOW CONFIGURATION
1
,
2
SHOW DATABASE
1
SHOW FAR_SYNC
1
SHOW FAST_START FAILOVER
1
SHOW INSTANCE
1
SHUTDOWN
1
SQL
1
START OBSERVER
1
STARTUP
1
STOP OBSERVER
1
SWITCHOVER
1
,
2
VALIDATE DATABASE
1
VALIDATE FAR_SYNC
1
creating a configuration
1
DG_BROKER_START initialization parameter
1
enabling the configuration
1
monitoring broker configurations
1
performing routine management tasks
1
prerequisites
1
setting critical database properties
1
setting up standby redo log files
1
single command mode
1
starting
1
stopping
1
string values
1
summary of commands
1
suppressing command prompts
1
Data Guard configuration file
for an Oracle RAC database
1
in a CFS area
1
inconsistent values from server parameter file
1
relationship to DMON process
1
setting up
1
Data Guard configurations
automated creation of
1
background
1
Data Guard monitor (DMON)
interaction with the Oracle database
1
managing objects
1
,
2
,
3
Oracle database background processes
1
overview
1
two-way network communication
1
data protection modes
See:
protection modes
DBA_LOGSTDBY_EVENTS table
managing
1
DbFileNameConvert property
1
DBMS_DG package
using to direct fast-start failover
1
delaying
application of redo data with DelayMins property
1
DelayMins property
1
destinations
archived redo log file parameters
1
viewing the LogXptStatus property
1
DG_BROKER_CONFIG_FILEn file
in a CFS area
1
DG_BROKER_START initialization parameter
1
,
2
,
3
DGConnectIdentifier property
1
DGMGRL
reinstating a database
1
diagnostic information
sources
1
DISABLE CONFIGURATION command
example
1
DISABLE DATABASE command
example
1
DISABLE FAR_SYNC command
1
,
2
DISABLE FAST_START FAILOVER command
1
DISABLE FAST_START FAILOVER CONDITION command
1
disabling
broker configuration
1
,
2
broker management of standby database
1
databases
1
fast-start failover
on a standby database
1
disaster protection
benefits
1
displaying
configuration information
1
help for DGMGRL commands
1
distributed management framework
1
DMON
See:
Data Guard monitor (DMON)
downgrading
Data Guard
1
Oracle Enterprise Manager
1
protection mode
1
drc* log files
broker diagnostic information
1
during reinstatement
1
recording failed reinstatement
1
E
EDIT CONFIGURATION (Property) command
1
EDIT CONFIGURATION (protection mode) command
1
EDIT CONFIGURATION (RENAME) command
1
,
2
EDIT CONFIGURATION RESET (Property) command
1
,
2
EDIT DATABASE (property) command
example
1
EDIT DATABASE (Property) command
1
,
2
EDIT DATABASE (rename) command
1
EDIT DATABASE (state) command
example
1
EDIT DATABASE RESET (Property) command
1
EDIT FAR_SYNC command
1
EDIT FAR_SYNC RESET (Property) command
1
editing
configurable properties
1
database instance
1
,
2
,
3
database name
1
database state
1
protection modes
1
EDIT INSTANCE (AUTO PFILE) command
1
EDIT INSTANCE (property) command
1
,
2
EDIT INSTANCE RESET (Property) command
1
effect of switchovers on
1
e-mail
reporting events
1
ENABLE CONFIGURATION command
1
,
2
ENABLE DATABASE command
1
ENABLE FAR_SYNC command
1
ENABLE FAST_START FAILOVER command
1
ENABLE FAST_START FAILOVER CONDITION command
1
enabling
broker configuration
1
,
2
Enterprise Edition database
installation
1
Enterprise Manager
Fast-Start Failover wizard
disabling fast-start failover
1
wizards
automate standby database creation
1
error messages
ORA-16795
1
error status
1
events
managing
in a logical standby database
1
monitoring with Oracle Enterprise Manager
1
Oracle Enterprise Manager
1
reporting
1
responding to
1
EXIT command
1
,
2
See also:
QUIT command
F
failover
failing over to a standby database
1
Oracle Enterprise Manager
1
FAILOVER command
1
,
2
failovers
benefits
1
broker tasks
1
choosing a target standby database
1
complete
1
fast-start failover
1
immediate
1
managing
fast-start
1
manual
1
manual
complete option
1
effect on data protection mode
1
immediate option
1
reenabling disabled databases after
1
starting manually
1
using DGMGRL
1
failures
observer
1
far sync instances
managing
1
fast-start failover
configuration information in the fsfo.dat file
1
defined
1
DGMGRL client as the observer
1
directed from an application
1
disabling
to perform manual failover
1
enabling
1
instance failures
1
monitoring by the observer
1
observer overview
1
performing manual failovers when enabled
1
performing switchover when enabled
1
querying V$DATABASE
1
reinstating the former primary database
1
restarting databases after shut down
1
setting the FastStartFailoverThreshold property
1
shutdown abort
1
,
2
to Oracle RAC database instances
1
unobserved
1
viewing failover configuration statistics
1
FastStartFailoverAutoReinstate property
1
FastStartFailoverLagLimit property
1
FastStartFailoverPmyShutdown property
1
FastStartFailoverTarget property
1
FastStartFailoverThreshold property
setting
1
FASTSYNC redo transport mode
1
FASTSYNC redo transport service
1
files
naming the server parameter file
1
Flashback Database
reinstating databases
1
use after failover
1
flashback logs
reinstating a failed primary database
1
FORCE option
performing a manual failover
1
FS_FAILOVER_OBSERVER_HOST column
of V$DATABASE view
1
FS_FAILOVER_OBSERVER_PRESENT column
of V$DATABASE view
1
FS_FAILOVER_STATUS column
of V$DATABASE view
failed reinstatement
1
FSFO.DAT file
overview
1
H
health check
monitoring
1
on primary database
1
on standby database
1
revealed by configuration status
1
HELP command
1
high availability
benefits
1
levels of data protection
1
,
2
LogXptMode property
1
restoring after fast-start failover
1
I
immediate failover
1
,
2
InconsistenLogXptProps property
1
InconsistentProperties property
1
increased scalability
benefits
1
initialization parameters
database configurable properties
1
DG_BROKER_CONFIG_FILEn
1
DG_BROKER_START
1
,
2
dynamic
1
static
1
installation
ARCHIVELOG mode setup
1
Data Guard
1
Oracle Enterprise Manager
1
Oracle Instant Client
1
,
2
prerequisites
1
instances
failures
1
removing
1
,
2
shutting down
1
starting
1
intended state
configuration health check
1
L
life cycle of a broker configuration
1
log apply services
and apply instance failover
1
and parallel apply
1
apply instance
1
configuring
1
Data Guard configuration
1
delayed application of redo data
1
delaying
1
in an Oracle RAC database
1
managing
1
selecting the apply instance
1
verifying
1
LogArchiveFormat property
1
LogArchiveMaxProcesses property
1
LogArchiveMinSucceedDest property
1
LogArchiveTrace property
1
LogFileNameConvert property
1
log files
broker
1
logical standby databases
managing events
1
SQL Apply
1
state transitions
1
switchover to the primary role
1
LogShipping property
1
LogXptMode property
1
LogXptStatus property
1
LsbyFailedTxnInfo property
1
LsbyMaxEventsRecorded property
1
LsbyMaxServers property
1
LsbyMaxSga property
1
LsbyParameters property
1
LsbyPreserveCommitOrder property
1
LsbyRecordAppliedDdl property
1
LsbyRecordSkipDdl property
1
LsbyRecordSkipErrors property
1
M
management
benefits
1
Oracle Enterprise Manager
1
managing
a broker configuration
1
,
2
databases
1
DBA_LOGSTDBY_EVENTS table
1
events
in a logical standby database
1
fast-start failover
1
local operations
1
log apply services
1
manual failover
1
parallel apply in a physical standby database
1
remote operations
1
roles
fast-start failover
1
manual failover
1
switchover
1
switchover
1
manual failover
complete option
1
effect on protection modes
1
immediate option
1
performing when fast-start failover is enabled
1
,
2
starting
1
manual role changes
performing when fast-start failover is enabled
1
MaxConnections property
1
MaxFailure property
1
maximize availability
1
,
2
,
3
maximize data protection
1
,
2
,
3
maximize performance
1
,
2
,
3
maximum availability
data protection mode
1
maximum performance
data protection mode
1
maximum protection
data protection mode
1
monitorable properties
InconsistentLogXptProps
1
InconsistentProperties
1
LogXptStatus
1
LsbyFailedTxnInfo
1
LsbyParameters
1
RecvQEntries
1
SendQEntries
1
TopWaitEvents
1
monitoring
broker configurations
1
,
2
,
3
local and remote databases
1
Oracle Enterprise Manager performance page
1
through the command-line interface
1
multitenant container databases
See CDBs
1
N
NetTimeout property
1
networks
Data Guard configuration
1
setting up files
1
two-way communication
1
normal status
1
O
objects
broker configuration
1
disabling
1
observer
and FastStartFailoverThreshold property
1
connecting to the configuration
1
connection to the local computer
1
detecting
database shutdown
1
,
2
instance failures
1
failures
1
finding host machine name
1
installing Oracle Instant Client kit
1
,
2
lost connection
1
maintaining fast-start failover configuration information
1
monitoring
1
using Oracle Wallet for connection credentials
1
ObserverConnectIdentifier property
1
ObserverOverride property
1
ObserverReconnect property
1
operations
complete failover
1
disable broker management
effect on protection modes
1
downgrade
effect on protection modes
1
effect on protection modes
1
enable broker management
effect on protection modes
1
failover
1
immediate failover
1
manual failover
effect on protection modes
1
removing a database from the configuration
effect on protection modes
1
OperationTimeout property
1
ORA-16661 message
reinstating a database
1
,
3
ORA-16795 message
re-creating a database
1
Oracle Clusterware
and instances of an Oracle RAC database
1
integration with Data Guard broker
1
recover failed instances
1
Oracle Enterprise Manager
Add Standby Database wizard
1
database property pages
1
downgrading
1
event management system
1
integration
1
integration with the Data Guard monitor
1
introduction
1
,
2
making Oracle Net Services configuration changes
1
,
2
monitoring events
1
performance tools and graphs
1
upgrading
1
wizards
creating standby databases
1
Oracle Instant Client
installing
1
,
2
Oracle Managed Files (OMF)
creating a standby database that uses
1
Oracle Net Services
configuration changes
1
,
2
installation prerequisites
1
supported configuration
1
two-way communication
1
Oracle RAC One Node
supported by Oracle Data Guard broker
1
Oracle Real Application Clusters
and log apply services
1
and setting the apply instance
1
availability of instances with Oracle Clusterware
1
benefits
1
fast-start failover
1
observer behavior in
1
observer connection to instances
1
Oracle Clusterware
1
Oracle Universal Installer
installing Oracle Instant Client
1
,
2
Oracle Wallet
starting the observer
1
P
parallel apply
and log apply services
1
managing in a physical standby database
1
performance
Oracle Enterprise Manager tools
1
physical standby databases
managing parallel apply
1
state transitions
1
switchover to the primary role
1
PreferredApplyInstance property
1
prerequisites
installation
1
switchover
1
primary database
ARCHIVELOG mode
1
constructing a standby database
1
,
2
Data Guard configuration
1
during failover
1
during switchover
1
Flashback Database
1
health check
1
preparing for switchover
1
reinstating after a fast-start failover
1
state transitions
1
switching over to the standby role
1
PrimaryLostWriteAction property
1
processes
DMON
1
Oracle database
1
properties
configurable
1
database
1
managing
1
monitorable
1
setting
in server parameter file
1
,
2
property pages
database
1
protection modes
after a failover
1
,
2
benefits
1
configuration
1
,
2
,
3
downgrading
1
redo transport services setup
1
setting for a broker configuration
1
updating
1
upgrading
1
Q
QUIT command
1
,
2
See also:
EXIT command
R
RecvQEntries property
1
Redo Apply
1
,
2
RedoCompression property
1
RedoRoutes property
1
redo transport services
ASYNC mode
1
configuring
data protection modes
1
Data Guard configuration
1
FASTSYNC mode
1
,
2
managing
1
SYNC mode
1
tuning
1
turning off
1
turning on
1
verifying
1
REINSTATE DATABASE command
1
reinstatement
failure logged in broker drc* log files
1
Flashback Database requirement
1
flashback logs requirement
1
how to
1
logged in broker log files
1
ORA-16661 message
1
,
3
using DGMGRL
1
using Enterprise Manager
1
REMOVE CONFIGURATION command
example
1
REMOVE DATABASE command
1
REMOVE FAR_SYNC command
1
REMOVE INSTANCE command
1
removing
a standby database
1
ReopenSecs property
1
requests
passing between sites
1
restarting
databases
when fast-start failover is enabled
1
role transitions
changing
1
managing
fast-start failover
1
manual failover
1
switchover
1
S
scripts
using Data Guard command-line interface (DGMGRL)
1
selecting the apply instance
1
SendQEntries property
1
server parameter file
broker property management
1
,
2
filenames
1
inconsistent values from Data Guard configuration file
1
server-side software
1
SET STATE command
and setting the apply instance
1
setting
configuration protection mode
1
database properties
1
log apply services
1
redo transport services
1
SGA memory
and SQL Apply
1
SHOW CONFIGURATION command
1
,
2
,
3
SHOW DATABASE command
1
SHOW FAR_SYNC command
1
SHOW FAST_START FAILOVER command
1
showing
See:
each SHOW command
SHOW INSTANCE command
1
shutdown abort
effect on fast-start failover
1
SHUTDOWN command
1
shutting down an Oracle instance
1
SidName property
1
single command mode
for Data Guard command-line interface
1
SQL Apply
and logical standby databases
1
effect of switchovers on
1
SQL command
1
SQL statements
executing from DGMGRL command line
1
StandbyArchiveLocation property
setting log apply services
1
standby databases
choosing a target standby database
1
constructing from backups
1
,
2
creating
if primary database uses ASM or OMF
1
health check
1
not involved in a switchover
1
reenabling after failover
1
removing
1
specifying the location of archived redo logs
1
switching over to the primary role
1
StandbyFileManagement property
1
standby redo log files
setting up with DGMGRL
1
starting
Data Guard command-line interface (DGMGRL)
1
Data Guard monitor (DMON)
1
manual failover
1
Oracle instance
1
switchover
1
START OBSERVER command
fast-start failover configuration file (fsfo.dat)
1
STARTUP command
1
states
changing
1
database
1
database transitions
1
state transitions
effect on database states
1
logical standby database
1
physical standby database
1
primary database
1
StaticConnectIdentifier property
1
status
configuration
1
health check on primary database
1
health check on standby database
1
health of the database
1
intended state of a configuration
1
status messages
ORA-16661
1
ORA-16795
1
STOP OBSERVER command
1
,
2
string values
Data Guard command-line interface
1
SWITCHOVER command
1
,
2
switchovers
benefits
1
broker tasks
1
choosing a target standby database
1
DGMGRL SWITCHOVER command
1
effect on
database startup
1
primary database
1
protection modes
1
standby databases not involved in the switchover
1
managing
1
,
2
overview
Oracle Enterprise Manager
1
performing when fast-start failover is enabled
1
preparing the primary database
1
prerequisites
1
reenabling disabled standby databases
1
starting
1
transitioning
a logical standby database to the primary role
1
a physical standby database to the primary role
1
using the DGMGRL SWITCHOVER command
1
SYNC redo transport mode
1
SYSDBA privileges
to connect to the database
1
T
target standby database
choosing
1
disabling fast-start failover on
1
TopWaitEvents property
1
TraceLevel property
1
transaction commit order
controlling
1
TransportDisconnectedThreshold property
1
TransportLagThreshold property
1
TRANSPORT-ON state
setting LogShipping property
1
troubleshooting
Data Guard
1
diagnostics logged in broker drc* log files
1
tuning
redo transport services
1
two-way communication channel
1
U
unobserved configuration
1
updating configuration properties
1
upgrading
Data Guard
1
,
2
Oracle Enterprise Manager
1
protection mode
1
user interfaces
overview
1
V
V$DATABASE view
fast-start failover columns
1
FS_FAILOVER_OBSERVER_HOST column
1
FS_FAILOVER_OBSERVER_PRESENT column
1
viewing
fast-start failover statistics
1
V$FS_FAILOVER_STATS view
1
VALIDATE DATABASE command
1
VALIDATE FAR_SYNC command
1
W
warning status
1
wizards
Add Standby Database
1
Scripting on this page enhances content navigation, but does not change the content in any way.