Oracle Database 11g R2 Administration II

IT/Networking/Server/Operating Systems
  IT Online Library (1 Year Subscription - $1595.00)
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions

This Oracle Database 11g - Advanced Database Administration training class brings database administrators beyond a basic understanding of their duties and to gain advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise. The primary target audiences for this course are database administrators, web server administrators, system administrators, implementation specialists, data center support engineers, and senior application designers and developers.


  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:

  • Introduction to SQL Training
  • Oracle Database 11g R2 - RMAN Backup and Recovery

Course Setup
  • Live Online: Course Setup | WebEx Setup