1/19
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes in This Release for Oracle Data Guard Broker
Changes in Oracle Database 12
c
Release 1 (12.1.0.2)
Changes in Oracle Database 12
c
Release 1 (12.1.0.1)
1
Oracle Data Guard Broker Concepts
1.1
Overview of Oracle Data Guard and the Broker
1.1.1
Oracle Data Guard Configurations and Broker Configurations
1.1.2
Oracle Data Guard Broker
1.1.3
Oracle Data Guard Broker and CDBs
1.1.4
Oracle Data Guard Broker and Oracle Global Data Services
1.2
Benefits of Oracle Data Guard Broker
1.3
Oracle Data Guard Broker Components
1.4
Oracle Data Guard Broker User Interfaces
1.4.1
Oracle Enterprise Manager Cloud Control
1.4.2
Oracle Data Guard Command-Line Interface (DGMGRL)
1.5
Oracle Data Guard Monitor
1.5.1
Oracle Data Guard Monitor (DMON) Process
1.5.2
Configuration Management
1.5.3
Database Property Management
2
Oracle Data Guard Installation
2.1
Oracle Data Guard Installation
2.2
Prerequisites
3
Managing Broker Configurations
3.1
Configuration Support
3.2
Configuration Properties
3.3
Setting Up the Broker Configuration Files
3.3.1
Renaming the Broker Configuration Files
3.3.2
Managing Broker Configuration Files in an Oracle RAC Environment
3.3.2.1
Using Cluster File System (CFS) for Configuration Files
3.3.2.2
Using Oracle ASM Disk Groups for Configuration Files
3.4
Starting the Data Guard Broker
3.5
Management Cycle of a Broker Configuration
3.6
Enable and Disable Operations
3.7
Configuration Status
4
Managing the Members of a Broker Configuration
4.1
Managing Broker Configuration Members
4.2
Managing States of Broker Configuration Members
4.2.1
Database State Transitions
4.3
Managing Database Properties
4.3.1
Monitorable (Read-Only) Properties
4.3.2
Configurable (Changeable) Properties
4.3.2.1
Resetting Broker Configurable Properties to Default Values
4.4
Managing Redo Transport Services
4.4.1
Setting Up For Redo Transport
4.4.2
Managing Redo Transport Services for Data Protection Modes
4.4.3
Advanced Redo Transport Settings
4.4.4
Turning Redo Transport Services On and Off
4.4.5
Specifying Locations for Archived Redo Log Files
4.4.6
Other Redo Transport Settings
4.4.7
Redo Transport Services in an Oracle RAC Database Environment
4.4.8
Transport Lag
4.5
Managing Log Apply Services
4.5.1
Managing Delayed Apply
4.5.2
Managing Parallel Apply with Redo Apply
4.5.3
Allocating Resources to SQL Apply
4.5.4
Managing the DBA_LOGSTDBY_EVENTS Table
4.5.5
Apply Services in an Oracle RAC Database Environment
4.5.5.1
Selecting the Apply Instance
4.5.5.2
Apply Instance Failover
4.5.6
Apply Lag
4.6
Managing Data Protection Modes
4.6.1
Setting the Protection Mode for Your Configuration
4.6.2
How the Protection Modes Influence Broker Operations
4.6.2.1
Upgrading or Downgrading the Current Protection Mode
4.6.2.2
Switchover Operations
4.6.2.3
Failover Operations
4.6.2.4
Disable and Enable Operations
4.6.2.5
Requirements For Removing a Database from the Configuration
4.6.2.6
Requirements On Other Operations
4.7
Managing Far Sync Instances
4.8
Managing Fast-Start Failover
4.8.1
Configure Properties to Tune Fast-Start Failover
4.8.2
Configure Conditions for Fast-start Failover
4.8.3
Application Initiated Fast-Start Failover
4.9
Managing Database Conversions
4.10
Database Status
4.10.1
Querying Database Status
4.10.2
Validating a Database Before a Role Change
5
Switchover and Failover Operations
5.1
Overview of Switchover and Failover in a Broker Environment
5.2
Choosing a Target Standby Database
5.2.1
Choosing a Target Standby Database for Switchover
5.2.2
Choosing a Target Standby Database for Failover
5.3
Switchover
5.3.1
Before You Perform a Switchover Operation
5.3.2
Starting a Switchover
5.3.3
How the Broker Performs a Switchover
5.4
Manual Failover
5.4.1
Complete and Immediate Manual Failovers
5.4.2
Performing a Manual Failover Operation
5.4.2.1
How the Broker Performs a Complete Failover Operation
5.4.2.2
How the Broker Performs an Immediate Failover Operation
5.4.3
Reenabling Disabled Databases After a Role Change
5.4.3.1
How to Reinstate a Database
5.4.3.2
How to Re-create and Reenable a Disabled Database
5.5
Fast-Start Failover
5.5.1
Prerequisites for Enabling Fast-Start Failover
5.5.2
Enabling Fast-Start Failover
5.5.2.1
When Fast-Start Failover Is Enabled and the Observer Is Running
5.5.2.2
Restrictions When Fast-Start Failover is Enabled
5.5.2.3
Shutting Down the Primary Database When Fast-Start Failover Is Enabled
5.5.2.4
Performing Manual Role Changes When Fast-Start Failover Is Enabled
5.5.3
Directing a Fast-Start Failover From an Application
5.5.4
Viewing Fast-Start Failover Configuration Statistics and Status
5.5.4.1
V$DATABASE View
5.5.4.2
V$FS_FAILOVER_STATS View
5.5.5
Disabling Fast-Start Failover
5.5.6
Performance Considerations for Fast-Start Failover
5.5.7
Managing the Observer
5.5.7.1
Installing and Starting the Observer
5.5.7.2
Viewing Information About the Observer
5.5.7.3
What Happens if the Observer Fails?
5.5.7.4
Managing Observer's Connection to the Primary
5.5.7.5
Stopping the Observer
5.5.7.6
Moving the Observer to Another Computer
5.5.7.7
How the Observer Maintains Fast-Start Failover Configuration Information
5.5.7.8
Patching an Environment When the Observer Is Running and Fast-start Failover Is Enabled
5.5.8
Reinstating the Former Primary Database in the Broker Configuration
5.5.8.1
Requirements
5.5.8.2
Restrictions on Reinstatement
5.5.8.3
How the Broker Handles a Failed Reinstatement
5.5.9
Shutting Down Databases In a Fast-Start Failover Environment
5.6
Database Client Considerations
5.6.1
Oracle Data Guard Specific FAN and FCF Configuration Requirements
5.6.1.1
Oracle Net Configuration Requirements
5.6.1.2
Database Service Configuration Requirements
5.6.1.3
ONS Configuration Requirements
5.6.1.4
Application Continuity
6
Scenarios Using the DGMGRL Command-Line Interface
6.1
Prerequisites for Getting Started
6.2
Scenario 1: Creating a Configuration
6.3
Scenario 2: Setting Database Properties
6.4
Scenario 3: Enabling the Configuration and Databases
6.5
Scenario 4: Setting the Configuration Protection Mode
6.6
Scenario 5: Setting up Maximum Availability Mode with a Far Sync Instance
6.7
Scenario 6: Enabling Fast-Start Failover and Starting the Observer
6.8
Scenario 7: Enabling Fast-Start Failover When a Far Sync Instance Is In Use
6.9
Scenario 8: Performing Routine Management Tasks
6.9.1
Changing Properties and States
6.9.1.1
Alter a Database Property
6.9.1.2
Reset a Property to Its Default Value
6.9.1.3
Alter the State of a Standby Database
6.9.1.4
Alter the State of a Primary Database
6.9.2
Disabling the Configuration and Databases
6.9.2.1
Disable a Configuration
6.9.2.2
Disable a Standby Database
6.9.2.3
Disabling a Far Sync Instance
6.9.3
Removing the Configuration, a Standby Database, or a Far Sync Instance
6.10
Scenario 9: Performing a Switchover Operation
6.11
Scenario 10: Performing a Manual Failover Operation
6.12
Scenario 11: Reinstating a Failed Primary Database
6.13
Scenario 12: Converting a Physical Standby to a Snapshot Standby
6.14
Scenario 13: Monitoring a Data Guard Configuration
7
Oracle Data Guard Command-Line Interface Reference
7.1
Starting the Data Guard Command-Line Interface
7.1.1
DGMGRL Optional Parameters
7.1.2
DGMGRL Command Format and Parameters
7.1.3
DGMGRL Command Usage Notes
7.2
Exiting the Data Guard Command-Line Interface
ADD DATABASE
ADD FAR_SYNC
CONNECT
CONVERT DATABASE
CREATE CONFIGURATION
DISABLE CONFIGURATION
DISABLE DATABASE
DISABLE FAR_SYNC
DISABLE FAST_START FAILOVER
DISABLE FAST_START FAILOVER CONDITION
EDIT CONFIGURATION (Property)
EDIT CONFIGURATION (Protection Mode)
EDIT CONFIGURATION (RENAME)
EDIT CONFIGURATION RESET (Property)
EDIT DATABASE (Property)
EDIT DATABASE (Rename)
EDIT DATABASE (State)
EDIT DATABASE RESET (Property)
EDIT FAR_SYNC
EDIT FAR_SYNC RESET (Property)
EDIT INSTANCE (AUTO PFILE)
EDIT INSTANCE (Property)
EDIT INSTANCE RESET (Property)
ENABLE CONFIGURATION
ENABLE DATABASE
ENABLE FAR_SYNC
ENABLE FAST_START FAILOVER
ENABLE FAST_START FAILOVER CONDITION
EXIT
FAILOVER
HELP
QUIT
REINSTATE DATABASE
REMOVE CONFIGURATION
REMOVE DATABASE
REMOVE FAR_SYNC
REMOVE INSTANCE
SHOW CONFIGURATION
SHOW CONFIGURATION WHEN PRIMARY IS
SHOW DATABASE
SHOW FAR_SYNC
SHOW FAST_START FAILOVER
SHOW INSTANCE
SHUTDOWN
SQL
START OBSERVER
STARTUP
STOP OBSERVER
SWITCHOVER
VALIDATE DATABASE
VALIDATE FAR_SYNC
8
Oracle Data Guard Broker Properties
8.1
Configuration Properties
8.1.1
BystandersFollowRoleChange
8.1.2
CommunicationTimeout
8.1.3
ExternalDestination1
8.1.4
ExternalDestination2
8.1.5
FastStartFailoverAutoReinstate
8.1.6
FastStartFailoverLagLimit
8.1.7
FastStartFailoverPmyShutdown
8.1.8
FastStartFailoverThreshold
8.1.9
ObserverOverride
8.1.10
ObserverReconnect
8.1.11
OperationTimeout
8.1.12
PrimaryLostWriteAction
8.1.13
TraceLevel
8.2
Monitorable (Read-Only) Properties
8.2.1
InconsistentLogXptProps (Inconsistent Redo Transport Properties)
8.2.2
InconsistentProperties (Inconsistent Properties)
8.2.3
LogXptStatus (Redo Transport Status)
8.2.4
LsbyFailedTxnInfo (Logical Standby Failed Transaction Information)
8.2.5
LsbyParameters (Logical Standby Parameters)
8.2.6
RecvQEntries (Receive Queue Entries)
8.2.7
SendQEntries (Send Queue Entries)
8.2.8
TopWaitEvents
8.3
Configurable Properties
8.3.1
AlternateLocation
8.3.2
ApplyInstanceTimeout
8.3.3
ApplyLagThreshold
8.3.4
ApplyParallel
8.3.5
ArchiveLagTarget
8.3.6
Binding
8.3.7
DbFileNameConvert
8.3.8
DelayMins
8.3.9
DGConnectIdentifier
8.3.10
FastStartFailoverTarget
8.3.11
LogArchiveFormat
8.3.12
LogArchiveMaxProcesses
8.3.13
LogArchiveMinSucceedDest
8.3.14
LogArchiveTrace
8.3.15
LogFileNameConvert
8.3.16
LogShipping
8.3.17
LogXptMode
8.3.18
LsbyMaxEventsRecorded
8.3.19
LsbyMaxServers
8.3.20
LsbyMaxSga
8.3.21
LsbyPreserveCommitOrder
8.3.22
LsbyRecordAppliedDdl
8.3.23
LsbyRecordSkipDdl
8.3.24
LsbyRecordSkipErrors
8.3.25
MaxConnections
8.3.26
MaxFailure
8.3.27
NetTimeout
8.3.28
ObserverConnectIdentifier
8.3.29
PreferredApplyInstance
8.3.30
RedoCompression
8.3.31
RedoRoutes
8.3.31.1
Redo Routing Rules
8.3.32
ReopenSecs
8.3.33
SidName
8.3.34
StandbyArchiveLocation
8.3.35
StandbyFileManagement
8.3.36
StaticConnectIdentifier
8.3.37
TransportDisconnectedThreshold
8.3.38
TransportLagThreshold
9
Troubleshooting Oracle Data Guard
9.1
Sources of Diagnostic Information
9.2
General Problems and Solutions
9.2.1
ORA-16596: database not part of the Oracle Data Guard broker configuration
9.2.2
Redo Accumulating on the Primary Is Not Sent to Some Standby Databases
9.2.3
Many Log Files Are Received on a Standby Database But Not Applied
9.2.4
The Request Timed Out or Cloud Control Performance Is Sluggish
9.2.5
The Primary Database is Flashed Back
9.2.6
Standby Fails to Automatically Start Up Due to Unknown Service (ORA-12514)
9.3
Troubleshooting Problems During a Switchover Operation
9.4
Troubleshooting Problems During a Failover Operation
9.4.1
Failed Failovers to Physical Standby Databases
9.4.1.1
Failed Broker Complete Physical Failovers
9.4.1.2
Failed Broker Immediate Physical Failovers
9.4.2
Failed Failovers to Logical Standby Databases
9.5
Troubleshooting Problems with the Observer
9.5.1
Problems Starting the Observer
9.5.2
Problems Because the Observer Has Stopped
9.5.3
Capturing Observer Actions in the Observer Log File
A
Oracle Data Guard Broker Upgrading and Downgrading
A.1
Upgrading from Oracle Database 9
i
Release 2 (9.2) to Oracle Database 12
c
Release 1 (12.1)
A.2
Upgrading from Oracle Database 10
g
and Oracle Database 11
g
to Oracle Database 12
c
Release 1 (12.1)
A.3
Downgrading from Oracle Database 12
c
Release 1 (12.1)
A.4
Preserving Broker Configurations During Rolling Upgrades
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.