Oracle Database 11g: Administration Workshop II Release 2 (Self-Study Course)

 

Who should attend

  • Database administrators
  • Technical consultants

Prerequisites

  • Oracle Database 11g Database Administration
  • Oracle Database 11g: Administration Workshop I Release 2

Course Objectives

  • Recognize the Oracle Database architecture with ASM, and the configuration and management DBA Tools
  • Recognize the causes of file loss and how to recover files
  • Identify how to configure backup and recovery functionality in Oracle Database 11g Release 2
  • Recognize the benefits and uses of an RMAN recovery catalog and identify the steps for creating and configuring one
  • Identify how to prepare a database for backup and then for perform and monitor various types of RMAN backups
  • Recognize the steps for manually backing up, recovering and restoring a database
  • Identify the options available when performing RMAN recoveries
  • Identify ways to monitor and tune RMAN to reduce bottlenecks and balance backup and recovery operations
  • Identify how to diagnose and repair database problems
  • Identify how to use Flashback technologies to recover a database
  • Recognize the memory components used in Oracle Database 11g, and configure AMM and ASMM
  • Identify how to improve a database's performance by monitoring statistics, implementing recommendations from advisors, tuning SQL statements, and replaying workloads
  • Identify how to use the Database Resource Manager to monitor and manage system resources to consumer groups
  • Identify how to schedule and monitor event-based and time-based jobs and job chains in order to make the best use of resources
  • Manage storage in a database by allocating and reclaiming space and by quickly moving large amounts of data to other databases
  • Identify how to create a cloned copy of a database using RMAN and Enterprise Manager

Product Description

  • Oracle Database 11g Release 2: Database Architecture and Recovery Operations
    • Oracle Database Architecture
    • Backup and Recovery Operations
  • Oracle Database 11g Release 2: The RMAN Catalog and Creating Backups
    • The RMAN Recovery Catalog
    • Creating Backups with RMAN
  • Oracle Database 11g Release 2: Performing Restore and Recovery Tasks
    • Restore and Recovery Tasks
    • Performing User-Managed Backup and Recovery
  • Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN
    • Using RMAN to Perform Recovery
    • Monitoring and Tuning RMAN
  • Oracle Database 11g Release 2: Database Diagnostics and Flashback Technologies
    • Diagnosing the Oracle Database
    • Flashback Technologies
  • Oracle Database 11g Release 2: Managing Database Memory and Performance
    • Managing Memory
    • Managing Database Performance
  • Oracle Database 11g Release 2: Managing Database Resources and the Scheduler
    • Managing Resources
    • Task Automation and Administration
  • Oracle Database 11g Release 2: Managing Database Space and Duplication
    • Oracle Database 11g Release 2: Managing Database Space and Duplication
    • Duplicate Databases

Price on request