You are previewing OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043.
O'Reilly logo
OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

Book Description

Here's the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers' Choice Awards for two consecutive years, this book provides:

  • Clear and concise information on advanced database administration with Oracle 10g

  • Practical examples and insights drawn from the authors' real-world experiences

  • Leading-edge exam preparation software, including a test engine and electronic flashcards

You'll also find authoritative coverage of key exam topics, including:

  • Configuring Recovery Manager

  • Understanding the Flashback Database

  • Recovering from User Errors

  • Working with Globalization Support

  • Using the Scheduler to Automate Tasks

  • Monitoring and Managing Storage

  • Securing the Oracle Listener

Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace.

Table of Contents

  1. Copyright
  2. To Our Valued Readers:
  3. Wiley Publishing, Inc. End-User License Agreement
  4. Dedication
  5. Acknowledgments
  6. Introduction
  7. Configuring Recovery Manager
    1. Exploring the Features and Components of RMAN
    2. RMAN Usage Considerations
    3. RMAN Repository and Control Files
    4. Starting and Connecting to RMAN
    5. Describing Media Management Layer
    6. Describing Channel Allocation
    7. Parameters and Persistent Settings for RMAN
    8. Configuring RMAN Settings with Enterprise Manager
    9. Describing Retention Policies
    10. Configuring the Control File Autobackup
    11. Summary
    12. Exam Essentials
    13. Review Questions
    14. Answers to Review Questions
  8. Using Recovery Manager
    1. RMAN Commands
    2. Backup Sets and Image Copies
    3. Enabling and Disabling Block Change Tracking
    4. Managing Backups with Enterprise Manager
    5. Monitoring RMAN Backups
    6. Using LIST Commands
    7. Using REPORT Commands
    8. Working Examples Using RMAN
    9. Summary
    10. Exam Essentials
    11. Review Questions
    12. Answers to Review Questions
  9. Recovering From Non-Critical Losses
    1. An Overview of Non-Critical Files
    2. Creating a New Temporary Tablespace
    3. Re-creating Redo Log Files
    4. Recovering an Index Tablespace
    5. Recovering Read-Only Tablespaces
    6. Re-creating the Password File
    7. Summary
    8. Exam Essentials
    9. Review Questions
    10. Answers to Review Questions
  10. Database Recovery
    1. Understanding the Restore and Recovery Process
    2. Server-Managed Recovery
    3. User-Managed Recovery
    4. Recovering Control Files
    5. Performing an Incomplete Recovery
    6. Database Recovery Using Enterprise Manager
    7. Performing a Recovery after a RESETLOGS Operation
    8. Summary
    9. Exam Essentials
    10. Review Questions
    11. Answers to Review Questions
  11. Understanding the Flashback Database
    1. An Overview of Flashback Technologies
    2. An Overview of the Flashback Database
    3. Managing the Flash Recovery Area with Recovery Manager
    4. Using the Flashback Database with Enterprise Manager
    5. Summary
    6. Exam Essentials
    7. Review Questions
    8. Answers to Review Questions
  12. Recovering from User Errors
    1. An Overview of Flashback Technologies
    2. Using Flashback Drop
    3. Using EM to Perform Flashback Dropped Tables
    4. Using Flashback Versions Query
    5. Using Flashback Transaction Query
    6. Using Flashback Table
    7. Summary
    8. Exam Essentials
    9. Review Questions
    10. Answers to Review Questions
  13. Handling Block Corruption
    1. An Overview of Block Corruption
    2. Block Corruption Symptoms
    3. Using Various Methods to Detect and Resolve Corruption
    4. Block Media Recovery
    5. Summary
    6. Exam Essentials
    7. Review Questions
    8. Answers to Review Questions
  14. Understanding Automatic Database Management
    1. Using the Automatic Workload Repository (AWR)
    2. Managing Server-Generated Alerts
    3. Using Automatic Routine Administration Tasks
    4. Understanding the Advisory Framework
    5. Summary
    6. Exam Essentials
    7. Review Questions
    8. Answers to Review Questions
  15. Understanding Automatic Storage Management
    1. Introducing the ASM Architecture
    2. Understanding an ASM Instance
    3. Defining ASM Initialization Parameters
    4. Categorizing ASM Dynamic Performance Views
    5. Using ASM Filenames
    6. Understanding ASM File Types and Templates
    7. Administering ASM Disk Groups
    8. Using RMAN to Perform Database Migration to ASM
    9. Summary
    10. Exam Essentials
    11. Review Questions
    12. Answers to Review Questions
  16. Understanding Globalization Support
    1. An Overview of Globalization Support
    2. Using NLS Parameters
    3. Using Datetime Datatypes
    4. Using Linguistic Sorts and Searches
    5. Summary
    6. Exam Essentials
    7. Review Questions
    8. Answers to Review Questions
  17. Managing Resources
    1. An Overview of the Database Resource Manager
    2. Working with the Pending Area
    3. Resource Consumer Groups
    4. Resource Plans
    5. Resource Plan Directives
    6. Putting the Pieces Together
    7. Summary
    8. Exam Essentials
    9. Review Questions
    10. Answers to Review Questions
  18. Using the Scheduler to Automate Tasks
    1. Scheduler Overview
    2. Scheduler Architecture
    3. Common Administration Tools
    4. Using Scheduler Jobs
    5. Using Job Classes
    6. Using Scheduler Programs
    7. Using Schedules
    8. Using Scheduler Windows
    9. Using Scheduler Views
    10. Summary
    11. Exam Essentials
    12. Review Questions
    13. Answers to Review Questions
  19. Monitoring and Managing Storage
    1. Monitoring Tablespace Storage
    2. Using Segment Management Tools
    3. Understanding Special Table Types
    4. Using Miscellaneous Space Management Tools
    5. Leveraging Resumable Space Allocation
    6. Summary
    7. Exam Essentials
    8. Review Questions
    9. Answers to Review Questions
  20. Securing the Oracle Listener, Diagnostic Sources, and Memory
    1. Securing the Oracle Listener
    2. An Overview of the TNS Listener
    3. Diagnostic Sources
    4. Automatic Memory Management
    5. Summary
    6. Exam Essentials
    7. Review Questions
    8. Answers to Review Questions
  21. Glossary
    1. A
    2. B
    3. C
    4. D
    5. E
    6. F
    7. G
    8. H
    9. I
    10. J
    11. L
    12. M
    13. N
    14. O
    15. P
    16. R
    17. S
    18. T
    19. U
    20. V
    21. W