Oracle Database 11g Administration Courses | Technical IT

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

Overview
Course Content
What's Included

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

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

Explore Now

Choose Mode of Training

Classroom

Online Instructor-led

Online Self-Paced

Onsite

Key Points

Duration: *

Tutor Support

Certificate

Oracle Database 11g Administration Workshop II Release 2

Book Now

Edinburgh

Best Selling Course in Edinburgh

Mon

Nov

2024

£4995

Duration:

Oracle Database 11g Administration Workshop II Release 2

Book Now

Sheffield

Best Selling Course in Sheffield

Mon

Dec

2024

£4995

Duration:

Oracle Database 11g Administration Workshop II Release 2

Book Now

Milton Keynes

Best Selling Course in Milton Keynes

Mon

Dec

2024

£4995

Duration:

Oracle Database 11g Administration Workshop II Release 2

Book Now

Leeds

Best Selling Course in Leeds

Mon

Dec

2024

£4995

Duration:

Oracle Database 11g Administration Workshop II Release 2

Book Now

Online Instructor-led(Virtual)

Best Selling Course

Thu

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

40 Hours (on average)

90 Days Access

40 Hours (on average)

Course Price

£2745
add-ons Price

£0
Sub-Total

£2745

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!

Video Conferencing

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

Digital Whiteboards

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

Instant Messaging

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

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

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.

Select the Course

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

Attend the Course

Attend the training with your prefered method at your convenience.

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:

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.

Best Practice Training provides specially designed training courses in 410+ locations spanning over 30+ countries globally. All our locations have state of the art facilities for the learners. Some of the Popular Locations are: