Oracle Database 11g Release 2 DBA - Part II

5 Day Course
Hands On

Book Now - 1 Delivery Method Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online


This Oracle Database 11g Release 2 DBA - Part II course introduces the delegate to advanced administration tasks. Participants will learn how to plan and implement a backup and recovery strategy using Recovery Manager. They will also learn how to control database resources using the Resource Manager; how to automate administration tasks with the Scheduler and how to carry out performance monitoring and tuning.

The delegate will practise:

  • Planning a backup strategy and a disaster recovery strategy
  • Altering a database to archivelog and noarchivelog modes
  • Managing memory
  • Using Recovery Manager to perform backups and restorations
  • Using Flashback technology to diagnose and repair a database
  • Reviewing database logs for diagnostic purposes
  • Using Database advisors and views to monitor and improve database performance
  • Controlling database resources using Resource Manager
  • Automating management tasks with the Scheduler

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Hide all

Backup and Recovery Considerations (6 topics)

  • Oracle Suggested Backup Strategy
  • Plan and Implement a Backup and Recovery Strategy
  • Define a Backup Strategy
  • Define a Disaster Recovery Plan
  • The Advantages and Disadvantages of Different Backup Methods
  • Test a Backup and Recovery Plan

Oracle Recovery Structures and Processes (4 topics)

  • Architectural Components of Backup and Restore
  • Redo Logs, Checkpoints and Archives
  • Multiplexing Control Files and Redo Logs
  • Types of Database Failure

Memory Management (6 topics)

  • Automatic Shared Memory Management
  • PGA Memory Management
  • Automatic Memory Management
  • The Memory Advisor
  • Memory Allocation Advisors
  • Memory Management Data Dictionary Views

Using Archivelog and Noarchivelog Modes (5 topics)

  • The Archive Modes of a Database
  • Altering the Archive Mode of a Database
  • Configuring Multiple Archival Destinations
  • Configuring Multiple ARCH Processes
  • Data Dictionary Tables for Archiving

Troubleshooting Utilities (12 topics)

  • Database Synchronization
  • Using Log and Trace Files to Diagnose Problems
  • Detecting Block Corruption
  • The ANALYZE Command
  • The DBMS_REPAIR Package
  • Use DBVERIFY to Validate the Database File Structure
  • Block Media Recovery
  • Automatic Diagnostic Repository (ADR)
  • The ADR Command Line Tool (ADRCI)
  • The Health Monitor

Recovery Manager Overview (4 topics)

  • Overview of Recovery Manager
  • RMAN Features and Components
  • Connect to RMAN
  • Start Up and Shut Down a Target Database Using RMAN

Create a Recovery Catalog (9 topics)

  • Recovery Catalog Overview
  • Create a Recovery Catalog
  • Use a Flashback Recovery Area
  • Register and Unregister a Database
  • Control File Information
  • RESYNC CATALOG command
  • Virtual Private Catalogs
  • Merge Catalogs
  • Backup a Recovery Catalog

Backing up with RMAN (10 topics)

  • Channel Allocation
  • The Configure Channel Command
  • Types of RMAN Backup
  • Recovery Manager Commands
  • Performing Backups with RMAN
  • The Backup Command
  • The Copy Command
  • Backup File Image Copies
  • Perform Full, Incremental and Cumulative Backups
  • Use Data Dictionary Tables

Maintain a Recovery Catalog (8 topics)

  • Reset Database Command
  • Change the Availability Status of Backups and Copies
  • Catalog Backups Made with Operating System Commands
  • Generate Reports and Lists
  • Configuration Values
  • Cross Check Backups and Copies
  • Delete Backups
  • Drop Database and Archival Backups

Restore and Recover with RMAN (14 topics)

  • Overview of Restore
  • The Restore Command
  • Restore a Database in Noarchivelog Mode
  • Restore and Recover a Database in Archivelog Mode
  • Incomplete Recovery using Until Time and Until Sequence
  • Restore and Recover a Tablespace
  • Automatic tempfile Recovery
  • Recover a Datafile Not Backed Up
  • Recover a Lost Redo Log Group
  • Re-create a Password Authentication File
  • Apply Incremental Backups to Restore Datafile Image Copies
  • The Switch command
  • The Data Recovery Advisor (DRA)
  • Restore and Recover the Database on a New Host

