Index
A
- ADD DATABASE command 7.5
- ADD FAR_SYNC command 7.6
- Add Standby Database wizard
- altering
- AlternateLocation property 8.3.1
- application continuity
- support in Oracle Data Guard broker 5.6.1.4
- application integration 1.2
- apply instance 4.6.4
- ApplyInstanceTimeout property 8.3.4
- ApplyLagThreshold property 8.3.5
- ApplyParallel property 8.3.6
- architecture
- Data Guard broker 1.3
- ARCHIVE_LAG_TARGET initialization parameter
- setting in a broker configuration 8.3.7
- archived redo logs
- ArchiveLagTarget property 8.3.7
- ArchiveLocation property 8.3.2
- ASYNC redo transport service 4.4.2
B
- background processes
- DMON 1.5.1
- banners
- suppressing from DGMGRL command-line interface output 7.1.1
- batch programs
- using Data Guard command-line interface (DGMGRL) 7
- before you perform a switchover 5.3.1
- before you use DGMGRL 6.1
- benefits
- Binding property 8.3.8
- broker
- broker configuration
- broker configurations
- benefits 1.2
- changing roles 3.5
- creating 6.2
- Data Guard configuration file 1.5.1
- disabling databases 3.6, 7.11
- effects of removing metadata from 7.50
- enabling 6.4, 7.35
- enabling databases 3.5, 3.6, 6.4, 7.35
- enabling fast-start failover 7.38
- health 1.5.1, 3.7
- life cycle 3.5
- management 1.4.1, 1.4.2, 1.5.2
- monitoring 6.14
- Oracle Net Services configuration 1.2, 1.4.1
- properties 4.3
- protection modes 7.18
- setting protection mode 4.7.1
- status modes 3.7
- supported 3.1
- broker processes
- monitoring 1.5.1
- BystandersFollowRoleChange property 8.1.1
- bystander standby databases 5.3
- reintegrating into configuration 5.4.2.5
C
- CDBs
- Data Guard broker support 1.1.3
- CFS
- See: cluster file system
- changing 7.17, 7.18
- cluster file system (CFS)
- broker configuration files 3.3.2.1
- command-line interface
- See: Data Guard command-line interface (DGMGRL)
- command prompts
- suppressing from DGMGRL command-line interface output 7.1.1
- CommunicationTimeout property 8.1.2
- complete failover 5.4.1, 7.43
- components
- configurable properties 4.3
- AlternateLocation 8.3.1
- ApplyInstanceTimeout 8.3.4
- ApplyLagThreshold 8.3.5
- ApplyParallel 8.3.6
- ArchiveLagTarget 8.3.7
- ArchiveLocation 8.3.2
- Binding 8.3.8
- database 4.3.2, 8.3
- DbFileNameConvert 8.3.10
- DelayMins 8.3.11
- DGConnectIdentifier 8.3.12
- FastStartFailoverTarget 8.3.14
- InstanceName 8.3.15
- LogArchiveFormat 8.3.16
- LogArchiveMaxProcesses 8.3.17
- LogArchiveMinSucceedDest 8.3.18
- LogArchiveTrace 8.3.19
- LogFileNameConvert 8.3.20
- LogShipping 8.3.21
- LogXptMode 8.3.22
- LsbyMaxEventsRecorded 8.3.23
- LsbyMaxServers 8.3.24
- LsbyMaxSga 8.3.25
- LsbyPreserveCommitOrder 8.3.26
- LsbyRecordAppliedDdl 8.3.27
- LsbyRecordSkipDdl 8.3.28
- LsbyRecordSkipErrors 8.3.29
- managing redo transport services 4.4
- MaxFailure 8.3.30
- NetTimeout 8.3.31
- ObserverConnectIdentifier 8.3.32
- PreferredApplyInstance 8.3.33
- RedoCompression 8.3.35
- RedoRoutes 8.3.36
- ReopenSecs 8.3.37
- resetting to default values 4.3.2.1
- StandbyAlternateLocation 8.3.38
- StandbyArchiveLocation 8.3.39
- StandbyFileManagement 8.3.40
- StaticConnectIdentifier 8.3.41
- TransportDisconnectedThreshold 8.3.42
- TransportLagThreshold 8.3.43
- configuration files
- configuration properties 3.2
- BystandersFollowRoleChange 8.1.1
- CommunicationTimeout 8.1.2
- FastStartFailoverAutoReinstate 8.1.6
- FastStartFailoverLagLimit 8.1.7
- FastStartFailoverPmyShutdown 8.1.8
- FastStartFailoverThreshold 8.1.9
- ObserverOverride 8.1.10
- ObserverReconnect 8.1.11
- OperationTimeout 8.1.12
- PrimaryLostWriteAction 8.1.14
- Tracelevel 8.1.15
- connecting
- CONVERT DATABASE command 7.9
- CREATE CONFIGURATION command 7.10
- creating
D
- database resources
- monitoring 1.2
- databases
- changing the state of 6.9
- creating and adding to a broker configuration 1.4.1
- dependencies 4.2
- disabling management of 7.11
- during
- enabling 6.4
- health 4.11
- installation for broker management 2.2
- monitorable properties 4.3.1
- network setup 1.5.1, 2.2
- properties 1.4.1, 4.3.2
- property management 1.5.3
- reenabling after a role transition 5.4.3
- restarting
- after fast-start failover 5.5.9
- shutting down
- states 4.2
- status 4.11
- database status
- querying 4.11.1
- Data Guard
- troubleshooting 9
- Data Guard broker
- See Also broker 1.1.2
- Data Guard command line interface
- Data Guard command-line interface
- Data Guard command-line interface (DGMGRL)
- banners from output 7.1.1
- commands
- ADD DATABASE 7.5
- ADD FAR_SYNC 7.6
- CONVERT DATABASE 7.9
- CREATE CONFIGURATION 7.10
- DISABLE CONFIGURATION 7.11
- DISABLE DATABASE 7.12
- DISABLE FAR_SYNC 7.10, 7.13
- DISABLE FAST_START FAILOVER 7.14
- DISABLE FAST_START FAILOVER CONDITION 7.15
- EDIT CONFIGURATION (property) 7.17
- EDIT CONFIGURATION (protection mode) 7.18
- EDIT CONFIGURATION (RENAME) 7.10, 7.19
- EDIT CONFIGURATION RESET (Property) 7.10, 7.20
- EDIT DATABASE (Property) 7.10, 7.21
- EDIT DATABASE (rename) 7.23
- EDIT DATABASE (state) 7.24
- EDIT DATABASE RESET (Parameter) 7.26
- EDIT DATABASE RESET (Property) 7.25
- EDIT FAR_SYNC 7.27
- EDIT FAR_SYNC RESET (Parameter) 7.29
- EDIT FAR_SYNC RESET (Property) 7.28
- ENABLE CONFIGURATION 7.35
- ENABLE DATABASE 7.36
- ENABLE FAR_SYNC 7.37
- ENABLE FAST_START FAILOVER 7.38
- ENABLE FAST_START FAILOVER CONDITION 7.39
- EXIT 7.41
- EXPORT CONFIGURATION 7.42
- FAILOVER 6.11
- HELP 7.44
- IMPORT CONFIGURATION 7.46
- QUIT 7.48
- REINSTATE DATABASE 7.49
- REMOVE CONFIGURATION 7.50
- REMOVE DATABASE 7.51
- REMOVE FAR_SYNC 7.52
- REMOVE INSTANCE 7.53
- SET FAST_START FAILOVER TARGET 7.56
- SHOW CONFIGURATION 7.63, 7.64
- SHOW DATABASE 7.65
- SHOW FAR_SYNC 7.66
- SHOW FAST_START FAILOVER 7.67
- SHOW INSTANCE 7.68
- SHUTDOWN 7.73
- SQL 7.75
- START OBSERVER 7.76
- STARTUP 7.79
- STOP OBSERVER 7.80
- SWITCHOVER 6.10, 7.82
- VALIDATE DATABASE 7.83
- VALIDATE FAR_SYNC 7.86
- creating a configuration 6.2
- DG_BROKER_START initialization parameter 7.1.3
- enabling the configuration 6.4
- monitoring broker configurations 6.14
- performing routine management tasks 6.9
- prerequisites 6.1
- setting critical database properties 6.3
- setting up standby redo log files 4.7.1.2
- single command mode 7.1.1
- starting 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
- Data Guard configurations
- Data Guard monitor (DMON) 1.5
- data protection modes
- See: protection modes
- DbFileNameConvert property 8.3.10
- DBMS_DG package
- using to direct fast-start failover 5.5.3
- delaying
- application of redo data with DelayMins property 4.6.1
- DelayMins property 8.3.11
- destinations
- DG_BROKER_CONFIG_FILEn file 3.3.2
- in a CFS area 3.3.2.1
- DG_BROKER_START initialization parameter 2.2, 6.1, 7.1.3
- DGConnectIdentifier property 8.3.12
- DGMGRL
- reinstating a database 5.4.3.1
- diagnostic information
- sources 9.1
- DISABLE CONFIGURATION command 7.11
- example 6.9.2.1
- DISABLE DATABASE command 7.12
- example 6.9.2.2
- DISABLE FAR_SYNC command 7.10, 7.13
- DISABLE FAST_START FAILOVER command 7.14
- DISABLE FAST_START FAILOVER CONDITION command 7.15
- disabling 7.11
- disaster protection
- benefits 1.2
- displaying
- distributed management framework 1.1.2
- DMON
- See: Data Guard monitor (DMON)
- downgrading
- drc* log files
E
- EDIT CONFIGURATION (Property) command 7.17
- EDIT CONFIGURATION (protection mode) command 7.18
- EDIT CONFIGURATION (RENAME) command 7.10, 7.19
- EDIT CONFIGURATION RESET (Property) command 7.10, 7.20
- EDIT DATABASE (Parameter) command 7.22
- EDIT DATABASE (property) command
- example 6.9.1.1
- EDIT DATABASE (Property) command 7.10, 7.21
- EDIT DATABASE (rename) command 7.23
- EDIT DATABASE (state) command 7.24
- example 6.9.1.3
- EDIT DATABASE RESET (Parameter) command 7.26
- EDIT DATABASE RESET (Property) command 7.25
- EDIT FAR_SYNC command 7.27
- EDIT FAR_SYNC RESET (Parameter) command 7.29
- EDIT FAR_SYNC RESET (Property) command 7.28
- editing
- EDIT RECOVERY_APPLIANCE (Parameter) command 7.31
- e-mail
- reporting events 1.4.1
- ENABLE CONFIGURATION command 6.4, 7.35
- ENABLE DATABASE command 7.36
- ENABLE FAR_SYNC command 7.37
- ENABLE FAST_START FAILOVER command 7.38
- ENABLE FAST_START FAILOVER CONDITION command 7.39
- enabling 7.38
- Enterprise Edition database
- installation 2.1
- Enterprise Manager
- error messages
- ORA-16795 5.4.3
- error status 3.7
- events
- EXIT command 7.41, 7.48
- See also: QUIT command
- EXPORT CONFIGURATION command 7.42
- exporting
F
- failover
- FAILOVER command 6.11, 7.43
- failovers
- failures
- observer 5.5.7.4
- far sync instances
- managing 4.8
- fast-start failover
- configuration information in the fsfo.dat file 5.5.7.8
- defined 5.5
- DGMGRL client as the observer 1.4.2
- directed from an application 5.5.3
- disabling 5.5.5
- to perform manual failover 5.5.5
- enabling 7.38
- instance failures 5.5.2.10
- monitoring by the observer 5.5.2.10
- observer overview 5.5
- performing manual failovers when enabled 5.5.2.14
- performing switchover when enabled 5.5.2.14
- querying V$DATABASE 5.5.2.11
- reinstating the former primary database 5.5.8
- restarting databases after shut down 5.5.9
- setting the FastStartFailoverThreshold property 5.5.2.4
- shutdown abort 5.5.2.10, 5.5.2.13
- to Oracle RAC database instances 5.5.2.10
- tuning 4.9.1
- unobserved 5.5.7.4
- viewing failover configuration statistics 5.5.4.1
- FastStartFailoverAutoReinstate property 8.1.6
- FastStartFailoverLagLimit property 8.1.7
- FastStartFailoverPmyShutdown property 8.1.8
- FastStartFailoverTarget property 8.3.14
- FastStartFailoverThreshold property 8.1.9
- setting 5.5.2.4
- FASTSYNC redo transport mode 8.3.22
- FASTSYNC redo transport service 4.4.2
- files
- naming the server parameter file 1.5.3
- Flashback Database
- flashback logs
- reinstating a failed primary database 5.4.3.1
- FORCE option
- 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
- of V$DATABASE view
- FSFO.DAT file
- overview 5.5.7.8
I
- immediate failover 5.4.1, 7.43
- IMPORT CONFIGURATION command 7.46
- importing
- InconsistenLogXptProps property 8.2.1
- InconsistentProperties property 8.2.2
- increased scalability
- benefits 1.2
- initialization parameters
- installation
- InstanceName property 8.3.15
- instances
- intended state
- configuration health check 3.7
L
- life cycle of a broker configuration 3.5
- log apply services
- LogArchiveFormat property 8.3.16
- LogArchiveMaxProcesses property 8.3.17
- LogArchiveMinSucceedDest property 8.3.18
- LogArchiveTrace property 8.3.19
- LogFileNameConvert property 8.3.20
- log files
- broker 5.5.8.3
- logical standby databases
- LogShipping property 8.3.21
- LogXptMode property 8.3.22
- LogXptStatus property 8.2.3
- LsbyFailedTxnInfo property 8.2.4
- LsbyMaxEventsRecorded property 8.3.23
- LsbyMaxServers property 8.3.24
- LsbyMaxSga property 8.3.25
- LsbyParameters property 8.2.5
- LsbyPreserveCommitOrder property 8.3.26
- LsbyRecordAppliedDdl property 8.3.27
- LsbyRecordSkipDdl property 8.3.28
- LsbyRecordSkipErrors property 8.3.29
M
- management
- managing
- manual failover 1.2, 5.1
- manual role changes
- performing when fast-start failover is enabled 5.5.2.14
- MaxFailure property 8.3.30
- maximize availability 1.2, 8.3.22
- maximize data protection 1.2, 8.3.22
- maximize performance 1.2, 8.3.22
- maximum availability
- data protection mode 4.7.1.1
- maximum performance
- data protection mode 4.7.1.1
- maximum protection
- data protection mode 4.7.1.1
- monitorable properties 4.3, 4.3.1, 8.2
- monitoring
- multitenant container databases
- See CDBs 1.1.3
O
- objects
- observer 5.5
- and FastStartFailoverThreshold property 5.5.2.4
- connecting to the configuration 6.7
- connection to the local computer 5.5.7.2
- detecting
- failures 5.5.7.4
- finding host machine name 5.5.7.2
- installing Oracle Instant Client kit 2.1, 7.76
- lost connection 5.5.7.4
- maintaining fast-start failover configuration information 5.5.7.8
- monitoring 5.5.2.10
- using Oracle Wallet for connection credentials 7.8
- ObserverConnectIdentifier property 8.3.32
- ObserverOverride property 8.1.10
- ObserverReconnect property 8.1.11
- operations
- complete failover 7.43
- disable broker management
- effect on protection modes 4.7.2.4
- downgrade
- effect on protection modes 4.7.2.1
- effect on protection modes 4.7.2
- enable broker management
- effect on protection modes 4.7.2.4
- failover 6.11
- immediate failover 7.43
- manual failover
- effect on protection modes 4.7.2.3
- removing a database from the configuration
- effect on protection modes 4.7.2.5
- OperationTimeout property 8.1.12
- ORA-16661 message
- ORA-16795 message
- re-creating a database 5.4.3
- Oracle Clusterware 1.2
- Oracle Enterprise Manager 1.4.1
- Add Standby Database wizard 1.4.1
- database property pages 1.4.1
- downgrading A.3
- event management system 1.2
- integration 1.4.1
- integration with the Data Guard monitor 1.4.1
- introduction 1.1.2, 1.3
- making Oracle Net Services configuration changes 1.2, 1.4.1
- monitoring events 1.1.2
- performance tools and graphs 1.4.1
- upgrading A.1
- wizards
- creating standby databases 1.4.1
- Oracle Instant Client
- Oracle Net Services
- Oracle RAC One Node
- supported by Oracle Data Guard broker 1.1
- Oracle Real Application Clusters
- Oracle Universal Installer
- Oracle Wallet
- starting the observer 7.8
P
- parallel apply
- performance
- Oracle Enterprise Manager tools 1.4.1
- physical standby databases
- PreferredApplyInstance property 8.3.33
- prerequisites
- primary database
- ARCHIVELOG mode 2.2
- constructing a standby database 3.5, 6.1
- Data Guard configuration 3.1
- during failover 1.4.1
- during switchover 5.3.3
- Flashback Database 5.4.3.1
- health check 4.11
- preparing for switchover 5.3.1
- reinstating after a fast-start failover 5.5.8
- state transitions 4.2.1
- switching over to the standby role 7.82
- PrimaryLostWriteAction property 8.1.14
- processes
- properties 4.3.2
- property pages
- database 1.4.1
- protection modes
R
- RecvQEntries property 8.2.6
- Redo Apply 3.1
- RedoCompression property 8.3.35
- RedoRoutes property 8.3.36
- redo transport services
- REINSTATE DATABASE command 7.49
- reinstatement 5.5.8
- REMOVE CONFIGURATION command 7.50
- example 6.9.3.3
- REMOVE DATABASE command 7.51
- REMOVE FAR_SYNC command 7.52
- REMOVE INSTANCE command 7.53
- removing
- See: each REMOVE command
- a standby database 4.7.2.5
- ReopenSecs property 8.3.37
- requests
- passing between sites 1.5.1
- restarting
- databases
- when fast-start failover is enabled 5.5.9
- databases
- role transitions
S
- scripts
- using Data Guard command-line interface (DGMGRL) 7
- selecting the apply instance 4.6.4.1
- SendQEntries property 8.2.7
- server parameter file
- server parameter files
- validating before role changes 4.11.3
- server-side software 1.5
- SET ECHO command 7.55
- SET FAST_START FAILOVER TARGET command 7.56
- SET STATE command
- and setting the apply instance 4.6.4.1
- setting
- SET TRACE_LEVEL command 7.61
- SHOW ALL command 7.62
- SHOW CONFIGURATION command 6.4, 7.63, 7.64
- SHOW DATABASE command 7.65
- SHOW FAR_SYNC command 7.66
- SHOW FAST_START FAILOVER command 7.67
- showing
- See: each SHOW command
- SHOW INSTANCE command 7.68
- shutdown abort 5.5.2.10
- effect on fast-start failover 5.5.2.13
- SHUTDOWN command 7.73
- shutting down an Oracle instance 7.73
- single command mode
- for Data Guard command-line interface 7.1.1
- SQL Apply 3.1
- SQL command 7.75
- SQL statements
- executing from DGMGRL command line 7.75
- StandbyAlternateLocation property 8.3.38
- setting log apply services 4.4.5
- StandbyArchiveLocation property 8.3.39
- setting log apply services 4.4.5
- standby databases
- StandbyFileManagement property 8.3.40
- standby redo log files
- setting up with DGMGRL 4.7.1.2
- starting 7.1
- START OBSERVER command
- fast-start failover configuration file (fsfo.dat) 5.5.7.8
- STARTUP command 7.79
- states 3.6
- state transitions
- StaticConnectIdentifier property 8.3.41
- static connect identifiers
- status
- status messages
- STOP OBSERVER command 7.76, 7.80
- string values
- Data Guard command-line interface 7.1.3
- SWITCHOVER command 6.10, 7.82
- switchovers
- benefits 1.2
- broker tasks 5.3.3
- choosing a target standby database 5.2
- DGMGRL SWITCHOVER command 6.10
- effect on
- managing 5, 5.3
- overview 5.1
- Oracle Enterprise Manager 1.4.1
- performing when fast-start failover is enabled 5.5.2.14
- preparing the primary database 5.3.1
- prerequisites 5.3.1
- reenabling disabled standby databases 5.4.3
- starting 5.3.2
- transitioning
- using the DGMGRL SWITCHOVER command 7.82
- SYNC redo transport mode 4.4.2
- SYSDBA privileges
- to connect to the database 7.1.3
T
- target standby database
- TopWaitEvents property 8.2.8
- TraceLevel property 8.1.15
- TransportDisconnectedThreshold property 8.3.42
- transport lag 4.4.8
- TransportLagThreshold property 8.3.43
- TRANSPORT-ON state
- setting LogShipping property 8.3.21
- troubleshooting
- tuning
- redo transport services 4.4.6
- tuning fast-start failover 4.9.1
- two-way communication channel 1.5.1
V
- V$DATABASE view
- V$DATAGUARD_PROCESS
- using to monitor broker processes 1.5.1
- V$FS_FAILOVER_STATS view 5.5.4.2
- VALIDATE DATABASE command 7.83
- VALIDATE DATABASE SPFILE command 4.11.3, 7.85
- VALIDATE FAR_SYNC command 7.86
- VALIDATE NETWORK CONFIGURATION command 4.11.4, 7.87
- VALIDATE STATIC CONNECT IDENTIFIER command 4.11.5, 7.88