Oracle Database 11g : Administration Workshop II


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. Ÿ 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 Ÿ 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


Oracle Database 11g Release 2 ( COURSE OUTLINE Ÿ Database Architecture and Recovery Operations Ÿ The RMAN Catalog and Creating Backups Ÿ Performing Restore and Recovery Tasks Ÿ Using, Monitoring and Tuning RMAN Ÿ Database Diagnostics and Flashback Technologies Ÿ Managing Database Memory and Performance Ÿ Managing Database Resources and the Scheduler Ÿ Managing Database Space and Duplication


• The Oracle Database Architecture: Overview • ASM Storage Concepts • Connecting to the Database and the ASM Instance • DBA Tools Overview

• Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology • Using the Recovery Manager (RMAN) • Configuring your Database for B&R Operations • Configuring Archivelog Mode • Configuring Backup Retention • Configuring and Using a Flash Recovery Area (FRA)

• Tracking and Storing Backup Information • Setting up a Recovery Catalog • Recording Backups • Using RMAN Stored Scripts • Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)

• Configuring and Managing Persistent Settings for RMAN • Configuring Autobackup of Control File • Backup optimization • Advanced Configuration Settings: Compressing Backups • Configuring Backup and Restore for Very Large Files (Multisection)

• RMAN backup types • Creating and Using the following: • Backup Sets and Image Copies • Whole Database Backup • Fast Incremental Backup • Configure Backup Destinations • Duplexed Backup Sets • Archival Backups

• Restoring and Recovering • Causes of File Loss • Automatic Tempfile Recovery • Recovering from the Loss of a Redo Log Group • Recovering from a Lost Index Tablespace • Re-creating a Password Authentication File • Complete and Incomplete Recovery • Other Recovery Operations

• Complete Recovery after Loss of a Critical or Noncritical Data File • Recovering Image Copies and Switching Files • Restore and Recovery of a Database in NOARCHIVELOG Mode • Incomplete Recovery • Performing Recovery with a Backup Control File • Restoring from Autobackup: Server Parameter File and Control File • Restoring and Recovering the Database on a New Host

• Monitoring RMAN Jobs • Balance Between Speed of Backup Versus Speed of Recovery • RMAN Multiplexing • Synchronous and Asynchronous I/O • Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION

• Data Recovery Advisor (DRA) • Block Corruption • Automatic Diagnostic Repository (ADR) • Health Monitor • The ADR Command-Line Tool, ADRCI

• Flashback Technology: Overview and Setup • Using Flashback Technology to Query Data • Flashback Table • Flashback Transaction Query • Performing Flashback Transaction Backout

• Oracle Total Recall • Flashback Drop and the Recycle Bin

• Configuring Flashback Database • Performing Flashback Database Operations • Monitoring Flashback Database

• Oracle Memory Structures • Oracle Database Memory Parameters • Using Automatic Memory Management • Automatic Shared Memory Management • Using Memory Advisors • Using Data Dictionary Views

• Tuning Activities • Using Statistic Preferences • Optimizer Statistics Collection • Monitor the Performance of Sessions and Services • Automatic Workload Repository (AWR) • Describing the Benefits of Database Replay

• SQL Tuning and SQL Advisors • Using SQL Tuning Advisor • SQL Access Advisor • SQL Performance Analyzer Overview

• Database Resource Manager: Overview and Concepts • Accessing and Creating Resource Plans • Creating Consumer Group • Specifying Resource Plan Directives, including: • Limiting CPU Utilization at the Database Level • Instance Caging • Activating a Resource Plan • Monitoring the Resource Manager

• Simplifying Management Tasks • Creating a Job, Program, and Schedule • Using Time-Based, Event-Based, and Complex Schedules • Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups • Multi-Destination Jobs

• Free Space Management • Monitoring Space • Compressing Data

• Segment Creation on Demand • Additional Automatic Space-Saving Functionalit • Shrinking Segments • Segment Advisor • Managing Resumable Space Allocation

• Using 4 KB-Sector Disks • Transporting Tablespaces • Transporting Databases

• Purpose and Methods of Cloning a Database • Using RMAN to Create a Duplicate Database • Cloning a Database from a Backup • Duplicate a Database Based on a Running Instance • Targetless Duplicating a Database


Practice Activities
Case Studies


Pre Test
Post Test
Certification Exam


5 Days

Target Audience

Database Administrators , Java Developers , Support Engineer , Technical Consultant , Technical Administrator


Aug 2017Nov 2017