Skip Headers
Oracle® Data Guard Broker
10
g
Release 1 (10.1)
Part Number B10 822-01
Home
Book List
Index
< /a>
Master Index
Feedbac k
< tr>
Next
View PDF
Contents
List of Examples
List of Figures
List of Tables
Title and C opyright Information
Send Us Your Comments
Preface
Audience
Documentation Accessibility
Organization
Related Documentation
Conventions
What's New in Oracle Data Gua rd Broker?
Oracle Database Release 10.1 New Features in Data Guard Broker
1
Oracle Data G uard Broker Concepts
1.1
Oracle Data Guard Overv iew
1.1.1
Oracle Data Guard Configuration Overview
1.1.2
Oracle Data Guard Broker Overview
1.2
Benefits of Data Guard Broker
1.3
Data Guard Broker Management Model
1.4
Data Guard Broker Components
1.5
Data G uard Broker User Interfaces
1.5.1
Data Guard GUI
1.5.2
Data Guard Command-Line Interface (DGMGRL)
1.6
Data Guard Monitor
1.6.1
Data Guard Monitor (DMON) Process
1.6.2
Configuration Management
1.6.3 Database Property Management
1.7
Oracle Dat a Guard Installation, Upgrade, Downgrade, and First Use
1.7.1
Installation
1.7.2
Upgrade from Release 9.0.
n to Release 10.1
1.7.3
Upgrade from Release 9.2.0 t o Release 10.1
1.7.4
Downgrade from Release 10.1
< dd>
1.7.5
Prerequisites for First Use
2
Managing Broker Configurations
2.1
Configuration Support
2.2
Setting Up the Broker Configuration Files
2.2.1
Sizing for Raw Devices
2.3
Starting the Data Guard Broker
2.4
Management Cycle of a Broker Configuration
2.5
Enable and Disable Operations
2.6
Configuration Status
3
Managing Dat abases
3.1
Database Objects
3.2
Database States
3.2.1
Database State Transitions
3.3
Database Properties
3.3.1
Monitorable (Read-Only) Properties
3.3.2
Configurable (C hangeable) Database Properties
3.4
Managing Log Transport Services
3.4.1
Managing Log Transpor t Services for Data Protection Modes
3.4.2
Turning On and Off Log Transport Services
3.4.3
Managing Standby Locati ons to Archive the Online Redo Log Files From the Primary Database
3.4.4
Setting a Dependent Standby Database
3.4.5
Other Log Transport Settings
3.4.6
Managing Connections to the Standby Databases for Log Transport Services
3.4.7
Log Transport Services in a RAC Database Environment
3.5
Managing Log Apply Services
3.5.1
M anaging Real-Time Apply
3.5.2
Managing Delayed Apply
< /dd>
3.5.3
Managing Parallel Apply in Physical Standby Databases
3.5.4
Allocating Resources to SQL Apply in Logical Standby Databases
3.5.5
Managing SQL Apply Filtering in Logical Standby Databases
3.5.6
Managing SQL Apply Error Handling in Logical Standby Databases
3.5.7
Managing the DBA_LOGS TDBY_EVENTS Table in Logical Standby Databases
3.5.8
Log Apply Services in a RAC Database Environment
3.5.8.1 Selecting the Apply Instance
3.5.8.2
Apply Instance Failover
3.6
Managing Data Protectio n Modes
3.6.1
Setting the Protection Mode for Y our Configuration
3.6.2
How Broker Operations Affect Prot ection Modes
3.6.2.1
Upgrading or Downgrading t he Current Protection Mode
3.6.2.2
Switchover Operations< /a>
3.6.2.3
Failover Operations
3.6.2.4
Disable and Enable Operations
3.6.2.5
Requirements When Removing a Database from the Configuration
3.6.2.6
Requirements On Other Operations
3.7
Database Status
4
Role Management
4.1
Managing Switchover Operations
4.1.1
Before You Perform a Switchover Operation
4.1.2
Starting a Switchover Operation
4.1.3
How the Broker Performs a Switchover Operation
4.2
Managing Failover Operations
4.2.1
Co nsiderations When Selecting the Failover Target
4.2.2
S tarting a Failover Operation
4.2.3
How the Broker Perfo rms a Complete Failover Operation
4.2.4
How the Broker Performs an Immediate Failover Operation
4.2.5
Re-creat ing a Viable Disaster Recovery Solution After Failover
5
Data Guard Scenarios - Using Oracle Enterprise Manager
5.1
Scenario 1: Starting the Data Guard GUI
5.2
Scenario 2: Creating a Configuration or Adding an Additional Standby Database
5.3
Scenario 3: Adding an Existing RAC Standby Database
5.4
Scenario 4: Performing Routine Maintenance
5.4.1
Changing the State of a Database
5.4.2
Changing the Properties of a Database
5.4.3
Chan ging the Database Protection Mode
5.5
Scenario 5: Perf orming a Switchover Operation
5.6
Scenario 6: Performing a Failo ver Operation
5.7
Scenario 7: Monitoring a Data Guard Configurat ion
5.7.1
Verifying a Broker Configuration
5.7.2
Viewing Log File Details
5.7.3 Monitoring Configuration Performance
5.8
Scenario 8: Using Metrics
5.8.1
Unde rstanding the Data Guard Metrics
5.8.1.1
Data Guard St atus
5.8.1.2
Data Not Applied (MB)
5.8.1.3
Data Not Applied (Log Files)
5.8.1.4
Data Not Received (MB)
5.8.1.5
Data Not Rec eived (Log Files)
5.8.2
Managing Data Guard Metrics
5.9
Scenario 9: Removing a Standby Database and Configur ation
5.9.1
Remove a Standby Database
5.9.2
Remove the Data Guard Configuration
6
Data Guard Scenarios - Using DGMGRL CLI
6.1
Prerequisites for Getting Started
6.2
Scenario 1: Creating a Configuration
< span class="secnum">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
Sc enario 5: Performing Routine Management Tasks
6.6.1
Ch anging States and Properties
6.6.1.1
Alter a Database Property
6.6.1.2
Alter the State of a Standby Database
6.6.1.3
Alter the State of a Primary Database
6.6.2
Disabling the Configuration and Databases
6.6.2.1
Disable a Configuration
6.6.2.2
Disable a Standby Database
6.6.3
Removing the Configuration or a Standby Database
6.7
Scenario 6: Performing a Switchover Operation
6.8
Scenario 7: Pe rforming a Failover Operation
6.9
Scenario 8: Monitoring a Data Guard Configuration
7 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
Stopping the Data Guard Command-Line Interface
ADD DATABASE
CONNECT
CREATE CONFIGURATION
DISABLE CONFIGURATION
DISABLE DATABASE
EDIT CONFIGURATION (Protection Mode)
EDIT DATABASE (Property)
EDIT DATABASE (Rename)
EDIT DATABASE (State)
EDIT INSTANCE (AUTO PFILE)
EDIT INSTANCE (Property)
ENABLE CONFIGURATION
ENABLE DATABASE
EXIT
FAI LOVER
HELP
QUIT
REMOVE CONFIGURATION
REMOVE DATABASE
REMOVE INSTANCE
SHOW CONFIGURATION
SHOW DATABASE
SHOW INSTANCE
SHUTDOWN
STARTUP
SWITCHOVER
8
Database Properties
8.1
Monitorable (Read-Only) Database Properties
< dl>
8.1.1
InconsistentLogXptProps (Inconsistent Log Transport Prop erties)
8.1.2
InconsistentProperties (Inconsistent Databa se Properties)
8.1.3
LatestLog
8.1.4
LogXptStatus (Log Transport Status)
8.1.5
LsbyFailedTxnInfo (Logical Standby Failed Transaction Information)
8.1.6
LsbyParameters (Logical Standby Parameters)
8.1.7
LsbySkipTable (Logical Standby Skip Table)
8.1.8
LsbySkipTxnTable (Logical Standby Skip Transaction Table)
8.1.9
RecvQEntries (Receive Queue Entries)
8.1.10
SendQEntries (Send Queue Entries)
8.1.11
StatusReport (Status Report)
8.1.12
T opWaitEvents
8.2
Configurable Database Properti es
8.2.1
AlternateLocation
8.2.2
ApplyInstanceTimeout
8.2.3 ApplyNext
8.2.4
ApplyNoDe lay
8.2.5
ApplyParallel
8.2.6
ArchiveLagTarget
8.2.7
AsyncBlocks
8.2.8
Binding
8.2.9
DbFileNameConvert
< span class="secnum">8.2.10 DelayMins
8.2.11
Depend ency
8.2.12
HostName
8.2.13
InitialConnectIdentifier
8.2.14
LocalListenerAddress
8.2.15
LogArch iveFormat
8.2.16
LogArchiveMaxProcesses
8.2.17
LogArchiveMinSucceedDest
8.2.18
LogArchiveTrace
8.2.19< /span> LogFileNameConvert
8.2.20
LogShipping
8.2.21
LogXptMode
8.2.22 LsbyASkipCfgPr
8.2.23
Lsb yASkipErrorCfgPr
8.2.24
LsbyASkipTxnCfgPr
8.2.25
LsbyDSkipCfgPr
8.2.26 LsbyDSkipErrorCfgPr
8.2.27 LsbyDSkipTxnCfgPr
8.2.28
LsbyMaxEventsRecorded
8.2.29
LsbyMaxSga
8.2.30
LsbyMaxServers
8.2.31
LsbyRecordAppliedDdl
8.2.32
LsbyRecordSkipDdl
8.2.33
LsbyRecordSkipErrors
8.2.34
LsbyTxnConsistency
8.2.35
MaxFailure
8.2.36
NetTimeout
< a href="dbpropref.htm#sthref1288">
8.2.37
PreferredApplyInstance
8.2.38
RealTimeApply
8.2.39 ReopenSecs
8.2.40
SidName
8.2.41
StandbyArchiveLocation
8.2.42 StandbyFileManagement
9
Troubleshooting Data Guard
9.1
Sources of Diagnostic Information
9.2
General Problems and Solutions
9.2.1
ORA-16596: Database is Not a Member of the Data Guard Configuration
9.2.2
Log Files Are Being Accumulated on the Primary and Not Archived to Some St andby Databases
9.2.3
Many Log Files Are Received o n a Standby Database But Not Applied
9.2.4
The Prim ary Database is Flashed Back
9.3
Troubles hooting Problems During a Failover Operation
9.4
Tr oubleshooting Problems During a Switchover Operation
A
Data Guard Broker Changed and Deprecated Features
A.1
Data Guard Broker Changed Features
A.1.1
General Features That Changed
A.1.2
Changed Properties
A.1.3
Changed State Names
A.1.4
Cha nged CLI Features
A.1.5
Changed Data Guard GUI Feat ures
A.2
Data Guard Broker Deprecated Fea tures
A.2.1
Deprecated Properties
A.2.2
Deprecated CLI Commands and Keywords
A.2.3
Data Guard GUI Features That Are Deprecated
Glossary
Index
