Index
A
- ADD_DATABASE 11.2
- ADD_FAR_SYNC 11.3
- ADD_RECOVERY_APPLIANCE 11.4
- ADD CONFIGURATION 10.5
- ADD DATABASE command 10.6
- ADD FAR_SYNC command 10.7
- ADD PLUGGABLE DATABASE 10.8
- Add Standby Database wizard
- altering
- AlternateLocation property 12.3.1
- application continuity
- support in Oracle Data Guard broker 6.6.1.4
- application integration 1.4
- apply instance 4.6.4
- ApplyInstanceTimeout property 12.3.4
- ApplyLagThreshold property 12.3.5
- ApplyParallel property 12.3.6
- architecture
- Data Guard broker 1.5
- archived redo logs
- ArchiveLocation property 12.3.2
- ASYNC redo transport service 4.4.2
B
- background processes
- DMON 1.7.1
- banners
- suppressing from DGMGRL command-line interface output 10.1.1
- batch programs
- before you perform a switchover 6.3.1
- before you use DGMGRL 8.1, 9.1
- benefits
- Binding property 12.3.7
- broker
- broker configuration
- broker configurations
- benefits 1.4
- changing roles 3.5
- creating 8.2, 9.2, 9.3, 9.4, 9.5, 9.6, 9.7, 9.8, 9.9, 9.10, 9.11
- Data Guard configuration file 1.7.1
- disabling databases 3.6, 10.14
- enabling 8.4, 10.42
- enabling databases 3.5, 3.6, 8.4, 10.42
- enabling fast-start failover 10.45
- health 1.7.1, 3.7
- life cycle 3.5
- management 1.6.1, 1.6.2, 1.6.3, 1.6.4, 1.7.2
- monitoring 8.14
- Oracle Net Services configuration 1.4, 1.6.1
- properties 4.3
- protection modes 10.25
- setting protection mode 4.7.1
- status modes 3.7
- supported 3.1.1
- broker processes
- monitoring 1.7.1
- BystandersFollowRoleChange property 12.1.1
- bystander standby databases 6.3
- reintegrating into configuration 6.4.2.5
C
- CDBs
- Data Guard broker support 1.3.3
- CFS
- See: cluster file system
- changing 10.20, 10.21, 10.22, 10.23, 10.24, 10.25
- 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 10.1.1
- CommunicationTimeout property 12.1.2
- complete failover 6.4.1, 10.50
- components
- configurable properties 4.3
- AlternateLocation 12.3.1
- ApplyInstanceTimeout 12.3.4
- ApplyLagThreshold 12.3.5
- ApplyParallel 12.3.6
- ArchiveLocation 12.3.2
- Binding 12.3.7
- database 4.3.2, 12.3
- DelayMins 12.3.8
- DGConnectIdentifier 12.3.9
- FastStartFailoverTarget 12.3.11
- LogShipping 12.3.12
- LogXptMode 12.3.13
- managing redo transport services 4.4
- MaxFailure 12.3.14
- NetTimeout 12.3.15
- ObserverConnectIdentifier 12.3.16
- PreferredApplyInstance 12.3.17
- RedoCompression 12.3.19
- RedoRoutes 12.3.20
- ReopenSecs 12.3.21
- resetting to default values 4.3.2.1
- StandbyAlternateLocation 12.3.22
- StandbyArchiveLocation 12.3.23
- StaticConnectIdentifier 12.3.24
- TransportDisconnectedThreshold 12.3.25
- TransportLagThreshold 12.3.26
- configuration files
- configuration properties 3.2
- BystandersFollowRoleChange 12.1.1
- CommunicationTimeout 12.1.2
- FastStartFailoverAutoReinstate 12.1.8
- FastStartFailoverLagGraceTime 12.1.9
- FastStartFailoverLagLimit 12.1.10
- FastStartFailoverLagType 12.1.11
- FastStartFailoverPmyShutdown 12.1.12
- FastStartFailoverThreshold 12.1.13
- ObserverOverride 12.1.14
- ObserverPingInterval 12.1.15
- ObserverPingRetry 12.1.16
- ObserverReconnect 12.1.17
- OperationTimeout 12.1.18
- PrimaryLostWriteAction 12.1.19
- Tracelevel 12.1.20
- connecting
- CONVERT_TO_PHYSICAL 11.5
- CONVERT_TO_SNAPSHOT 11.6
- CONVERT DATABASE command 10.11
- CREATE_CONFIGURATION 11.7
- CREATE CONFIGURATION command 10.12
- CREATE FAR_SYNC command 10.13
- creating
D
- database resources
- monitoring 1.4
- databases
- changing the state of 8.9
- creating and adding to a broker configuration 1.6.1
- dependencies 4.2
- disabling management of 10.14
- during
- enabling 8.4
- health 4.11
- installation for broker management 2.2
- monitorable properties 4.3.1
- network setup 1.7.1, 2.2
- properties 1.6.1, 4.3.2
- property management 1.7.3
- reenabling after a role transition 6.4.3
- restarting
- after fast-start failover 6.5.10
- shutting down
- states 4.2
- status 4.11
- database status
- querying 4.11.1
- Data Guard
- troubleshooting 13
- Data Guard broker
- See Also broker 1.3.2
- Data Guard command line interface
- Data Guard command-line interface
- Data Guard command-line interface (DGMGRL)
- banners from output 10.1.1
- commands
- ADD DATABASE 10.6
- ADD FAR_SYNC 10.7
- CONVERT DATABASE 10.11
- CREATE CONFIGURATION 10.12
- CREATE FAR_SYNC 10.13
- DISABLE CONFIGURATION 10.14
- DISABLE DATABASE 10.15
- DISABLE FAR_SYNC 10.12, 10.16
- DISABLE FAST_START FAILOVER 10.17
- DISABLE FAST_START FAILOVER CONDITION 10.18
- EDIT ALL MEMBERS SET (parameter) 10.22
- EDIT ALL MEMBERS SET (property) 10.23
- EDIT CONFIGURATION (property) 10.24
- EDIT CONFIGURATION (protection mode) 10.25
- EDIT CONFIGURATION (RENAME) 10.12, 10.26
- EDIT CONFIGURATION PREPARE DGPDB 10.27
- EDIT CONFIGURATION RESET (Property) 10.12, 10.28
- EDIT DATABASE (Property) 10.12, 10.29
- EDIT DATABASE (rename) 10.31
- EDIT DATABASE (state) 10.32
- EDIT DATABASE RESET (Parameter) 10.34
- EDIT DATABASE RESET (Property) 10.33
- EDIT FAR_SYNC 10.35
- EDIT FAR_SYNC RESET (Parameter) 10.37
- EDIT FAR_SYNC RESET (Property) 10.36
- EEDIT ALL MEMBERS RESET (parameter) 10.20
- EEDIT ALL MEMBERS RESET (property) 10.21
- ENABLE CONFIGURATION 10.42
- ENABLE DATABASE 10.43
- ENABLE FAR_SYNC 10.44
- ENABLE FAST_START FAILOVER 10.45
- ENABLE FAST_START FAILOVER CONDITION 10.46
- EXIT 10.48
- EXPORT CONFIGURATION 10.49
- FAILOVER 8.11
- HELP 10.52
- IMPORT CONFIGURATION 10.54
- PREPARE DATABASE FOR DATA GUARD 10.56
- QUIT 10.57
- REINSTATE DATABASE 10.58
- REMOVE CONFIGURATION 10.59
- REMOVE DATABASE 10.60
- REMOVE FAR_SYNC 10.61
- REMOVE INSTANCE 10.62
- SET FAST_START FAILOVER TARGET 10.65
- SHOW ALL MEMBERS(property) 10.73
- SHOW ALL MEMBERS SET (parameter) 10.72
- SHOW CONFIGURATION 10.74, 10.75, 10.76
- SHOW DATABASE 10.77
- SHOW FAR_SYNC 10.78
- SHOW FAST_START FAILOVER 10.79
- SHOW INSTANCE 10.80
- SHUTDOWN 10.86
- SQL 10.88
- START OBSERVER 10.89
- STARTUP 10.92
- STOP OBSERVER 10.93
- SWITCHOVER 8.10, 10.95
- VALIDATE DATABASE 10.97, 10.104
- VALIDATE FAR_SYNC 10.101
- creating a configuration 8.2
- DG_BROKER_START initialization parameter 10.1.3
- DG PDB 9.2, 9.9, 9.3, 9.4, 9.5, 9.6, 9.7, 9.8, 9.10, 9.11
- enabling the configuration 8.4
- monitoring broker configurations 8.14
- performing routine management tasks 8.9
- prerequisites 8.1, 9.1
- setting critical database properties 8.3
- setting up standby redo log files 4.7.1.2
- single command mode 10.1.1
- starting 10.1
- stopping 10.2
- string values 10.1.3
- summary of commands 10.1.2
- suppressing command prompts 10.1.1
- Data Guard configuration file
- Data Guard configurations
- Data Guard DBMS_DG PL/SQL API
- introduction 1.6.3
- Data Guard Fixed Views
- introduction 1.6.4
- Data Guard monitor (DMON) 1.7
- data protection modes
- See: protection modes
- DBMS_DG package
- using to direct fast-start failover 6.5.4
- delaying
- application of redo data with DelayMins property 4.6.1
- DelayMins property 12.3.8
- destinations
- DG_BROKER_CONFIG_FILEn file 3.3.2
- in a CFS area 3.3.2.1
- DG_BROKER_START initialization parameter 2.2, 8.1, 9.1, 10.1.3
- DGConnectIdentifier property 12.3.9
- DGMGRL
- reinstating a database 6.4.3.1
- diagnostic information
- sources 13.1
- DISABLE 11.8
- DISABLE_CONFIGURATION 11.9
- DISABLE_FS_FAILOVER 11.10
- DISABLE_FS_FAILOVER_CONDITION 11.11
- DISABLE CONFIGURATION command 10.14
- example 8.9.2.1
- DISABLE DATABASE command 10.15
- example 8.9.2.2
- DISABLE FAR_SYNC command 10.12, 10.16
- DISABLE FAST_START FAILOVER command 10.17
- DISABLE FAST_START FAILOVER CONDITION command 10.18
- disabling 10.14
- disaster protection
- benefits 1.4
- displaying
- distributed management framework 1.3.2
- DMON
- See: Data Guard monitor (DMON)
- downgrading
- protection mode 4.7.2.1
- drc* log files
E
- EDIT ALL MEMBERS RESET (Parameter) command 10.20
- EDIT ALL MEMBERS RESET (Property) command 10.21
- EDIT ALL MEMBERS SET (Parameter) command 10.22
- EDIT ALL MEMBERS SET (Property) command 10.23
- EDIT CONFIGURATION (Property) command 10.24
- EDIT CONFIGURATION (protection mode) command 10.25
- EDIT CONFIGURATION (RENAME) command 10.12, 10.26
- EDIT CONFIGURATION PREPARE DGPDB 10.27
- EDIT CONFIGURATION RESET (Property) command 10.12, 10.28
- EDIT DATABASE (Parameter) command 10.30
- EDIT DATABASE (property) command
- example 8.9.1.1
- EDIT DATABASE (Property) command 10.12, 10.29
- EDIT DATABASE (rename) command 10.31
- EDIT DATABASE (state) command 10.32
- example 8.9.1.3
- EDIT DATABASE RESET (Parameter) command 10.34
- EDIT DATABASE RESET (Property) command 10.33
- EDIT FAR_SYNC command 10.35
- EDIT FAR_SYNC RESET (Parameter) command 10.37
- EDIT FAR_SYNC RESET (Property) command 10.36
- editing
- EDIT PLUGGABLE DATABASE command 10.38
- e-mail
- reporting events 1.6.1
- ENABLE 11.12
- ENABLE_CONFIGURATION 11.13
- ENABLE_FS_FAILOVER 11.14
- ENABLE_FS_FAILOVER_CONDITION 11.15
- ENABLE CONFIGURATION command 8.4, 10.42
- ENABLE DATABASE command 10.43
- ENABLE FAR_SYNC command 10.44
- ENABLE FAST_START FAILOVER command 10.45
- ENABLE FAST_START FAILOVER CONDITION command 10.46
- enabling 10.45
- Enterprise Edition database
- installation 2.1
- Enterprise Manager
- error messages
- ORA-16795 6.4.3
- error status 3.7
- events
- EXIT command 10.48, 10.57
- See also: QUIT command
- EXPORT CONFIGURATION command 10.49
- exporting
F
- failover
- FAILOVER 11.16
- FAILOVER command 8.11, 10.50
- failovers
- failures
- observer 6.5.8.4
- far sync instances
- managing 4.8
- fast-start failover
- configuration information in the fsfo.dat file 6.5.8.9
- DGMGRL client as the observer 1.6.2
- directed from an application 6.5.4
- disabling 6.5.6
- to perform manual failover 6.5.6
- enabling 10.45
- instance failures 6.5.3.11
- monitoring by the observer 6.5.3.11
- observer overview 6.5
- performing manual failovers when enabled 6.5.3.15
- performing switchover when enabled 6.5.3.15
- querying V$DATABASE 6.5.3.12
- reinstating the former primary database 6.5.9
- restarting databases after shut down 6.5.10
- setting the FastStartFailoverThreshold property 6.5.3.4
- shutdown abort 6.5.3.11, 6.5.3.14
- to Oracle RAC database instances 6.5.3.11
- tuning 4.9.1
- unobserved 6.5.8.4
- viewing failover configuration statistics 6.5.5.1
- FastStartFailoverAutoReinstate property 12.1.8
- FastStartFailoverLagGraceTime property 12.1.9
- FastStartFailoverLagLimit property 12.1.10
- FastStartFailoverLagType property 12.1.11
- FastStartFailoverPmyShutdown property 12.1.12
- FastStartFailoverTarget property 12.3.11
- FastStartFailoverThreshold property 12.1.13
- setting 6.5.3.4
- FASTSYNC redo transport mode 12.3.13
- FASTSYNC redo transport service 4.4.2
- files
- naming the server parameter file 1.7.3
- Flashback Database
- flashback logs
- reinstating a failed primary database 6.4.3.1
- FORCE option
- performing a manual failover 6.5.6
- FS_FAILOVER_STATUS column
- of V$DATABASE view
- failed reinstatement 6.5.5.1
- of V$DATABASE view
- FSFO.DAT file
- overview 6.5.8.9
I
L
M
- management
- managing
- manual failover 1.4, 6.1
- manual role changes
- performing when fast-start failover is enabled 6.5.3.15
- MaxFailure property 12.3.14
- maximize availability 1.4, 12.3.13
- maximize data protection 1.4, 12.3.13
- maximize performance 1.4, 12.3.13
- 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, 12.2
- monitoring
- multitenant container databases
- See CDBs 1.3.3
O
- objects
- observer 6.5
- and FastStartFailoverThreshold property 6.5.3.4
- connecting to the configuration 8.7
- detecting
- failures 6.5.8.4
- installing Oracle Instant Client kit 2.1, 10.89
- lost connection 6.5.8.4
- maintaining fast-start failover configuration information 6.5.8.9
- monitoring 6.5.3.11
- using Oracle Wallet for connection credentials 10.10
- ObserverConnectIdentifier property 12.3.16
- ObserverOverride property 12.1.14
- ObserverPingInterval property 12.1.15
- ObserverPingRetry property 12.1.16
- ObserverReconnect property 12.1.17
- operations
- complete failover 10.50
- 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 8.11
- immediate failover 10.50
- 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 12.1.18
- ORA-16661 message
- ORA-16795 message
- re-creating a database 6.4.3
- Oracle Clusterware 1.4
- Oracle Data Guard DBMS_DG API)
- summary of commands 11.1
- Oracle Enterprise Manager 1.6.1
- Add Standby Database wizard 1.6.1
- database property pages 1.6.1
- event management system 1.4
- integration 1.6.1
- integration with the Data Guard monitor 1.6.1
- introduction 1.3.2, 1.5
- making Oracle Net Services configuration changes 1.4, 1.6.1
- monitoring events 1.3.2
- performance tools and graphs 1.6.1
- wizards
- creating standby databases 1.6.1
- Oracle Instant Client
- Oracle Net Services
- Oracle Real Application Clusters
- Oracle Universal Installer
- Oracle Wallet
- starting the observer 10.10
P
- parallel apply
- performance
- Oracle Enterprise Manager tools 1.6.1
- physical standby databases
- PreferredApplyInstance property 12.3.17
- PREPARE DATABASE FOR DATA GUARD command 10.56
- Prepare the Databases 9.2, 9.3, 9.4, 9.5, 9.6, 9.7, 9.8, 9.9, 9.10, 9.11
- prerequisites
- primary database
- ARCHIVELOG mode 2.2
- constructing a standby database 3.5, 8.1, 9.1
- Data Guard configuration 3.1.1
- during failover 1.6.1
- during switchover 6.3.3
- Flashback Database 6.4.3.1
- health check 4.11
- preparing for switchover 6.3.1
- reinstating after a fast-start failover 6.5.9
- state transitions 4.2.1
- switching over to the standby role 10.95
- PrimaryLostWriteAction property 12.1.19
- processes
- properties 4.3.2
- property pages
- database 1.6.1
- protection modes
R
- RecvQEntries property 12.2.5
- Redo Apply 3.1.1
- RedoCompression property 12.3.19
- RedoRoutes property 12.3.20
- redo transport services
- REINSTATE 11.20
- REINSTATE DATABASE command 10.58
- reinstatement 6.5.9
- REMOVE 11.21
- REMOVE_CONFIGURATION 11.22
- REMOVE_INSTANCE 11.23
- REMOVE CONFIGURATION command 10.59
- example 8.9.3.3
- REMOVE DATABASE command 10.60
- REMOVE FAR_SYNC command 10.61
- REMOVE INSTANCE command 10.62
- removing
- See: each REMOVE command
- a standby database 4.7.2.5
- ReopenSecs property 12.3.21
- requests
- passing between sites 1.7.1
- RESET_CONFIGURATION_PROPERTY 11.24
- RESET_PROPERTY 11.25
- restarting
- databases
- when fast-start failover is enabled 6.5.10
- databases
- role transitions
S
- scripts
- selecting the apply instance 4.6.4.1
- SendQEntries property 12.2.6
- server parameter file
- server parameter files
- validating before role changes 4.11.3
- server-side software 1.7
- SET_CONFIGURATION_PROPERTY 11.26
- SET_PROPERTY 11.27
- SET_PROTECTION_MODE 11.28
- SET_STATE_APPLY_OFF 11.29
- SET_STATE_APPLY_ON 11.30
- SET_STATE_TRANSPORT_OFF 11.31
- SET_STATE_TRANSPORT_ON 11.32
- SET ECHO command 10.64
- SET FAST_START FAILOVER TARGET command 10.65
- SET STATE command
- and setting the apply instance 4.6.4.1
- setting
- SET TRACE_LEVEL command 10.70
- show 10.72, 10.73
- SHOW ALL command 10.71
- SHOW ALL MEMBERS (Parameter) command 10.72
- SHOW ALL MEMBERS(Property) command 10.73
- SHOW CONFIGURATION command 8.4, 10.74, 10.75
- SHOW CONNECTION command 10.76
- SHOW DATABASE command 10.77
- SHOW FAR_SYNC command 10.78
- SHOW FAST_START FAILOVER command 10.79
- showing
- See: each SHOW command
- SHOW INSTANCE command 10.80
- SHOW PLUGGABLE DATABASE 10.84
- shutdown abort 6.5.3.11
- effect on fast-start failover 6.5.3.14
- SHUTDOWN command 10.86
- shutting down an Oracle instance 10.86
- single command mode
- for Data Guard command-line interface 10.1.1
- source target configurations
- creating 9.4
- SQL Apply 3.1.1
- SQL command 10.88
- SQL statements
- executing from DGMGRL command line 10.88
- StandbyAlternateLocation property 12.3.22
- setting log apply services 4.4.5
- StandbyArchiveLocation property 12.3.23
- setting log apply services 4.4.5
- standby databases
- standby redo log files
- setting up with DGMGRL 4.7.1.2
- starting 10.1
- START OBSERVER command
- fast-start failover configuration file (fsfo.dat) 6.5.8.9
- STARTUP command 10.92
- states 3.6
- state transitions
- StaticConnectIdentifier property 12.3.24
- static connect identifiers
- status
- status messages
- STOP_OBSERVER 11.33
- STOP OBSERVER command 10.89, 10.93
- string values
- Data Guard command-line interface 10.1.3
- SWITCHOVER 11.34
- SWITCHOVER command 8.10, 10.95
- SWITCHOVER PLUGGABLE DATABASE command 10.96
- switchovers
- benefits 1.4
- broker tasks 6.3.3
- choosing a target standby database 6.2
- DGMGRL SWITCHOVER command 8.10
- effect on
- managing 6, 6.3
- overview 6.1
- Oracle Enterprise Manager 1.6.1
- performing when fast-start failover is enabled 6.5.3.15
- preparing the primary database 6.3.1
- prerequisites 6.3.1
- reenabling disabled standby databases 6.4.3
- starting 6.3.2
- transitioning
- using the DGMGRL SWITCHOVER command 10.95
- SYNC redo transport mode 4.4.2
- SYSDBA privileges
- to connect to the database 10.1.3
T
- target standby database
- TopWaitEvents property 12.2.7
- TraceLevel property 12.1.20
- TransportDisconnectedThreshold property 12.3.25
- transport lag 4.4.8
- TransportLagThreshold property 12.3.26
- TRANSPORT-ON state
- setting LogShipping property 12.3.12
- troubleshooting
- tuning
- redo transport services 4.4.6
- tuning fast-start failover 4.9.1
- two-way communication channel 1.7.1
V
- V$DATABASE view
- V$DATAGUARD_PROCESS
- using to monitor broker processes 1.7.1
- V$FAST_START_FAILOVER_CONFIG view 6.5.5.2
- V$FS_FAILOVER_STATS view 6.5.5.3
- VALIDATE DATABASE command 10.97, 10.104
- VALIDATE DATABASE SPFILE command 4.11.3, 10.99
- VALIDATE DGConnectIdentifier command 10.100
- VALIDATE FAR_SYNC command 10.101
- VALIDATE NETWORK CONFIGURATION command 4.11.4, 10.103
- VALIDATE STATIC CONNECT IDENTIFIER command 4.11.5, 4.11.6, 10.105