Best Practices from Oracle Experts Find Undocumented,Expert Advice Inside Take full advantage of the strength and reliability of Oracle9i and the management features of Windows 2000. Written by the experts and authorized by Oracle Corporation,Oracle9i for Windows 2000 Tips & Techniques presents insider best practices for installation,upgrades,migration,tuning,backup and recovery,clustering,and high availability. You'll also get in-depth details on the new features of Oracle9i.
Covers Oracle Database Releases 7. x,8i,and 9i
| 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 |
Overview
Best Practices from Oracle Experts Find Undocumented,Expert Advice Inside Take full advantage of the strength and ...