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.

Oracle Database 11g Administration Workshop II Release 2

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

Course Content

  • 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

What's Included

Tutor Support

Tutor Support

Certificate

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.

Target Audience

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

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

Training Solutions at Your Convenience

Our objective has always been to address and resolve the problems of our learners in an efficient manner and improve their learning prospects. We are accustomed in providing training courses as per our learner’s convenience. We love every opportunity to use our experience to resolve difficulties confronted by learners.

Oracle Database 11g Administration Workshop II Release 2 Training Calender

Filters

arrow

Key Points

Duration: *

Tutor Support

Certificate

course-virtual

Leeds

Best Selling Course in Leeds

Mon

16

Dec

2024

£4995

Duration:

course-virtual

Online Instructor-led(Virtual)

Best Selling Course

Thu

19

Dec

2024

£2495

Duration:

Optional add-ons

6 Months Access - £219

Extend your access to match your schedule.

1 Year Access - £439

Give yourself as much time as you need to complete the course

Oracle Database 11g Administration Workshop II Release 2

hours

40 Hours (on average)

days

90 Days Access

administration

40 Hours (on average)

  • Course Price

    £2745

  • add-ons Price

    £0

  • Sub-Total

    £2745

foundation-call Enquire Now

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days from the date of purchase.

ONSITE ENQUIRY?

Fill up the form below and we will get back to you!

name name-red
email email-red
phone-call phonecall-red
house house-red
book book-red
position position-red
house house-red
comment comment-red
conference

Video Conferencing

We provide the best web conferencing platform(s) to facilitate our learners to enhance their communication with the instructor.

whiteboard

Digital Whiteboards

Our courses include the real-time demonstration of figures, diagrams and other interactive material through digital whiteboards.

messaging

Instant Messaging

During the Virtual Classroom session, learners can raise their queries through instant messaging and follow up on their doubts.

control

Participation Controls

Through participating effectively in training, individuals can easily discuss their views, mute their surroundings and virtually "raise" their hands.

Features of Our Virtual Classroom Courses

future

How to Choose and Attend Your Ideal Course?

FIND COURSES

We provide 400+ courses covering broader aspects of personal and professional development training needed by any individual. You can choose any course as per your need or requirement. Our courses are designed to fulfil the current organisational and job marketplace requirements.

search}

Select the Course

Choose the course you want to attend to fulfil your desired goals.

details}

Attend the Course

Attend the training with your prefered method at your convenience.

book}

Get Certification

Upon finishing the course, you will get the completion certificate validating your learning.

Oracle Database 11g Administration Workshop II Release 2

£ 2745 £ 2695

Benefits of Attending Our Online Courses

We provide a variety of certification programmes or courses for individuals to master a skill set and pursue a full-time career in management, IT, or other domains through the online method to provide them with the convenience of learning. Our dedicated staff works tirelessly to assure the availability of courses with eminence quality that's not found anywhere with benefits like:

skilled

Get Tailored Programmes

affordable

Quick Delivery

flexible

Scalability and Consistency

access

90 Days Access

Learn a New Skill From Onsite Training

Adaptable Courses

We provide onsite courses modified according to our client's organisational needs.

Cost-Effective Learning

Onsite training helps you to reduce travelling and venue expenses.

Learn in Familiar Surroundings

Training at your convenient place can be ideal for learning new skills.

Team Building Opportunity

Attending onsite training with your team can help to improve your team dynamics tremendously.

name

name name-red
phone-call phonecall-red
email email-red
email email-red
comment comment-red
up-arrow
LOADING