Oracle 9i Real Application Clusters. Administration

Bauer M.

Oracle 9i Real Application Clusters Administration is written primarily for network or Database Administrator (DBA) responsible for the administration of Real Application Clusters.To use this document you should first read the Oracle 9i Database Administrator’s Guide to become familiar with single-instance administrative procedures. You should then read Oracle 9i Real Application Clusters Concepts for a conceptual understanding of Real Application Clusters processing. You should also have installed Real Application Clusters using the document Oracle 9i Real Application Clusters Installation and Configuration and any platform-specific documentation.

---

Table of contents :
Send Us Your Comments……Page 15
Preface……Page 17
What’s New in Cluster Software Administration?……Page 27
Part I Introduction to Administering Real Application Clusters……Page 31
1 Introduction to Real Application Clusters Administration……Page 33
General Administration Issues……Page 34
Scaling Your Real Application Clusters Environment……Page 35
Troubleshooting……Page 36
2 Parameter Management in Real Application Clusters Environments……Page 37
Setting the Server Parameter File Parameter Values for Real Application Clusters……Page 38
Setting Parameters within the Server Parameter File……Page 40
Using Client-Side Parameter Files……Page 41
Client-Side Parameter File Naming Conventions……Page 42
Purpose of initsid.ora……Page 43
Purpose of initdb_name.ora……Page 44
Using Multiple IFILE Entries in Client-Side Parameter Files……Page 46
Instance-Specific Parameter Settings Using sid in the Server Parameter File……Page 48
Parameters That Must Be Identical Across All Instances……Page 49
Parameters That Must Be Unique Across All Instances……Page 50
Multiple Instance Issues for Parameters……Page 51
Starting Two Instances on Remote Nodes……Page 55
Setting Instance Numbers……Page 56
3 Administering Storage Components in Real Application Clusters……Page 59
Using Automatic Undo Management……Page 60
Switching Undo Tablespaces……Page 61
Overriding Automatic Undo Management by Using Rollback Segment Undo……Page 62
Public and Private Rollback Segments……Page 63
Using Redo Log Files……Page 65
Associating Instances, Users, and Resources with Free List Groups……Page 67
FREELIST GROUPS and MAXINSTANCES……Page 68
Preallocating Extents to Free List Groups……Page 69
The CACHE Option……Page 70
The ORDER Option……Page 71
4 Administering Real Application Clusters Databases with Server Control, SQL, and SQL*Plus……Page 73
SRVCTL Cluster Database Tasks……Page 74
srvctl start……Page 75
srvctl status……Page 76
Updating Your Configuration Information with SRVCTL……Page 77
srvctl delete db……Page 78
srvctl unset env……Page 79
Migrating Oracle8i Configurations to Oracle9i……Page 80
Administering the GSD on Windows Platforms……Page 81
Starting Databases in Cluster Mode on UNIX……Page 82
Starting Databases in Cluster Mode on Windows NT and Windows 2000……Page 83
Using RETRY to Mount a Database in Cluster Mode……Page 84
Setting and Connecting to Instances……Page 85
The CONNECT Command……Page 86
Shutting Down Real Application Clusters Instances……Page 87
Quiescing A Real Application Clusters Database……Page 88
How SQL and SQL*Plus Commands Affect Instances……Page 89
Part II Using Oracle Enterprise Manager to Administer Real Application Clusters……Page 91
5 Administering Real Application Clusters Databases with Oracle Enterprise Manager……Page 93
Displaying Objects in the Navigator Pane……Page 94
Database-Specific File Structure……Page 95
Resource Plan Schedule……Page 96
Using the Cluster Database Right-Mouse Menu……Page 99
Starting a Cluster Database……Page 100
Shutting Down a Cluster Database……Page 101
Viewing the Cluster Database Operation Results……Page 103
Status Details Tab……Page 104
Output Tab……Page 105
Viewing Cluster Database Status……Page 106
General Tab……Page 107
Status Details Tab……Page 108
Specifying Job Details……Page 110
General Tab……Page 111
Cluster Database Startup Task……Page 113
Parameters for the Cluster Database Shutdown Task……Page 115
Registering Cluster Database Events……Page 116
Part III Backup and Recovery in Real Application Clusters……Page 119
6 Configuring RMAN for Real Application Clusters……Page 121
Configuring RMAN Control File Snapshots and Autobackups……Page 122
Configuring the Control File Autobackup Feature in RMAN……Page 123
Selecting An Archived Log Configuration Scheme……Page 124
RMAN Archive Log Configuration Schemes……Page 125
Non-Shared Local Archive Logging……Page 126
Configuring Initialization Parameters for Non-Shared Archiving Destinations……Page 127
Backups Using Non-Shared Archive Logging……Page 128
Restore and Recovery Using Non-Shared Archive Logging……Page 129
Shared Read Local Archive Logging……Page 130
One Remote Archive Logging……Page 133
Configuring Initialization Parameters for One Remote Archive Logging……Page 134
Backups for One Remote Archive Logging……Page 135
Backups for No Cross-Mounting……Page 136
Configuring Initialization Parameters for Cross-Mounting for Writing……Page 137
Restore and Recovery for Cross-Mounting for Writing……Page 139
Optimizing the Reading of Local Archivelog Destinations……Page 140
Cross Shared Cross Writing with One Local and N Remote Archive Logging……Page 141
Central NFS Directory for High Availability Archive Logging……Page 143
Hybrid Archive Logging……Page 144
NFS Implemented for High Availability……Page 145
Using Shared Drives on Windows Platforms……Page 146
7 Backing Up Real Application Clusters Databases……Page 149
Open Database Backups……Page 150
Closed Database Backups……Page 151
Changing the Archiving Mode in Real Application Clusters……Page 152
Archive File Format and Destinations in Real Application Clusters……Page 153
Forcing a Checkpoint……Page 154
Forcing a Log Switch……Page 155
Node Affinity Awareness……Page 156
Performing an Open Backup Using RMAN……Page 157
Avoiding the Thread Statement for Backing Up Archivelogs……Page 158
Backing Up Local Files from Each Node Using Non-Shared Archive Log Destinations……Page 159
Recovering Archive Logs from One Node……Page 160
Restoring and Recovering Archive Logs from All Local Nodes Using Oracle 8.1.5 Or Earlier……Page 161
8 Database Recovery in Real Application Clusters……Page 163
Single Node Failure……Page 164
Fast-Start Checkpointing and Fast-Start On-Demand Rollback……Page 165
Steps of Oracle Instance Recovery……Page 166
Recovery from Media Failures……Page 167
Complete Media Recovery……Page 168
Incomplete Media Recovery……Page 169
Recovery Using Operating System Utilities……Page 170
Disaster Recovery Using RMAN……Page 171
Parallel Recovery in Real Application Clusters……Page 173
Parallel Recovery Using RMAN……Page 174
Fast-Start Parallel Rollback in Real Application Clusters……Page 175
Restoring Archive Logs with RMAN……Page 176
Part IV Scaling Your Real Application Clusters Environment……Page 181
9 Adding Nodes and Instances and Deleting Instances in Real Application Clusters……Page 183
Overview of Procedures for Adding Nodes……Page 184
Adding a Node at the Clusterware Layer on UNIX……Page 185
Adding a Node at the Clusterware Layer on Windows NT and Windows 2000……Page 186
Install Cluster Software……Page 187
Create Links to Disk Partitions……Page 189
Adding a Node at the Oracle Layer……Page 191
Deleting Instances……Page 201
Part V Reference……Page 207
Background Thread Trace Files……Page 209
Alert File……Page 210
Error Call Trace Stack……Page 211
Severe Errors……Page 212
Glossary……Page 213
Index……Page 235