Oracle 9i For Windows Book

	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