Oracle Database 11g R2 Administration II

This Oracle Database 11g - Advanced Database Administration training class teaches database administrators the skills needed to effectively administer an Oracle database installation within a large-scale enterprise.

The target audience for this course is database administrators, web server administrators, system administrators, implementation specialists, data center support engineers, and senior application designers and developers.


Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

  1. Learn to perform other flashback operations, including Flashback Version Query, Flashback.
  2. Learn about Query and Flashback.
  3. Learn to control resource utilization on database servers whose resource demand exceeds its capacity.
  4. Learn resource management for complex configurations involving multiple CPUs and multiple database instances.
  5. Learn to automate launching routine maintenance tasks and application functions using the database Scheduler.
  6. Learn to tune performance of database operations and SQL statement execution using the extensive advisory framework and the Automatic Database Diagnostic Monitoring (ADDM) facility.
  7. Learn user-managed and automatically managed backup strategies and database recovery.
  8. Learn database instance recovery, tuning checkpoints, the Redo Log File Size Advisor and the mTTR Advisor.
  9. Learn managed recovery scenarios, including recovery from temporary, read-only and index .
  10. Learn to automatically manage backup strategies and database recovery operations using RMAN.
  11. Learn to build upon basic RMAN capabilities with a centralized recovery catalog.
  1. Managing Memory
    1. About Advanced Administration
    2. About Manual Memory Management
    3. Automatic Memory Management
    9. Using EM and the Memory Advisors
    10. Monitor in Memory Access Mode
  2. Managing Storage and the Segment Advisor
    1. Monitor Tablespaces
    2. ABOUT Resumable Space Allocation
    3. Table Storage Management
    4. Use the Segment Advisor
  3. Globalization
    1. Globalization Settings
    2. NLS_LANG
    4. Date and Time Localization
    5. Linguistic Indexes
    6. About Locale Builder
  4. Diagnosing Database Problems
    1. Fault Diagnosability Infrastructure
    2. Using the Alert Log
    3. About the Trace Files
    4. Database Instance Health Snapshot
    5. Using the Support Workbench
    6. Enable Oracle Configuration Manage
  5. Recovery Concepts
    1. The Backup and Recovery Structures
    2. Oracle Secure Backup
    3. Managing Redo Data
    4. Managing Archived Redo Data
    5. Checklist for Sound Recovery
  6. Oracle Flashback Technology
    1. About Flashback Technology
    2. Select...As of Timestamp
    3. Select...As of SCN
    4. Undo Management for Flashback
    6. Flashback Table
    7. Flashback Drop
    8. Flashback Versions Query
    9. Flashback Transaction Query
    10. Flashback Transaction Backout
  7. Flashback Database and Flashback Data Archive
    1. About Flashback Database
    2. Configuring the Flash Recovery Area
    3. Performing Database Flashback
    4. Monitoring Flashback Performance
    5. Flashback Database Considerations
    6. Configure Flashback Data Archive
  8. Managing Resources
    1. Resource Manager Architecture
    2. Consumer Groups
    3. Resource Plans
    4. Automatic and Adaptive Mapping
    5. Activating Plans
    6. Monitoring Resource Allocation
    7. Explicit Consumer Group Switching
    8. Instance Caging
  9. Automating Tasks with the Scheduler (Basic)
    1. Scheduler Architecture
    2. Manage Programs
    3. Manage Schedules
    4. Manage Jobs
  10. Automating Tasks with the Scheduler (Advanced)
    1. Manage Job Classes
    2. Manage Windows and Window Groups
    3. Manage Chains
    4. About Events and the Scheduler
  11. Managing Database Performance
    1. Management and Advisory Framework
    2. Manage AWR
    3. ADDM
    4. SQL Tuning Advisor
    5. SQL Access Advisor
  12. Instance Recovery
    1. About Instance Recovery
    2. Instance Recovery Parallelism
    4. MTTR Advisor and Tuning Checkpoints
    6. Redo Logfile Size Advisor
    7. Fast-start On-demand Parallelism
  13. Configuring RMAN
    1. RMAN Architecture
    2. Launch and Use RMAN
    3. Configure RMAN Settings
    4. Allocate RMAN Channels
  14. Backup with RMAN
    1. About Backup File Types
    2. Performing Full Backups
    3. Performing Incremental Backups
    4. Establishing Backup Retention Policy
    5. Generate Reports
    6. Report Unrecoverable
    7. Report Need Backup
    8. List Incarnation
  15. RMAN Management with EM
    1. Monitoring the Flash Recovery Area
    2. The EM Interface to RMAN
    3. Scheduling RMAN Backups
    4. Oracle-Suggested Backup Strategy
    5. Manage Current Backups
    6. Backup Reports
    7. Manage Restore Points
  16. User-managed Recovery Operations
    1. Recovery Concepts
    2. Recover Temporary TABLESPACES
    3. Recover Read-only TABLESPACES
    4. Recover Index TABLESPACES
    5. Recover Redo Log Group Member
    6. Recreate the Password File
  17. Recovery with RMAN
    1. Complete Media Recovery
    2. Incomplete Media Recovery
    3. Recovery Using EM
  18. Using the RMAN Recovery Catalog
    1. Understanding Catalog Concepts
    2. Create the Recovery Catalog
    3. Manage Virtual Private Catalogs
    4. Protection of the Recovery Catalog
    5. Using RMAN Scripts
  19. Database Duplication and Cloning
    1. Why Perform Database Duplication?
    2. RMAN Duplicate Database
    3. RMAN Duplicate
    4. Database Cloning
  20. Advanced RMAN Capabilities
    1. Backup Optimization
    2. Enhancing Parallelism, Section Sizes
    3. Backup Performance and control
    4. Minimize Time vs. Minimize Load
    5. Archival Backups
    6. Copying Files between Databases
  21. Transporting TABLESPACES
    1. About TABLESPACE Transportation
    2. Read-only TABLESPACE Transportation
    3. Read-write TABLESPACE Transport
    4. Transport TABLESPACES Using EM
  22. Recovering from Corruption with Data Recovery Advisor
    1. How Does Corruption Occur?
    2. Detecting Corruption
    3. Analyze
    9. Using the Data Recovery Advisor
    10. Block Media Recovery
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Oracle class:

  • Database administration experience.
  • Resource manager and scheduler as well as RMAN backup and recovery experience.
Prerequisite Courses

Courses that can help you meet these prerequisites:

Training for your Team

Length: 5 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

An excellent course. Well worth the cost and my time.
Kathleen Rhode
Kodak Alaris
The teacher explained things well and, when I asked questions beyond the immediate scope of the course content, was able to answer them to a level that indicated broad and deep knowledge of the technology.
Hans Heilman
No Company
Excellent class! Well taught by a very informative instructor!
Karen Mesonas
Saint Peter's University Hospital
Webucator taught a musician how to write SQL!
Ryan Blauvelt
Sheet Music Plus

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing


Students who have taken Instructor-led Training


Organizations who trust Webucator for their Instructor-led training needs


Satisfaction guarantee and retake option


Students rated our trainers 9.30 out of 10 based on 30,188 reviews

Contact Us or call 1-877-932-8228