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 11.2.1
  • ADD_FAR_SYNC 11.2.2
  • ADD_RECOVERY_APPLIANCE 11.2.3
  • ADD CONFIGURATION 10.6
  • ADD DATABASE command 10.7
  • ADD FAR_SYNC command 10.8
  • ADD PLUGGABLE DATABASE 10.9
  • Add Standby Database wizard
    • creating a broker configuration 3.5
    • definition 1.6.1
    • introduction 1.6.1
  • 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
    • destination and configuration parameters 3.1.1
    • in a Data Guard configuration 3.1.1
    • primary database setup 2.2
  • ArchiveLocation property 12.3.2
  • ASYNC redo transport service 4.4.2

B

C

  • CDBs
    • Data Guard broker support 1.3.3
  • CFS
    • See: cluster file system
  • changing 10.21, 10.22, 10.23, 10.24, 10.25, 10.26
    • properties
      • databases in a broker configuration 3.5, 4.3.2
    • roles
      • within the broker configuration 3.5
    • states
      • databases in a broker configuration 4.2.1
      • of databases in a broker configuration 8.9
  • 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.59
  • components
    • broker 1.5
    • Data Guard configuration 3.1.1
  • configurable properties 4.3
  • configuration files
    • fast-start failover configuration (fsfo.dat) file 6.5.8.9
    • See Also Data Guard configuration file 1.7.2
  • configuration properties 3.2
  • connecting
    • privileges required for Data Guard broker configurations 10.1.3
    • starting the observer 8.7
  • CONVERT_TO_PHYSICAL 11.2.4
  • CONVERT_TO_SNAPSHOT 11.2.5
  • CONVERT DATABASE command 10.12
  • CREATE_CONFIGURATION 11.2.6
  • CREATE CONFIGURATION command 10.13
  • CREATE FAR_SYNC command 10.14
  • creating
    • a broker configuration 8.2
      • with the Add Standby Database wizard 3.5
    • a standby database 3.5

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.15
    • during
      • fast-start failover 6.5
      • manual failover 6.4
      • switchover 6.3
    • enabling 8.4
    • health 4.12
    • 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.12
  • database status
  • Data Guard
    • troubleshooting 13
  • Data Guard broker
  • Data Guard command line interface
  • Data Guard command-line interface
    • commands
    • DG_BROKER_START initialization parameter 2.2
    • enabling a database 8.4
    • introduction 1.6.2
  • Data Guard command-line interface (DGMGRL)
  • Data Guard configuration file
    • for an Oracle RAC database 3.3.2
    • in a CFS area 3.3.2.1
    • relationship to DMON process 1.7.1
    • setting up 3.3
  • Data Guard configurations
    • automated creation of 1.4
    • background 3.1.1
  • Data Guard DBMS_DG PL/SQL API
  • Data Guard Fixed Views
  • Data Guard monitor (DMON) 1.7
    • interaction with the Oracle database 1.7.1
    • managing objects 3.1.1, 3.5, 8.4
    • Oracle database background processes 1.7.1
    • overview 1.7.1
    • two-way network communication 1.7.1
  • data protection modes
    • See: protection modes
  • DBMS_DG package 11
    • using to direct fast-start failover 6.5.4
  • DBMS_DG Package
    • INITIATE_FS_FAILOVER procedure 11.2.21
  • delaying
    • application of redo data with DelayMins property 4.6.1
  • DelayMins property 12.3.8
  • destinations
    • archived redo log file parameters 3.1.1
    • viewing the LogXptStatus property 12.2.2
  • DG_BROKER_CONFIG_FILEn file 3.3.2
  • DG_BROKER_START initialization parameter 2.2, 8.1, 9.1, 10.1.3
  • DGConnectIdentifier property 12.3.9
  • DGMGRL
  • diagnostic information
  • DISABLE 11.2.7
  • DISABLE_CONFIGURATION 11.2.8
  • DISABLE_FS_FAILOVER 11.2.9
  • DISABLE_FS_FAILOVER_CONDITION 11.2.10
  • DISABLE CONFIGURATION command 10.15
  • DISABLE DATABASE command 10.16
  • DISABLE FAR_SYNC command 10.13, 10.17
  • DISABLE FAST_START FAILOVER command 10.18
  • DISABLE FAST_START FAILOVER CONDITION command 10.19
  • disabling 10.15
  • disaster protection
  • displaying
  • distributed management framework 1.3.2
  • DMON
    • See: Data Guard monitor (DMON)
  • downgrading
  • drc* log files
    • broker diagnostic information 13.1
    • during reinstatement 6.5.5.1
    • recording failed reinstatement 6.5.9.3

