toc

Slide 1: 

Preface 1 Networking Overview Objectives 1-2 Network Environment Challenges 1-3 Simple Network: Two-Tier 1-5 Simple to Complex Network: N-Tier 1-6 Complex Network 1-7 Oracle9i Networking Solutions 1-8 Connectivity: Oracle Net Services 1-9 Connectivity: Database Connectivity with IIOP and HTTP 1-11 Directory Naming 1-12 Directory Services: Oracle Internet Directory 1-14 Scalability: Oracle Shared Server 1-15 Scalability: Connection Manager 1-16 Security: Advanced Security 1-18 Advanced Security Encryption 1-19 Security: Oracle Net Services and Firewalls 1-20 Accessibility: Heterogeneous Services 1-21 Accessibility: External Procedures 1-22 Oracle Net Configuration Assistant 1-23 Oracle Net Manager 1-24 Summary 1-25 2 Oracle Net Architecture Objectives 2-2 Oracle Net Connections 2-3 Client-Server Application Connection: No Middle-Tier 2-4 Web Client Application Connections 2-6 Web Client Application Connection: Web Server Middle-Tier 2-7 Web Client Application Connection: Java Application Client 2-8 Web Client Application Connection: Java Applet Client 2-9 Web Client Application Connection: No Middle Tier 2-10 Connectivity Concepts and Terminology 2-12 Oracle Net Configuration Models 2-14 Oracle Net Configuration Files 2-15 Summary 2-17 3 Basic Oracle Net Server Side Configuration Objectives 3-2 The Listener Process 3-3 Connection Methods 3-4 Spawn and Bequeath and Direct Hand-Off Connections 3-5 Redirected Session 3-7 Service Configuration and Registration 3-9 Contents iii

Slide 2: 

Static Service Registration: The listener.ora File 3-12 Static Service Registration: Create a Listener 3-15 Configure Services 3-16 Logging and Tracing 3-17 Dynamic Service Registration: Configure Registration 3-18 Dynamic Service Registration: Registering Information with the Listener 3-19 Configure the Listener for Oracle9i JVM: IIOP and HTTP 3-20 Listener Control Utility (LSNRCTL) 3-22 LSNRCTL Commands 3-23 LSNRCTL SET and SHOW Modifiers 3-25 Summary 3-27 Practice 3 Overview 3-28 4 Naming Method Configuration Objectives 4-2 Overview of Naming Methods 4-3 Host Naming 4-4 Host Naming: Client Side 4-5 Host Naming: Server Side 4-6 Host Naming Example 4-7 Naming Methods Configuration 4-8 Selecting the Host Naming Method 4-9 Local Naming 4-10 Selecting the Local Naming Method 4-11 Configuring Local Net service Names 4-12 Working with Net Service Names 4-13 Specify the Oracle Database Version 4-14 Database Service Name 4-15 Network Protocol 4-16 Host Name and Listener Port 4-17 Testing the Connection 4-18 Connection Test Result 4-19 Net Service Name 4-20 Save the Net Service Name 4-21 Generated Files: tnsnames.ora 4-22 Generated Files: sqlnet.ora 4-24 Troubleshooting the Client Side 4-25 Summary 4-27 Practice 4 Overview 4-28 5 Usage and Configuration of the Oracle Shared Server Objectives 5-2 Server Configurations 5-3 Dedicated Server Processes 5-4 Oracle Shared Server 5-5 Benefits of Oracle Shared Server 5-7 iv

Slide 3: 

