1. Index

Index

A  B  C  D  E  F  H  I  L  M  N  O  P  Q  R  S  T  U  V  W  

A

  • ADD CONFIGURATION 10.5
  • ADD DATABASE command 10.6
  • ADD FAR_SYNC command 10.7
  • ADD PLUGGABLE DATABASE 10.8
  • Add Standby Database wizard
    • creating a broker configuration 3.5
    • definition 1.5.1
    • introduction 1.5.1
  • altering
  • AlternateLocation property 11.3.1
  • application continuity
    • support in Oracle Data Guard broker 6.6.1.4
  • application integration 1.3
  • apply instance 4.6.4
  • ApplyInstanceTimeout property 11.3.4
  • ApplyLagThreshold property 11.3.5
  • ApplyParallel property 11.3.6
  • architecture
    • Data Guard broker 1.4
  • 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 11.3.2
  • ASYNC redo transport service 4.4.2

B

  • background processes
  • banners
    • suppressing from DGMGRL command-line interface output 10.1.1
  • batch programs
    • using Data Guard command-line interface (DGMGRL) 10
  • before you perform a switchover 6.3.1
  • before you use DGMGRL 8.1
  • benefits
    • Data Guard broker 1.3
    • high availability 1.3
    • scalability 1.3
    • with Oracle Real Application Clusters 1.3
  • Binding property 11.3.7
  • broker
    • components 1.4
    • configuration 1.2.1
    • Data Guard configuration file 1.6.2
    • drc* log files 12.1
    • introduction 1.2.2
    • user interfaces 1.5
  • broker configuration
  • broker configurations
  • broker processes
  • BystandersFollowRoleChange property 11.1.1
  • bystander standby databases 6.3
    • reintegrating into configuration 6.4.2.5

C

  • CDBs
    • Data Guard broker support 1.2.3
  • CFS
    • See: cluster file system
  • changing 10.20, 10.21
    • 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 11.1.2
  • complete failover 6.4.1, 10.48
  • components
    • broker 1.4
    • 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.6.2
  • configuration properties 3.2
  • connecting
    • privileges required for Data Guard broker configurations 10.1.3
    • starting the observer 8.7
  • CONVERT DATABASE command 10.11
  • CREATE CONFIGURATION command 10.12
  • CREATE FAR_SYNC command 10.13
  • creating
    • a broker configuration 8.2
      • with the Add Standby Database wizard 3.5
    • a standby database 3.5

D

  • database resources
    • monitoring 1.3
  • databases
    • changing the state of 8.9
    • creating and adding to a broker configuration 1.5.1
    • dependencies 4.2
    • disabling management of 10.14
    • during
      • fast-start failover 6.5
      • manual failover 6.4
      • switchover 6.3
    • enabling 8.4
    • health 4.11
    • installation for broker management 2.2
    • monitorable properties 4.3.1
    • network setup 1.6.1, 2.2
    • properties 1.5.1, 4.3.2
    • property management 1.6.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
  • Data Guard
    • troubleshooting 12
  • 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.5.2
  • Data Guard command-line interface (DGMGRL)
    • banners from output 10.1.1
    • commands
    • creating a configuration 8.2
    • DG_BROKER_START initialization parameter 10.1.3
    • enabling the configuration 8.4
    • monitoring broker configurations 8.14
    • performing routine management tasks 8.9
    • prerequisites 8.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
    • for an Oracle RAC database 3.3.2
    • in a CFS area 3.3.2.1
    • inconsistent values from server parameter file 11.2.2
    • relationship to DMON process 1.6.1
    • setting up 3.3
  • Data Guard configurations
    • automated creation of 1.3
    • background 3.1.1
  • Data Guard monitor (DMON) 1.6
    • interaction with the Oracle database 1.6.1
    • managing objects 3.1.1, 3.5, 8.4
    • Oracle database background processes 1.6.1
    • overview 1.6.1
    • two-way network communication 1.6.1
  • 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 11.3.8
  • destinations
    • archived redo log file parameters 3.1.1
    • viewing the LogXptStatus property 11.2.3
  • DG_BROKER_CONFIG_FILEn file 3.3.2
  • DG_BROKER_START initialization parameter 2.2, 8.1, 10.1.3
  • DGConnectIdentifier property 11.3.9
  • DGMGRL
  • diagnostic information
  • DISABLE CONFIGURATION command 10.14
  • DISABLE DATABASE command 10.15
  • 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
  • displaying
    • configuration information 10.71
    • help for DGMGRL commands 10.50
  • distributed management framework 1.2.2
  • DMON
    • See: Data Guard monitor (DMON)
  • downgrading
  • drc* log files
    • broker diagnostic information 12.1
    • during reinstatement 6.5.5.1
    • recording failed reinstatement 6.5.9.3

