Oracle Database 11g: Administration Workshop II Release 2 Training

Live Online & Classroom Enterprise Certification Training

This Database 11g Administration training teaches you to perform backup and recovery, and diagnose and repair data failures. Manage major database components like memory, performance and resources using Oracle Database 11g.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Administration Workshop II Release 2 Certification Training about?

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led in class or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study and Knowledge Center courses DO NOT meet the Hands-on Requirement.

What are the objectives of Administration Workshop II Release 2 Certification Training ?

Configure the Oracle Database for optimal recovery
Configure the database instance such that resources are appropriately allocated among sessions and tasks
Schedule jobs to run inside or outside of the database
Use compression to optimize database storage and duplicate a database
Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
Use an appropriate and flexible memory configuration for your database
Identify burdensome database sessions and poorly performing SQL

Who is Administration Workshop II Release 2 Certification Training for?

Database Administrators
Support Engineer
Technical Consultant
Technical Administrator

What are the prerequisites for Administration Workshop II Release 2 Certification Training?

Suggested Prerequisite

Oracle Database 11g Database Administration
Working knowledge of SQL and how to use PL/SQL packages

Required Prerequisite

Oracle Database 11g: Administration Workshop I Release 2

Available Training Modes

Live Online Training

40 Hours

Classroom Training

5 Days

Course Outline Expand All

Expand All

Core Concepts and Tools of the Oracle Database

The Oracle Database Architecture: Overview

Connecting to the Database and the ASM Instance

ASM Storage Concepts

DBA Tools Overview

Configuring for Recoverability

Configuring Backup Retention

Using the Recovery Manager (RMAN)

Configuring Archivelog Mode

Configuring your Database for B&R Operations

Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology

Configuring and Using a Flash Recovery Area (FRA)

Using the RMAN Recovery Catalog

Tracking and Storing Backup Information

Using RMAN Stored Scripts

Recording Backups

Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)

Setting up a Recovery Catalog

Configuring Backup Settings

Configuring Autobackup of Control File

Backup optimization

Configuring Backup and Restore for Very Large Files (Multisection)

Configuring and Managing Persistent Settings for RMAN

Advanced Configuration Settings: Compressing Backups

Creating Backups with RMAN

Fast Incremental Backup

Creating and Using the following:

RMAN backup types

Whole Database Backup

Configure Backup Destinations

Archival Backups

Duplexed Backup Sets

Backup Sets and Image Copies

Restore and Recovery Task

Re-creating a Password Authentication File

Complete and Incomplete Recovery

Causes of File Loss

Restoring and Recovering

Automatic Tempfile Recovery

Other Recovery Operations

Recovering from a Lost Index Tablespace

Recovering from the Loss of a Redo Log Group

Using RMAN to Perform Recovery

Recovering Image Copies and Switching Files

Restore and Recovery of a Database in NOARCHIVELOG Mode

Performing Recovery with a Backup Control File

Restoring from Autobackup: Server Parameter File and Control File

Incomplete Recovery

Complete Recovery after Loss of a Critical or Noncritical Data File

Restoring and Recovering the Database on a New Host

Monitoring and Tuning RMAN

RMAN Multiplexing

Balance Between Speed of Backup Versus Speed of Recovery

Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION

Monitoring RMAN Jobs

Synchronous and Asynchronous I/O

Diagnosing the Database

Health Monitor

Data Recovery Advisor (DRA)

The ADR Command-Line Tool, ADRCI

Block Corruption

Automatic Diagnostic Repository (ADR)

Using Flashback Technology I

Flashback Technology: Overview and Setup

Flashback Table

Using Flashback Technology to Query Data

Performing Flashback Transaction Backout

Flashback Transaction Query

Using Flashback Technology II

Flashback Drop and the Recycle Bin

Oracle Total Recall

Performing Flashback Database

Configuring Flashback Database

Monitoring Flashback Database

Performing Flashback Database Operations

Managing Memory

Oracle Database Memory Parameters

Automatic Shared Memory Management

Using Automatic Memory Management

Using Data Dictionary Views

Oracle Memory Structures

Using Memory Advisors

Managing Database Performance

Using Statistic Preferences

Describing the Benefits of Database Replay

Optimizer Statistics Collection

Tuning Activities

Automatic Workload Repository (AWR)

Monitor the Performance of Sessions and Services

Managing Performance by SQL Tuning

SQL Performance Analyzer Overview

SQL Tuning and SQL Advisors

SQL Access Advisor

Using SQL Tuning Advisor

Managing Resources

Instance Caging

Database Resource Manager: Overview and Concepts

Accessing and Creating Resource Plans

Activating a Resource Plan

Limiting CPU Utilization at the Database Level

Creating Consumer Group

Specifying Resource Plan Directives, including:

Monitoring the Resource Manager

Automating Tasks with the Scheduler

Simplifying Management Tasks

Using Time-Based, Event-Based, and Complex Schedules

Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups

Creating a Job, Program, and Schedule

Multi-Destination Jobs

Managing Space in Blocks

Free Space Management

Compressing Data

Monitoring Space

Managing Space in Segments

Additional Automatic Space-Saving Functionalit

Managing Resumable Space Allocation

Segment Advisor

Shrinking Segments

Segment Creation on Demand

Managing Space for the Database

Using 4 KB-Sector Disks

Transporting Databases

Transporting Tablespaces

Duplicating a Database

Using RMAN to Create a Duplicate Database

Targetless Duplicating a Database

Duplicate a Database Based on a Running Instance

Cloning a Database from a Backup

Purpose and Methods of Cloning a Database

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Administration Workshop II Release 2 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree