Oracle Database 11g - Administration II

Course Overview

This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise.

Who Should Attend

The primary target audiences for this course are: Database administrators Web server administrators System administrators Implementation specialists Data center support engineers Senior application designers and developers

Course Objectives

This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise.

  • Automatic database management, monitoring and tuning facilities. Included are automatic management of storage space and memory resources within the database and the role of the Segment Advisor and Memory Advisors.
  • Automatic resumption of database operations even in the face of storage space allocation failures and errors.
  • Setting metric and alert thresholds for proactive database monitoring.
  • Using deferred segment creation to improve performance and establish efficient use of space.
  • Globalization features within the database to support applications in multiple languages, currencies, time zones and countries.
  • Utilizing diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure, the Database Instance Health monitor and the Support Workbench to capture and process fault data.
  • Configuring the database to recover from a wide variety of failures. This includes configuring redo log files and the Flash or Fast Recovery Area.
  • Using Oracle flashback technology to recover from user errors and from database failures, including Flashback Data Archive and Flashback Transaction Backout as part of the Oracle Total Recall technology.
  • Course Prerequisites

    Course Outline

    1 - Volume A: Advanced Database Administration

    • Managing Memory
    • Managing Storage & The Segment Advisor
    • Globalization
    • Diagnosing Database Problems
    • Recovery Concepts
    • Oracle Flashback Technology
    • Flashback Database & Flashback Data Archive

    2 - Volume B: Resource Manager & Scheduler

    • Managing Resources
    • Automating Tasks with the Scheduler (Basic)
    • Automating Tasks with the Scheduler (Advanced)
    • Managing Database Performance

    3 - Volume C: RMAN Backup & Recovery

    • Instance Recovery
    • Configuring RMAN
    • Backup with RMAN
    • RMAN Management with EM
    • User-Managed Recovery Operations
    • Recovery with RMAN
    • Using the RMAN Recovery Catalog
    • Database Duplication & Cloning
    • Advanced RMAN Capabilities
    • Transporting TableSpaces
    • Recovering From Corruption with Data Recovery Advisor