Create aa Duplicate Database with RMAN (8 topics)

  • Overview of Database Duplication
  • Database Duplication
  • Duplication Options
  • Create Files for the Duplicate Database
  • Prepare an Auxiliary Instance for Duplication
  • Create a Duplicate Database
  • Clone a Running Database without a Backup
  • Targetless duplication of a database

Manage Space for the Database (2 topics)

  • Transport Tablespaces
  • Transport Databases

Monitor, Tune RMAN (8 topics)

  • Recovery Manager Tuning Overview
  • Tuning RMAN Backup Performance
  • Synchronous and Asynchronous I/O
  • Instance Recovery Performance Tuning
  • RMAN Messages
  • Troubleshoot RMAN
  • RMAN Detected Block Corruptions

Flashback (13 topics)

  • Configure and Use Flashback Database
  • Monitor Flashback Database
  • Flash Recovery Area Space Usage
  • Flashback Query
  • Retrieve Row History with Flashback Versions Query
  • Audit or Recover from Transactions with Flashback Transactions Query
  • Flashback Table
  • Recover Dropped Tables with Flashback Drop
  • The Recycle Bin
  • Recover Tables to a Point in Time with Flashback Table
  • Flashback Database
  • Flashback Restore Points
  • Flashback Transaction Backout

Oracle Total Recall (4 topics)

  • Overview of Oracle Total Recall
  • Manage Flashback Archives
  • Flashback Data Archive and Auditing
  • Flashback Data Archive Uses

Automate Tasks with the Scheduler (13 topics)

  • Introduction to the Scheduler
  • Scheduler Related Parameters
  • Access Rights
  • Create a Program
  • Drop a Program
  • Create a Schedule
  • Create a Job
  • Job Classes
  • Windows
  • Window Group
  • Monitoring and Logging
  • Use Time Based, Event Based and Complex Schedules
  • Multi Destination Jobs

Manage Space in Segments (6 topics)

  • Tablespace Monitoring
  • Segment Management Enhancements
  • Segment Advisor
  • Segment Space Estimation
  • Online Segment Shrink
  • Proactive Tablespace Management

Manage Space in Blocks (3 topics)

  • Free Space Management
  • Monitor Space
  • Compress Data

Manage Database Performance (6 topics)

  • Tuning Activities
  • Use Statistic Preferences
  • Optimizer Statistics Collection
  • Monitor The Performance of Sessions And Services
  • Automatic Workload Repository (AWR)
  • The Benefits of Automatic Database Replay

Database Performance by SQL Tuning (4 topics)

  • Application and SQL Tuning
  • SQL Tuning Advisor
  • SQL Access Adviso
  • SQL Performance Analyzer

Automatic Storage Management (10 topics)

  • Overview of ASM
  • ASM Instance Creation
  • SYSASM Role
  • Administer ASM Disk Groups
  • ASM Files
  • ASM Startup and Shutdown
  • ASM Data Dictionary Views
  • Migrate a Database to ASM Using RMAN
  • The ASM Command Line Tool
  • Use 4KB Sector Disks

Managing Resources with Resource Manager (10 topics)

  • Overview of the Database Resource Manager
  • Create Resource Plans
  • Create Resource Consumer Groups
  • Create Resource Plan Directives
  • Limit CPU Utilization at the Database Level
  • Instance Caging
  • Control Resources by User Groups
  • Specify an Instance Plan
  • Monitor the Resource Manager
  • Data Dictionary Views


A working knowledge of Oracle SQL and Oracle Database Administration. This can be obtained by attendance on the pre-requisite courses. Knowledge of PL/SQL would be beneficial.

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

Relevant Certifications

Course PDF


Share this Course


Recommend this Course