| Foreword | xxi |
| Acknowledgements | xxiii |
| Introduction | xxvii |
Part I | Overview | |
1 | Windows 2000 | 3 |
| Oracle and Microsoft | 4 |
| Windows 2000 | 5 |
| A Brief Look Inside Windows 2000 | 7 |
| Security | 18 |
| The Windows 2000 Interface | 21 |
| The Registry and the Environment | 23 |
| Summary | 27 |
2 | Overview of Oracle9i RDBMS | 29 |
| Process Architecture | 30 |
| The Oracle Instance | 34 |
| The Database Files | 39 |
| Internal Database Management | 44 |
| Database Integrity Checks | 53 |
| Summary | 56 |
Part II | Implementing the Oracle RDBMS on Windows 2000 | |
3 | Configuring Windows 2000 | 61 |
| Tuning Windows for Oracle | 63 |
| Microsoft Management Console | 70 |
| Command-Line Management | 79 |
| System Administration | 92 |
| The Operating System Environment | 101 |
| Remote Administration | 106 |
| Resources | 109 |
| Looking Ahead | 111 |
| Summary | 113 |
4 | Installing and Configuring the Oracle RDBMS | 115 |
| History of Oracle on Windows NT | 117 |
| The Oracle Universal Installer | 120 |
| Beginning the Installation | 123 |
| Creating the Database | 130 |
| The Database Storage Page | 143 |
| Deinstalling Oracle Products | 153 |
| Summary | 155 |
5 | Advanced Database Administration for Windows 2000 | 157 |
| Advanced Database Creation and Management | 159 |
| Oracle Memory Usage on Windows 2000 | 168 |
| Using the Performance Monitor | 183 |
| Using the Oracle Administration Assistant | 194 |
| Additional 9i Features | 199 |
| Summary | 208 |
6 | Backup and Recovery Considerations | 209 |
| Base Your Backup Strategy on Your Business Needs | 211 |
| Align Backup Strategies with Business Needs Before Agreeing to a Service Level Agreement | 213 |
| Cold Backups Make Your Life Easier | 214 |
| Using Windows 2000 Backup Utility | 216 |
| Third-Party Backup Products | 217 |
| Understanding and Implementing Hot Backups | 217 |
| Leveraging Server Managed Recovery | 220 |
| Understanding the Oracle9i Recovery Manager Architecture | 221 |
| RMAN Configuration: A Primer | 223 |
| RMAN Integration with Media Management Software | 226 |
| Understanding the Benefits of an RMAN Implementation | 227 |
| RMAN Backups: Syntax and Usage | 231 |
| Establishing Persistent Backup Parameters | 241 |
| RMAN Restore and Recovery: A Primer | 242 |
| RMAN Recovery: Syntax and Usage | 245 |
| Understanding and Using Incomplete Recovery | 248 |
| Using RMAN Backups to Create Clone Copies of Production Databases | 257 |
| Test All Backups for Recoverability | 262 |
| Summary | 262 |
Part III | Windows 2000: The Premiere Enterprise Management Platform | |
7 | Oracle Connectivity | 265 |
| The Oracle Net Architecture | 267 |
| Connectivity Configuration | 295 |
| General Network Tuning and Configuration | 316 |
| Resources | 318 |
| Summary | 321 |
8 | Oracle Enterprise Manager | 323 |
| EM Functionality | 324 |
| EM Framework | 329 |
| The Agent | 342 |
| Events | 346 |
| Jobs | 355 |
| Database Administration | 358 |
| The Oracle Management Server | 363 |
| EM Web Reporting | 368 |
| EM 3-Tier Infrastructure and Firewalls | 375 |
| EM Reference and Help | 376 |
| Summary | 378 |
9 | Advanced Management, Tools, and Analysis | 379 |
| Techniques with Tools | 380 |
| Tools for Holistic Database Management | 398 |
| Summary | 412 |
10 | Change Management | 413 |
| Upgrading the Operating System | 414 |
| Migrating or Upgrading the Oracle Database | 419 |
| Upgrading in a Clustered or Standby Environment | 434 |
| Summary | 438 |
Part IV | Clustering and High Availability | |
11 | Oracle Failsafe | 441 |
| Oracle Failsafe Concepts | 443 |
| Designing an Oracle Failsafe Solution | 447 |
| Preparing to Install MSCS | 450 |
| Installing Microsoft Cluster Server | 453 |
| Installing Oracle Failsafe | 458 |
| Making the Database Failsafe | 462 |
| Troubleshooting in a Failsafe/MSCS Environment | 472 |
| Summary | 476 |
12 | Oracle Real Application Clusters | 477 |
| The RAC Environment | 479 |
| Preparing for the Cluster Installation | 481 |
| Installing the Cluster Software and Oracle9i RDBMS | 493 |
| Maintaining a RAC Instance | 502 |
| Summary | 507 |
13 | The Standby Database | 509 |
| Standby Database Architecture | 510 |
| Traditional Standby Configuration: A Test Case | 518 |
| Utilizing Oracle9i Log Transport Services | 523 |
| Using Oracle9i Data Guard for Standby Database Management | 525 |
| Use RMAN to Configure the Standby Database | 528 |
| Use the Standby Database for RMAN Backups of the Production Database | 529 |
| Summary | 531 |
14 | Oracle9i Advance Replication | 533 |
| Replication: Load Balancing, Disaster Recovery, and Distributed Offline Transaction Processing | 535 |
| The Advanced Replication Architecture | 536 |
| Replication and Database Performance | 539 |
| Replication Manager vs. Replication API | 539 |
| N-Way Setup and Configuration | 540 |
| Conflict Resolution Techniques | 553 |
| Offline Instantiation | 554 |
| Administration of the Replication Environment | 556 |
| Conclusions and Advice for the Replication DBA | 558 |
| Summary | 559 |
15 | Maximizing Availability | 561 |
| Transparent Application Failover | 562 |
| Real Application Clusters Guard | 564 |
| Backing Up a RAC Database Using RMAN | 581 |
| Creating a Single Instance Standby Database from a Cluster Database | 587 |
| Summary | 590 |
Part V | Appendices | |
A | Media Management Configuration for RMAN Backups to Tape | 593 |
| VERITAS NetBackup | 594 |
| NetBackup Configuration for RMAN Backups | 594 |
| Monitoring Backups from the NetBackup Server | 596 |
B | Generating and Finding Diagnostic Information for Oracle 9i | 599 |
| Oradebug | 600 |
| Dumping Information to Trace Files | 602 |
| Tracing SQL | 605 |
| More to Explore | 611 |
| Index | 613 |