Course Introduction

This Oracle training course takes the candidates beyond the scope of Workshop I. It gives a better and a deeper understanding of the duties of the DBA. It mainly deals with Backup and Recovery using almost all the tools at the disposal of the DBA.

  • topics-icons

    Have an in-depth understanding of the duties of an Oracle DBA

  • topics-icons

    Use Flashback to recover data to a past state

  • topics-icons

    Use RMAN to perform BACKUP and RECOVERY

  • topics-icons

    Salaries Range from £26,500 to £48,000

  • topics-icons

    Expert Professionals Provide Training with Hands-On Practices

  • topics-icons

    Very Low Prices

What’s included

BPT offers more benefits. Here is what's included with this course:

exam

Tutor Support

exam

Certificate

Prerequisites

The candidates must hold a certificate in Oracle Database 11g Administration Workshop I Release 2. Familiarity with Oracle SQL or equivalent and PL/SQL will be an added advantage.

Show More

Delegates will learn how to

The Candidates will be able to perform the following actions after the course completion:

  • Backup and Recovering a Database using RMAN (Command Line Interface and Enterprise Manager)
  • Using Flashback to View Past States of Data and Revert the Database or Objects to that state.
  • Using an Adaptable Memory Configuration for the Database
  • Isolating sessions with heavy Traffic and bad performing SQL Statements
  • Configuring the Oracle Database for Optimal Recovery
  • Configure the Database instance to allocate Resources appropriately among Sessions and Tasks
  • Scheduling jobs
  • Optimizing Database storage
Show More

Target Audience

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

Course Information

The candidates learn to implement Performance evaluation and Tuning of the Oracle Database including some advisors. They also use various advisors, flashback technologies, and job scheduling for such purposes. Also they learn to control resource usage.

During the course the participants will learn the following:

  • Diagnose and repair data failures with Flashback technology
  • Monitor and manage major database components, including as memory, performance, and resources
  • Automate DBA tasks with the Scheduler
  • Diagnose and repair data failures with Flashback technology
  • Secure the availability of your database by appropriate backup and recovery strategies

  • Core Concepts And Tools Of Oracle 11g
    • Reviewing The Oracle 11g Architecture
    • ASM Storage Concepts
    • Connecting to The Oracle Database and The ASM Instance
    • The Administration Tools
  • Configuring For Recoverability
    • Backup and Recovery – Purpose, Tasks, and Terminology
    • The Recovery Manager (RMAN)
    • Configuring The Database for Backup and Recovery
    • The Archivelog Mode
    • Configure Backup Retention
    • The Flash Recovery Area – Configuring and Using
  • Using RMAN Recovery Catalog
    • Track and Store Backup Information
    • Setting Up Recovery Catalog
    • Recording Backups
    • Using RMAN Stored Scripts
    • Managing Recovery Catalog
  • Configuring Backup Settings
    • Configuring and Managing Permanent Settings for RMAN
    • Autobackup Control File
    • Enhancing Backup
    • Advanced Configuration Settings – Compressing Backups
    • Configuring Backup and Recovery For Large Files
  • Creating RMAN Backups
    • Backup Types In RMAN
    • Creating and Using :
      • Backup Sets and Image Copies
      • Whole Database Backup
      • Fast Incremental Backup
      • Configure Backup Destinations
    • Duplexed Backup Sets Archival Backups
  • Restore and Recovery Tasks
    • Restoring and Recovering
    • Explain The Causes of File Loss
    • Recovering TempFile Automatically
    • Recovering From  A  Lost Redo Log Group
    • Recovering from a Lost Index Tablespace
    • Re-creating Password Authentication File
    • Complete and Incomplete Recovery
    • Recovery Operations
  • Recovery With RMAN
    • Performing Complete Recovery On Loosing A Data File
    • Recovering Image Copies and Switching Files
    • Restore and Recover A Database In NOARCHIVELOG Mode
    • Restoring SPFILE and Control File From Autobackup
    • Recover and Restore The Database on A New Host
  • Monitoring and Tuning RMAN
    • Monitoring Jobs With RMAN
    • Balance between Backup Speed and Recovery Speed
    • Multiplexing with RMAN
    • Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION
  • Database Diagnosis
    • Using The Data Recovery Advisor
    • Explaining Block Corruption
    • Automatic Diagnostic Repository
    • Health Monitor
    • The ADR Command Line Interface
  • Flashback Technology I
    • Overview and Setup of Flashback Technology
    • Query Data With Flashback Technology
    • Flashback Table
    • Flashback Transaction Query
    • Performing Flashback Transaction Backout
  • Flashback Technology II
    • Oracle Total Recall
    • Flashback Drop and Recycle Bin
  • Performing Flashback Database
    • Configuring and Performing Flashback Database Options
    • Supervising Flashback Database
  • Managing Memory
    • Memory Structures in Oracle
    • Database Memory Parameters
    • Automatic Memory Management
    • Automatic Shared Memory Management
    • Using Memory Advisors
    • Using Data Dictionary Views
  • Managing Database Performance
      • Activity Tuning
      • Using Statistic Preferences
      • Optimizer Statistic Collection
      • Monitoring Sessions and Services Performance
      • The AWR
      • Database Replay and Its Advantages
  • SQL Tuning to Manage Performance
    • SQL Tuning and SQL Advisors
    • Using The SQL Tuning Advisor
    • SQL Access Advisor
    • An Overview of SQL Performance Analyzer
  • Resource Management
    • An Overview of Database Resource Manager
    • Creating Resource Plans and Accessing Them
    • Creating Consumer Groups
    • List Out Resource Plan Directives
    • Activating A Resource Plan
    • Monitoring The Resource Manager
  • Using Scheduler to Automate Tasks
    • Simplifying management Tasks
    • Creating Jobs, Programs and Schedules
    • Using Different Types Of Schedules – Time-based, Event-based and Complex
    • Describe the Use of Windows, Window Groups, Job Classes and Consumer Groups
    • Multi-Destination Jobs
  • Managing Block Space
    • Free Space Management
    • Monitoring Space
    • Compacting Data
  • Managing Segment Space
    • On Demand Segment Creation
    • Additional Automatic Space Saving Functionality
    • Shrinking Segments
    • Segment Advisor
    • Managing resumed Space Allocation
  • Managing Space For The Database
    • Using 4-KB Sector Disks
    • Transporting Tablespaces
    • Transporting Databases
  • Duplicating A Database
    • Cloning A Database – Purpose and Technique
    • Creating Duplicate Databases with RMAN
    • Database Cloning from Backups
    • Duplicate Database Based on Running Instance
    • Target-less Duplicating a Database



