Index
A
- ADD DATABASE command 7.5
- ADD FAR_SYNC command 7.6
- Add Standby Database wizard
- altering
- AlternateLocation property 8.3.1
- setting log apply services 4.4.5
- application continuity
- support in Oracle Data Guard broker 5.6.1.4
- application integration 1.2
- apply instance 4.6.6
- ApplyInstanceTimeout property 8.3.3
- ApplyLagThreshold property 8.3.4
- ApplyParallel property 8.3.5
- architecture
- Data Guard broker 1.3
- ARCHIVE_LAG_TARGET initialization parameter
- setting in a broker configuration 8.3.6
- archived redo logs
- ArchiveLagTarget property 8.3.6
- 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.7
- broker
- 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.46
- enabling 6.4, 7.33
- enabling databases 3.5, 3.6, 6.4, 7.33
- enabling fast-start failover 7.36
- 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
- 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.40
- components
- configurable properties 4.3
- AlternateLocation 8.3.1
- ApplyInstanceTimeout 8.3.3
- ApplyLagThreshold 8.3.4
- ApplyParallel 8.3.5
- ArchiveLagTarget 8.3.6
- Binding 8.3.7
- database 4.3.2, 8.3
- DbFileNameConvert 8.3.9
- DelayMins 8.3.10
- DGConnectIdentifier 8.3.11
- FastStartFailoverTarget 8.3.13
- LogArchiveFormat 8.3.14
- LogArchiveMaxProcesses 8.3.15
- LogArchiveMinSucceedDest 8.3.16
- LogArchiveTrace 8.3.17
- LogFileNameConvert 8.3.18
- LogShipping 8.3.19
- LogXptMode 8.3.20
- LsbyMaxEventsRecorded 8.3.21
- LsbyMaxServers 8.3.22
- LsbyMaxSga 8.3.23
- LsbyPreserveCommitOrder 8.3.24
- LsbyRecordAppliedDdl 8.3.25
- LsbyRecordSkipDdl 8.3.26
- LsbyRecordSkipErrors 8.3.27
- managing redo transport services 4.4
- MaxConnections 8.3.28
- MaxFailure 8.3.29
- NetTimeout 8.3.30
- ObserverConnectIdentifier 8.3.31
- PreferredApplyInstance 8.3.32
- RedoCompression 8.3.34
- RedoRoutes 8.3.35
- ReopenSecs 8.3.36
- SidName 8.3.37
- StandbyArchiveLocation 8.3.38
- StandbyFileManagement 8.3.39
- StaticConnectIdentifier 8.3.40
- TransportDisconnectedThreshold 8.3.41
- TransportLagThreshold 8.3.42
- configuration files
- configuration properties
- 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
- controlling
- available SGA memory 4.6.4
- 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
- Data Guard
- troubleshooting 9
- Data Guard broker
- See Also broker 1.1.2
- 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.22
- EDIT DATABASE (state) 7.23
- EDIT DATABASE RESET (Property) 7.24
- EDIT FAR_SYNC 7.25
- EDIT FAR_SYNC RESET (Property) 7.26
- EDIT INSTANCE (AUTO PFILE) 7.27
- EDIT INSTANCE (property) 7.28, 7.29
- EDIT INSTANCE RESET (Property) 7.29
- ENABLE CONFIGURATION 7.33
- ENABLE DATABASE 7.34
- ENABLE FAR_SYNC 7.35
- ENABLE FAST_START FAILOVER 7.36
- ENABLE FAST_START FAILOVER CONDITION 7.37
- EXIT 7.39
- FAILOVER 6.11
- HELP 7.41
- QUIT 7.44
- REINSTATE DATABASE 7.45
- REMOVE CONFIGURATION 7.46
- REMOVE DATABASE 7.47
- REMOVE FAR_SYNC 7.48
- REMOVE INSTANCE 7.49
- SHOW CONFIGURATION 7.55, 7.56
- SHOW DATABASE 7.57
- SHOW FAR_SYNC 7.58
- SHOW FAST_START FAILOVER 7.59
- SHOW INSTANCE 7.60
- SHUTDOWN 7.65
- SQL 7.67
- START OBSERVER 7.68
- STARTUP 7.71
- STOP OBSERVER 7.72
- SWITCHOVER 6.10, 7.74
- VALIDATE DATABASE 7.75
- VALIDATE FAR_SYNC 7.77
- 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
- DBA_LOGSTDBY_EVENTS table
- managing 4.6.5
- DbFileNameConvert property 8.3.9
- 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.10
- 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.11
- 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 (property) command
- example 6.9.1.1
- EDIT DATABASE (Property) command 7.10, 7.21
- EDIT DATABASE (rename) command 7.22
- EDIT DATABASE (state) command 7.23
- example 6.9.1.3
- EDIT DATABASE RESET (Property) command 7.24
- EDIT FAR_SYNC command 7.25
- EDIT FAR_SYNC RESET (Property) command 7.26
- editing
- EDIT INSTANCE (AUTO PFILE) command 7.27
- EDIT INSTANCE (property) command 7.28, 7.29
- EDIT INSTANCE RESET (Property) command 7.29
- e-mail
- reporting events 1.4.1
- ENABLE CONFIGURATION command 6.4, 7.33
- ENABLE DATABASE command 7.34
- ENABLE FAR_SYNC command 7.35
- ENABLE FAST_START FAILOVER command 7.36
- ENABLE FAST_START FAILOVER CONDITION command 7.37
- enabling 7.36
- Enterprise Edition database
- installation 2.1
- Enterprise Manager
- error messages
- ORA-16795 5.4.3
- error status 3.7
- events
- EXIT command 7.39, 7.44
- See also: QUIT command
F
- failover
- FAILOVER command 6.11, 7.40
- 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.36
- 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.13
- performing switchover when enabled 5.5.2.13
- 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.12
- to Oracle RAC database instances 5.5.2.10
- 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.13
- FastStartFailoverThreshold property 8.1.9
- setting 5.5.2.4
- FASTSYNC redo transport mode 8.3.20
- 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
L
- life cycle of a broker configuration 3.5
- log apply services
- LogArchiveFormat property 8.3.14
- LogArchiveMaxProcesses property 8.3.15
- LogArchiveMinSucceedDest property 8.3.16
- LogArchiveTrace property 8.3.17
- LogFileNameConvert property 8.3.18
- log files
- broker 5.5.8.3
- logical standby databases
- LogShipping property 8.3.19
- LogXptMode property 8.3.20
- LogXptStatus property 8.2.3
- LsbyFailedTxnInfo property 8.2.4
- LsbyMaxEventsRecorded property 8.3.21
- LsbyMaxServers property 8.3.22
- LsbyMaxSga property 8.3.23
- LsbyParameters property 8.2.5
- LsbyPreserveCommitOrder property 8.3.24
- LsbyRecordAppliedDdl property 8.3.25
- LsbyRecordSkipDdl property 8.3.26
- LsbyRecordSkipErrors property 8.3.27
M
- management
- managing
- a broker configuration 6
- broker configurations 3
- databases 4
- DBA_LOGSTDBY_EVENTS table 4.6.5
- events
- in a logical standby database 4.6.5
- fast-start failover 5.5
- local operations 1.1.2
- log apply services 4.6
- manual failover 5.4
- parallel apply in a physical standby database 4.6.2
- remote operations 1.1.2
- roles 5
- switchover 5.3
- manual failover 1.2, 5.1
- manual role changes
- performing when fast-start failover is enabled 5.5.2.13
- MaxConnections property 8.3.28
- MaxFailure property 8.3.29
- maximize availability 1.2, 8.3.20
- maximize data protection 1.2, 8.3.20
- maximize performance 1.2, 8.3.20
- 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.68
- 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.31
- ObserverOverride property 8.1.10
- ObserverReconnect property 8.1.11
- operations
- complete failover 7.40
- 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.40
- 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.32
- 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.74
- 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.34
- RedoRoutes property 8.3.35
- redo transport services
- REINSTATE DATABASE command 7.45
- reinstatement 5.5.8
- REMOVE CONFIGURATION command 7.46
- example 6.9.3.3
- REMOVE DATABASE command 7.47
- REMOVE FAR_SYNC command 7.48
- REMOVE INSTANCE command 7.49
- removing
- See: each REMOVE command
- a standby database 4.7.2.5
- ReopenSecs property 8.3.36
- 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.6.1
- SendQEntries property 8.2.7
- server parameter file
- server-side software 1.5
- SET STATE command
- and setting the apply instance 4.6.6.1
- setting
- SGA memory
- and SQL Apply 4.6.4
- SHOW CONFIGURATION command 6.4, 7.55, 7.56
- SHOW DATABASE command 7.57
- SHOW FAR_SYNC command 7.58
- SHOW FAST_START FAILOVER command 7.59
- showing
- See: each SHOW command
- SHOW INSTANCE command 7.60
- shutdown abort 5.5.2.10
- effect on fast-start failover 5.5.2.12
- SHUTDOWN command 7.65
- shutting down an Oracle instance 7.65
- SidName property 8.3.37
- single command mode
- for Data Guard command-line interface 7.1.1
- SQL Apply 3.1
- and logical standby databases 4.6.4
- SQL command 7.67
- SQL statements
- executing from DGMGRL command line 7.67
- StandbyArchiveLocation property 8.3.38
- setting log apply services 4.4.5
- standby databases
- StandbyFileManagement property 8.3.39
- 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.71
- states 3.6
- state transitions
- StaticConnectIdentifier property 8.3.40
- status
- status messages
- STOP OBSERVER command 7.68, 7.72
- string values
- Data Guard command-line interface 7.1.3
- SWITCHOVER command 6.10, 7.74
- 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.13
- 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.74
- 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
- transaction commit order
- controlling 4.6.4
- TransportDisconnectedThreshold property 8.3.41
- TransportLagThreshold property 8.3.42
- TRANSPORT-ON state
- setting LogShipping property 8.3.19
- troubleshooting
- tuning
- redo transport services 4.4.6
- two-way communication channel 1.5.1