Oracle 9i. Data Guard Broker (Part No. A88807-01) (Release 9.0.1)

Description

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