Table of Contents
- Title and Copyright Information
- Preface
- 1 Oracle Data Guard Broker Concepts
- 2 Oracle Data Guard Installation
- 3 Managing Broker Configurations
-
4
Managing the Members of a Broker Configuration
- Managing Broker Configuration Members
- Managing States of Broker Configuration Members
- Managing Database Properties
-
Managing Redo Transport Services
- Setting Up For Redo Transport
- Managing Redo Transport Services for Data Protection Modes
- Advanced Redo Transport Settings
- Turning Redo Transport Services On and Off
- Specifying Locations for Archived Redo Log Files
- Other Redo Transport Settings
- Redo Transport Services in an Oracle RAC Database Environment
- Transport Lag
- Managing Redo Transport Services for Recovery Appliance
- Managing Log Apply Services
- Managing Data Protection Modes
- Managing Far Sync Instances
- Managing Fast-Start Failover
- Managing Database Conversions
- Database Status
-
5
Switchover and Failover Operations
- Overview of Switchover and Failover in a Broker Environment
- Choosing a Target Standby Database
- Switchover
-
Manual Failover
- Complete and Immediate Manual Failovers
-
Performing a Manual Failover Operation
- Performing a Manual Failover Task 1: Determine Which of the Available Standby Databases is the Best Target for the Failover
- Performing a Manual Failover Task 2: Start the Failover
- Performing a Manual Failover Task 3: Reset the Protection Mode
- Performing a Manual Failover Task 4: Re-establish a Disaster-Recovery Configuration
- How the Broker Performs a Complete Failover Operation
- How the Broker Performs an Immediate Failover Operation
- Reenabling Disabled Databases After a Role Change
-
Fast-Start Failover
- About Fast-start Failover
- Prerequisites for Enabling Fast-Start Failover
-
Enabling Fast-Start Failover
- Enabling Fast-Start Failover Task 1: Determine Which Available Standby Databases Should Be Targets for the Failover
- Enabling Fast-Start Failover Task 2: Specify Target Standby Databases with the FastStartFailoverTarget Configuration Property
- Enabling Fast-Start Failover Task 3: Determine the Protection Mode You Want
- Enabling Fast-Start Failover Task 4: Set the FastStartFailoverThreshold Configuration Property
- Enabling Fast-Start Failover Task 5: Set Other Properties Related to Fast-Start Failover (Optional)
- Enabling Fast-Start Failover Task 6: Enable Additional Fast-Start Failover Conditions (Optional)
- Enabling Fast-Start Failover Task 7: Configure Actions Before and After Fast-start Failover (Optional)
- Enabling Fast-Start Failover Task 8: Using DGMGRL or Cloud Control
- Enabling Fast-Start Failover Task 9: Start the Observer
- Enabling Fast-Start Failover Task 10: Verify the Fast-Start Failover Environment
- When Fast-Start Failover Is Enabled and the Observer Is Running
- Restrictions When Fast-Start Failover is Enabled
- Configuring Fast-Start Failover in Observe-only Mode
- Shutting Down the Primary Database When Fast-Start Failover Is Enabled
- Performing Manual Role Changes When Fast-Start Failover Is Enabled
- Directing a Fast-Start Failover From an Application
- Viewing Fast-Start Failover Configuration Statistics and Status
- Disabling Fast-Start Failover
- Performance Considerations for Fast-Start Failover
-
Managing the Observer
- Installing and Starting the Observer
- Viewing Information About the Master Observer
- Viewing Information About All Observers
- What Happens if the Master Observer Fails?
- Managing Observer's Connection to the Primary
- Configuring the Time Taken to Initiate Fast-Start Failover
- Stopping the Observer
- Moving the Observer to Another Computer
- How the Observer Maintains Fast-Start Failover Configuration Information
- Managing Observers for Multiple Configurations
- Patching an Environment When the Observer Is Running and Fast-start Failover Is Enabled
- Reinstating the Former Primary Database in the Broker Configuration
- Shutting Down Databases In a Fast-Start Failover Environment
- Database Client Considerations
-
6
Scenarios Using the DGMGRL Command-Line Interface
- Prerequisites for Getting Started
-
Scenario 1: Creating a Configuration
- Creating a Configuration Task 1: Invoke DGMGRL
- Creating a Configuration Task 2: Connect to the Primary Database
- Creating a Configuration Task 3: Clear Existing Remote Redo Transport Destinations on Standbys and Far Sync Instances To Be Added.
- Creating a Configuration Task 4: Create the Broker Configuration
- Creating a Configuration Task 5: Show the Configuration Information
- Creating a Configuration Task 6: Add a Standby Database to the Configuration
- Scenario 2: Setting Database Properties
- Scenario 3: Enabling the Configuration and Databases
- Scenario 4: Setting the Configuration Protection Mode
- Scenario 5: Setting up Maximum Availability Mode with a Far Sync Instance
- Scenario 6: Enabling Fast-Start Failover and Starting the Observer
- Scenario 7: Enabling Fast-Start Failover When a Far Sync Instance Is In Use
- Scenario 8: Performing Routine Management Tasks
-
Scenario 9: Performing a Switchover Operation
- Using the SWITCHOVER Command Task 1: Check the Primary Database
- Using the SWITCHOVER Command Task 2: Check the Standby Database That is the Target of the Switchover
- Using the SWITCHOVER Command Task 3: Confirm That the Database Is Ready for a Role Change
- Using the SWITCHOVER Command Task 4: Issue the Switchover Command
- Using the SWITCHOVER Command Task 5: Show the Configuration
- Scenario 10: Performing a Manual Failover Operation
- Scenario 11: Reinstating a Failed Primary Database
- Scenario 12: Converting a Physical Standby to a Snapshot Standby
- Scenario 13: Monitoring a Data Guard Configuration
- Scenario 14: Adding a Recovery Appliance to a Broker Configuration
- Scenario 15: Exporting and Importing a Broker Configuration File
- Scenario 16: Using the Observe-only Mode for Fast-Start Failover
-
7
Oracle Data Guard Command-Line Interface Reference
- Starting the Data Guard Command-Line Interface
- Exiting the Data Guard Command-Line Interface
- @ (at sign) Command
- / (slash) Command
- ADD DATABASE
- ADD FAR_SYNC
- ADD RECOVERY_APPLIANCE
- CONNECT
- CONVERT DATABASE
- CREATE CONFIGURATION
- CREATE FAR_SYNC
- DISABLE CONFIGURATION
- DISABLE DATABASE
- DISABLE FAR_SYNC
- DISABLE FAST_START FAILOVER
- DISABLE FAST_START FAILOVER CONDITION
- DISABLE RECOVERY_APPLIANCE
- EDIT CONFIGURATION (Property)
- EDIT CONFIGURATION (Protection Mode)
- EDIT CONFIGURATION (RENAME)
- EDIT CONFIGURATION RESET (Property)
- EDIT DATABASE (Property)
- EDIT DATABASE (Parameter)
- EDIT DATABASE (Rename)
- EDIT DATABASE (State)
- EDIT DATABASE RESET (Property)
- EDIT DATABASE RESET (Parameter)
- EDIT FAR_SYNC
- EDIT FAR_SYNC RESET (Property)
- EDIT FAR_SYNC RESET (Parameter)
- EDIT RECOVERY_APPLIANCE (Property)
- EDIT RECOVERY_APPLIANCE (Parameter)
- EDIT RECOVERY_APPLIANCE (Rename)
- EDIT RECOVERY_APPLIANCE RESET (Property)
- EDIT RECOVERY_APPLIANCE RESET (Parameter)
- ENABLE CONFIGURATION
- ENABLE DATABASE
- ENABLE FAR_SYNC
- ENABLE FAST_START FAILOVER
- ENABLE FAST_START FAILOVER CONDITION
- ENABLE RECOVERY_APPLIANCE
- EXIT
- EXPORT CONFIGURATION
- FAILOVER
- HELP
- HOST or ! (exclamation point)
- IMPORT CONFIGURATION
- MIGRATE PLUGGABLE DATABASE
- PREPARE DATABASE FOR DATA GUARD
- QUIT
- REINSTATE DATABASE
- REMOVE CONFIGURATION
- REMOVE DATABASE
- REMOVE FAR_SYNC
- REMOVE INSTANCE
- REMOVE RECOVERY_APPLIANCE
- SET ECHO
- SET FAST_START FAILOVER TARGET
- SET MASTEROBSERVER TO
- SET MASTEROBSERVERHOSTS
- SET ObserverConfigFile
- SET TIME
- SET TRACE_LEVEL
- SHOW ALL
- SHOW CONFIGURATION
- SHOW CONFIGURATION WHEN PRIMARY IS
- SHOW DATABASE
- SHOW FAR_SYNC
- SHOW FAST_START FAILOVER
- SHOW INSTANCE
- SHOW OBSERVER
- SHOW ObserverConfigFile
- SHOW OBSERVERS
- SHOW RECOVERY_APPLIANCE
- SHUTDOWN
- SPOOL
- SQL
- START OBSERVER
- START OBSERVER IN BACKGROUND
- START OBSERVING
- STARTUP
- STOP OBSERVER
- STOP OBSERVING
- SWITCHOVER
- VALIDATE DATABASE
- VALIDATE DATABASE DATAFILE
- VALIDATE DATABASE SPFILE
- VALIDATE FAR_SYNC
- VALIDATE FAST_START FAILOVER
- VALIDATE NETWORK CONFIGURATION
- VALIDATE STATIC CONNECT IDENTIFIER
-
8
Oracle Data Guard Broker Properties
-
Configuration Properties
- BystandersFollowRoleChange
- CommunicationTimeout
- ConfigurationSimpleName
- ConfigurationWideServiceName
- ExternalDestination1
- ExternalDestination2
- FastStartFailoverAutoReinstate
- FastStartFailoverLagLimit
- FastStartFailoverPmyShutdown
- FastStartFailoverThreshold
- ObserverOverride
- ObserverPingInterval
- ObserverPingRetry
- ObserverReconnect
- OperationTimeout
- PreferredObserverHosts
- PrimaryLostWriteAction
- TraceLevel
-
Monitorable (Read-Only) Properties
- InconsistentLogXptProps (Inconsistent Redo Transport Properties)
- InconsistentProperties (Inconsistent Properties)
- LogXptStatus (Redo Transport Status)
- LsbyFailedTxnInfo (Logical Standby Failed Transaction Information)
- LsbyParameters (Logical Standby Parameters)
- RecvQEntries (Receive Queue Entries)
- SendQEntries (Send Queue Entries)
- TopWaitEvents
-
Configurable Properties
- AlternateLocation
- ArchiveLocation
- ApplyInstances
- ApplyInstanceTimeout
- ApplyLagThreshold
- ApplyParallel
- Binding
- DelayMins
- DGConnectIdentifier
- Encryption
- FastStartFailoverTarget
- InstanceName
- LogShipping
- LogXptMode
- MaxFailure
- NetTimeout
- ObserverConnectIdentifier
- PreferredApplyInstance
- PreferredObserverHosts
- RedoCompression
- RedoRoutes
- ReopenSecs
- StandbyAlternateLocation
- StandbyArchiveLocation
- StaticConnectIdentifier
- TransportDisconnectedThreshold
- TransportLagThreshold
-
Configuration Properties
-
9
Troubleshooting Oracle Data Guard
- Sources of Diagnostic Information
-
General Problems and Solutions
- ORA-16596: database not part of the Oracle Data Guard broker configuration
- Redo Accumulating on the Primary Is Not Sent to Some Standby Databases
- Many Log Files Are Received on a Standby Database But Not Applied
- The Request Timed Out or Cloud Control Performance Is Sluggish
- The Primary Database is Flashed Back
- Standby Fails to Automatically Start Up Due to Unknown Service (ORA-12514)
- Troubleshooting Problems During a Switchover Operation
- Troubleshooting Problems During a Failover Operation
- Troubleshooting Problems with the Observer
- A Oracle Data Guard Broker Upgrading and Downgrading
- Glossary
- Index