E

  • EDIT ALL MEMBERS RESET (Parameter) command 10.21
  • EDIT ALL MEMBERS RESET (Property) command 10.22
  • EDIT ALL MEMBERS SET (Parameter) command 10.23
  • EDIT ALL MEMBERS SET (Property) command 10.24
  • EDIT CONFIGURATION (Property) command 10.25
  • EDIT CONFIGURATION (protection mode) command 10.26
  • EDIT CONFIGURATION (RENAME) command 10.13, 10.27
  • EDIT CONFIGURATION PREPARE DGPDB 10.28
  • EDIT CONFIGURATION RESET (Property) command 10.13, 10.29
  • EDIT CONFIGURATION RESET TAG 10.30, 10.31, 10.38
  • EDIT CONFIGURATION SET TAG 10.39
  • EDIT DATABASE (Parameter) command 10.33
  • EDIT DATABASE (property) command
  • EDIT DATABASE (Property) command 10.13, 10.32
  • EDIT DATABASE (rename) command 10.34
  • EDIT DATABASE (state) command 10.35
  • EDIT DATABASE RESET (Parameter) command 10.36
  • EDIT DATABASE RESET (Property) command 10.37
  • EDIT FAR_SYNC command 10.40
  • EDIT FAR_SYNC RESET (Parameter) command 10.41
  • EDIT FAR_SYNC RESET (Property) command 10.42
  • EDIT FAR_SYNC RESET TAG 10.43
  • EDIT FAR_SYNC SET TAG 10.44
  • editing
  • EDIT MEMBER RESET TAG 10.45
  • EDIT MEMBER SET TAG 10.46
  • EDIT PLUGGABLE DATABASE command 10.47
  • e-mail
  • ENABLE 11.2.11
  • ENABLE_CONFIGURATION 11.2.12
  • ENABLE_FS_FAILOVER 11.2.13
  • ENABLE_FS_FAILOVER_CONDITION 11.2.14
  • ENABLE CONFIGURATION command 8.4, 10.51
  • ENABLE DATABASE command 10.52
  • ENABLE FAR_SYNC command 10.53
  • ENABLE FAST_START FAILOVER command 10.54
  • ENABLE FAST_START FAILOVER CONDITION command 10.55
  • enabling 10.54
    • broker configuration 3.5, 8.4
  • Enterprise Edition database
    • installation 2.1
  • Enterprise Manager
    • Fast-Start Failover wizard
      • disabling fast-start failover 6.5.6
    • wizards
      • automate standby database creation 1.3.2
  • error messages
  • error status 3.7
  • events
    • monitoring with Oracle Enterprise Manager 1.3.2
    • Oracle Enterprise Manager 1.4
    • reporting 1.6.1
    • responding to 1.4
  • EXIT command 10.57, 10.66
    • See also: QUIT command
  • EXPORT CONFIGURATION command 10.58
  • exporting

F

  • failover
    • failing over to a standby database 10.59
    • Oracle Enterprise Manager 1.6.1
  • FAILOVER 11.2.15
  • FAILOVER command 8.11, 10.59
  • failovers
  • failures
  • far sync instances
  • 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.54
    • 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
    • shutdown cancel 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
  • 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
  • FSFO.DAT file

G

H

  • HEALTH_CHECK 11.2.20
  • health check 1.4
    • monitoring 1.7.1
    • on primary database 4.12
    • on standby database 4.12
    • revealed by configuration status 3.7
  • HELP command 10.61
  • high availability

I

  • immediate failover 6.4.1, 10.59
  • IMPORT CONFIGURATION command 10.63
  • importing
  • InconsistenLogXptProps property 12.2.1
  • increased scalability
  • initialization parameters
  • installation
    • ARCHIVELOG mode setup 2.2
    • Data Guard 2.1
    • Oracle Enterprise Manager 2.1
    • Oracle Instant Client 2.1, 10.103
    • prerequisites 2.2
  • instances
  • intended state
    • configuration health check 3.7

