Skip to main Content

Oracle Database 11g: Administration Workshop II (D17092GC30)

  • Course Code O11GAWS2
  • Duration 5 days

Public Classroom Price

Please call

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Course Overview

Top
  • In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.
  • Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.
  • Back up and recover a database using RMAN and Enterprise Manager
  • Configure Oracle Database for optimal recovery for any environment
  • Identify burdensome database sessions and poorly performing SQL
  • Configure the database instance such that resources are allocated among sessions and tasks appropriately Schedule jobs to run inside or outside of the database

Course Schedule

Top

Target Audience

Top
  • Database Administrators
  • Data Warehouse Administrator
  • Technical Consultant
  • Support Engineer

Course Objectives

Top
  • Back up and recover a database
  • Configure Oracle Database for optimal recovery
  • Administer ASM disk groups
  • Use an RMAN backup to duplicate a database
  • Automating Tasks with the Scheduler

Course Content

Top
  • Database Architecture and ASM
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Specifications
  • Creating Backups
  • Performing User-Managed Backup and Recovery
  • Using RMAN to Perform Recovery
  • Using RMAN to Duplicate a Database
  • Performing Tablespace Point-in-time Recovery
  • Monitoring and Tuning RMAN
  • Using Flashback Technology
  • Using Flashback Database
  • Diagnosing the Database
  • Managing Memory
  • Managing Database Performance
  • Using the Segment Advisor
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Administering the Scheduler
  • Globalization

Course Prerequisites

Top
  • Oracle Database 11g: Administration Workshop I