Using a Dedicated Server with Oracle Shared Server 5-8 Connecting 5-9 Processing a Request 5-10 The SGA and PGA 5-12 Configuring Oracle Shared Server 5-13 DISPATCHERS 5-14 MAX_DISPATCHERS 5-16 SHARED_SERVERS 5-18 MAX_SHARED_SERVERS 5-20 CIRCUITS 5-21 SHARED_SERVER_SESSIONS 5-22 Related Parameters 5-23 Verifying Setup 5-25 Dynamic Views 5-27 Summary 5-28 Practice 5 Overview 5-29 6 Backup and Recovery Overview Objectives 6-2 Backup and Recovery Issues 6-3 Categories of Failures 6-4 Causes of Statement Failures 6-6 Resolutions for Statement Failures 6-7 Causes of User Process Failures 6-8 Resolution of User Process Failures 6-9 Possible User Errors 6-10 Resolution of User Errors 6-11 Causes of Instance Failure 6-12 Recovery from Instance Failure 6-13 Causes of Media Failures 6-15 Resolutions for Media Failures 6-16 Defining a Backup and Recovery Strategy 6-17 Business Requirements 6-18 Operational Requirements 6-19 Technical Considerations 6-21 Disaster Recovery Issues 6-23 Summary 6-25 7 Instance and Media Recovery Structures Objectives 7-2 Overview 7-3 Large Pool 7-6 Database Buffer Cache, DBWn, and Datafiles 7-8 Redo Log Buffer, LGWR, and Redo Log Files 7-10 v

Slide 4: 

Multiplexed Redo Log Files 7-13 Redo Log Files in Enterprise Manager 7-15 Checkpointing 7-16 Types of Checkpoints 7-17 CKPT Process 7-18 Multiplexed Control Files 7-19 Control Files in Enterprise Manager 7-21 ARCn Process and Archived Log Files 7-22 Database Synchronization 7-24 Phases for Instance Recovery 7-25 Tuning Crash and Instance Recovery Performance 7-27 Tuning the Duration of Instance and Crash Recovery 7-28 Initialization Parameters Influencing Checkpoints 7-29 Controlling Instance Crash Recovery Time 7-31 V$INSTANCE_RECOVERY 7-32 Tuning the Phases of Crash and Instance Recovery 7-34 Tuning the Rolling Forward Phase 7-35 Tuning the Rolling Black Phase 7-36 Fast-Start On-Demand Rollback 7-37 Fast-Start Parallel Rollback 7-38 Controlling Fast-Start Parallel Rollback 7-39 Monitoring Parallel Rollback 7-40 Summary 7-41 Practice 7 Overview 7-42 8 Configuring the Database Archiving Mode Objectives 8-2 Redo Log History 8-3 NOARCHIVELOG Mode 8-4 ARCHIVELOG Mode 8-6 Changing the Archiving Mode 8-8 Setting the Archiving Mode 8-10 Automatic and Manual Archiving 8-11 Enabling Automatic Archiving 8-13 Specifying Multiple ARCn Processes 8-14 Stop or Start Additional Archive Processes 8-15 Enabling Automatic Archiving at Instance Startup 8-16 Enabling Automatic Archiving After Instance Startup 8-17 Disabling Automatic Archiving 8-18 Manually Archiving Online Redo Log Files 8-19 Manually Archive Redo Log Files 8-21 Specifying the Archive Log Destination 8-22 Specifying Multiple Archive Log Destinations 8-23 LOG_ARCHIVE_DEST_n Options 8-24 Specifying a Minimum Number of Local Destinations 8-25 vi

Slide 5: 

Controlling Archiving to a Destination 8-27 Specifying the Filename Format 8-28 Obtaining Archive Log Information 8-29 Summary 8-32 Practice 8 Overview 8-33 9 Oracle Recovery Manager Overview and Configuration Objectives 9-2 Recovery Manager Features 9-3 Recovery Manager Components 9-5 Using the Backup Management Wizards 9-7 RMAN Repository: Using the Control File 9-8 Channel Allocation 9-9 Automatic Channel Allocation 9-11 Channel Allocation Using OEM 9-12 Manual Channel Allocation 9-13 Media Management 9-15 Types of Connections with RMAN 9-17 Connecting Without a Recovery Catalog 9-18 Additional RMAN Command Line Arguments 9-20 Recovery Manager Modes 9-21 RMAN Commands 9-23 Job Command Example 9-25 RMAN Configuration Settings 9-26 The CONFIGURE Command 9-27 The SHOW Command 9-29 LIST Command Operations 9-30 The LIST Command 9-31 The REPORT Command 9-32 The REPORT NEED BACKUP Command 9-33 Recovery Manager Packages 9-34 RMAN Usage Considerations 9-35 Summary 9-37 Practice 9 Overview 9-38 10 User-Managed Backups Objectives 10-2 Terminology 10-3 User-Managed Backup and Recovery 10-5 Querying Views to Obtain Database File Information 10-6 Obtaining Database File Information 10-8 Backup Methods 10-9 Consistent Whole Database Backup (Closed Database Backup) 10-10 Advantages of Making Consistent Whole Database Backups 10-11 Making a Consistent Whole Database Backup 10-13 Open Database Backup 10-15 vii

