Oracle Database 11g Administration Courses | Technical IT

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.

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

Target Audience

Database Administrators
Support Engineer
Technical Consultant
Technical Administrator

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

Oracle Database 11g Administration Workshop II Release 2

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

Use Flashback to recover data to a past state

Use RMAN to perform BACKUP and RECOVERY

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

Expert Professionals Provide Training with Hands-On Practices

Very Low Prices

Tutor Support

Certificate

Course Information

Southampton