Oracle 9i. Data Guard Broker

Contents......Page 3
List of Examples......Page 7
List of Figures......Page 8
List of Tables......Page 9
Send Us Your Comments......Page 11
Preface......Page 13
Organization......Page 14
Conventions......Page 15
Accessibility of Code Examples in Documentation......Page 18
1.1 Oracle9i Data Guard Broker Overview......Page 19
1.2 Data Guard Broker Management Model......Page 20
1.3.1.1 Oracle9i Data Guard Manager......Page 22
1.3.1.2 Data Guard Command-Line Interface (DGMGRL)......Page 23
1.3.2.1 Data Guard Monitor (DMON) Process......Page 24
1.4 Benefits of the Data Guard Broker......Page 27
1.5 Oracle9i Data Guard Prerequisites......Page 28
2.1 Configuration Support......Page 31
2.3 Management Cycle of a Broker Configuration......Page 35
2.5 States......Page 38
2.6 State Transitions......Page 39
2.7 Status......Page 41
2.8 Properties......Page 42
3.2 Database Resource States......Page 45
3.2.1 Database Online and Offline States......Page 46
3.2.2 Database Substates......Page 47
3.2.3 Database State Transitions......Page 48
3.3.1 Configurable (Changeable) Database Resource Properties......Page 50
3.3.1.2 Critical Database Properties......Page 53
3.3.2 Monitorable (Read-Only) Properties......Page 54
3.3.2.1 SendQEntries (Send Queue Entries)......Page 55
3.3.2.3 SbyLogQueue (Standby Log Queue)......Page 56
4.1 Starting Data Guard Manager......Page 59
4.2 Creating a Configuration......Page 64
4.3 Connecting to a Configuration......Page 76
4.4 Enabling the Configuration, Sites, and Resources......Page 77
4.5.1 Changing the State of a Database Resource......Page 80
4.5.2 Changing a Database Property......Page 81
4.6 Performing a Manual Switchover Outside of Data Guard Manager......Page 83
4.7 Monitoring a Data Guard Configuration......Page 85
4.7.1 Using Event Tests......Page 86
4.7.2 Creating and Registering Data Guard Events......Page 88
5.1 Creating a Standby Database......Page 95
5.2 Creating a Configuration......Page 96
5.4 Enabling the Configuration, Sites, and Resources......Page 100
5.5.1 Changing States and Properties......Page 101
5.5.1.3 Alter the State of a Database Resource......Page 102
5.5.2 Disabling the Configuration, Sites, and Database Resources......Page 103
5.5.2.3 Disable the Standby Site......Page 104
5.5.3 Removing the Configuration or the Standby Site......Page 105
5.6 Performing Activities Outside of the Broker......Page 106
5.7 Monitoring a Data Guard Configuration......Page 107
6.1.1 DGMGRL Optional Parameters......Page 111
6.1.2 DGMGRL Command Format and Parameters......Page 112
6.1.3 DGMGRL Command Usage Notes......Page 114
6.2 Stopping the Data Guard Command-Line Interface......Page 115
ALTER CONFIGURATION......Page 117
ALTER RESOURCE (property)......Page 118
ALTER RESOURCE (state)......Page 120
ALTER SITE......Page 122
ALTER SITE (AUTO PFILE)......Page 123
CONNECT......Page 125
CREATE CONFIGURATION......Page 126
CREATE SITE......Page 129
DISABLE CONFIGURATION......Page 132
DISABLE RESOURCE......Page 133
DISABLE SITE......Page 134
ENABLE CONFIGURATION......Page 135
ENABLE RESOURCE......Page 136
ENABLE SITE......Page 138
EXIT......Page 139
HELP......Page 140
QUIT......Page 141
REMOVE CONFIGURATION......Page 142
REMOVE SITE......Page 143
SHOW CONFIGURATION......Page 144
SHOW DEPENDENCY TREE......Page 146
SHOW LOG......Page 148
SHOW RESOURCE......Page 153
SHOW SITE......Page 156
SHUTDOWN......Page 158
STARTUP......Page 160
A Oracle9i Data Guard Error Messages......Page 165
Glossary......Page 193
Index......Page 197