Slide 6: 

Advantages of Making Open Database Backups 10-16 Open Database Backup Requirements 10-17 Open Database Backup Options 10-18 Making a Backup of an Online Tablespace 10-19 Ending the Online Tablespace Backup 10-20 Backup Status Information 10-21 Failure During Online Tablespace Backup 10-23 Ending the Online Backup 10-24 Read Only Tablespace Backup 10-26 Read Only Tablespace Backup Issues 10-27 Backup Issues with Logging and Nologging Options 10-28 Manual Control File Backups 10-29 Backing Up the Initialization Parameter File 10-31 Verifying Backups Using the DBVERIFY Utility 10-32 DBVERIFY Command-Line Interface 10-33 Summary 10-35 Practice 10 Overview 10-36 11 RMAN Backups Objectives 11-2 RMAN Backup Concepts 11-3 Recovery Manger Backups 11-4 Backup Sets 11-5 Characteristics of Backup Sets 11-6 Backup Piece 11-7 Backup Piece Size 11-8 The BACKUP Command 11-9 Creating a Backup Set 11-12 Multiplexed Backup Sets 11-13 Parallelization of Backup Sets 11-14 Duplexed Backup Sets 11-16 Backups of Backup Sets 11-17 Archived Redo Log File Backups 11-18 Archived Redo Log Backup Sets 11-19 Backup Constraints 11-20 Image Copies 11-21 Characteristics of an Image Copy 11-22 Creating an Image Copy 11-23 Image Copy Example 11-24 The COPY Command 11-25 Image Copy Parallelization 11-26 Copying the Whole Database 11-27 Making Incremental Backups 11-28 Differential Incremental Backup Example 11-30 Cumulative Incremental Backup Example 11-32 viii

Slide 7: 

Backup in NOARCHIVELOG Mode 11-33 RMAN Control File Autobackups 11-34 Tags for Backups and Image Copies 11-36 RMAN Dynamic Views 11-37 Monitoring RMAN Backups 11-38 Miscellaneous RMAN Issues 11-40 Summary 11-42 Practice 11 Overview 11-43 12 User-Managed Complete Recovery Objectives 12-2 Media Recovery 12-3 Recovery Steps 12-4 Restoration and Datafile Media Recovery with User-Managed Procedures 12-5 ARCHIVELOG and NOARCHIVELOG Modes 12-6 Recovery in NOARCHIVELOG Mode 12-7 Recovery in NOARCHIVELOG Mode with Redo Log File Backups 12-9 Recovery in NOARCHIVELOG Mode without Redo Log File Backups 12-10 Recovery in ARCHIVELOG Mode 12-11 Complete Recovery 12-12 Complete Recovery in ARCHIVELOG Mode 12-13 Determining Which Files Need Recovery 12-14 User-Managed Recovery Procedures: RECOVER Command 12-16 Using Archived Redo Log Files During Recovery 12-17 Restoring Datafiles to a New Location with User-Managed Procedures 12-19 Complete Recovery Methods 12-20 Complete Recovery of a Closed Database 12-22 Closed Database Recovery Example 12-23 Open Database Recovery When the Database Is Initially Open 12-25 Open Database Recovery Example 12-26 Open Database Recovery When the Database Is Initially Closed 12-28 Open Database Recovery Example 12-29 Recovery of a Datafile Without a Backup 12-31 Re-creating Lost Datafiles Without Backup 12-32 Recovery without a Backup Example 12-33 Read-Only Tablespace Recovery 12-35 Read-Only Tablespace Recovery Issues 12-36 Loss of Control Files 12-37 Recovering Control Files 12-38 Summary 12-39 Practice 12 Overview 12-40 13 RMAN Complete Recovery Objectives 13-2 Restoration and Datafile Media Recovery Using RMAN 13-3 ix

Slide 8: 

