| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| Oracle Networking | |
| |
| |
| Networking Overview | |
| |
| |
| Networking Challenges in the Business Environment | |
| |
| |
| Network Configurations | |
| |
| |
| Oracle's Solution to Networking Issues | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Basic Oracle Net Architecture | |
| |
| |
| Open System Interconnection Architecture | |
| |
| |
| Oracle Net Layered Architecture | |
| |
| |
| Oracle Net Services | |
| |
| |
| Web Client Connections | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Basic Net Server-Side Configuration | |
| |
| |
| How the Listener Responds to Incoming Connections | |
| |
| |
| Components of the Listener | |
| |
| |
| Configuring the Listener Using the Oracle Net Manager | |
| |
| |
| Controlling the Listener Using the Listener Control Utility (Isnrctl) | |
| |
| |
| Dynamic Service Registration | |
| |
| |
| Configuring the Listener for IIOP | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Basic Oracle Net Services Client-Side Configuration | |
| |
| |
| Naming Methods | |
| |
| |
| Configuring the Host Naming Method | |
| |
| |
| Configuring the Local Naming Method | |
| |
| |
| Configuring Net Service Names | |
| |
| |
| Performing Simple Connection Troubleshooting | |
| |
| |
| Chapter Questions | |
| |
| |
| Chapter Answers | |
| |
| |
| Usage and Configuration of the Oracle Shared Server | |
| |
| |
| Identifying the Components of the Oracle Shared Server | |
| |
| |
| Oracle Shared Server Architecture | |
| |
| |
| Configuring the Oracle Shared Server | |
| |
| |
| Shared Server Related Dictionary Views | |
| |
| |
| Chapter Questions | |
| |
| |
| Chapter Answers | |
| |
| |
| Backup and Recovery | |
| |
| |
| Backup and Recovery Overview | |
| |
| |
| Classification of Failures | |
| |
| |
| Basics of Database Backup, Restoration, and Recovery | |
| |
| |
| Backup and Recovery Strategies | |
| |
| |
| Disaster Recovery Plan | |
| |
| |
| Oracle's High-Availability Features | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Instance and Media Recovery Structures | |
| |
| |
| Oracle Memory Structures | |
| |
| |
| Oracle Background Processes | |
| |
| |
| Oracle Database Files | |
| |
| |
| Importance of Checkpoints During Instance Recovery | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Configuring the Database Archive Mode | |
| |
| |
| Differences Between ARCHIVELOG and NOARCHIVELOG Mode | |
| |
| |
| Configuring a Database for ARCHIVELOG Mode | |
| |
| |
| Configuring Multiple Archive Processes | |
| |
| |
| Configuring Multiple Destinations, Including Remote Destinations | |
| |
| |
| Useful V$VIEWS | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Oracle Recovery Manager Overview and Configuration | |
| |
| |
| Features of RMAN | |
| |
| |
| Components of RMAN | |
| |
| |
| RMAN Repository | |
| |
| |
| RMAN Channel Allocation | |
| |
| |
| Media Management Library Interface | |
| |
| |
| Connecting to RMAN Without the Recovery Catalog | |
| |
| |
| Configuring the RMAN Environment | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| User-Managed Backups | |
| |
| |
| User-Managed Backup and Recovery | |
| |
| |
| Closed Database Backups | |
| |
| |
| Open Database Backups | |
| |
| |
| Backups of Read-Only Tablespaces | |
| |
| |
| Backup of the Control File | |
| |
| |
| Backups of Archived Redo Logs | |
| |
| |
| Cleanup Operations after Failed Online Backups | |
| |
| |
| LOGGING and NOLOGGING Options | |
| |
| |
| dbverify Utility | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| RMAN Backups | |
| |
| |
| RMAN Backup Concepts | |
| |
| |
| RMAN Image Copies | |
| |
| |
| RMAN Backup Sets | |
| |
| |
| Tags for Backup Sets and Image Copies | |
| |
| |
| Backing Up the Control File | |
| |
| |
| Backing Up the Archive Redo Log files | |
| |
| |
| Important V$VIEWS | |
| |
| |
| Chapter Questions | |
| |
| |
| Chapter Answers | |
| |
| |
| User-Managed Complete Recovery | |
| |
| |
| Media Recovery | |
| |
| |
| Performing User-Managed Complete Recovery | |
| |
| |
| Performing Recovery in NOARCHIVELOG Mode | |
| |
| |
| Performing Complete Recovery in ARCHIVELOG Mode | |
| |
| |
| Restoring Data Files to Different Locations | |
| |
| |
| Relocating and Recovering a Tablespace Using Archived Redo Log Files | |
| |
| |
| Loss of an Online Inactive Redo Log Group and Recovery | |
| |
| |
| Recovery of Read-Only Tablespaces | |
| |
| |
| Chapter Questions | |
| |
| |
| Chapter Answers | |
| |
| |
| RMAN Complete Recovery | |
| |
| |
| Server-Managed Media Recovery Using RMAN | |
| |
| |
| Performing Recovery in NOARCHIVELOG Mode | |
| |
| |
| Performing Complete Recovery in ARCHIVELOG Mode | |
| |
| |
| Restore Data Files to Different Locations Using RMAN | |
| |
| |
| Relocate and Recover a Tablespace Using the Archived Redo Log Files | |
| |
| |
| Block Media Recovery (BMR) | |
| |
| |
| Chapter Questions | |
| |
| |
| Chapter Answers | |
| |
| |
| User-Managed Incomplete Recovery | |
| |
| |
| Incomplete Recovery | |
| |
| |
| Identifying Loss of a Current Online Redo Log File | |
| |
| |
| Media Recovery in Parallel | |
| |
| |
| Important V$VIEWS | |
| |
| |
| Chapter Questions | |
| |
| |
| Chapter Answers | |
| |
| |
| RMAN Incomplete Recovery | |
| |
| |
| Incomplete Recovery Using RMAN | |
| |
| |
| Perform an Incomplete Database Recovery Using UNTIL TIME | |
| |
| |
| Perform Incomplete Database Recovery Using UNTIL SEQUENCE | |
| |
| |
| Restore Optimization | |
| |
| |
| Chapter Questions | |
| |
| |
| Chapter Answers | |
| |
| |
| RMAN Maintenance | |
| |
| |
| RMAN Crosscheck | |
| |
| |
| Performing a Crosscheck of Backup Sets and Image Copies | |
| |
| |
| Updating the Repository When Backups Have Been Deleted | |
| |
| |
| Changing the Availability Status of Backup Sets and Image Copies | |
| |
| |
| Making a Backup Set or an Image Copy Exempt from the Retention Policy | |
| |
| |
| Cataloging Backups Made with the Operating System Commands | |
| |
| |
| Chapter Questions | |
| |
| |
| Chapter Answers | |
| |
| |
| Recovery Catalog Creation and Maintenance | |
| |
| |
| Contents of the Recovery Catalog | |
| |
| |
| Recovery Catalog Creation | |
| |
| |
| Use RMAN to Register, Resynchronize, and Reset a Database | |
| |
| |
| Maintain the Recovery Catalog by Using RMAN Commands | |
| |
| |
| Query the Recovery Catalog to Generate Reports and Lists | |
| |
| |
| Create, Store, and Run Scripts | |
| |
| |
| Methods of Backing Up and Recovering the Recovery Catalog | |
| |
| |
| Important Recovery Catalog Views | |
| |
| |
| Chapter Questions | |
| |
| |
| Chapter Answers | |
| |
| |
| Transporting Data Between Databases | |
| |
| |
| Oracle Logical Backups | |
| |
| |
| Export Concepts and Structures | |
| |
| |
| Import Concepts and Structures | |
| |
| |
| A List of Export and Import Parameters | |
| |
| |
| Methods to Invoke Export and Import | |
| |
| |
| Perform Export and Import Operations | |
| |
| |
| List Guidelines for Using Export and Import | |
| |
| |
| Chapter Questions | |
| |
| |
| Chapter Answers | |
| |
| |
| Loading Data into a Database | |
| |
| |
| Direct-Path Insert Operations | |
| |
| |
| SQL *Loader Usage | |
| |
| |
| Loading Methods in SQL *Loader | |
| |
| |
| SQL *Loader Files | |
| |
| |
| Performing Basic SQL *Loader Operations | |
| |
| |
| Guidelines for Using SQL *Loader and Direct-Load Insert | |
| |
| |
| Chapter Questions | |
| |
| |
| Chapter Answers | |
| |
| |
| Test Yourself: Oracle9i DBA Practice Exams | |
| |
| |
| Practice Exams for OCP DBA II Fundamentals | |
| |
| |
| Full-Length Examination I | |
| |
| |
| Full-Length Examination II | |
| |
| |
| Answers to Full-Length Examination I | |
| |
| |
| Answers to Full-Length Examination II | |
| |
| |
| Index | |