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