E

  • EDIT CONFIGURATION (Property) command 10.20
  • EDIT CONFIGURATION (protection mode) command 10.21
  • EDIT CONFIGURATION (RENAME) command 10.12, 10.22
  • EDIT CONFIGURATION (Set Source) command 10.24
  • EDIT CONFIGURATION RESET (Property) command 10.12, 10.23
  • EDIT DATABASE (Parameter) command 10.26
  • EDIT DATABASE (property) command
  • EDIT DATABASE (Property) command 10.12, 10.25
  • EDIT DATABASE (rename) command 10.27
  • EDIT DATABASE (state) command 10.28
  • EDIT DATABASE RESET (Parameter) command 10.30
  • EDIT DATABASE RESET (Property) command 10.29
  • EDIT FAR_SYNC command 10.31
  • EDIT FAR_SYNC RESET (Parameter) command 10.33
  • EDIT FAR_SYNC RESET (Property) command 10.32
  • editing
  • EDIT PLUGGABLE DATABASE command 10.34
  • EDIT RECOVERY_APPLIANCE (Parameter) command 10.36
  • e-mail
  • ENABLE CONFIGURATION command 8.4, 10.40
  • ENABLE DATABASE command 10.41
  • ENABLE FAR_SYNC command 10.42
  • ENABLE FAST_START FAILOVER command 10.43
  • ENABLE FAST_START FAILOVER CONDITION command 10.44
  • enabling 10.43
    • 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.2.2
  • error messages
  • error status 3.7
  • events
    • monitoring with Oracle Enterprise Manager 1.2.2
    • Oracle Enterprise Manager 1.3
    • reporting 1.5.1
    • responding to 1.3
  • EXIT command 10.46, 10.55
    • See also: QUIT command
  • EXPORT CONFIGURATION command 10.47
  • exporting

F

  • failover
    • failing over to a standby database 10.48
    • Oracle Enterprise Manager 1.5.1
  • FAILOVER command 8.11, 10.48
  • 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.5.2
    • directed from an application 6.5.4
    • disabling 6.5.6
      • to perform manual failover 6.5.6
    • enabling 10.43
    • 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 11.1.7
  • FastStartFailoverLagLimit property 11.1.8
  • FastStartFailoverPmyShutdown property 11.1.9
  • FastStartFailoverTarget property 11.3.11
  • FastStartFailoverThreshold property 11.1.10
  • FASTSYNC redo transport mode 11.3.14
  • FASTSYNC redo transport service 4.4.2
  • files
    • naming the server parameter file 1.6.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_OBSERVER_HOST column
  • FS_FAILOVER_OBSERVER_PRESENT column
  • FS_FAILOVER_STATUS column
    • of V$DATABASE view
  • FSFO.DAT file

H

  • health check 1.3
    • monitoring 1.6.1
    • on primary database 4.11
    • on standby database 4.11
    • revealed by configuration status 3.7
  • HELP command 10.50
  • high availability

I

  • immediate failover 6.4.1, 10.48
  • IMPORT CONFIGURATION command 10.52
  • importing
  • InconsistenLogXptProps property 11.2.1
  • InconsistentProperties property 11.2.2
  • 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.85
    • prerequisites 2.2
  • InstanceName property 11.3.12
  • 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.5.1
    • Data Guard configuration 3.1.1
    • delayed application of redo data 4.6.1
    • delaying 11.3.8
    • in an Oracle RAC database 4.6.4
    • managing 4.6
    • selecting the apply instance 4.6.4.1
    • verifying 1.3
  • log files
  • logical standby databases
    • state transitions 4.2.1
    • switchover to the primary role 6.3
  • LogShipping property 11.3.13
  • LogXptMode property 11.3.14
  • LogXptStatus property 11.2.3
  • LsbyFailedTxnInfo property 11.2.4
  • LsbyParameters property 11.2.5

