You are previewing OCP Oracle Database 11g: Administration II Exam Guide (Exam 1Z0-053).
O'Reilly logo
OCP Oracle Database 11g: Administration II Exam Guide (Exam 1Z0-053)

Book Description

A Fully Integrated Study System for OCP Exam 1Z0-053

Prepare for the Oracle Certified Professional Oracle Database 11g: Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-053, including:

• Database structure and Oracle Automatic Storage Management

• Configuring database recoverability

• Oracle Recovery Manager (RMAN)

• Oracle Flashback

• Memory management techniques

• Database tuning advisors

• Disk space and resource management

• Configuring database diagnostics

• Administering the Oracle Scheduler

• Database globalization

On the CD-ROM:

• One full practice exam that simulates the actual OCP exam

• Detailed answers and explanations

• Score report performance assessment tool

• Complete electronic book

• Bonus exam available free with online registration

Table of Contents

  1. Cover Page
  2. OCP Oracle Database 11g: Administration II Exam Guide (Exam 1Z0-053)
  3. Copyright Page
  4. Contents
  5. Acknowledgments
  6. Introduction
  7. 1 Database Architecture and ASM
    1. Understanding Database Architecture and ASM
      1. Oracle Logical Storage Structures
      2. Oracle Physical Storage Structures
      3. Oracle Memory Structures
    2. Describe ASM
      1. ASM Architecture
      2. Exercise 1-1 Find New ASM-related Processes in ASM and RDBMS Instances
      3. Creating an ASM Instance
    3. Set Up Initialization Parameter Files for ASM and Database Instances
      1. ASM Instance Components
      2. ASM Dynamic Performance Views
      3. Exercise 1-2 Query Disk Groups and Available Raw Devices
      4. ASM Filename Formats
      5. ASM File Types and Templates
    4. Start Up and Shut Down ASM Instances
      1. Exercise 1-3 Stop ASM Instance with Active Connections
    5. Administer ASM Disk Groups
      1. Disk Group Architecture
      2. Disk Group Mirroring and Failure Groups
      3. Disk Group Dynamic Rebalancing
      4. Disk Group Fast Mirror Resync
      5. Altering Disk Groups
      6. Enterprise Manager Database Control and ASM Disk Groups
      7. Using the asmcmd Command
      8. Exercise 1-4 Use the asmcmd Utility to Create a Backup of the SPFILE
      9. Two-Minute Drill
      10. Self Test
      11. Lab Question
      12. Self Test Answers
      13. Lab Answer
  8. 2 Configuring Database Recoverability
    1. Configuring for Database Recoverability
      1. Logical Backups
      2. Physical Backups
      3. RMAN Command Overview
    2. Configure Multiple Archive Log File Destinations to Increase Availability
      1. Configuring ARCHIVELOG Mode
      2. Leveraging Multiple Archive Destinations
      3. Exercise 2-1 Identify the Archive Log File Destinations
    3. Define, Apply, and Use a Retention Policy
      1. Exercise 2-2 Query and Change the Retention Policy
    4. Configure the Flash Recovery Area
    5. Use the Flash Recovery Area
      1. Exercise 2-3 Query the Location, Contents, and Size of the Flash Recovery Area
      2. Two-Minute Drill
      3. Self Test
      4. Lab Question
      5. Self Test Answers
      6. Lab Answer
  9. 3 Creating and Maintaining an RMAN Catalog
    1. Identify Situations that Require RMAN Recovery Catalog
      1. Using the Control File for RMAN Metadata
      2. Using a Recovery Catalog for RMAN Metadata
    2. Create and Configure a Recovery Catalog
      1. Configure the Recovery Catalog Database
      2. Create the Recovery Catalog Owner
      3. Create the Recovery Catalog
    3. Synchronize the Recovery Catalog
      1. Registering a Database
      2. Changing the DBID of a Database
      3. Unregistering a Database
      4. Cataloging Additional Backup Files
      5. Exercise 3-1 Cataloging Additional Backup Files
      6. Manually Resynchronize the Recovery Catalog
    4. Create and Use RMAN Stored Scripts
      1. Creating RMAN Stored Scripts
      2. Executing RMAN Stored Scripts
      3. Exercise 3-2 Creating a Parameterized Stored Script
      4. Retrieving RMAN Stored Script Metadata
      5. Managing RMAN Stored Scripts
    5. Back Up the Recovery Catalog
      1. Backing Up the Recovery Catalog
      2. Recovering from a Lost Recovery Catalog
      3. Exporting and Importing the Recovery Catalog
      4. Dropping a Recovery Catalog
      5. Upgrading the Recovery Catalog
    6. Create and Use a Virtual Private Catalog
      1. Understanding Virtual Private Catalogs
      2. Creating and Managing a Virtual Private Catalog
    7. Configure Backup Settings
      1. Types of RMAN Backups
      2. RMAN Backup Destinations
      3. Persisting RMAN Settings
      4. Control File Autobackups
    8. Allocate Channels to Use in Backing Up
    9. Configure Backup Optimization
      1. Two-Minute Drill
      2. Self Test
      3. Self Test Answers
  10. 4 Creating RMAN Backups
    1. Using RMAN to Create Backups
    2. Create Image File Backups
      1. Creating Backupsets
      2. Exercise 4-1 Create a Compressed Backupset
      3. Creating Image Copies
    3. Create a Whole Database Backup
      1. Whole Database Backups
      2. Full Backups
      3. Exercise 4-2 Perform a Full Backup of Two Tablespaces
      4. Incremental Backups
    4. Enable Fast Incremental Backup
      1. Understanding Block Change Tracking
      2. Enabling Fast Incremental Backup
      3. Exercise 4-3 Relocate the Block Change Tracking File
      4. Monitoring Block Change Tracking
    5. Create Duplex Backup and Back Up Backupsets
      1. Creating Duplexed Backupsets
      2. Exercise 4-4 Configuring Multiple Disk Locations for a Duplexed Disk Backup
      3. Creating Backups of Backupsets
      4. Backing Up Read-Only Tablespaces
    6. Create an Archival Backup for Long-term Retention
      1. Understanding Archival Backups
      2. Performing an Archival Backup
      3. Managing Archival Backups
    7. Create a Multisection, Compressed, and Encrypted Backup
      1. Creating a Multisection Backup
      2. Compressing Backups
      3. Encrypting Backups
    8. Report On and Maintain Backups
      1. Using the LIST Command
      2. Using the REPORT Command
      3. Using the DELETE Command
      4. Using the CROSSCHECK Command
      5. Two-Minute Drill
      6. Self Test
      7. Self Test Answers
  11. 5 Recovering Using RMAN Backups
    1. Perform Complete Recovery from a Critical or Noncritical Data File Loss Using RMAN
      1. Using the RMAN RESTORE and RECOVER Commands
      2. Performing Complete Recovery of a Noncritical Datafile
      3. Exercise 5-1 Restore and Recover the USERS Tablespace
      4. Performing Complete Recovery of a Critical Datafile
    2. Perform Incomplete Recovery Using RMAN
      1. Creating Restore Points
      2. Performing Server-Managed Incomplete Recovery
      3. Exercise 5-2 Perform Incomplete Recovery to Restore the USERS Tablespace
    3. Recover Using Incrementally Updated Backups
      1. Recovering Image Copies
      2. Implementing an Image Copy Strategy
    4. Switch to Image Copies for Fast Recovery
      1. Performing a Fast Switch to Image Copies
      2. Exercise 5-3 Use the SWITCH Command to Recover a Datafile Quickly
      3. Exercise 5-4 Use the SWITCH Command after Creating the USERS Tablespace's Datafile in the Original Location
      4. Using the RMAN SET NEWNAME with Fast Switch
    5. Restore a Database onto a New Host
      1. Understanding Restoration to a New Host
      2. Preparing the New Host
      3. Restoring and Recovering on the New Host
    6. Recover Using a Backup Control File
      1. Restoring the SPFILE from the Autobackup
      2. Restoring the Control File from the Autobackup
      3. Exercise 5-5 Restore the Control File from an Autobackup
    7. Perform Disaster Recovery
      1. Performing Recovery in NOARCHIVELOG Mode
      2. Using Incremental Backups in NOARCHIVELOG Mode
      3. Performing Recovery of the Entire Database
      4. Two-Minute Drill
      5. Self Test
      6. Self Test Answers
  12. 6 User-Managed Backup and Recovery
    1. Recover from a Lost Tempfile
      1. Losing a Tempfile
      2. Exercise 6-1 Create a Replacement Tempfile for the TEMP tablespace
      3. Starting a Database Without a Tempfile
    2. Recover from a Lost Redo Log Group
      1. Understanding Log Group Status
      2. Recovering from Log Group Member Failures
      3. Recovering from Loss of an Entire Log Group
    3. Recover from the Loss of the Password File
      1. Review of Authentication Methods
      2. Re-creating a Password File
      3. Exercise 6-2 Re-create the Password File after Accidental Deletion
    4. Perform User-Managed Complete Database Recovery
      1. Performing Complete Closed Database Recovery
      2. Exercise 6-3 Perform a Complete Database Recovery
      3. Performing Complete Open Database Recovery
    5. Perform User-Managed Incomplete Database Recovery
      1. Choosing the PITR Method
      2. Performing User-Managed, Time-Based Incomplete Recovery
      3. Exercise 6-4 Perform Incomplete Time-based Recovery
    6. Perform User-Managed and Server-Managed Backups
      1. Identifying Files for Manual Backup
      2. Backing Up a Database in NOARCHIVELOG Mode
      3. Backing Up a Database in ARCHIVELOG Mode
    7. Identify the Need for Backup Mode
    8. Back up and Recover a Control File
      1. Backing Up the Control File in ARCHIVELOG mode
      2. Recovering the Control File
      3. Exercise 6-5 Recover from the Loss of All Control Files
      4. Two-Minute Drill
      5. Self Test
      6. Self Test Answers
  13. 7 Miscellaneous RMAN Features
    1. Creating a Duplicate Database Using RMAN
      1. Using RMAN to Create a Duplicate Database
      2. Using Enterprise Manager to Create a Duplicate Database
      3. Exercise 7-1 Clone a Running Database
    2. Using a Duplicate Database
      1. Exercise 7-2 Recover a Dropped Table Using a Cloned Database
    3. Identify the Situations that Require TSPITR
    4. Perform Automated TSPITR
      1. Verifying Tablespace Dependencies
      2. Identifying Objects Lost after TSPITR
      3. Performing Automated TSPITR
      4. Two-Minute Drill
      5. Self Test
      6. Self Test Answers
  14. 8 Monitoring and Tuning RMAN
    1. Monitoring RMAN Sessions and Jobs
      1. Using V$SESSION and V$PROCESS
    2. Exercise 8-1 Monitor RMAN Channels
      1. Exercise 8-2 Monitor Multiple RMAN Jobs
      2. Using V$SESSION_LONGOPS
      3. Leveraging RMAN Error Logs and Messages
      4. Exercise 8-3 Debug Part of an RMAN Session
    3. Tuning RMAN
      1. Identifying Backup and Restore Steps
      2. Parallelizing Backup Sets
      3. Understanding RMAN Multiplexing
      4. Tuning RMAN Channels
      5. Tuning the BACKUP Command
      6. Configuring LARGE_POOL_SIZE
    4. Configure RMAN for Asynchronous I/O
      1. Understanding Asynchronous and Synchronous I/O
      2. Monitoring Asynchronous I/O
      3. Monitoring Synchronous I/O
      4. Two-Minute Drill
      5. Self Test
      6. Self Test Answers
  15. 9 Configuring and Using Flashback
    1. Restore Dropped Tables from the Recycle Bin
      1. Understanding the Recycle Bin
      2. Querying the Recycle Bin
      3. Exercise 9-1 Move Objects to the Recycle Bin
      4. Restoring Tables from the Recycle Bin
      5. Exercise 9-2 Restore a Table from the Recycle Bin, Keeping the Original Dependent Object Names
      6. Recycle Bin Space Reclamation
      7. Bypassing the Recycle Bin
      8. Accessing Tables in the Recycle Bin
    2. Perform Flashback Query
      1. Configuring Flashback Parameters
      2. Using Flashback Query
      3. Using Flashback Version Query
    3. Use Flashback Transaction
      1. Understanding Flashback Transaction Query
      2. Flashback Transaction Query Prerequisites
      3. Using Flashback Transaction Query
      4. Using EM with Flashback Transaction Query
      5. Choosing Transaction Back-out Options
    4. Perform Flashback Table Operations
      1. Understanding Flashback Table
      2. Configuring Flashback Table
      3. Using Flashback Table
      4. Exercise 9-3 Use Flashback Table on a Table
    5. Set Up and Use a Flashback Data Archive
      1. Understanding Flashback Data Archive
      2. Creating an Archive
      3. Using Flashback Data Archive Data Dictionary Views
      4. Assigning Flashback Data Archive Permissions
      5. Managing Flashback Data Archives
      6. Assigning a Table to a Flashback Data Archive
      7. Querying Flashback Data Archives
    6. Configure, Monitor Flashback Database and Perform Flashback Database Operations
      1. Understanding Flashback Database
      2. Configuring Flashback Database
      3. Using Flashback Database
      4. Monitoring Flashback Database
      5. Two-Minute Drill
      6. Self Test
      7. Self Test Answers
  16. 10 Memory Management Techniques
    1. Implement Automatic Memory Management
      1. Understanding Oracle Memory Structures
      2. Configuring Automatic Memory Management
      3. Exercise 10-1 Enable Automatic Memory Management
      4. Monitoring Automatic Memory Management
    2. Manually Configure SGA Parameters
      1. Understanding Automatic Shared Memory Management
      2. Switching to ASMM
      3. Exercise 10-2 Enable Automatic Shared Memory Management
      4. Tuning SGA Components
    3. Configure Automatic PGA Memory Management
      1. Understanding PGA Components
      2. Configuring PGA Memory Management
      3. Managing PGA Memory
      4. Two-Minute Drill
      5. Self Test
      6. Self Test Answers
  17. 11 Using Database Tuning Advisors
    1. Use the SQL Tuning Advisor
      1. Overview of SQL Tuning Advisor
      2. Using SQL Tuning Advisor
      3. Exercise 11-1 Run SQL Tuning Advisor for a SQL Statement
    2. Use the SQL Access Advisor to Tune a Workload
      1. Understanding the SQL Access Advisor
      2. Using the SQL Access Advisor with EM
      3. Using the SQL Access Advisor with DBMS_ADVISOR
    3. Understand Database Replay
      1. Database Replay Workload Capture
      2. Database Replay Workload Preprocessing
      3. Database Replay Workload Replay
      4. Database Replay Analysis and Reporting
      5. Two-Minute Drill
      6. Self Test
      7. Self Test Answers
  18. 12 Disk Space and Resource Management
    1. Manage Resumable Space Allocation
      1. Understanding Resumable Space Allocation
      2. Configuring Resumable Space Allocation
      3. Using Resumable Space Allocation
      4. Exercise 12-1 Configure Resumable Space Allocation for the HR User
    2. Describe the Concepts of Transportable Tablespaces and Databases
      1. Configuring Transportable Tablespaces
      2. Transporting Tablespaces
      3. Exercise 12-2 Transport a Tablespace Using SQL and PL/SQL
    3. Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
      1. Understanding Segment Shrink
      2. Automating Segment Advisor
      3. Shrinking Segments
      4. Exercise 12-3 Perform Segment Analysis and Shrink Operations
    4. Understand the Database Resource Manager
      1. Understanding Resource Manager Terminology
      2. Understanding Resource Manager Allocation Methods
    5. Create and Use Database Resource Manager Components
      1. Understanding DEFAULT_PLAN
      2. Creating a New Resource Plan
      3. Creating and Assigning Consumer Groups
      4. Understanding Resource Allocation Methods
      5. Activating Resource Plans
      6. Exercise 12-4 Create and Use a New Resource Manager Plan
      7. Understanding Resource Manager Views
      8. Monitoring Resource Manager
      9. Two-Minute Drill
      10. Self Test
      11. Self Test Answers
  19. 13 Configuring Database Diagnostics
    1. Set Up Automatic Diagnostic Repository
      1. Understanding the ADR
      2. Using the ADRCI Tool
    2. Using Support Workbench
      1. Understanding Alerts, Problems, and Incidents
      2. Managing Service Requests
      3. Using the Health Monitor
    3. Perform Block Media Recovery
      1. Understanding Block Corruption
      2. Using the DB_BLOCK_CHECKING Parameter
      3. Using Block Media Recovery
      4. Using the Data Recovery Advisor
      5. Exercise 13-1 Use Data Recovery Advisor
      6. Two-Minute Drill
      7. Self Test
      8. Self Test Answers
  20. 14 Using the Scheduler for Task Automation
    1. Create a Job, Program, and Schedule
      1. Understanding the Scheduler Architecture
      2. Jobs
      3. Programs
      4. Schedules
      5. Job Classes
      6. Windows
      7. Privileges
    2. Use a Time-based or Event-based Schedule for Executing Scheduler Jobs
      1. Creating and Scheduling Time-based Jobs
      2. Exercise 14-1 Creating a Job with the Scheduler API
      3. Creating and Scheduling Event-based Jobs
      4. Using Programs and Schedules
    3. Create Lightweight Jobs
      1. Understanding Lightweight Jobs
      2. Using Lightweight Jobs
      3. Exercise 14-2 Create and Run a Lightweight Job
    4. Use Job Chains to Perform a Series of Related Tasks
      1. Understanding Job Chains
      2. Creating Chain Objects
      3. Defining Chain Steps
      4. Defining Chain Rules
      5. Starting the Chain
      6. Monitoring Job Chains
    5. Create Windows and Job Classes
      1. Creating Windows
      2. Creating Job Classes
      3. Preconfigured Jobs
    6. Use Advanced Scheduler Concepts to Prioritize Jobs
      1. Using Classes, Windows, and the Resource Manager
      2. Two-Minute Drill
      3. Self Test
      4. Self Test Answers
  21. 15 Database Globalization
    1. Customize Language-Dependent Behavior for the Database and Individual Sessions
      1. Globalization Capabilities
      2. Using Globalization Support Features
      3. Exercise 15-1 Make Globalization and Client Environment Settings
      4. Exercise 15-2 Control Globalization Within the Session
    2. Work with Database and NLS Character Sets
      1. Linguistic Sorting and Selection
      2. The Locale Builder
      3. Using Time Zones
      4. Exercise 15-3 Make Time Zone Adjustments
      5. Two-Minute Drill
      6. Self Test
      7. Self Test Answers
  22. A About the Download
    1. Steps to Download MasterExam
      1. System Requirements
      2. MasterExam
    2. Help
    3. Removing Installation
    4. Technical Support
      1. LearnKey Technical Support
  23. Glossary
  24. Index