Oracle Database11g: Administration Workshop II

Course code:ORAP01


Duration:5 Days / 40 Hours

This Oracle Database 11g: Administration Workshop II training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. You'll also learn how to manage memory effectively, as well as how to perform some performance evaluation and tuning tasks. Instructors will review all types of flashback technologies, scheduling jobs inside and outside of the database and controlling system resource usage. This course will also prepare the students for the certification Oracle Database 11g Administrator Certified Professional.

Audience

  • Support Engineer
  • Database Administrators
  • Technical Consultant
  • Technical Administrator

Prerequisites

Required: Obtained Oracle Database 11g Administrator Certified Associate or equivalent experience

Preferred: Taken Oracle SQL and PL/SQL course or equivalent experience

Objective

After completing this course, students will be able to:

  • Configure the Oracle Database for optimal recovery
  • Configure the database instance such that resources are appropriately allocated among sessions and tasks
  • Schedule jobs to run inside or outside of the database
  • Use compression to optimize database storage and duplicate a database
  • Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
  • Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
  • Use an appropriate and flexible memory configuration for your database
  • Identify burdensome database sessions and poorly performing SQL

Education Criteria

None

Module 1: Oracle Database 11g Release 2: Database Architecture and Recovery Operations

  • Oracle Database Architecture
  • Backup and Recovery Operations

Module 2: Oracle Database 11g Release 2: The RMAN Catalog and Creating Backups

  • The RMAN Recovery Catalog
  • Creating Backups with RMAN

Module 3: Oracle Database 11g Release 2: Performing Restore and Recovery Tasks

  • Restore and Recovery Tasks
  • Performing User-Managed Backup and Recovery

Module 4: Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN

  • Using RMAN to Perform Recovery
  • Monitoring and Tuning RMAN

Module 5: Oracle Database 11g Release 2: Database Diagnostics and Flashback Technologies

  • Diagnosing the Oracle Database
  • Flashback Technologies

Module 6: Oracle Database 11g Release 2: Managing Database Memory and Performance

  • Managing Memory
  • Managing Database Performance

Module 7: Oracle Database 11g Release 2: Managing Database Resources and the Scheduler

  • Managing Resources
  • Task Automation and Administration

Module 8: Oracle Database 11g Release 2: Managing Database Space and Duplication

  • Oracle Database 11g Release 2: Managing Database Space and Duplication
  • Duplicate Databases
 

Course Review

Exam Preparation