OCP: Oracle 10g Administration II Study Guide -- Frontmatter -- Acknowledgments -- Contents at a Glance -- Contents -- Introduction -- Assessment Test -- Answers to Assessment Test -- Chapter 1: Configuring Recovery Manager -- Exploring the Features and Components of RMAN -- RMAN Usage Considerations -- RMAN Repository and Control Files -- RMAN Using the Recovery Catalog -- Starting and Connecting to RMAN -- Describing Media Management Layer -- Describing Channel Allocation -- Parameters and Persistent Settings for RMAN -- Configuring RMAN Settings with Enterprise Manager -- Describing Retention Policies -- Configuring the Control File Autobackup -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 2: Using Recovery Manager -- RMAN Commands -- Backup Sets and Image Copies -- Creating Backup Sets -- Creating Image Copies -- Compressed Backups -- Full and Incremental Backups -- Parallelization of Backup Sets -- Backup Options -- Enabling and Disabling Block Change Tracking -- Managing Backups with Enterprise Manager -- Monitoring RMAN Backups -- Using LIST Commands -- Using REPORT Commands -- Working Examples Using RMAN -- Enabling ARCHIVELOG Mode -- Using RMAN to Back Up Archived Redo Logs -- Scheduling a Backup Job -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 3: Recovering From Non-Critical Losses -- An Overview of Non-Critical Files -- Creating a New Temporary Tablespace -- Starting the Database with a Missing Tempfile -- Altering the Default Temporary Tablespace for a Database -- Re-creating Redo Log Files -- Recovering an Index Tablespace -- Re-creating Indexes -- Recovering Read-Only Tablespaces -- Re-creating the Password File -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 4: Database Recovery.

Understanding the Restore and Recovery Process -- Server-Managed Recovery -- User-Managed Recovery -- Recovering Control Files -- Recovering a Control File Autobackup -- Re-creating a Control File -- Performing an Incomplete Recovery -- RMAN Incomplete Recovery -- Performing User-Managed Incomplete Recovery -- Database Recovery Using Enterprise Manager -- Performing a Recovery after a RESETLOGS Operation -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 5: Understanding the Flashback Database -- An Overview of Flashback Technologies -- An Overview of the Flashback Database -- Managing the Flash Recovery Area with Recovery Manager -- Configuring the Flash Recovery Area -- Using the Flash Recovery Area -- Backing Up the Flash Recovery Area -- Configuring the Flashback Database -- Using the Flashback Database with RMAN -- Monitoring the Flashback Database -- Using the Flashback Database with Enterprise Manager -- Configuring the Flashback Database with EM -- Using the Flashback Database with EM -- Monitoring the Flashback Database with EM -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 6: Recovering from User Errors -- An Overview of Flashback Technologies -- Using Flashback Drop -- Understanding the Recycle Bin -- Limitations on Flashback Drop and the Recycle Bin -- Using EM to Perform Flashback Dropped Tables -- Using Flashback Versions Query -- Using Flashback Transaction Query -- Using Flashback Table -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 7: Handling Block Corruption -- An Overview of Block Corruption -- Block Corruption Symptoms -- Using Various Methods to Detect and Resolve Corruption -- Using the ANALYZE Utility -- Using the DBVERIFY Utility -- Using DB_BLOCK_CHECKING -- Using the DBMS_REPAIR Package.

Block Media Recovery -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 8: Understanding Automatic Database Management -- Using the Automatic Workload Repository (AWR) -- AWR Statistics Collection Facility -- Workload Repository -- Active Session History -- AWR Snapshots -- AWR Baselines -- Using AWR Views -- Using AWR Reports -- Managing Server-Generated Alerts -- Threshold and Non-Threshold Alerts -- Default Alerts -- An Overview of the Alert Process -- Using Enterprise Manager to Configure Thresholds -- Setting Thresholds through PL/SQL -- Viewing Server Alerts -- Using Automatic Routine Administration Tasks -- Automatic Statistics Collection -- Understanding the Advisory Framework -- An Overview of the Advisors -- Automatic Database Diagnostic Monitor (ADDM) -- SQL Tuning Advisor -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 9: Understanding Automatic Storage Management -- Introducing the ASM Architecture -- Understanding an ASM Instance -- Creating an ASM Instance -- Connecting to an ASM Instance -- Starting Up and Shutting Down an ASM Instance -- Defining ASM Initialization Parameters -- Categorizing ASM Dynamic Performance Views -- Using ASM Filenames -- Fully Qualified Names -- Numeric Names -- Alias Names -- Alias with Template Names -- Incomplete Names -- Incomplete Names with Template -- Understanding ASM File Types and Templates -- Administering ASM Disk Groups -- Understanding Disk Group Architecture -- Understanding Failure Groups and Disk Group Mirroring -- Understanding Disk Group Dynamic Rebalancing -- Creating and Deleting Disk Groups -- Altering Disk Groups -- Using EM Database Control with ASM Disk Groups -- Using RMAN to Perform Database Migration to ASM -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions.

