Includes index.

Introduction to Network Administration -- Network Design Considerations -- Network Responsibilities for the DBA -- Network Configurations -- Overview of Oracle Net Features -- The Oracle Net Stack Architecture -- Configuring Oracle Net on the Server -- The Oracle Listener -- Managing Oracle Listeners -- Using Oracle Net Manager -- Managing the Listener Using lsnrctl -- Dynamic Registration of Services -- Configure the Listener for Oracle9i JVM -- Troubleshooting Server-Side Connection Problems -- Oracle Net Logging and Tracing on the Server -- Configuring Oracle Net for the Client -- Client-Side Names Resolution Options -- Troubleshooting Client-Side Connection Problems -- Configuring the Shared Server Option -- Shared Server Configuration -- Configuring the Shared Server Option -- Starting the Instance and Managing Shared Server -- Requesting a Dedicated Connection in a Shared Server Environment -- Tuning the Shared Server Option -- Backup and Recovery Overview -- Database Backup, Restoration, and Recovery -- Types of Failure in Oracle Environments -- Defining a Backup and Recovery Strategy -- Testing a Backup and Recovery Plan -- Instance and Media Recovery Structures -- Oracle Recovery Processes, Memory Components, and File Structures -- Checkpoints, Redo Logs, and Archived Logs -- Ways to Tune the Instance Recovery -- Configuring the Database Archiving Mode -- Choosing ARCHIVELOG Mode or NOARCHIVELOG Mode -- Understanding Recovery Implications of NOARCHIVELOG -- Configuring a Database for ARCHIVELOG Mode and Automatic Archiving -- Manually Archiving Logs -- Using init.ora Parameters for Multiple Archive Processes and Locations -- Oracle Recovery Manager Overview and Configuration -- Identifying Features of Oracle Recovery Manager (RMAN) -- Exploring RMAN Components -- Storing Information Using the RMAN Repository and Control Files -- Describing Channel Allocation -- Exploring the Media Management Library Interface -- Connecting to RMAN without a Recovery Catalog -- Configuring the RMAN Environment -- User-Managed and RMAN-Based Backups -- User-Managed Backup and Recovery Operations -- Working with Read-Only Tablespaces -- Understanding Closed and Opened Database Backups -- Performing Closed and Opened Database Backups -- Identifying User-Managed Control-File Backups -- Cleaning Up after Failed Online Backups -- The DBVERIFY Utility -- Identifying RMAN-Specific Backups -- Using RMAN's BACKUP and COPY Commands -- Backing Up the Control File -- Backing Up the Archived Redo Logs -- User-Managed Complete Recovery and RMAN Complete Recovery -- Defining Media Recovery -- Recovering Using NOARCHIVELOG and ARCHIVELOG Modes -- Restoring Data Files to Different Locations -- Relocate and Recover a Tablespace by Using Archived Redo Logs -- Describe Read-Only Tablespace Recovery -- Using RMAN for Restoration and Recovery -- Performing RMAN Recovery in NOARCHIVE Mode -- Performing RMAN Complete Recovery in ARCHIVELOG Mode -- Using RMAN to Restore Data Files to Different Locations -- Use RMAN to Relocate and Recover a Tablespace Using Archived Logs -- User-Managed and RMAN-Based Incomplete Recovery -- Describing the User-Managed Incomplete Recovery -- Performing an Incomplete Database Recovery -- Recovering after Losing Current Redo Logs -- Performing an RMAN-Based Incomplete Recovery Using UNTIL TIME -- Performing RMAN-Based Incomplete Recovery Using UNTIL SEQUENCE -- RMAN Maintenance -- Performing Cross Checking of Backups and Copies -- Updating the Repository When Backups Have Been Deleted -- Change the Availability Status of Backups and Copies -- Make a Backup or Copy Exempt from the Retention Policy -- Catalog Backups Made with Operating System Commands -- Recovery Catalog Creation and Maintenance -- Considerations for Using the Recovery Catalog -- The Components of Recovery Catalog -- Creating a Recovery Catalog -- Use RMAN Commands to Maintain the Recovery Catalog -- Using RMAN to Register, Resynchronize, and Reset the Database -- Generating Lists and Reports from the Recovery Catalog -- Creating, Storing, and Running RMAN Scripts -- Methods for Backing Up and Recovering the Recovery Catalog -- Transporting Data between Databases -- Using the Export and Import Utilities -- Export and Import Concepts and Structures -- Performing Simple Export and Import Operations -- Guidelines for Using Export and Import -- Using SQL *Loader to Load Data -- Using Direct-Load Insert Operations -- Using SQL *Loader -- Performing Basic SQL *Loader Operations -- Guidelines for Using SQL *Loader and Direct-Load Insert.

The perfect way to prepare for the Oracle9i DBA Fundamentals II exam. Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book.