Oracle Database 11g: Administration Workshop 2

What you will learn:
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.
Why Oracle 11 g training from Mapple Edusoft :

• Official Course-ware from Oracle University.
  
• Authorized Structured Oracle Training in Jaipur.
• Highly Qualified Java Industry Experts as Trainer.
• Hands on experience on Oracle Software.
  
• Course Completion Certificate From Oracle University.
  
• Discount Vouchers for International Exams.
• 10 Full-length Online Mock Tests (Real-life Oracle® Exam) per Module.
  

Prerequisites :

• Oracle Database 11g: SQL Fundamentals I
  Oracle Database 11g: Administration Workshop I 
  
  

Course Topics :
Core Concepts and Tools of the Oracle Database

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

Configuring for Recoverability

• 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)
  

Using the RMAN Recovery Catalog

• 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 Backup Settings

• 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)
  

Creating Backups with RMAN

• 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
  

Restore and Recovery Task

• 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
  

Using RMAN to Perform Recovery

• 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 and Tuning RMAN

• 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
  

Diagnosing the Database

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

Using Flashback Technology I

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

Using Flashback Technology II

• Oracle Total Recall
  
• Flashback Drop and the Recycle Bin
  

Performing Flashback Database

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

Managing Memory

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

Managing Database Performance

• 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
  

Managing Performance by SQL Tuning

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

Managing Resources

• 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
  

Automating Tasks with the Scheduler

• 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
  

Managing Space in Blocks

• Free Space Management
  
• Monitoring Space
  
• Compressing Data
  

Managing Space in Segments

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

Managing Space for the Database

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

Duplicating a Database

• 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
  



Certificate From Oracle University :

Oracle Training in Jaipur - DBA, Developer - OCA -OCP

Authorized Oracle 11g Training in Jaipur @ Mapple Edusoft