OCP: Oracle Database 11g Administrator Certified Professional Study Guide

Book description

This updated study guide for the latest release of the most popular database software in the world—Oracle Database 11g— reviews using the RMAN recovery catalog, handling Flashback technology, managing memory and resources, automating tasks, diagnosing the database, and much more. Plus, more than 100 pages of workbook exercises help prepare you to take the 1Z0-053 exam.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of contents

  1. Copyright
  2. Dear Reader,
  3. Acknowledgments
  4. About the Authors
  5. Introduction
    1. Why Become Oracle Certified?
    2. Oracle Certifications
      1. Oracle DBA Certification
      2. Oracle Database 11g Administrator Certified Associate
      3. Oracle Database 11g Administrator Certified Professional
      4. Oracle Database 11g Certified Master
      5. Oracle 11g Upgrade Paths
    3. Oracle Exam Requirements
      1. Skills Required for the Oracle Database 11g: Administration II Exam
    4. Tips for Taking the Administration II Exam
    5. Where Do You Take the Certification Exam?
    6. What Does This Book Cover?
    7. How to Use This Book
    8. What's on the CD?
      1. The Wiley Test Engine Preparation Software
      2. Electronic Flashcards for PC and Palm Devices
      3. OCP: Oracle 11g Administrator Certified Professional Study Guide in PDF
    9. Assessment Test
    10. Answers to Assessment Test
  6. 1. Using Oracle ASM
    1. 1.1. What Is ASM?
    2. 1.2. Working with the ASM Instance
      1. 1.2.1. Creating the ASM Instance
        1. 1.2.1.1. Creating the ASM Instance with the DBCA
        2. 1.2.1.2. Creating the ASM Instance Manually
          1. 1.2.1.2.1. Step 1: Creating Directories for the ASM Instance
          2. 1.2.1.2.2. Step 2: Creating the Instance Parameter File
          3. 1.2.1.2.3. Step 3: Performing Any Microsoft Windows–Specific Configuration
          4. 1.2.1.2.4. Step 4: Starting the ASM Instance
          5. 1.2.1.2.5. Step 5: Creating the ASM Spfile
      2. 1.2.2. Managing the ASM Instance
        1. 1.2.2.1. Starting and Stopping the ASM Instance
        2. 1.2.2.2. ASM Processes
        3. 1.2.2.3. ASM Disk Discovery
          1. 1.2.2.3.1. Setting the ASM_DISKSTRING Parameter
          2. 1.2.2.3.2. ASM Disk Discovery on Instance Start
        4. 1.2.2.4. Redundancy, Striping, and Other ASM Topics
          1. 1.2.2.4.1. Redundancy
          2. 1.2.2.4.2. Default ASM Template Redundancy Settings
          3. 1.2.2.4.3. Dealing with ASM Disk Loss
          4. 1.2.2.4.4. Striping
          5. 1.2.2.4.5. Templates
          6. 1.2.2.4.6. ASM Disk Group Attributes
          7. 1.2.2.4.7. ASM Fast Disk Resync
          8. 1.2.2.4.8. ASM Preferred Mirror Read
          9. 1.2.2.4.9. ASM AU Size and Extents
        5. 1.2.2.5. Adding an ASM Disk Group
        6. 1.2.2.6. Dropping an ASM Disk Group
        7. 1.2.2.7. Altering an ASM Disk Group
          1. 1.2.2.7.1. Adding Disks to an ASM Disk Group
          2. 1.2.2.7.2. Removing Disks from an ASM Disk Group
          3. 1.2.2.7.3. Adding and Dropping Disks from an ASM Disk Group
          4. 1.2.2.7.4. Undropping Disks from an ASM Disk Group
          5. 1.2.2.7.5. Resizing Disks in an ASM Disk Group
          6. 1.2.2.7.6. Manually Rebalancing Disks Assigned to an ASM Disk Group
          7. 1.2.2.7.7. Manually Mounting and Unmounting an ASM Disk Group
          8. 1.2.2.7.8. Checking the Consistency of a Disk Group
          9. 1.2.2.7.9. Creating ASM Disk Group Directories
          10. 1.2.2.7.10. Managing ASM Disk Group Directories
        8. 1.2.2.8. Using the ASMCMD Command-Line Utility
          1. 1.2.2.8.1. Starting ASMCMD
          2. 1.2.2.8.2. ASMCMD Commands
    3. 1.3. Overview of ASM Data Dictionary Views
    4. 1.4. Using ASM Storage
      1. 1.4.1. What Are ASM Files?
        1. 1.4.1.1. ASM Files
        2. 1.4.1.2. ASM Filename Types
          1. 1.4.1.2.1. Fully Qualified ASM Filenames
          2. 1.4.1.2.2. ASM Numeric Filenames
          3. 1.4.1.2.3. Alias ASM Filenames
          4. 1.4.1.2.4. Alias ASM Filenames with Templates
          5. 1.4.1.2.5. Incomplete ASM Filenames
          6. 1.4.1.2.6. Incomplete ASM Filenames with Templates
          7. 1.4.1.2.7. Adding ASM Filename Aliases to Existing Files
          8. 1.4.1.2.8. Managing ASM File Alias Names
          9. 1.4.1.2.9. Drop Files from an ASM Disk Group
      2. 1.4.2. Defining ASM as the Default Destination for Database Files
      3. 1.4.3. Creating a Tablespace Using an ASM Disk Group as the Destination
        1. 1.4.3.1. Creating Tablespaces Using Default ASM Assignments
        2. 1.4.3.2. Creating Tablespaces Referencing Specific ASM Disk Groups
        3. 1.4.3.3. Tablespace Maintenance When Using Tablespaces Referencing Specific ASM Disk Groups
      4. 1.4.4. Creating a Database Using ASM Disk Group Locations
        1. 1.4.4.1. Creating a Database Using ASM Disks with DBCA
        2. 1.4.4.2. Creating a Database Manually Using ASM Disks
        3. 1.4.4.3. Creating a Control File in an ASM Disk Group Location
        4. 1.4.4.4. Creating Spfiles or Parameter Files on an ASM Disk Group
        5. 1.4.4.5. Creating Online Redo Logs in an ASM Disk Group Location
        6. 1.4.4.6. Defining an ASM Disk Group Location as an Archived Redo Log Storage Area
        7. 1.4.4.7. Creating Database Objects Using ASM Filename Aliases
    5. 1.5. Using RMAN with ASM
      1. 1.5.1. Copying Database Datafiles to an ASM Disk with RMAN
      2. 1.5.2. Creating RMAN Backups on ASM
        1. 1.5.2.1. Backing Up from RMAN to ASM Directly
        2. 1.5.2.2. Configuring and Backing Up to an ASM Flash Recovery Area
    6. 1.6. Summary
    7. 1.7. Exam Essentials
    8. 1.8. Review Questions
    9. 1.9. Answers to Review Questions
  7. 2. Performing Oracle User-Managed Backups
    1. 2.1. Understanding the Oracle Database as It Relates to Backup and Recovery
      1. 2.1.1. Oracle Processes Related to Backup and Recovery
        1. 2.1.1.1. LGWR Process
        2. 2.1.1.2. DBWR Process
        3. 2.1.1.3. ARCH Process
        4. 2.1.1.4. User Processes
      2. 2.1.2. Oracle Memory Structures Related to Backup and Recovery
      3. 2.1.3. The Oracle Data Dictionary
        1. 2.1.3.1. Overview of the Data Dictionary
        2. 2.1.3.2. Forms of the Data Dictionary
        3. 2.1.3.3. Common Data Dictionary and Dynamic Performance Views You Will Use
      4. 2.1.4. Oracle Datafiles and Tablespaces
        1. 2.1.4.1. Oracle Datafiles
        2. 2.1.4.2. Oracle Tablespaces
      5. 2.1.5. Redo Logs
        1. 2.1.5.1. Online Redo Logs
          1. 2.1.5.1.1. Redo Log File Basics
          2. 2.1.5.1.2. Redo Log File Groups
          3. 2.1.5.1.3. Redo Log File Members
          4. 2.1.5.1.4. Redo Log Sequence Numbers
        2. 2.1.5.2. Archived Redo Logs
      6. 2.1.6. Control Files
      7. 2.1.7. Parameter Files
        1. 2.1.7.1. Parameter Files and Parameters
        2. 2.1.7.2. Parameter Files (pfiles)
        3. 2.1.7.3. Server Parameter Files (spfiles)
          1. 2.1.7.3.1. What Is an spfile?
          2. 2.1.7.3.2. How Do You Set Parameter Values When Using an spfile?
      8. 2.1.8. NOARCHIVELOG and ARCHIVELOG Modes
      9. 2.1.9. The Oracle Instance and the Oracle Database
        1. 2.1.9.1. Oracle Instances and Oracle Databases: A Review
        2. 2.1.9.2. Oracle Database Startup and Shutdown
          1. 2.1.9.2.1. Exploring the Stages of Database Startup and Shutdown
          2. 2.1.9.2.2. Starting and Stopping the Database
          3. 2.1.9.2.3. Performing Database Restricted-Mode Operations
          4. 2.1.9.2.4. Performing Backup and Recovery Operations and Getting Database Status
    2. 2.2. Configuring the Database for Backup and Recovery
      1. 2.2.1. Configuring for ARCHIVELOG Mode
      2. 2.2.2. Putting the Database in ARCHIVELOG Mode
      3. 2.2.3. Using ARCHIVELOG Mode Data Dictionary Views
    3. 2.3. Performing Oracle Offline Backups
    4. 2.4. Performing Oracle Online Backups
      1. 2.4.1. The Mechanics of Online Backups
    5. 2.5. Backing Up the Control File
      1. 2.5.1. Creating a Backup Control File
      2. 2.5.2. Creating a Trace File with the Create Control File Command in It
    6. 2.6. Summary
    7. 2.7. Exam Essentials
    8. 2.8. Review Questions
    9. 2.9. Answers to Review Questions
  8. 3. Performing Oracle User-Managed Database Recoveries
    1. 3.1. Performing a Recovery in NOARCHIVELOG Mode
    2. 3.2. Performing a Full Database Recovery in ARCHIVELOG Mode
      1. 3.2.1. Preparing for the Recovery
        1. 3.2.1.1. Restoring Datafiles After the Loss of All Datafiles
        2. 3.2.1.2. Restoring Datafiles After the Loss of the SYSTEM or UNDO Tablespace Datafile
        3. 3.2.1.3. Restoring Datafiles After the Loss of One or More Non-SYSTEM or -UNDO Tablespace Datafiles
      2. 3.2.2. Recovering the Database
        1. 3.2.2.1. Using the recover database Command
        2. 3.2.2.2. Recovering the Database After the Loss of All Datafiles
        3. 3.2.2.3. Recovering the Database After the Loss of the SYSTEM or UNDO Tablespace Datafile
        4. 3.2.2.4. Recovering the Database After the Loss of One or More Non-SYSTEM or -UNDO Tablespace Datafiles
    3. 3.3. Performing Incomplete Recoveries
      1. 3.3.1. Requirements for and Mechanics of an Incomplete Recovery
      2. 3.3.2. Preparing for an Incomplete Recovery
      3. 3.3.3. Performing an Incomplete Recovery
        1. 3.3.3.1. Determining the Type of Point-in-Time Recovery
        2. 3.3.3.2. Perform Your Point-in-Time Recovery
        3. 3.3.3.3. Opening the Database
    4. 3.4. Performing Other Types of Recoveries
      1. 3.4.1. Recovering from the Loss of a Tempfile
      2. 3.4.2. Recovering from the Loss of an Online Redo Log Group
        1. 3.4.2.1. Dealing with the Loss of an Inactive Online Redo Log Group Member
        2. 3.4.2.2. Dealing with the Loss of an Inactive Online Redo Log Group
          1. 3.4.2.2.1. Dealing with the Loss of an Inactive Online Redo Log Group on Startup
          2. 3.4.2.2.2. Dealing with the Loss of an Inactive Online Redo Log Group When the Database Is Running
        3. 3.4.2.3. Dealing with the Loss of an Active but Not Current Online Redo Log Group
        4. 3.4.2.4. Dealing with the Loss of the Current Online Redo Log Group
      3. 3.4.3. Recovering from the Loss of a Control File
        1. 3.4.3.1. Dealing with the Loss of One or More Control Files but Not All
        2. 3.4.3.2. Recovering from Loss of All Control Files
          1. 3.4.3.2.1. Recovering Lost Control Files with a Backup Control File
          2. 3.4.3.2.2. Recovering Lost Control Files Using the create control file Command
      4. 3.4.4. Recovering from the Loss of the Password File
      5. 3.4.5. Recovering from the Loss of Everything
    5. 3.5. Summary
    6. 3.6. Exam Essentials
    7. 3.7. Review Questions
    8. 3.8. Answers to Review Questions
  9. 4. Configuring and Backing Up Using RMAN
    1. 4.1. Why Use RMAN?
    2. 4.2. Exploring the RMAN Architecture
    3. 4.3. Connecting to RMAN
    4. 4.4. Configuring RMAN for Use
      1. 4.4.1. The Flash Recovery Area
        1. 4.4.1.1. Introducing the FRA
        2. 4.4.1.2. Configuring the FRA
        3. 4.4.1.3. Managing the FRA
      2. 4.4.2. RMAN Persistent Configuration Settings
      3. 4.4.3. Unique RMAN Configuration Settings
      4. 4.4.4. Preparing RMAN for Use
        1. 4.4.4.1. Setting the control_file_record_keep_time Parameter
        2. 4.4.4.2. Retention Policies
          1. 4.4.4.2.1. Types of Retention Policies
          2. 4.4.4.2.2. Configuring Retention Policies
        3. 4.4.4.3. Compression
        4. 4.4.4.4. Encryption
        5. 4.4.4.5. Channel Configuration
          1. 4.4.4.5.1. Configuring Backup Locations
          2. 4.4.4.5.2. Configuring Parallelism
          3. 4.4.4.5.3. Other Channel Configuration Options
        6. 4.4.4.6. Control-File Autobackups
        7. 4.4.4.7. Backup Optimization
        8. 4.4.4.8. Snapshot Control-File Location
        9. 4.4.4.9. Backup Tags
        10. 4.4.4.10. Duplexing Backups
    5. 4.5. Backing Up Your Database with RMAN
      1. 4.5.1. Using the RMAN Command Line
      2. 4.5.2. Types of RMAN Backups
        1. 4.5.2.1. RMAN Backup Sets
        2. 4.5.2.2. RMAN Image Copies
      3. 4.5.3. RMAN Offline Backups
      4. 4.5.4. RMAN Online Backups
      5. 4.5.5. RMAN Incremental Backups
        1. 4.5.5.1. Configuring for Incremental Backups
        2. 4.5.5.2. Types of Incremental Backups
        3. 4.5.5.3. Performing Incremental Backups
      6. 4.5.6. RMAN Incrementally Updated Backups
      7. 4.5.7. RMAN Multisection Backups
      8. 4.5.8. RMAN Backup of Archived Redo Logs
      9. 4.5.9. RMAN Backup of the Spfile and Control Files
      10. 4.5.10. Backing Up RMAN Backup Sets
    6. 4.6. Summary
    7. 4.7. Exam Essentials
    8. 4.8. Review Questions
    9. 4.9. Answers to Review Questions
  10. 5. Using the RMAN Recovery Catalog
    1. 5.1. Introducing the Recovery Catalog
    2. 5.2. Creating the Recovery Catalog User and Schema Objects
    3. 5.3. Using a Recovery Catalog
      1. 5.3.1. Connecting to the Recovery Catalog from RMAN
      2. 5.3.2. Registering the Target Database with the Recovery Catalog
      3. 5.3.3. Unregistering a Database
    4. 5.4. Using Scripts in the RMAN Recovery Catalog
      1. 5.4.1. Executing External Scripts
      2. 5.4.2. Creating Stored Scripts
      3. 5.4.3. Replacing Stored Scripts
      4. 5.4.4. Removing Stored Scripts
      5. 5.4.5. Executing Stored Scripts
      6. 5.4.6. Printing Stored Scripts
      7. 5.4.7. Using Script Substitution Variables
    5. 5.5. Maintaining the Recovery Catalog
      1. 5.5.1. Synchronizing the Recovery Catalog
      2. 5.5.2. Backing Up the Recovery Catalog
    6. 5.6. Using the RMAN Virtual Private Catalog
      1. 5.6.1. Creating the RMAN Virtual Private Catalog
      2. 5.6.2. Administering the RMAN Virtual Private Catalog
    7. 5.7. Summary
    8. 5.8. Exam Essentials
    9. 5.9. Review Questions
    10. 5.10. Answers to Review Questions
  11. 6. Recovering Databases with RMAN
    1. 6.1. RMAN Database-Recovery Basics
    2. 6.2. Recovering a Database in NOARCHIVELOG Mode
    3. 6.3. Recovering a Database in ARCHIVELOG Mode
      1. 6.3.1. Complete Database Recovery in ARCHIVELOG Mode
      2. 6.3.2. Datafile or Tablespace Recovery in ARCHIVELOG Mode
        1. 6.3.2.1. Recovering Critical Database Datafiles and/or Tablespaces with the Database Down
        2. 6.3.2.2. Recovering Noncritical Database Datafile and/or Tablespaces with the Database Open
          1. 6.3.2.2.1. Preparing to Restore Datafiles or Tablespaces Online
          2. 6.3.2.2.2. Restoring Database Datafiles Online
          3. 6.3.2.2.3. Restoring Database Tablespaces Online
    4. 6.4. Recovering a Database Using Incomplete Recovery
      1. 6.4.1. Types of Point-in-Time Recovery
      2. 6.4.2. Point-in-Time Recovery Mechanics
    5. 6.5. Using Image Copies to Recover Your Database
    6. 6.6. Other Basic Recovery Topics
      1. 6.6.1. Block Media Recovery
      2. 6.6.2. Recovering the Control File
        1. 6.6.2.1. Recovering Control Files with Control-File Autobackups
          1. 6.6.2.1.1. Control-File Backups Using the FRA
          2. 6.6.2.1.2. Control-File Backups Not Using the FRA
        2. 6.6.2.2. Recovering Control Files When Not Using Control-File Autobackups
      3. 6.6.3. Recovering the Spfile
        1. 6.6.3.1. Restoring the spfile When Using the FRA
        2. 6.6.3.2. Restoring the Spfile When Not Using the FRA
    7. 6.7. Summary
    8. 6.8. Exam Essentials
    9. 6.9. Review Questions
    10. 6.10. Answers to Review Questions
  12. 7. Reporting, Monitoring, and Tuning with RMAN
    1. 7.1. Overview of the RMAN Report and List Commands
      1. 7.1.1. Using the RMAN report Command
        1. 7.1.1.1. Introducing the RMAN report Command
        2. 7.1.1.2. Seeing the RMAN report Command in Action
          1. 7.1.1.2.1. Example of the report need backup Command
          2. 7.1.1.2.2. Example of the report obsolete Command
          3. 7.1.1.2.3. Example of the report schema Command
          4. 7.1.1.2.4. Example of the report unrecoverable Command
      2. 7.1.2. Using the RMAN list Command
        1. 7.1.2.1. Seeing the list expired backup Command in Action
        2. 7.1.2.2. Seeing the list incarnation Command in Action
        3. 7.1.2.3. Seeing the list restore point Command in Action
        4. 7.1.2.4. Seeing the list all script names Command in Action
        5. 7.1.2.5. Examples of Listing Backup-Related Information
    2. 7.2. Monitoring, Administering, and Tuning RMAN
      1. 7.2.1. Monitoring RMAN Operations
        1. 7.2.1.1. Configuring for Asynchronous I/O
        2. 7.2.1.2. Using the V$SESSION_LONGOPS View to Monitor RMAN
        3. 7.2.1.3. Using the V$SESSION and V$SESSION_WAIT_HISTORY Views to Troubleshoot RMAN Problems
      2. 7.2.2. Administering RMAN Operations
        1. 7.2.2.1. Using the delete Command
        2. 7.2.2.2. Using the crosscheck Command
        3. 7.2.2.3. Using the catalog Command
        4. 7.2.2.4. Using the resync Command
      3. 7.2.3. Tuning RMAN Operations
    3. 7.3. Summary
    4. 7.4. Exam Essentials
    5. 7.5. Review Questions
    6. 7.6. Answers to Review Questions
  13. 8. Performing Oracle Advanced Recovery
    1. 8.1. Switching Between RMAN Incarnations
    2. 8.2. Overview of RMAN Database Duplication
      1. 8.2.1. RMAN Database Duplication Basics
      2. 8.2.2. Performing an RMAN Database Duplication
        1. 8.2.2.1. Preparing to Duplicate Your Database
        2. 8.2.2.2. Duplicating Your Database
          1. 8.2.2.2.1. Connecting to RMAN for a Database Duplication
          2. 8.2.2.2.2. The RMAN duplicate database Command
          3. 8.2.2.2.3. Active Database Duplication
          4. 8.2.2.2.4. Backup-Based Database Duplication
        3. 8.2.2.3. After the Duplication
    3. 8.3. Performing an RMAN Tablespace Point-in-Time Recovery
      1. 8.3.1. TSPITR Overview
      2. 8.3.2. Checking the Transport Set
      3. 8.3.3. Lost Objects
      4. 8.3.4. Rules, Rules, and More Rules
      5. 8.3.5. TSPITR Aftereffects
    4. 8.4. Performing a Database Disaster Recovery
    5. 8.5. Summary
    6. 8.6. Exam Essentials
    7. 8.7. Review Questions
    8. 8.8. Answers to Review Questions
  14. 9. Understanding Flashback Technology
    1. 9.1. Overview of Flashback Technology
    2. 9.2. Using Automatic Undo Management
      1. 9.2.1. Uncovering Undo
        1. 9.2.1.1. Transaction Processing
        2. 9.2.1.2. Failed-Transaction Recovery
        3. 9.2.1.3. Read Consistency
        4. 9.2.1.4. Flashback Functionality
      2. 9.2.2. Working with Automatic Undo Management
      3. 9.2.3. Understanding Undo Retention
        1. 9.2.3.1. Establishing an Undo Retention Period
        2. 9.2.3.2. Guaranteeing Retention
    3. 9.3. Using Flashback Technologies
      1. 9.3.1. Using Flashback Drop and the Recycle Bin
        1. 9.3.1.1. Using the Recycle Bin
        2. 9.3.1.2. Purging the Recycle Bin
        3. 9.3.1.3. Disabling and Enabling the Recycle Bin
        4. 9.3.1.4. Using Flashback Drop
      2. 9.3.2. Using Flashback Query
      3. 9.3.3. Using Flashback Versions Query
      4. 9.3.4. Using Flashback Transaction Query
    4. 9.4. Using Additional Flashback Operations
      1. 9.4.1. Using Flashback Table
      2. 9.4.2. Configuring and Monitoring Flashback Database and Performing Flashback Database Operations
        1. 9.4.2.1. Configuring the Flashback Database
        2. 9.4.2.2. Monitoring Flashback Database
        3. 9.4.2.3. Using Flashback Database
      3. 9.4.3. Setting Up and Using a Flashback Data Archive
        1. 9.4.3.1. Configuring the Flashback Data Archive
        2. 9.4.3.2. Using the Flashback Data Archive
        3. 9.4.3.3. Monitoring the Flashback Data Archive
    5. 9.5. Summary
    6. 9.6. Exam Essentials
    7. 9.7. Review Questions
    8. 9.8. Answers to Review Questions
  15. 10. Diagnosing the Database and Managing Performance
    1. 10.1. Diagnosing the Database
      1. 10.1.1. Setting Up the Automatic Diagnostic Repository
        1. 10.1.1.1. ADR Initialization Parameters
        2. 10.1.1.2. Directory Structure of the Automatic Diagnostic Repository
      2. 10.1.2. Using the Support Workbench
        1. 10.1.2.1. Fundamental Tasks of the Support Workbench
          1. 10.1.2.1.1. Task 1: View Critical Error Alerts
          2. 10.1.2.1.2. Task 2: View Problem Details
          3. 10.1.2.1.3. Task 3: Gather Additional Diagnostic Information
          4. 10.1.2.1.4. Task 4: Create a Service Request
          5. 10.1.2.1.5. Task 5: Package and Upload Diagnostic Data to Oracle Support
          6. 10.1.2.1.6. Task 6: Track the Service Request and Implement Any Repairs
          7. 10.1.2.1.7. Task 7: Close the Incident
      3. 10.1.3. Performing Block Media Recovery
        1. 10.1.3.1. Advantages of Block Media Recovery
        2. 10.1.3.2. Detecting Block-level Corruption
        3. 10.1.3.3. Performing Block Media Recovery
    2. 10.2. Managing Database Performance
      1. 10.2.1. Using the SQL Tuning Advisor
        1. 10.2.1.1. Automatic SQL Tuning Advisor
        2. 10.2.1.2. Manual SQL Tuning Advisor
        3. 10.2.1.3. SQL Tuning Advisor Supplied Package and Views
      2. 10.2.2. Using the SQL Access Advisor to Tune a Workload
      3. 10.2.3. Understanding Database Replay
        1. 10.2.3.1. Capture a Workload
        2. 10.2.3.2. Preprocess a Captured Workload
        3. 10.2.3.3. Replay a Captured Workload
        4. 10.2.3.4. Analyze the Workload Replay Results
    3. 10.3. Summary
    4. 10.4. Exam Essentials
    5. 10.5. Review Questions
    6. 10.6. Answers to Review Questions
  16. 11. Managing Database Resources
    1. 11.1. Managing Memory
      1. 11.1.1. Implementing Automatic Memory Management
        1. 11.1.1.1. Automatic Memory Management Options
          1. 11.1.1.1.1. Automatic Shared Memory Management
        2. 11.1.1.2. Automatic Memory Management and Enterprise Manager
          1. 11.1.1.2.1. Disabling Automatic Memory Management Using Enterprise Manager
          2. 11.1.1.2.2. Disabling Automatic Shared Memory Management Using Enterprise Manager
          3. 11.1.1.2.3. Enabling Automatic Shared Memory Management Using Enterprise Manager
          4. 11.1.1.2.4. Enabling Automatic Memory Management Using Enterprise Manager
      2. 11.1.2. Manually Configuring SGA Parameters
      3. 11.1.3. Configuring Automatic PGA Memory Management
        1. 11.1.3.1. Automatic PGA Memory Management
          1. 11.1.3.1.1. Enabling Automatic PGA Memory Management Using Enterprise Manager
          2. 11.1.3.1.2. Monitoring Automatic PGA Memory Management
          3. 11.1.3.1.3. Tuning Automatic PGA Memory Management
          4. 11.1.3.1.4. Disabling Automatic PGA Memory Management Using Enterprise Manager
    2. 11.2. Managing Space
      1. 11.2.1. Managing Resumable Space Allocation
        1. 11.2.1.1. Understanding Resumable Space Allocation
        2. 11.2.1.2. Resumable Space Operations
        3. 11.2.1.3. Enabling and Disabling Resumable Operations
          1. 11.2.1.3.1. Enabling and Disabling Resumable Operations for an Instance
          2. 11.2.1.3.2. Enabling and Disabling Resumable Operations for a Session
          3. 11.2.1.3.3. Identifying Resumable Sessions
        4. 11.2.1.4. Working with Resumable Operations
          1. 11.2.1.4.1. Views for Monitoring Resumable Space Allocation
          2. 11.2.1.4.2. Monitoring Resumable Space Alerts with Enterprise Manager
          3. 11.2.1.4.3. The DBMS_RESUMABLE Supplied Package
          4. 11.2.1.4.4. Triggered Events to Respond to Suspends
      2. 11.2.2. Managing Transportable Tablespaces
        1. 11.2.2.1. Transportable Tablespace Sets
        2. 11.2.2.2. Manually Transporting a Tablespace
          1. 11.2.2.2.1. Step 1: Check Compatibility and Endian Format
          2. 11.2.2.2.2. Step 2: Choose the Transportable Tablespace Set
          3. 11.2.2.2.3. Step 3: Generate the Transportable Tablespace Set
          4. 11.2.2.2.4. Step 4: Transport the Tablespace Set
          5. 11.2.2.2.5. Step 5: Import the Tablespace Set
        3. 11.2.2.3. Using Enterprise Manager to Transport a Tablespace
      3. 11.2.3. Managing Transportable Databases
        1. 11.2.3.1. Checking Prerequisites
        2. 11.2.3.2. Identifying all External Files and Directories
        3. 11.2.3.3. Starting the Source Database in Read-Only Mode
        4. 11.2.3.4. Verifying that the Database Is Ready for Migration
        5. 11.2.3.5. Running RMAN CONVERT DATABASE
          1. 11.2.3.5.1. Database Conversion on the Source System
          2. 11.2.3.5.2. Database Conversion on the Destination System
        6. 11.2.3.6. Moving Files to the Destination System
        7. 11.2.3.7. Completing the Migration
      4. 11.2.4. Using Shrinking Segments
        1. 11.2.4.1. Performing an Online Segment Shrink Operation
        2. 11.2.4.2. Using Enterprise Manager Segment Space Advisor to Perform an Online Segment Shrink Operation
    3. 11.3. Managing Resources
      1. 11.3.1. Working with the Pending Area
        1. 11.3.1.1. Creating a Pending Area
        2. 11.3.1.2. Validating Changes to the Pending Area
        3. 11.3.1.3. Submitting the Pending Area
        4. 11.3.1.4. Clearing the Pending Area
      2. 11.3.2. Resource Consumer Groups
        1. 11.3.2.1. Managing Resource Consumer Groups
          1. 11.3.2.1.1. Creating Resource Consumer Groups
          2. 11.3.2.1.2. Updating Resource Consumer Groups
          3. 11.3.2.1.3. Deleting a Resource Consumer Group
          4. 11.3.2.1.4. Assigning User Sessions to Consumer Groups
          5. 11.3.2.1.5. Changing Resource Consumer Groups
      3. 11.3.3. Resource Plans
        1. 11.3.3.1. Creating Simple Resource Plans
        2. 11.3.3.2. Creating Complex Resource Plans
        3. 11.3.3.3. Creating Resource Subplans
        4. 11.3.3.4. Modifying Resource Plans
        5. 11.3.3.5. Deleting Resource Plans
      4. 11.3.4. Resource-Plan Directives
        1. 11.3.4.1. Creating Resource-Plan Directives
          1. 11.3.4.1.1. Creating Subplan Directives
          2. 11.3.4.1.2. Creating Multilevel Plan Directives
          3. 11.3.4.1.3. Creating Automatic Consumer Group Switching Directives
          4. 11.3.4.1.4. Updating Resource Plan-Directives
          5. 11.3.4.1.5. Deleting Resource-Plan Directives
        2. 11.3.4.2. Creating and Using Database Resource Manager Components
          1. 11.3.4.2.1. Creating the Pending Area
          2. 11.3.4.2.2. Creating the Resource Consumer Groups
          3. 11.3.4.2.3. Creating the Resource Plans
          4. 11.3.4.2.4. Creating the Resource-Plan Directives
          5. 11.3.4.2.5. Validating the Pending Area
          6. 11.3.4.2.6. Submitting the Pending Area
          7. 11.3.4.2.7. Enabling the Resource Plans
          8. 11.3.4.2.8. Switching the Enabled Resource Plan
      5. 11.3.5. I/O Calibration with DRM
      6. 11.3.6. Resource Manager Statistics in AWR
    4. 11.4. Summary
    5. 11.5. Exam Essentials
    6. 11.6. Review Questions
    7. 11.7. Answers to Review Questions
  17. 12. Using the Scheduler to Automate Tasks
    1. 12.1. Automating Tasks with the Scheduler
    2. 12.2. Exploring the Scheduler Architecture
      1. 12.2.1. The Job Table
      2. 12.2.2. The Job Coordinator
      3. 12.2.3. The Job-Slave Processes
      4. 12.2.4. RAC Considerations
      5. 12.2.5. Data Guard Considerations
    3. 12.3. Exploring Common Administration Tools
      1. 12.3.1. Using the ENABLE Procedure
      2. 12.3.2. Using the DISABLE Procedure
      3. 12.3.3. Setting Attributes
    4. 12.4. Using Scheduler Jobs
      1. 12.4.1. Creating Jobs
        1. 12.4.1.1. Job Attributes
        2. 12.4.1.2. Identifying the CREATE_JOB Procedure Options
        3. 12.4.1.3. Using the CREATE_JOB Procedure
      2. 12.4.2. Copying Jobs
      3. 12.4.3. Running Jobs
      4. 12.4.4. Stopping Jobs
      5. 12.4.5. Dropping Jobs
    5. 12.5. Using Scheduler Programs
      1. 12.5.1. Program Attributes
      2. 12.5.2. Creating Programs
      3. 12.5.3. Dropping Programs
    6. 12.6. Using Schedules
      1. 12.6.1. Schedule Attributes
      2. 12.6.2. Creating Schedules
      3. 12.6.3. Setting Repeat Intervals
      4. 12.6.4. Testing Repeat Intervals
    7. 12.7. Creating Lightweight Jobs
    8. 12.8. Using Job Chains
      1. 12.8.1. Creating a Chain
      2. 12.8.2. Defining Chain Steps
        1. 12.8.2.1. Defining a Chain That Waits for an Event
      3. 12.8.3. Adding Rules to a Chain
        1. 12.8.3.1. Step Attributes
        2. 12.8.3.2. Conditions
        3. 12.8.3.3. Defining Rules
        4. 12.8.3.4. Starting and Ending the Chain
      4. 12.8.4. Enabling a Chain
      5. 12.8.5. Creating Jobs for Chains
    9. 12.9. Using Scheduler Windows
      1. 12.9.1. Creating Windows
      2. 12.9.2. Opening and Closing Windows
      3. 12.9.3. Window Logging
      4. 12.9.4. Purging Logs
    10. 12.10. Creating and Using Job Classes
      1. 12.10.1. Job Class Parameters
      2. 12.10.2. Creating Job Classes
      3. 12.10.3. Dropping Job Classes
    11. 12.11. Using Advanced Scheduler Concepts to Prioritize Jobs
      1. 12.11.1. Prioritizing Jobs within a Job Class
    12. 12.12. Using Scheduler Views
    13. 12.13. Summary
    14. 12.14. Exam Essentials
    15. 12.15. Review Questions
    16. 12.16. Answers to Review Questions
  18. 13. Implementing Globalization Support
    1. 13.1. An Overview of Globalization Support
      1. 13.1.1. Globalization Support Features
      2. 13.1.2. Globalization Support Architecture
      3. 13.1.3. Supporting Multilingual Applications
        1. 13.1.3.1. Database Character Sets
          1. 13.1.3.1.1. Setting the Database Character Set
          2. 13.1.3.1.2. Changing the Database Character Set
        2. 13.1.3.2. Automatic Data Conversion
        3. 13.1.3.3. Resolving Client/Server Settings
      4. 13.1.4. Using Unicode in a Multilingual Database
    2. 13.2. Using NLS Parameters
      1. 13.2.1. Setting NLS Parameters
        1. 13.2.1.1. Using the NLS_LANG Parameter
        2. 13.2.1.2. Using Language and Territory Parameters
        3. 13.2.1.3. Using Date and Time Parameters
          1. 13.2.1.3.1. NLS_DATE_FORMAT
          2. 13.2.1.3.2. NLS_DATE_LANGUAGE
          3. 13.2.1.3.3. NLS_TIMESTAMP_FORMAT
          4. 13.2.1.3.4. NLS_TIMESTAMP_TZ_FORMAT
        4. 13.2.1.4. Using Calendar Parameters
        5. 13.2.1.5. Using Numeric, List, and Monetary Parameters
          1. 13.2.1.5.1. NLS_NUMERIC_CHARACTERS
          2. 13.2.1.5.2. NLS_LIST_SEPARATOR
          3. 13.2.1.5.3. NLS_CURRENCY
          4. 13.2.1.5.4. NLS_ISO_CURRENCY
        6. 13.2.1.6. Using the NLS_LENGTH_SEMANTICS Parameter
      2. 13.2.2. Prioritizing NLS Parameters
        1. 13.2.2.1. Setting Server-Initialization Parameters
        2. 13.2.2.2. Setting Client Environment Variables
        3. 13.2.2.3. Using the ALTER SESSION Statement
        4. 13.2.2.4. Setting NLS Parameters in SQL Functions
        5. 13.2.2.5. Prioritization Summary
      3. 13.2.3. Using NLS Views
        1. 13.2.3.1. NLS_SESSION_PARAMETERS
        2. 13.2.3.2. NLS_INSTANCE_PARAMETERS
        3. 13.2.3.3. NLS_DATABASE_PARAMETERS
        4. 13.2.3.4. V$NLS_VALID_VALUES
    3. 13.3. Using Datetime Datatypes
      1. 13.3.1. Using the DATE Datatype
      2. 13.3.2. Using the TIMESTAMP Datatype
      3. 13.3.3. Using the TIMESTAMP WITH TIME ZONE Datatype
      4. 13.3.4. Using the TIMESTAMP WITH LOCAL TIME ZONE Datatype
    4. 13.4. Using Linguistic Sorts and Searches
      1. 13.4.1. An Overview of Text Sorting
        1. 13.4.1.1. Binary Sorts
        2. 13.4.1.2. Linguistic Sorts
      2. 13.4.2. Using Linguistic Sort Parameters
        1. 13.4.2.1. NLS_SORT
        2. 13.4.2.2. NLS_COMP
      3. 13.4.3. Linguistic Sort Types
        1. 13.4.3.1. Monolingual Linguistic Sorts
        2. 13.4.3.2. Multilingual Linguistic Sorts
        3. 13.4.3.3. Case-Insensitive and Accent-Insensitive Linguistic Sorts
        4. 13.4.3.4. Case-Insensitive and Accent-Insensitive Binary Sorts
      4. 13.4.4. Searching Linguistic Strings
    5. 13.5. Summary
    6. 13.6. Exam Essentials
    7. 13.7. Review Questions
    8. 13.8. Answers to Review Questions
  19. A. Lab Exercises
    1. A.1. Lab 1.1: Creating an ASM Instance
    2. A.2. Lab 1.2: Creating ASM Disk Groups
    3. A.3. Lab 1.3: Using ASM Disk Groups from a Database
    4. A.4. Lab 2.1: Executing a Manual Offline (Cold) Backup
    5. A.5. Lab 2.2: Putting the Database in ARCHIVELOG Mode
    6. A.6. Lab 2.3: Executing a Manual Online (Hot) Backup
    7. A.7. Lab 3.1: Executing a Time-Based Point-in-Time Recovery
    8. A.8. Lab 3.2: Recovering from Control-File Loss with a Backup Control File
    9. A.9. Lab 3.3: Recovering from Loss of the Current Online Redo Log
    10. A.10. Lab 4.1: Creating an RMAN Offline Backup
    11. A.11. Lab 4.2: Creating an RMAN Incremental Backup
    12. A.12. Lab 4.3: Creating an Image-Copy Backup
    13. A.13. Lab 5.1: Implementing RVPC
    14. A.14. Lab 6.1: Restoring a Datafile Online
    15. A.15. Lab 6.2: Performing a Change-Based Recovery with RMAN
    16. A.16. Lab 6.3: Restoring a Control File from an Autobackup
    17. A.17. Lab 7.1: Monitoring RMAN Backups
    18. A.18. Lab 7.2: One of My Backups Is Missing!
    19. A.19. Lab 8.1: Duplicating a Database Using Active Database Duplication
    20. A.20. Lab 8.2: Duplicating a Database Using Backup-Based Duplication to a Different Point in Time
    21. A.21. Lab 9.1: Using the Recycle Bin
    22. A.22. Lab 9.2: Performing a More Complex Flashback Query Analysis
    23. A.23. Lab 9.3: Using Flashback Data Archive
    24. A.24. Lab 10.1: Using Support Workbench to Report a Problem to Oracle Support
    25. A.25. Lab 10.2: Performing Block Media Recovery
    26. A.26. Lab 11.1: Exporting a Transportable Tablespace
    27. A.27. Lab 11.2: Testing Resumable Space Allocation
    28. A.28. Lab 11.3: Manually Configuring the SGA
    29. A.29. Lab 12.1: Creating a Local External Job
    30. A.30. Lab 12.2: Creating a Job Window
    31. A.31. Lab 13.1: Using the Locale Builder to Create a New Linguistic Sort
    32. A.32. Lab 13.2: Setting NLS Parameters
    33. A.33. Lab 13.3: Performing Linguistic Sorts
  20. B. About the Companion CD
    1. B.1. What You'll Find on the CD
      1. B.1.1. Sybex Test Engine
      2. B.1.2. PDF of the Book
      3. B.1.3. Adobe Reader
      4. B.1.4. Electronic Flashcards
    2. B.2. System Requirements
    3. B.3. Using the CD
    4. B.4. Troubleshooting
      1. B.4.1. Customer Care
  21. Glossary

Product information

  • Title: OCP: Oracle Database 11g Administrator Certified Professional Study Guide
  • Author(s): Robert G. Freeman, Charles A. Pack, Doug Stuns
  • Release date: March 2009
  • Publisher(s): Sybex
  • ISBN: 9780470395134