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 command, 8.2
- Add Standby Database wizard
-
- creating a broker configuration, 3.4, 6.2
- creating a standby database, 6.2
- definition, 1.5.1
- introduction, 1.5.1
- adding
-
- an existing RAC standby database, 6.3
- standby database to the broker configuration, 7.2
- ALTER SYSTEM statement
-
- starting the broker, 7.1
- altering
-
- properties
-
- database, 7.7.1.1
- states
-
- database, 7.7.1.2, 7.7.1.3
- AlternateLocation property, 9.2.1
-
- setting log apply services, 4.4.3
- application integration, 1.2
- apply errors
-
- managing, 4.5.5
- apply instance, 4.5.7
-
- failover, 4.5.7
- of standby database, 4.2.1
- PreferredApplyInstance property, 4.5.7.1
- selecting, 4.5.7.1
- ApplyInstanceTimeout property, 4.5.7.2, 9.2.2
- ApplyParallel property, 4.5.2, 9.2.3
- ARCH redo transport service, 4.4.1
- architecture
-
- Data Guard broker, 1.4
- ARCHIVE_LAG_TARGET initialization parameter
-
- setting in a broker configuration, 9.2.4
- archived redo logs
-
- destination and configuration parameters, 3.1
- in a Data Guard configuration, 3.1
- primary database setup, 2.2
- ArchiveLagTarget property, 9.2.4
- ASYNC redo transport service, 4.4.1
- Automatic Storage Management (ASM)
-
- creating a standby database that uses, 2.2
B
- background processes
-
- DMON, 1.6.1
- banners
-
- suppressing from DGMGRL command-line interface output, 8.1.1
- before you perform a switchover, 5.3.1
- before you use DGMGRL, 7.1
- benefits
-
- Data Guard broker, 1.2
- high availability, 1.2
- scalability, 1.2
- with Real Application Clusters, 1.2
- binary configuration file, 1.6.2
- Binding property, 9.2.5
- broker
-
- components, 1.4
- configuration, 1.1.1
- Data Guard configuration file, 1.6.2
- drc* log files, 10.1
- installation, 2.2
- introduction, 1.1.2
- managing databases, 4.1
- user interfaces, 1.5
- broker configurations, 4.6.2.5
-
- add an existing RAC standby database, 6.3
- benefits, 1.2
- changing roles, 3.4
- components, 3.1
- creating, 6.2, 7.2, 7.2, 8.2
- Data Guard configuration file, 1.6.1
- database objects, 1.3
- database profiles, 1.3
- disabling databases, 3.5, 8.2
- effects of removing metadata from, 8.2
- enabling, 7.4, 8.2
- enabling databases, 3.4, 3.5, 7.4, 8.2
- enabling fast-start failover, 8.2
- health, 1.6.1, 3.6
- instance objects, 1.3
- life cycle, 3.4
- management, 1.3, 1.5.1, 1.5.2, 1.6.2
- monitoring, 6.8, 7.10
- objects, 1.3
- Oracle Net Services configuration, 1.2, 1.5.1
- overview, 3.1
- properties, 4.3
- protection modes, 8.2
- removing, 6.10.2
- setting protection mode, 4.6.1
- status modes, 3.6
- supported, 1.3, 3.1, 3.1
- using SHOW CONFIGURATION to verify fast-start failover, 7.6
- verifying, 6.8.1
C
- CFS
-
- See cluster file system
- changed features, A
- changing
-
- properties
-
- databases in a broker configuration, 3.4, 4.3.2
- of a database in a broker configuration, 6.5.2
- protection mode
-
- of a database in a broker configuration, 6.5.3
- roles
-
- within the broker configuration, 3.4
- states
-
- databases in a broker configuration, 3.4, 4.2.1
- of a standby database in a broker configuration, 6.5.1
- of databases in a broker configuration, 7.7
- See also editing
- cluster file system (CFS)
-
- broker configuration files, 3.2.2.1
- Cluster Ready Services (CRS), 1.2
- command prompts
-
- suppressing from DGMGRL command-line interface output, 8.1.1
- command-line interface
-
- See Data Guard command-line interface (DGMGRL)
- COMPATIBLE initialization parameter
-
- requirements for setting, 2.2
- complete failover, 5.4.1, 8.2
-
- reinstating disabled databases, 5.4.3.1
- components
-
- broker, 1.4
- Data Guard configuration, 3.1
- configurable properties, 4.3
-
- AlternateLocation, 9.2.1
- ApplyInstanceTimeout, 9.2.2
- ApplyParallel, 9.2.3
- ArchiveLagTarget, 9.2.4
- Binding, 9.2.5
- database, 4.3.2, 4.3.2, 9.2
- DbFileNameConvert, 9.2.6
- DelayMins, 9.2.7
- Dependency, 9.2.8
- FastStartFailoverTarget, 9.2.9
- FastStartFailoverThreshold, 9.2.10
- FastStartFailoverThreshold property, 8.2
- HostName, 9.2.11
- InitialConnectIdentifier, 9.2.12
- LocalListenerAddress, 9.2.13
- LogArchiveFormat, 9.2.14
- LogArchiveMaxProcesses, 9.2.15
- LogArchiveMinSucceedDest, 9.2.16
- LogArchiveTrace, 9.2.17
- LogFileNameConvert, 9.2.18
- LogShipping, 9.2.19
- LogXptMode, 9.2.20
- LsbyASkipCfgPr, 9.2.21
- LsbyASkipErrorCfgPr, 9.2.22
- LsbyASkipTxnCfgPr, 9.2.23
- LsbyDSkipCfgPr, 9.2.24
- LsbyDSkipErrorCfgPr, 9.2.25
- LsbyDSkipTxnCfgPr, 9.2.26
- LsbyMaxEventsRecorded, 9.2.27
- LsbyMaxServers, 9.2.29
- LsbyMaxSga, 9.2.28
- LsbyRecordAppliedDdl, 9.2.30
- LsbyRecordSkipDdl, 9.2.31
- LsbyRecordSkipErrors, 9.2.32
- LsbyTxnConsistency, 9.2.33
- managing redo transport services, 4.4
- MaxConnections, 9.2.34
- MaxFailure, 9.2.35
- NetTimeout, 9.2.36
- PreferredApplyInstance, 9.2.37
- ReopenSecs, 9.2.38
- SidName, 9.2.39
- StandbyArchiveLocation, 9.2.40
- StandbyFileManagement, 9.2.41
- TopWaitEvents, 9.1.11
- configuration files
-
- fast-start failover configuration (fsfo.dat) file, 5.5.6.6
- located on raw devices, 3.2.1
- See Also Data Guard configuration file
- CONNECT command, 7.2, 8.2
- connecting
-
- privileges required for Data Guard broker configurations, 8.1.3
- starting the observer, 7.6
- to the primary database, 7.2
- to the standby database, 4.4.6
- connection credentials
-
- using Oracle Wallet, 7.6
- controlling
-
- available SGA memory, 4.5.3
- transaction consistency level, 4.5.3
- CREATE CONFIGURATION command, 7.2, 8.2
- creating
-
- a broker configuration, 6.2, 7.2, 7.2, 7.2, 8.2
-
- with the Add Standby Database wizard, 3.4
- a standby database, 3.4, 6.2, 6.2, 8.2
D
- Data Guard
-
- troubleshooting, 10
- Data Guard broker
-
- changed features, A
- deprecated features, A
- integration with Oracle Enterprise Manager, 6.1
- See Alsobroker
- Data Guard command-line interface
-
- commands, 1.5.2
-
- ENABLE FAST_START FAILOVER, 8.2
- SET STATE, 4.5.7.1
- DG_BROKER_START initialization parameter, 2.2
- enabling a database, 7.4
- introduction, 1.1.2, 1.5.2
- Data Guard command-line interface (DGMGRL)
-
- banners from output, 8.1.1
- commands
-
- ADD DATABASE, 8.2
- CONNECT, 8.2
- CREATE CONFIGURATION, 8.2
- DISABLE CONFIGURATION, 8.2
- DISABLE DATABASE, 8.2
- DISABLE FAST_START FAILOVER, 5.5.4, 8.2
- EDIT CONFIGURATION (property), 8.2
- EDIT CONFIGURATION (protection mode), 8.2
- EDIT DATABASE (property), 8.2
- EDIT DATABASE (rename), 8.2
- EDIT DATABASE (state), 8.2
- EDIT INSTANCE (AUTO PFILE), 8.2
- EDIT INSTANCE (property), 8.2
- ENABLE CONFIGURATION, 8.2
- ENABLE DATABASE, 8.2
- EXIT, 8.2
- FAILOVER, 7.9
- HELP, 8.2
- QUIT, 8.2
- REMOVE CONFIGURATION, 8.2
- REMOVE DATABASE, 8.2
- REMOVE INSTANCE, 8.2
- SHOW CONFIGURATION, 8.2
- SHOW DATABASE, 8.2
- SHOW INSTANCE, 8.2
- SHUTDOWN, 8.2
- STARTUP, 8.2
- SWITCHOVER, 7.8, 8.2
- creating
-
- a standby database, 8.2
- and adding a primary database, 8.2
- creating a configuration, 7.2
- DG_BROKER_START initialization parameter, 8.1.3
- enabling the configuration, 7.4
- FAILOVER command, 5.4.2
- FSFO.DAT file creation, 8.2
- monitoring broker configurations, 7.10
- performing routine management tasks, 7.7
- prerequisites, 7.1
- setting critical database properties, 7.3
- setting up standby redo log files, 4.6.1
- single command mode, 8.1.1
- starting, 7.2, 8.1
- stopping, 8.2
- string values, 8.1.3
- summary of commands, 8.1.2
- suppressing command prompts, 8.1.1
- Data Guard configuration file
-
- for a RAC database, 3.2.2
- in a CFS area, 3.2.2.1
- inconsistent values from server parameter file, 9.1.2
- on a raw device, 3.2.2.3
- relationship to DMON process, 1.6.1
- renaming, 1.6.2
- setting up, 3.2
- Data Guard configurations
-
- automated creation of, 1.2
- background, 3.1
- supported, 3.1
- Data Guard Fast-Start Failover metrics
-
- understanding, 6.9.1.1
- Data Guard monitor (DMON), 1.6
-
- in a broker configuration, 3.1
- in a Data Guard configuration, 3.1
- interaction with the Oracle database, 1.6.1
- maintaining configuration data, 1.6.2
- managing objects, 3.1, 3.4, 7.4
- Oracle database background processes, 1.6.1
- overview, 1.6.1
- removing objects, 7.7.3
- running on each location, 3.1
- starting with the DG_BROKER_START parameter, 3.3
- two-way network communication, 1.6.1
- Data Guard Performance metric
-
- understanding, 6.9.1.2
- Data Guard Status metric
-
- understanding, 6.9.1.3
- data protection modes
-
- See protection modes
- database resources
-
- monitoring, 1.2
- databases
-
- changing the state of, 7.7
- connecting to, 7.2
- creating and adding to a broker configuration, 1.5.1
- dependencies, 4.2
- disabling management of, 8.2
- during
-
- fast-start failover, 5.5
- manual failover, 5.4
- switchover, 5.3
- enabling, 7.4
- health, 4.7
- installation for broker management, 2.2
- monitorable database properties, 4.3.1, 9.1
- network setup, 1.6.1, 2.2
- objects, 1.3
-
- definition, 1.3
- in a broker configuration, 1.3
- prerequisites for broker configurations, 2.2
- properties, 1.5.1, 4.3.2, 9.2
- property management, 1.6.3
- reenabling after a role transition, 5.4.3
- removing
-
- from a broker configuration, 7.7.3
- restarting
-
- after fast-start failover, 5.5.8
- after manual failover, 8.2
- shutting down
-
- effect on fast-start failover, 5.5.2.1, 5.5.2.3, 5.5.8
- states, 4.2
-
- dependencies, 4.2
- transitions, 4.2.1
- status, 4.7
- DB_FILE_NAME_CONVERT initialization parameter
-
- initialization parameters
-
- setting DB_FILE_NAME_CONVERT in a broker configuration, 9.2.6
- DB_ROLE_CHANGE system event, 5.1
- DB_UNIQUE_NAME initialization parameter, 4.4.6
- db_unique_name_DGMGRL static service name
-
- registering, 2.2
- db_unique_name_XPT static service name, 4.4.6
- DBA_LOGSTDBY_EVENTS table
-
- managing, 4.5.6
- DbFileNameConvert property, 9.2.6
- delaying
-
- application of redo data with DelayMins property, 4.5.1
- DelayMins property, 9.2.7
-
- delaying log apply services, 4.5.1
- Dependency property, 4.4.4, 9.2.8
- deprecated features, A
- destinations
-
- archived redo log file parameters, 3.1
- viewing the LogXptStatus property, 9.1.3
- DG_BROKER_CONFIG_FILEn file, 1.6.2, 3.2.2
-
- in a CFS area, 3.2.2.1
- on a raw device, 3.2.2.3
- DG_BROKER_START initialization parameter, 2.1, 2.2, 7.1, 8.1.3
- DGMGRL
-
- See Data Guard command-line interface (DGMGRL)
- DGMGRL commands
-
- FAILOVER, 8.2
- SWITCHOVER, 8.2
- diagnostic information
-
- sources, 10.1
- diagrams of database state transitions, 4.2.1
- DISABLE CONFIGURATION command, 8.2
-
- example, 7.7.2.1
- DISABLE DATABASE command, 8.2
-
- example, 7.7.2.2
- DISABLE FAST_START FAILOVER command, 5.5.4, 8.2
- disabling
-
- broker configuration, 7.7.2, 8.2
- broker management of standby database, 8.2
- databases, 3.5, 7.7.2.1, 7.7.2.2
- fast-start failover, 5.5.4, 8.2
-
- on a standby database, 5.5.4
- See also each DISABLE command
- disaster protection
-
- benefits, 1.2
- displaying
-
- configuration information, 8.2
- help for DGMGRL commands, 8.2
- help for Enterprise Manager, 6.1
- properties, 4.3
- distributed management framework, 1.1.2
- DMON
-
- See Data Guard monitor (DMON)
- downgrading
-
- Data Guard, B.4
- Oracle Enterprise Manager, B.4
- protection mode, 4.6.2.1
- drc* log files
-
- broker diagnostic information, 10.1
- during reinstatement, 5.5.3
- recording failed reinstatment, 5.5.7.3
E
- EDIT CONFIGURATION (Property) command, 8.2
- EDIT CONFIGURATION (protection mode) command, 8.2
- EDIT DATABASE (property) command, 8.2
-
- example, 7.7.1.1
- EDIT DATABASE (rename) command, 8.2
- EDIT DATABASE (state) command, 8.2
-
- example, 7.7.1.2
- EDIT INSTANCE (AUTO PFILE) command, 8.2
- EDIT INSTANCE (property) command, 8.2
- editing
-
- configurable properties, 8.2
- database instance, 8.2, 8.2
- database name, 8.2
- database properties, 8.2
- database state, 8.2
- protection modes, 8.2
- effect of switchovers on, 5.3.3
- e-mail
-
- reporting events, 1.5.1
- ENABLE CONFIGURATION command, 7.4, 8.2
- ENABLE DATABASE command, 8.2
- ENABLE FAST_START FAILOVER command, 8.2
- enabling
-
- broker configuration, 3.4, 7.4, 7.4, 7.4
- databases in a broker configuration, 3.5
- fast-start failover, 5.5.1, 5.5.2, 6.4
- See also each ENABLE command
- Enterprise Edition database
-
- installation, 2.1
- Enterprise Manager
-
- adding an existing RAC standby database, 6.3
- changing
-
- database properties, 6.5.2
- database protection mode, 6.5.3
- database state, 6.5.1
- creating
-
- a configuration, 6.2
- a standby database, 6.2
- Fast-Start Failover wizard
-
- disabling fast-start failover, 5.5.4
- managing metrics, 6.9.2
- monitoring
-
- broker configurations, 6.8
- configuration performance, 6.8.3
- performing
-
- fast-start failover, 6.4
- manual failover, 6.7
- routine maintenance, 6.5
- switchover, 6.6
- removing
-
- broker configuration, 6.10.2
- standby database, 6.10.1
- starting, 6.1
- using metrics, 6.9
- verifying a broker configuration, 6.8.1
- viewing log file details, 6.8.2
- wizards
-
- automate standby database creation, 1.1.2
- error messages
-
- ORA-16795, 5.4.3, 5.4.3
- error status, 3.6
- events
-
- managing
-
- in a logical standby database, 4.5.6
- monitoring with Oracle Enterprise Manager, 1.1.2
- Oracle Enterprise Manager, 1.2
- reporting, 1.5.1
- responding to, 1.2
- EXIT command, 8.2
-
- See also QUIT command
F
- failover
-
- database restarts and, 8.2
- failing over to a standby database, 8.2
- Oracle Enterprise Manager, 1.5.1
- FAILOVER command, 7.9, 8.2
-
- manual failover, 5.4.2
- failovers
-
- and FastStartFailoverTarget property, 7.6
- benefits, 1.2
- broker tasks, 5.4.2.1
- choosing a target standby database, 5.2
- complete, 5.4.2, 5.4.2.1
- defined, 5.1
- fast-start failover, 5.5.2.2
-
- effect on data protection mode, 5.5.1
- V$DATABASE, 5.5.3
- immediate, 5.4.2.2
- managing, 5
-
- fast-start, 5.5
- manual, 5.4
- manual
-
- complete option, 5.4.1
- effect on data protection mode, 5.4.2
- immediate option, 5.4.1
- reenabling disabled databases after, 5.4.2.1, 5.4.3
- scenario
-
- fast-start failover, 6.4
- manual failover, 6.7
- starting manually, 5.4.2
- to a RAC database, 5.4.2
- troubleshooting, 10.4
- using DGMGRL, 7.9
- failures
-
- observer, 5.5.6.3
- primary database, 5.1
- fast-start failover, 5.1
-
- broken network connections, 5.5.2.1
- conditions resulting in, 5.5.2.1
- configuration information in the fsfo.dat file, 5.5.6.6
- defined, 5.5
- DGMGRL client as the observer, 1.5.2
- disabling, 5.5.4, 5.5.4
-
- to perform manual failover, 5.5.4
- enabling, 5.5.2, 6.4, 8.2
- instance failures, 5.5.2.1
- monitoring by the observer, 5.5.2.1
- observer monitoring, 5.5.2.1
- observer overview, 5.5
- offline data files, 5.5.2.1
- performing manual failovers when enabled, 5.5.2.4
- performing switchover when enabled, 5.5.2.4
- querying V$DATABASE, 5.5.2.2
- reinstating the former primary database, 5.5.7
- requirements, 5.5.1
- restarting databases after shut down, 5.5.8
- setting the FastStartFailoverTarget property, 5.5.2, 5.5.2, 5.5.2, 7.6
- setting the FastStartFailoverThreshold property, 5.5.2, 6.4
- shutdown abort, 5.5.2.1, 5.5.2.3
- shutting down databases, 5.5.8
- starting the observer, 5.5.2
- to RAC database instances, 5.5.2.1
- unobserved, 5.5.6.3
- using SHOW CONFIGURATION to verify, 7.6
- using SHOW CONFIGURATION VERBOSE, 5.5.3
- verifying the environment, 5.5.2
- viewing failover configuration statistics, 5.5.3
- FastStartFailoverTarget property, 9.2.9
-
- setting, 5.5.2, 5.5.2, 5.5.2, 7.6
- FastStartFailoverThreshold property, 9.2.10
-
- conditions causing fast-start failover, 5.5.2.1
- configurable property, 8.2
- setting, 5.5.2, 6.4
- files
-
- naming the server parameter file, 1.6.3
- Flashback Database
-
- reinstating databases, 5.4.3.1
- use after failover, 5.4.2.1
- flashback logs
-
- reinstating a failed primary database, 5.4.3.1
- FORCE option
-
- disabling fast-start failover, 5.5.4, 8.2
- performing a manual failover, 5.5.4
- FS_FAILOVER_OBSERVER_HOST column
-
- of V$DATABASE view, 5.5.6.2
- FS_FAILOVER_OBSERVER_PRESENT column
-
- of V$DATABASE view, 5.5.6.2
- FS_FAILOVER_STATUS column
-
- of V$DATABASE view
-
- failed reinstatement, 5.5.3
- FSFO.DAT file
-
- overview, 5.5.6.6
- START OBSERVER command, 8.2
G
- global service names
-
- registering, 2.2
- GLOBAL_DBNAME attribute
-
- setting, 2.2
H
- health check, 1.2
-
- monitoring, 1.6.1, 1.6.1
- on primary database, 4.7
- on standby database, 4.7
- revealed by configuration status, 3.6
- StatusReport property, 4.7
- HELP command, 8.2
- high availability
-
- benefits, 1.2
- levels of data protection, 4.6, 9.2.20
- LogXptMode property, 9.2.20
- restoring after fast-start failover, 5.5.7
- HostName property, 9.2.11
I
- immediate failover, 5.4.1, 8.2
- InconsistentProperties property, 9.1.2
- increased scalability
-
- benefits, 1.2
- InitialConnectIdentifier property, 9.2.12
- initialization parameters
-
- COMPATIBLE, 2.2
- database configurable properties, 4.3.2
- DB_UNIQUE_NAME, 4.4.6
- DG_BROKER_CONFIG_FILEn, 3.2.2
- DG_BROKER_START, 2.2, 7.1
- dynamic, 4.3.2
- inconsistent, 9.1.2
- INSTANCE_NAME, 4.4.6
- LOCAL_LISTENER, 2.2, 4.4.6, 4.4.6
- LOG_ARCHIVE_DEST_n, 4.4.5
- static, 4.3.2
- See also server parameter file, 2.2
- installation
-
- ARCHIVELOG mode setup, 2.2
- Data Guard, 2.1
- Oracle Enterprise Manager, 2.1
- Oracle Instant Client, 2.1, 8.2
- prerequisites, 2.2
- INSTANCE_NAME initialization parameter, 4.4.6
- instances
-
- failures, 5.5.2.1
- objects
-
- in a broker configuration, 1.3
- removing, 8.2
- restarting during the course of broker operations, 2.2
- shutting down, 8.2
- starting, 8.2
- intended state
-
- configuration health check, 3.6
- invoking
-
- the Data Guard command-line interface, 7.2
L
- life cycle of a broker configuration, 3.4
- listener
-
- address, 4.4.6
- LISTENER.ORA file
-
- registering global service names, 2.2
- local listener
-
- for RAC databases, 2.2
- statically registering services with, 2.2
- LOCAL_LISTENER initialization parameter, 2.2, 4.4.6, 4.4.6, 4.4.6, 9.2.13
-
- for standby instances, 4.4.6
- LocalListenerAddress property, 9.2.13
- log apply services
-
- and apply instance failover, 4.5.7, 4.5.7.2
- and parallel apply, 4.5.2
- apply instance, 4.5.7
- configuring, 1.2, 1.5.1
- Data Guard configuration, 3.1
- delayed application of redo data, 4.5.1
- delaying, 9.2.7
- in a RAC database, 4.5.7
- managing, 4.5
- selecting the apply instance, 4.5.7.1
- verifying, 1.2
- log files
-
- broker, 5.5.7.3
- FSFO.DAT
-
- creating, 8.2
- viewing, 6.8.2
- LOG_ARCHIVE_DEST_n initialization parameter
-
- SERVICE attribute, 4.4.6
- setting redo transport services, 4.4.5
- setting the DELAY attribute, 9.2.7
- setting the DEPENDENCY attribute, 9.2.8
- setting the ENABLE and DEFER attributes, 9.2.19
- setting the MANDATORY or OPTIONAL attributes, 9.2.5
- LOG_ARCHIVE_FORMAT initialization parameter, 9.2.14
- LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 9.2.15
- LOG_ARCHIVE_MIN_SUCCEED initialization parameter, 9.2.16
- LOG_ARCHIVE_TRACE initialization parameter
-
- setting LogArchiveTrace property, 9.2.17
- LOG_FILE_NAME_CONVERT initialization parameter
-
- setting LogFileNameConvert property, 9.2.18
- LogArchiveFormat property, 9.2.14
- LogArchiveMaxProcesses property, 9.2.15
- LogArchiveMinSucceedDest property, 9.2.16
- LogArchiveTrace property, 9.2.17
- LogFileNameConvert property, 9.2.18
- logical standby databases
-
- and SQL Apply error handling, 4.5.5
- and SQL Apply filters, 4.5.4
- during switchovers, 5.3.3
- managing events, 4.5.6
- SQL Apply, 4.5.3
- state transitions, 4.2.1
- switchover to the primary role, 5.3
- LogShipping property, 9.2.19
- LOG-TRANSPORT-OFF state
-
- LogShipping property setting, 9.2.19
- LogXptMode property, 9.2.20
- LogXptStatus property, 9.1.3
- LsbyASkipCfgPr property, 9.2.21
- LsbyASkipErrorCfgPr property, 4.5.5, 9.2.22
- LsbyASkipTxnCfgPr property, 9.2.23
- LsbyDSkipCfgPr property, 9.2.24
- LsbyDSkipErrorCfgPr property, 4.5.5, 9.2.25
- LsbyDSkipTxnCfgPr property, 9.2.26
- LsbyFailedTxnInfo property, 9.1.4
- LsbyMaxEventsRecorded property, 9.2.27
- LsbyMaxServers property, 9.2.29
- LsbyMaxSga property, 4.5.3, 9.2.28
- LsbyParameters property, 9.1.5
- LsbyRecordAppliedDdl property, 9.2.30
- LsbyRecordSkipDdl property, 9.2.31
- LsbyRecordSkipErrors property, 9.2.32
- LsbySkipTable property, 9.1.6
- LsbySkipTxnTable property, 9.1.7
- LsbyTxnConsistency property, 4.5.3, 9.2.33
M
- management
-
- benefits, 1.2
- model, 1.3
- Oracle Enterprise Manager, 1.5.1
- managing
-
- a broker configuration, 3, 7
- apply errors, 4.5.5
- Data Guard metrics, 6.9.2
- databases, 4
- DBA_LOGSTDBY_EVENTS table, 4.5.6
- events
-
- in a logical standby database, 4.5.6
- fast-start failover, 5.5
- local operations, 1.1.2
- log apply services, 4.5
- manual failover, 5.4
- objects in a broker configuration, 1.3
- parallel apply in a physical standby database, 4.5.2
- remote operations, 1.1.2
- roles, 5
-
- fast-start failover, 5.5
- manual failover, 5.4
- switchover, 5.3
- switchover, 5.3
- MANDATORY attribute
-
- set with the Binding property, 9.2.5
- manual failover, 1.2, 5.1
-
- complete option, 5.4.1
- effect on protection modes, 4.6.2.3
- immediate option, 5.4.1
- performing when fast-start failover is enabled, 5.5.2.4, 5.5.4
- starting, 5.4.2
- to a RAC database, 5.4.2
- manual role changes
-
- performing when fast-start failover is enabled, 5.5.2.4
- MaxConnections property, 9.2.34
- MaxFailure property, 9.2.35
- maximize availability, 1.2, 3.4, 9.2.20
- maximize data protection, 1.2, 3.4, 9.2.20
- maximize performance, 1.2, 3.4, 9.2.20
- maximum availability
-
- data protection mode, 4.6.1
- maximum performance
-
- data protection mode, 4.6.1
- maximum protection
-
- data protection mode, 4.6.1
- metrics
-
- Data Guard Fast-Start Failover, 6.9.1.1
- Data Guard Performance, 6.9.1.2
- Data Guard Status, 6.9.1.3
- managing, 6.9.2
- using, 6.9
- monitorable properties, 4.3
-
- database, 4.3.1
- InconsistentProperties, 9.1.2
- LogXptStatus, 9.1.3, 9.1.3
- LsbyFailedTxnInfo, 9.1.4, 9.1.4
- LsbyParameters, 9.1.5
- LsbySkipTable, 9.1.6
- LsbySkipTxnTable, 9.1.7
- RecvQEntries, 9.1.8
- SendQEntries, 9.1.9
- StatusReport, 9.1.10
- monitoring
-
- broker configurations, 1.6.1, 6.8, 7, 7.10
- configuration performance, 6.8.3
- local and remote databases, 1.2
- observer
-
- fast-start failover environment, 5.5.2.1
- Oracle Enterprise Manager performance page, 3.4
- through the command-line interface, 1.5.2
N
- NetTimeout property, 9.2.36
- networks
-
- broken connections, 5.5.2.1
- Data Guard configuration, 3.1
- setting up files, 2.2
- two-way communication, 1.6.1
- normal status, 3.6
O
- objects
-
- broker configuration, 1.3, 3.1
- disabling, 7.7.2
- properties for databases, 1.6.3
- relationship, 1.3
- observer, 5.5
-
- and FastStartFailoverThreshold property, 5.5.2, 6.4
- connecting to the configuration, 7.6
- connection to the local computer, 5.5.6.2
- detecting
-
- broken network connections, 5.5.2.1
- database shutdown, 5.5.2.1, 5.5.2.3
- instance failures, 5.5.2.1
- offline data files, 5.5.2.1
- failures, 5.5.6.3
- finding host machine name, 5.5.6.2
- installing Oracle Instant Client kit, 2.1, 8.2
- lost connection, 5.5.6.3
- maintaining fast-start failover configuration information, 5.5.6.6
- monitoring, 5.5.2.1, 5.5.2.1
- shutting down, 5.5.8
- starting, 5.5.2
- using Oracle Wallet for connection credentials, 7.6, 8.2, 8.2
- offline data files
-
- broken, 5.5.2.1
- ONLINE state
-
- setting LogShipping property, 9.2.19
- operations
-
- complete failover, 8.2
- disable broker management
-
- effect on protection modes, 4.6.2.4
- downgrade
-
- effect on protection modes, 4.6.2.1
- effect on protection modes, 4.6.2
- enable broker management
-
- effect on protection modes, 4.6.2.4
- failover, 7.9
-
- troubleshooting, 10.4
- fast-start failover scenario, 6.4
- immediate failover, 8.2
- manual failover
-
- effect on protection modes, 4.6.2.3
- manual failover scenario, 6.7
- removing a database from the configuration
-
- effect on protection modes, 4.6.2.5
- upgrade
-
- effect on protection modes, 4.6.2.1
- OPTIONAL attribute
-
- set with the Binding property, 9.2.5
- ORA-16649 message, 5.5.2.2
- ORA-16661 message
-
- reinstating a database, 5.4.3, 5.4.3, 5.4.3.1
- ORA-16795 message
-
- re-creating a database, 5.4.3
- Oracle Cluster Repository (OCR)
-
- setting START_OPTIONS, 2.2
- Oracle Clusterware
-
- and instances of a RAC database, 1.2
- integration with Data Guard broker, 1.2
- recover failed instances, 1.2
- Oracle Enterprise Manager, 1.5.1
-
- Add Standby Database wizard, 1.5.1
- database property pages, 1.5.1
- downgrading, B.4
- event management system, 1.2
- integration, 1.5.1
- integration with the Data Guard monitor, 1.5.1
- introduction, 1.1.2, 1.4
- making Oracle Net Services configuration changes, 1.2, 1.5.1
- monitoring events, 1.1.2
- Overview page, 1.5.1
- performance tools and graphs, 1.5.1
- setting up standby redo log files, 4.6.1
- upgrading, B.1, B.2
- wizards
-
- creating standby databases, 1.5.1
- Oracle Instant Client
-
- installing, 2.1, 8.2
- Oracle Managed Files (OMF)
-
- creating a standby database that uses, 2.2
- Oracle Net Services
-
- configuration changes, 1.2, 1.5.1
- installation prerequisites, 2.2
- supported configuration, 3.1
- two-way communication, 1.6.1
- Oracle Universal Installer
-
- installing Oracle Instant Client, 2.1, 8.2
- Oracle Wallet
-
- starting the observer, 8.2, 8.2
- when starting the observer, 7.6
P
- parallel apply
-
- and log apply services, 4.5.2
- managing in a physical standby database, 4.5.2
- performance
-
- Enterprise Manager tools, 6.8.3
- Oracle Enterprise Manager tools, 1.5.1
- Personal Edition database
-
- installation, 2.1
- physical standby databases
-
- during switchovers, 5.3.3
- managing parallel apply, 4.5.2
- state transitions, 4.2.1
- switchover to the primary role, 5.3
- port numbers
-
- setting nondefault, 2.2, 4.4.6
- PreferredApplyInstance property, 4.5.7.1, 9.2.37
- prerequisites
-
- installation, 2.2
- setting a nondefault port number, 2.2, 4.4.6
- switchover, 5.3.1
- primary database
-
- ARCHIVELOG mode, 2.2
- configuration, 3.1
- connecting to, 7.2, 7.2
- constructing a standby database, 3.4, 7.1
- Data Guard configuration, 3.1
- during failover, 1.5.1
- during switchover, 5.3.3
- failed
-
- reenabling, 5.4.3
- Flashback Database, 5.4.3.1
- health check, 4.7
- preparing for switchover, 5.3.1
- reinstating
-
- REINSTATEMENT command, 5.4.3.1
- reinstating after a fast-start failover, 5.5.7
- shutting down when fast-start failover is enabled, 5.5.8
- standby redo log files on, 4.6.1
- state transitions, 4.2.1
- switching over to the standby role, 8.2
- processes
-
- DMON, 1.6.1
- Oracle database, 1.6.1
- properties, 4.3.2
-
- AlternateLocation, 4.4.3
- ApplyInstanceTimeout, 4.5.7.2
- ApplyParallel, 4.5.2
- configurable, 4.3, 8.2
- database, 4.3
- DelayMins, 4.5.1
- Dependency, 4.4.4
- LsbyASkipErrorCfgPr, 4.5.5
- LsbyDSkipErrorCfgPr, 4.5.5
- LsbyMaxSga, 4.5.3
- LsbyTxnConsistency, 4.5.3
- managing, 1.6.3
- monitorable, 4.3
- PreferredApplyInstance, 4.5.7.1
- setting, 3.4, 6.5.2, 7.3
-
- in server parameter file, 1.6.3, 2.2
- StandbyArchiveLocation, 4.4.3
- StatusReport, 4.7
- property pages
-
- configuring, 1.5.1
- database, 1.5.1
- protection modes
-
- after a failover, 4.6.2.3, 5.4.2, 5.5.1
- benefits, 1.2
- configuration, 8.2
- downgrading, 4.6.2.1
- of a database
-
- changing in a broker configuration, 6.5.3
- redo transport services setup, 9.2.20
- setting for a broker configuration, 4.6
- updating, 3.4
- upgrading, 4.6.2.1
Q
- QUIT command, 8.2
-
- See also EXIT command
R
- RAC databases
-
- during switchovers, 5.3.3
- registering services with the local listener, 2.2
- raw devices
-
- and broker configuration files, 3.2.2.3
- configuration files located on, 3.2.1
- sizing, 3.2.2.3
- Real Application Clusters
-
- adding to a broker configuration, 6.3
- and apply instance failover, 4.5.7.2
- and log apply services, 4.5.7
- and redo transport services, 4.4.7
- and setting the apply instance, 4.5.7.1
- availability of instances with Oracle Clusterware, 1.2
- benefits, 1.2
- Cluster Ready Services (CRS), 1.2
- effect of switchover on databases, 5.3.3
- failing over to a database in, 5.4.2
- fast-start failover, 5.5.2.1
- observer behavior in, 5.5.2.1
- observer connection to instances, 5.5.6.2
- setting START_OPTIONS in OCR, 2.2
- RecvQEntries property, 9.1.8
- Redo Apply, 3.1, 5.3.3
- redo transport services
-
- and connections to the standby database, 4.4.6
- ARCH mode, 4.4.1, 9.2.20
- ASYNC mode, 4.4.1, 9.2.20
- configuring, 1.2, 1.5.1
-
- data protection modes, 9.2.20
- Data Guard configuration, 3.1
- in a RAC environment, 4.4.7
- LogShipping property, 9.2.19
- managing, 4.4
- SYNC mode, 4.4.1, 9.2.20
- tuning, 4.4.5
- turning off, 4.4.2
- turning on, 4.4.2
- verifying, 1.2
- reenabling
-
- a database after failover or switchover, 5.4.3
- registering
-
- db_unique_name_DGMGRL service name, 2.2
- db_unique_name_XPT service name, 4.4.6
- reinstatement, 5.5.7
-
- disabled databases, 5.4.3.1, 5.4.3.1
- failiure logged in broker drc* log files, 5.5.3
- Flashback Database requirement, 5.4.3.1
- flashback logs requirement, 5.4.3.1
- how to, 5.4.3.1
- logged in broker log files, 5.5.7.3
- ORA-16661 message, 5.4.3, 5.4.3, 5.4.3.1
- requires standby redo log files, 4.6.1
- using DGMGRL
-
- DGMGRL, 5.4.3.1
- using Enterprise Manager, 5.4.3.1
- REINSTATEMENT command, 5.4.3.1
- relationship
-
- objects in a broker configuration, 1.3
- REMOVE CONFIGURATION command, 8.2
-
- example, 7.7.3
- REMOVE DATABASE command, 8.2
- REMOVE INSTANCE command, 8.2
- removing, 4.6.2.5
-
- a standby database, 4.6.2.5
- broker configurations, 4.6.2.5, 6.10.2
- See each REMOVE command
- standby databases, 6.10.1
- ReopenSecs property, 9.2.38
- requests
-
- passing between sites, 1.6.1
- requirements
-
- for enabling fast-start failover, 5.5.1
- restarting
-
- databases
-
- when fast-start failover is enabled, 5.5.8
- instances, 2.2
- role transitions
-
- changing, 3.4
- managing, 5
-
- fast-start failover, 5.5
- manual failover, 5.4
- switchover, 5.3
- reenabling databases after, 5.4.3, 5.4.3
- writing triggers to manage tasks after, 5.1
S
- scenarios
-
- switchover, 6.6
- scripts
-
- using Data Guard command-line interface (DGMGRL), 8
- selecting the apply instance, 4.5.7.1
- SendQEntries property, 9.1.9
- server parameter file
-
- broker property management, 1.6.3, 2.2
- filenames, 1.6.3
- inconsistent values from Data Guard configuration file, 9.1.2
- server-side software, 1.6
- service names
-
- registering
-
- db_unique_name_DGMGRL, 2.2
- db_unique_name_XPT, 4.4.6
- SET STATE command
-
- and setting the apply instance, 4.5.7.1
- setting
-
- a dependent standby database, 4.4.4
- configuration protection mode, 4.6.1
- database properties, 7.3
- log apply services, 4.4.3
- redo transport services, 4.4.5
- SGA memory
-
- and SQL Apply, 4.5.3
- SHOW CONFIGURATION command, 7.2, 7.2, 7.4, 8.2
-
- verifying fast-start failover configuration, 7.6
- SHOW CONFIGURATION VERBOSE command
-
- viewing fast-start failover statistics, 5.5.3
- SHOW DATABASE command, 8.2
- SHOW DATABASE VERBOSE command
-
- displaying properties, 4.3
- SHOW INSTANCE command, 8.2
- showing
-
- See each SHOW command
- shutdown
-
- FS_FAILOVER_OBSERVER_PRESENT view, 5.5.8
- shutdown abort, 5.5.2.1
-
- effect on fast-start failover, 5.5.2.3
- SHUTDOWN command, 8.2
- shutting down an Oracle instance, 8.2
- SidName property, 9.2.39
- single command mode
-
- for Data Guard command-line interface, 8.1.1
- SQL Apply, 3.1
-
- and logical standby databases, 4.5.3
- effect of switchovers on, 5.3.3
- error handling
-
- and logical standby databases, 4.5.5
- filters
-
- and logical standby databases, 4.5.4
- standby databases
-
- apply instance, 4.2.1
- changing the state of, 6.5.1
- choosing a target standby database, 5.2
- constructing from backups, 3.4, 7.1
- creating, 1.5.1, 6.2, 6.2
-
- if primary database uses ASM or OMF, 2.2
- Data Guard configuration, 3.1
- DB_UNIQUE_NAME initialization parameter, 4.4.6
- health check, 4.7
- LOCAL_LISTENER initialization parameter, 4.4.6
- managing connections, 4.4.6
- not involved in a switchover, 5.3.3
- reenabling after failover, 5.4.2.1
- reinstating, 5.4.3.1
- removing, 4.6.2.5, 6.10.1, 8.2
- require standby redo log files, 4.6.1
- shutting down when fast-start failover is enabled, 5.5.8
- specifying the location of archived redo logs, 4.4.3
- switching over to the primary role, 8.2
- standby redo log files
-
- setting up, 4.6.1
- setting up with DGMGRL, 4.6.1
- StandbyArchiveLocation property, 9.2.40
-
- setting log apply services, 4.4.3
- StandbyFileManagement property, 9.2.41
- START OBSERVER command
-
- fast-start failover configuration file (fsfo.dat), 5.5.6.6
- START_OPTIONS
-
- setting in the Oracle Cluster Repository (OCR), 2.2
- starting
-
- Data Guard command-line interface (DGMGRL), 7.2, 8.1
- Data Guard monitor (DMON), 3.3
- Data Guard Web pages in Enterprise Manager, 6.1
- manual failover, 5.4.2
- Oracle instance, 8.2
- switchover, 5.3.2
- the observer, 5.5.2
- STARTUP command, 8.2
- 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
- states, 3.5
-
- any type of database
-
- OFFLINE, 4.2
- changing, 3.4, 7.7
- database, 4.2
- database transitions, 4.2.1
- logical standby database
-
- LOG-APPLY-OFF, 4.2
- ONLINE, 4.2
- of a standby database
-
- changing in a broker configuration, 6.5.1
- physical standby database
-
- LOG-APPLY-OFF, 4.2
- ONLINE, 4.2
- READ-ONLY, 4.2
- primary database
-
- LOG-TRANSPORT-OFF, 4.2
- ONLINE, 4.2
- static service name registration, 2.2, 4.4.6, 4.4.6
- status
-
- configuration, 3.6
- health check on primary database, 4.7
- health check on standby database, 4.7
- health of the database, 4.7
- intended state of a configuration, 3.6
- using metrics, 6.9
- status messages
-
- ORA-16661, 5.4.3, 5.4.3
- ORA-16795, 5.4.3
- StatusReport property, 4.7, 9.1.10
- string values
-
- Data Guard command-line interface, 8.1.3
- supported broker configuration, 1.3
- SWITCHOVER command, 7.8, 8.2
- switchovers
-
- benefits, 1.2
- broker tasks, 5.3.3
- choosing a target standby database, 5.2
- DGMGRL SWITCHOVER command, 7.8
- effect on
-
- database startup, 8.2
- logical standby databases, 5.3.3
- physical standby databases, 5.3.3
- primary database, 5.3.3
- protection modes, 4.6.2.2
- RAC databases, 5.3.3
- standby databases not involved in the switchover, 5.3.3
- managing, 5, 5.3
- overview, 5.1
-
- Oracle Enterprise Manager, 1.5.1
- performing when fast-start failover is enabled, 5.5.2.4
- preparing the primary database, 5.3.1
- prerequisites, 5.3.1
- reenabling disabled standby databases, 5.4.3
- reinstating a database after, 5.4.3
- scenario
-
- Oracle Enterprise Manager, 6.6
- starting, 5.3.2
- transitioning
-
- a logical standby database to the primary role, 5.3
- a physical standby database to the primary role, 5.3
- troubleshooting, 10.3, 10.3
- using the DGMGRL SWITCHOVER command, 8.2
- SYNC redo transport mode, 4.4.1
- SYSDBA privileges, 7.2
-
- to connect to the database, 8.1.3
- system events
-
- writing triggers for use DB_ROLE_CHANGE, 5.1
T
- target standby database
-
- choosing, 5.2
- disabling fast-start failover on, 5.5.4
- setting with the FastStartFailoverTarget property, 5.5.2, 5.5.2, 7.6
- TopWaitEvents property, 9.1.11
- transaction consistency level
-
- controlling, 4.5.3
- troubleshooting
-
- Data Guard, 10
- diagnostics logged in broker drc* log files, 10.1
- tuning
-
- redo transport services, 4.4.5
- two-way communication channel, 1.6.1
U
- understanding metrics, 6.9.1
- unobserved configuration, 5.5.6.3
- updating configuration properties, 4.3
- upgrading
-
- Data Guard, B.1, B.2, B.3
- Oracle Enterprise Manager, B.1, B.2
- protection mode, 4.6.2.1
- user interfaces
-
- overview, 1.5
V
- V$DATABASE view
-
- fast-start failover columns, 5.5.2.2, 5.5.3
- FS_FAILOVER_OBSERVER_HOST column, 5.5.6.2
- FS_FAILOVER_OBSERVER_PRESENT column, 5.5.6.2
-
- when shutting down databases, 5.5.8
- verifying
-
- fast-start failover environment, 5.5.2
- viewing
-
- fast-start failover statistics, 5.5.3
- verifying
-
- a broker configuration, 6.8.1
- fast-start failover environment, 5.5.2
- viewing
-
- log file details, 6.8.2
- property information about databases, 4.3.1, 9.1
W
- warning status, 3.6
- wizards
-
- Add Standby Database, 1.5.1, 6.2