M

  • management
    • benefits 1.3
    • Oracle Enterprise Manager 1.5.1
  • managing
    • a broker configuration 8
    • broker configurations 3
    • databases 4
    • fast-start failover 6.5
    • local operations 1.2.2
    • log apply services 4.6
    • manual failover 6.4
    • parallel apply in a physical standby database 4.6.2
    • remote operations 1.2.2
    • roles 6
      • fast-start failover 6.5
      • manual failover 6.4
      • switchover 6.3
    • switchover 6.3
  • manual failover 1.3, 6.1
  • manual role changes
    • performing when fast-start failover is enabled 6.5.3.15
  • MaxFailure property 11.3.15
  • maximize availability 1.3, 11.3.14
  • maximize data protection 1.3, 11.3.14
  • maximize performance 1.3, 11.3.14
  • maximum availability
  • maximum performance
  • maximum protection
  • monitorable properties 4.3, 4.3.1, 11.2
  • monitoring
    • broker configurations 1.6.1, 8, 8.14
    • broker processes 1.6.1
    • local and remote databases 1.3
    • Oracle Enterprise Manager performance page 3.5
    • through the command-line interface 1.5.2
  • multitenant container databases

N

  • NetTimeout property 11.3.16
  • network configurations
    • validating before role changes 4.11.4
  • networks
    • Data Guard configuration 3.1.1
    • two-way communication 1.6.1
  • normal status 3.7

O

  • objects
  • observer 6.5
    • and FastStartFailoverThreshold property 6.5.3.4
    • connecting to the configuration 8.7
    • connection to the local computer 6.5.8.2
    • detecting
    • failures 6.5.8.4
    • finding host machine name 6.5.8.2
    • installing Oracle Instant Client kit 2.1, 10.85
    • 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 11.3.17
  • ObserverOverride property 11.1.11
  • ObserverPingInterval property 11.1.12
  • ObserverPingRetry property 11.1.13
  • ObserverReconnect property 11.1.14
  • operations
    • complete failover 10.48
    • 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.48
    • 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 11.1.15
  • ORA-16661 message
  • ORA-16795 message
    • re-creating a database 6.4.3
  • Oracle Clusterware 1.3
    • and instances of an Oracle RAC database 1.3
    • integration with Data Guard broker 1.3
    • recover failed instances 1.3
  • Oracle Enterprise Manager 1.5.1
    • Add Standby Database wizard 1.5.1
    • database property pages 1.5.1
    • event management system 1.3
    • integration 1.5.1
    • integration with the Data Guard monitor 1.5.1
    • introduction 1.2.2, 1.4
    • making Oracle Net Services configuration changes 1.3, 1.5.1
    • monitoring events 1.2.2
    • performance tools and graphs 1.5.1
    • wizards
      • creating standby databases 1.5.1
  • Oracle Instant Client
  • Oracle Net Services
    • configuration changes 1.3, 1.5.1
    • supported configuration 3.1.1
    • two-way communication 1.6.1
  • Oracle RAC One Node
    • supported by Oracle Data Guard broker 1.2
  • 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.3
    • benefits 1.3
    • fast-start failover 6.5.3.11
    • observer behavior in 6.5.3.11
    • observer connection to instances 6.5.8.2
    • Oracle Clusterware 1.3
  • Oracle Universal Installer
    • installing Oracle Instant Client 2.1, 10.85
  • Oracle Wallet
    • starting the observer 10.10

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.5.1
  • physical standby databases
    • managing parallel apply 4.6.2
    • state transitions 4.2.1
    • switchover to the primary role 6.3
  • PreferredApplyInstance property 11.3.18
  • PREPARE DATABASE FOR DATA GUARD command 10.54
  • prerequisites
  • primary database
    • ARCHIVELOG mode 2.2
    • constructing a standby database 3.5, 8.1
    • Data Guard configuration 3.1.1
    • during failover 1.5.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.91
  • PrimaryLostWriteAction property 11.1.17
  • processes
  • properties 4.3.2
  • property pages
  • protection modes

Q

  • QUIT command 10.46, 10.55
    • See also: EXIT command

R

  • RecvQEntries property 11.2.6
  • Redo Apply 3.1.1
  • RedoCompression property 11.3.20
  • RedoRoutes property 11.3.21
  • redo transport services
  • REINSTATE DATABASE command 10.56
  • reinstatement 6.5.9
  • REMOVE CONFIGURATION command 10.57
  • REMOVE DATABASE command 10.58
  • REMOVE FAR_SYNC command 10.59
  • REMOVE INSTANCE command 10.60
  • REMOVE PLUGGABLE DATABASE command 10.61
  • removing
    • See: each REMOVE command
  • ReopenSecs property 11.3.22
  • requests
    • passing between sites 1.6.1
  • restarting
    • databases
      • when fast-start failover is enabled 6.5.10
  • role transitions
    • changing 3.5
    • managing 6
      • fast-start failover 6.5
      • manual failover 6.4
      • switchover 6.3