L

  • life cycle of a broker configuration 3.5
  • log apply services
    • and apply instance failover 4.6.4
    • and parallel apply 4.6.2
    • apply instance 4.6.4
    • configuring 1.6.1
    • Data Guard configuration 3.1.1
    • delayed application of redo data 4.6.1
    • delaying 12.3.8
    • in an Oracle RAC database 4.6.4
    • managing 4.6
    • selecting the apply instance 4.6.4.1
    • verifying 1.4
  • log files
  • logical standby databases
    • state transitions 4.2.1
    • switchover to the primary role 6.3
  • LogShipping property 12.3.12
  • LogXptMode property 12.3.13
  • LogXptStatus property 12.2.2
  • LsbyFailedTxnInfo property 12.2.3
  • LsbyParameters property 12.2.4

M

  • management
    • benefits 1.4
    • Oracle Enterprise Manager 1.6.1
  • managing
    • a broker configuration 8
    • broker configurations 3
    • databases 4
    • fast-start failover 6.5
    • local operations 1.3.2
    • log apply services 4.6
    • manual failover 6.4
    • parallel apply in a physical standby database 4.6.2
    • remote operations 1.3.2
    • roles 6
      • fast-start failover 6.5
      • manual failover 6.4
      • switchover 6.3
    • switchover 6.3
  • 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
  • maximum performance
  • maximum protection
  • monitorable properties 4.3, 4.3.1, 12.2
  • monitoring
    • broker configurations 1.7.1, 8, 8.14
    • broker processes 1.7.1
    • local and remote databases 1.4
    • Oracle Enterprise Manager performance page 3.5
    • through the command-line interface 1.6.2
    • through the DBMS_DG PL/SQL API 1.6.3, 1.6.4
  • multitenant container databases

N

  • NetTimeout property 12.3.15
  • network configurations
    • validating before role changes 4.12.4
  • networks
    • Data Guard configuration 3.1.1
    • two-way communication 1.7.1
  • normal status 3.7

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.103
    • 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.11
  • 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.59
    • 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.59
    • 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
    • and instances of an Oracle RAC database 1.4
    • integration with Data Guard broker 1.4
    • recover failed instances 1.4
  • Oracle Data Guard DBMS_DG API)
    • summary of commands 11.2
  • 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
    • configuration changes 1.4, 1.6.1
    • supported configuration 3.1.1
    • two-way communication 1.7.1
  • Oracle Real Application Clusters
    • and log apply services 4.6.4
    • and redo transport services 4.4.7
    • and setting the apply instance 4.6.4.1
    • availability of instances with Oracle Clusterware 1.4
    • benefits 1.4
    • fast-start failover 6.5.3.11
    • observer behavior in 6.5.3.11
    • Oracle Clusterware 1.4
  • Oracle SQLcl 10.2
  • Oracle Universal Installer
    • installing Oracle Instant Client 2.1, 10.103
  • Oracle Wallet
    • starting the observer 10.11

P

  • parallel apply
    • and log apply services 4.6.2
    • managing in a physical standby database 4.6.2
  • performance
    • Oracle Enterprise Manager tools 1.6.1
  • physical standby databases
    • managing parallel apply 4.6.2
    • state transitions 4.2.1
    • switchover to the primary role 6.3
  • PreferredApplyInstance property 12.3.17
  • PREPARE DATABASE FOR DATA GUARD command 10.65
  • 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.12
    • 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.109
  • PrimaryDatabaseCandidates property 12.1.19
  • PrimaryLostWriteAction property 12.1.20
  • processes
  • properties 4.3.2
  • property pages
  • protection modes

Q

  • QUIT command 10.57, 10.66
    • See also: EXIT command

R

