About this course
Private/In-House Training

  • We can deliver this course at either your organisation's venue, or at one of our many high-quality training venues.

    For IT training courses, you can take advantage of our computer hire service - we deliver and setup the computers for you. After the course, we will come and collect them

    Freephone 0800 781 0626

Course Reviews

Oracle Database 11g DBA - Part 2

Course Code : OD11G2

Delegates:
This course is designed for database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle Database 11g.  This course is also suitable for delegates who need to be able to monitor and improve the database performance.


Objectives:
This course introduces delegates to the main concepts of Oracle backup and recovery.  They will learn how to plan and implement a backup and recovery strategy using RMAN.  Delegates will also learn to manage memory effectively, carry out some evaluation and tuning exercises, control database resources using Resource Manager, automate tasks with the Scheduler and use Automatic Storage Management (ASM).

Topics Covered:
  • Manage Memory
  • Plan a Backup and Recovery Strategy
  • Oracle Recovery Structures
  • Create and Manage a RMAN Recovery Catalog
  • Configure Backup Settings
  • Use RMAN to Perform Backups
  • Use RMAN to Restore and Recover
  • Monitor and Tune RMAN
  • Perform Tablespace Point-in-Time Recovery
  • Create a Duplicate Database with RMAN
  • Additional Recovery Issues
  • Use Flashback Technology to Recover a Database
  • Use Flashback to Recover from User Errors
  • Diagnostic Sources
  • Use ASM
  • Manage Database Performance
  • Monitor and Manage Storage with the Segment Advisor
  • Control Database Resources using Resource Manager
  • Automate Management Tasks with the Scheduler
  • Administer the Scheduler
  • Use Globalization

Requirements:
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.
Desktop Applications Professional Development Project Management Technical IT new! - Datrix Training Books