Delivery methods for this course

classroomicon Classroom Training
classroomicon Online Training
classroomicon Virtual Training
classroomicon Onsite Training

Oracle Database 11g Release 2 DBA - Part II Classroom Schedules

Course Name Duration Dates Price
Oracle Database 11g Administration Workshop II Release 2 5 days Southampton
13-07-2020 £4614
Book Nowarw Enquire     arw
Oracle Database 11g Administration Workshop II Release 2 5 days Southampton
14-09-2020 £4614
Book Nowarw Enquire     arw
Oracle Database 11g Administration Workshop II Release 2 5 days Southampton
09-11-2020 £4614
Book Nowarw Enquire     arw
Oracle Database 11g Administration Workshop II Release 2 5 days London
13-07-2020 £4064
Book Nowarw Enquire     arw
Oracle Database 11g Administration Workshop II Release 2 5 days London
14-09-2020 £4064
Book Nowarw Enquire     arw
Oracle Database 11g Administration Workshop II Release 2 5 days London
09-11-2020 £4064
Book Nowarw Enquire     arw
Oracle Database 11g Administration Workshop II Release 2 5 days Bristol
13-07-2020 £4614
Book Nowarw Enquire     arw
Oracle Database 11g Administration Workshop II Release 2 5 days Bristol
14-09-2020 £4614
Book Nowarw Enquire     arw
Oracle Database 11g Administration Workshop II Release 2 5 days Bristol
09-11-2020 £4614
Book Nowarw Enquire     arw
Oracle Database 11g Administration Workshop II Release 2 5 days Manchester
13-07-2020 £4064
Book Nowarw Enquire     arw
Southampton

Southampton

Southampton is the largest city located in England. The city is situated 69 miles south-west of London and 15 miles west north-west of Portsmouth. Southampton is the main port and neighbouring city... Learn More

Popular Locations

Reaching You Across The World

Southampton
London
Birmingham
Bristol
Reading
Leeds
Manchester
Cardiff
Brighton

Cookie Policy - To give you the best possible experience, this site uses cookies. Continuing to use this site means that you agree to our use of cookies.  Okay, I accept

enquireEnquiry call02380
001008