S

  • scripts
    • using Data Guard command-line interface (DGMGRL) 10
  • selecting the apply instance 4.6.4.1
  • SendQEntries property 12.2.6
  • server parameter file
  • server parameter files
    • validating before role changes 4.12.3
  • server-side software 1.7
  • SET_CONFIGURATION_PROPERTY 11.2.32
  • SET_CONFIGURATION_TAG 11.2.33
  • SET_MEMBER_TAG 11.2.34
  • SET_PROPERTY 11.2.35
  • SET_PROTECTION_MODE 11.2.36
  • SET_STATE_APPLY_OFF 11.2.37
  • SET_STATE_APPLY_ON 11.2.38
  • SET_STATE_TRANSPORT_OFF 11.2.39
  • SET_STATE_TRANSPORT_ON 11.2.40
  • SET ECHO command 10.74
  • SET FAST_START FAILOVER TARGET command 10.75
  • SET STATE command
    • and setting the apply instance 4.6.4.1
  • setting
    • configuration protection mode 4.7.1
    • database properties 8.3
    • fast start failover target 10.75
    • log apply services 4.4.5
    • redo transport services 4.4.6
  • SET TRACE_LEVEL command 10.80
  • show 10.82, 10.83
  • SHOW ALL command 10.81
  • SHOW ALL MEMBERS (Parameter) command 10.82
  • SHOW ALL MEMBERS(Property) command 10.83
  • SHOW CONFIGURATION command 8.4, 10.84, 10.86
  • SHOW CONFIGURATION TAG 10.85
  • SHOW CONNECTION command 10.87
  • SHOW DATABASE command 10.88
  • SHOW DATABASE TAG 10.89
  • SHOW FAR_SYNC command 10.90
  • SHOW FAR_SYNC TAG 10.91
  • SHOW FAST_START FAILOVER command 10.92
  • showing
    • See: each SHOW command
  • SHOW INSTANCE command 10.93
  • SHOW MEMBER TAG 10.94
  • SHOW PLUGGABLE DATABASE 10.98
  • shutdown abort 6.5.3.11
  • shutdown cancel
    • effect on fast-start failover 6.5.3.14
  • SHUTDOWN command 10.100
  • shutting down an Oracle instance 10.100
  • single command mode
    • for Data Guard command-line interface 10.1.1
  • source target configurations
  • SQL Apply 3.1.1
  • SQL command 10.102
  • SQL statements
    • executing from DGMGRL command line 10.102
  • 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
    • choosing a target standby database 6.2
    • constructing from backups 3.5, 8.1, 9.1
    • creating 1.6.1
    • health check 4.12
    • not involved in a switchover 6.3.3
    • reenabling after failover 6.4.2.5
    • removing 4.7.2.5
    • specifying the location of archived redo logs 4.4.5
    • switching over to the primary role 10.109
  • standby redo log files
  • starting 10.1
    • Data Guard command-line interface (DGMGRL) 8.2.1
    • Data Guard monitor (DMON) 3.4
    • manual failover 6.4.2
    • Oracle instance 10.106
    • switchover 6.3.2
  • START OBSERVER command
    • fast-start failover configuration file (fsfo.dat) 6.5.8.9
  • STARTUP command 10.106
  • states 3.6
  • 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
  • StaticConnectIdentifier property 12.3.24
  • static connect identifiers
  • status
    • configuration 3.7
    • health check on primary database 4.12
    • health check on standby database 4.12
    • health of the database 4.12
    • intended state of a configuration 3.7
  • status messages
  • STOP_OBSERVER 11.2.41
  • STOP OBSERVER command 10.103, 10.107
  • string values
    • Data Guard command-line interface 10.1.3
  • SWITCHOVER 11.2.42
  • SWITCHOVER command 8.10, 10.109
  • SWITCHOVER PLUGGABLE DATABASE command 10.110
  • switchovers
    • benefits 1.4
    • broker tasks 6.3.3
    • choosing a target standby database 6.2
    • DGMGRL SWITCHOVER command 8.10
    • effect on
      • database startup 10.109
      • primary database 6.3.3
      • protection modes 4.7.2.2
      • standby databases not involved in the switchover 6.3.3
    • 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
      • a logical standby database to the primary role 6.3
      • a physical standby database to the primary role 6.3
    • using the DGMGRL SWITCHOVER command 10.109
  • SYNC redo transport mode 4.4.2
  • SYSDBA privileges
    • to connect to the database 10.1.3

T

  • target standby database
    • choosing 6.2
    • disabling fast-start failover on 6.5.6
  • TopWaitEvents property 12.2.7
  • TraceLevel property 12.1.21
  • 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
    • Data Guard 13
    • diagnostics logged in broker drc* log files 13.1
  • tuning
    • redo transport services 4.4.6
  • tuning fast-start failover 4.9.1
  • two-way communication channel 1.7.1

U

  • unobserved configuration 6.5.8.4
  • updating configuration properties 4.3
  • upgrading
  • user interfaces

V

  • V$DATABASE view
    • fast-start failover columns 6.5.3.12
    • viewing
      • fast-start failover statistics 6.5.5.1
  • 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.111, 10.118
  • VALIDATE DATABASE SPFILE command 4.12.3, 10.113
  • VALIDATE DGConnectIdentifier command 10.114
  • VALIDATE FAR_SYNC command 10.115
  • VALIDATE NETWORK CONFIGURATION command 4.12.4, 10.117
  • VALIDATE STATIC CONNECT IDENTIFIER command 4.12.5, 4.12.6, 10.119

W