S

  • scripts
    • using Data Guard command-line interface (DGMGRL) 10
  • selecting the apply instance 4.6.4.1
  • SendQEntries property 11.2.7
  • server parameter file
    • broker property management 1.6.3, 2.2
    • filenames 1.6.3
    • inconsistent values from Data Guard configuration file 11.2.2
  • server parameter files
    • validating before role changes 4.11.3
  • server-side software 1.6
  • SET ECHO command 10.63
  • SET FAST_START FAILOVER TARGET command 10.64
  • 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.64
    • log apply services 4.4.5
    • redo transport services 4.4.6
  • SET TRACE_LEVEL command 10.69
  • SHOW ALL command 10.70
  • SHOW CONFIGURATION command 8.4, 10.71, 10.72
  • SHOW DATABASE command 10.73
  • SHOW FAR_SYNC command 10.74
  • SHOW FAST_START FAILOVER command 10.75
  • showing
    • See: each SHOW command
  • SHOW INSTANCE command 10.76
  • SHOW PLUGGABLE DATABASE 10.80
  • shutdown abort 6.5.3.11
    • effect on fast-start failover 6.5.3.14
  • SHUTDOWN command 10.82
  • shutting down an Oracle instance 10.82
  • single command mode
    • for Data Guard command-line interface 10.1.1
  • SQL Apply 3.1.1
  • SQL command 10.84
  • SQL statements
    • executing from DGMGRL command line 10.84
  • StandbyAlternateLocation property 11.3.23
    • setting log apply services 4.4.5
  • StandbyArchiveLocation property 11.3.24
    • setting log apply services 4.4.5
  • standby databases
    • choosing a target standby database 6.2
    • constructing from backups 3.5, 8.1
    • creating 1.5.1
    • health check 4.11
    • 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.91
  • 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.88
    • switchover 6.3.2
  • START OBSERVER command
    • fast-start failover configuration file (fsfo.dat) 6.5.8.9
  • STARTUP command 10.88
  • 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 11.3.25
  • static connect identifiers
  • status
    • configuration 3.7
    • health check on primary database 4.11
    • health check on standby database 4.11
    • health of the database 4.11
    • intended state of a configuration 3.7
  • status messages
  • STOP OBSERVER command 10.85, 10.89
  • string values
    • Data Guard command-line interface 10.1.3
  • SWITCHOVER command 8.10, 10.91
  • SWITCHOVER PLUGGABLE DATABASE command 10.92
  • switchovers
    • benefits 1.3
    • broker tasks 6.3.3
    • choosing a target standby database 6.2
    • DGMGRL SWITCHOVER command 8.10
    • effect on
      • database startup 10.91
      • 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.5.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.91
  • 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 11.2.8
  • TraceLevel property 11.1.18
  • TransportDisconnectedThreshold property 11.3.26
  • transport lag 4.4.8
  • TransportLagThreshold property 11.3.27
  • TRANSPORT-ON state
    • setting LogShipping property 11.3.13
  • troubleshooting
    • Data Guard 12
    • diagnostics logged in broker drc* log files 12.1
  • tuning
    • redo transport services 4.4.6
  • tuning fast-start failover 4.9.1
  • two-way communication channel 1.6.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
    • FS_FAILOVER_OBSERVER_HOST column 6.5.8.2
    • FS_FAILOVER_OBSERVER_PRESENT column 6.5.8.2
    • viewing
      • fast-start failover statistics 6.5.5.1
  • V$DATAGUARD_PROCESS
    • using to monitor broker processes 1.6.1
  • V$FS_FAILOVER_STATS view 6.5.5.2
  • VALIDATE DATABASE command 10.93
  • VALIDATE DATABASE SPFILE command 4.11.3, 10.95
  • VALIDATE DGConnectIdentifier command 10.96
  • VALIDATE FAR_SYNC command 10.97
  • VALIDATE NETWORK CONFIGURATION command 4.11.4, 10.99
  • VALIDATE STATIC CONNECT IDENTIFIER command 4.11.5, 4.11.6, 10.100

W

  • warning status 3.7
  • wizards
    • Add Standby Database 1.5.1