Chapter 10: Understanding Globalization Support -- An Overview of Globalization Support -- Globalization Support Features -- Globalization Support Architecture -- Supporting Multilingual Applications -- Using Unicode in a Multilingual Database -- Using NLS Parameters -- Setting NLS Parameters -- Prioritizing NLS Parameters -- Using NLS Views -- Using Datetime Datatypes -- DATE Datatype -- TIMESTAMP Datatype -- TIMESTAMP WITH TIME ZONE Datatype -- TIMESTAMP WITH LOCAL TIME ZONE Datatype -- Using Linguistic Sorts and Searches -- An Overview of Text Sorting -- Using Linguistic Sort Parameters -- Linguistic Sort Types -- Searching Linguistic Strings -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 11: Managing Resources -- An Overview of the Database Resource Manager -- Working with the Pending Area -- Creating a Pending Area -- Validating Changes -- Submitting the Pending Area -- Clearing the Pending Area -- Resource Consumer Groups -- Managing Resource Consumer Groups -- Resource Plans -- Creating Simple Resource Plans -- Creating Complex Resource Plans -- Creating Resource Sub-Plans -- Modifying Resource Plans -- Deleting Resource Plans -- Resource Plan Directives -- Creating Resource Plan Directives -- Putting the Pieces Together -- Creating the Elements -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 12: Using the Scheduler to Automate Tasks -- Scheduler Overview -- Scheduler Architecture -- The Job Table -- The Job Coordinator -- The Job Slave Processes -- RAC Considerations -- Common Administration Tools -- Using the ENABLE Procedure -- Using the DISABLE Procedure -- Setting Attributes -- Using Scheduler Jobs -- Creating Jobs -- Copying Jobs -- Running Jobs -- Stopping Jobs -- Dropping Jobs -- Using Job Classes -- Job Class Parameters -- Creating Job Classes.

Dropping Job Classes -- Using Scheduler Programs -- Program Attributes -- Creating Programs -- Dropping Programs -- Using Schedules -- Schedule Attributes -- Creating Schedules -- Setting Repeat Intervals -- Testing Repeat Intervals -- Using Scheduler Windows -- Creating Windows -- Opening and Closing Windows -- Window Logging -- Purging Logs -- Using Scheduler Views -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 13: Monitoring and Managing Storage -- Monitoring Tablespace Storage -- Space Usage Monitoring -- Editing Thresholds with Enterprise Manager Database Control -- Using DBMS_SERVER_ALERT -- Using Segment Management Tools -- Segment Shrink -- Segment Advisor -- Index Space Monitoring -- Understanding Special Table Types -- Index-Organized Tables -- Clustered Tables -- Using Miscellaneous Space Management Tools -- Controlling Undo Space -- Controlling Redo Log File Space -- Leveraging Resumable Space Allocation -- An Overview of Resumable Space Allocation -- Using Resumable Space Allocation -- DBMS_RESUMABLE Package -- Using the AFTER SUSPEND System Event -- Resumable Space Allocation Data Dictionary Views -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 14: Securing the Oracle Listener, Diagnostic Sources, and Memory -- Securing the Oracle Listener -- An Overview of the TNS Listener -- Managing the Listener Remotely -- Setting the Listener Password -- Controlling Database Access -- Using Listener Logging -- Removing Unneeded External Procedure Services -- Creating a Separate Listener for External Procedures -- Diagnostic Sources -- Using the Oracle Alert Log -- Using Server-Generated Alerts -- Using Oracle Trace Files -- Automatic Memory Management -- Oracle Memory Usage -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions.

Glossary.