Using RMAN to Recover a Database in ARCHIVELOG Mode 13-4 Using the Recovery Wizard 13-5 Using RMAN to Restore Datafiles to a New Location 13-6 Restoring to a New Location 13-7 Using RMAN to Recover a Tablespace 13-8 Tablespace Recovery 13-9 Using RMAN to Relocate a Tablespace 13-10 Summary 13-12 Practices 13-1 and 13-2 Overview 13-13 14 RMAN Complete Recovery Objectives 14-2 Incomplete Recovery Overview 14-3 Situations Requiring Incomplete Recovery 14-4 Types of Incomplete Recovery 14-5 Incomplete Recovery Guidelines 14-7 Incomplete Recovery and the Alert Log 14-9 User-Managed Procedures for Incomplete Recovery 14-10 RECOVER Command Overview 14-11 Time-Based Recovery Example 14-12 UNTIL TIME Recovery 14-13 Cancel-Based Recovery Example 14-15 Using a Backup Control File During Recovery 14-18 Loss of Current Redo Log Files 14-21 Summary 14-23 Practices 14-1 and 14-2 Overview 14-24 15 RMAN Incomplete Recovery Objectives 15-2 Incomplete Recovery of a Database Using RMAN 15-3 Specifying the Restore Time 15-4 RMAN Incomplete Recovery UNTIL TIME Example 15-5 RMAN Incomplete Recovery UNTIL SEQUENCE Example 15-7 Summary 15-8 Practice 15 Overview 15-9 16 RMAN Maintenance Objectives 16-2 Cross Checking Backups and Copies 16-3 The CROSSCHECK Command 16-4 Deleting Backups and Copies 16-5 The DELETE Command 16-6 Deleting Backups and Copies 16-7 Changing the Availability of RMAN Backups and Copies 16-8 Changing the Availability Status 16-9 Exempting a Backup or Copy from the Retention Policy 16-10 x

Slide 9: 

The CHANGE … KEEP Command 16-11 Cataloging Archived Redo Log Files and User-Managed Backups 16-12 The CATALOG Command 16-13 Uncataloging RMAN Records 16-14 The CHANGE … UNCATALOG Command 16-15 Summary 16-16 Practice 16 Overview 16-17 17 Recovery Catalog Creation and Maintenance Objectives 17-2 Overview 17-4 Recovery Catalog Contents 17-5 Benefits of Using a Recovery Catalog 17-7 Create Recovery Catalog 17-8 Connecting Using a Recovery Catalog 17-11 Recovery Catalog Maintenance 17-12 Catalog Maintenance 17-13 Resynchronization of the Recovery Catalog 17-14 Using RESYNC CATALOG for Resynchronization 17-15 Resetting a Database Incarnation 17-16 Recovery Catalog Reporting 17-18 Viewing the Recovery Catalog 17-19 Stored Scripts 17-21 Script Examples 17-22 Managing Scripts 17-23 Backup of Recovery Catalog 17-24 Recovering the Recovery Catalog 17-25 Summary 17-26 Practice 17 Overview 17-27 18 Transporting Data Between Databases Objectives 18-2 Oracle Export and Import Utilities 18-3 Oracle Export and Import Utility Overview 18-4 Methods of Invoking the Export and Import Utilities 18-6 Export Modes 18-7 Invoking Export 18-9 Using the Export Wizard 18-12 Direct-Path Export Concepts 18-13 Direct-Path Export Features 18-14 Direct-Path Export Restrictions 18-15 Specifying Direct-Path Export 18-16 Uses of the Import Utility for Recovery 18-17 Import Modes 18-18 Invoking Import 18-19 Using the Import Wizard 18-21 xi

Slide 10: 

Invoking Import as SYSDBA 18-22 Import Process Sequence 18-23 Globalization Support Considerations 18-24 Summary 18-25 Practice 18 Overview 18-26 19 Workshop Objectives 19-2 Workshop Methodology 19-4 Workshop Approach 19-6 Business Requirements 19-7 Resolving a Database Failure 19-8 Resolving a Network Failure 19-10 Enable Tracing 19-11 Using Trace Files 19-12 Summary 19-15 Practice 19 19-17 Appendix A: Practice Solutions Appendix B: Workshop Scenarios Appendix C: Worldwide Support Bulletins Appendix D: Loading Data into a Database xii