Oracle Database 11g Administration Workshop 2 Training institute in Chennai SQL STAR

Oracle Database 11g: Administration Workshop II Release 2

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.

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.

Learn To:

• Diagnose and repair data failures with Flashback technology.
• Manage space to optimize database storage so you can respond to growingspace requirements.
• Monitorand manage major database components, including memory,performance and resources.
• Securethe availability of your database through appropriate backup andrecovery strategies.
• AutomateDBA tasks with the Scheduler.

Benefits to You

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.

Backup & Recovery

The concepts and architecture that support backup and recovery, along with the steps required to execute it in various ways and situations, are covered in detail. You'll learn how to define and test your own backup and recovery scenarios.

Manage Memory Effectively

You'll also learn how to manage memory effectively, as well as how to perform some performance evaluation and tuning tasks. Instructors will review all types of flashback technologies, scheduling jobs inside and outside of the database and controlling system resource usage.

Course Requirements

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.
Prerequisites
Suggested Prerequisite

• Oracle Database 11g Database Administration
• Workingknowledge of SQL and how to use PL/SQL packages

Required Prerequisite

• Oracle Database 11g: Administration Workshop I Release2

Audience

• Database Administrators
• Support Engineer
• Technical Consultant
• Technical Administrator

Course Objectives

• Configurethe Oracle Database for optimal recovery
• Configurethe database instance such that resources are appropriatelyallocated among sessions and tasks
• Schedulejobs to run inside or outside of the database
• Usecompression to optimize database storage and duplicate a database
• Backand recover a database (and its parts) with RMAN (command-line andEnterprise Manager)
• Useflashback technology to view past states of data and to reverteither objects or the entire database back to a past state
• Usean appropriate and flexible memory configuration for your database
• Identifyburdensome database sessions and poorly performing SQL

Course Topics
Core Concepts and Tools of the Oracle Database

• TheOracle Database Architecture: Overview
• Connecting to the Database and the ASM Instance
• ASM Storage Concepts
• DBATools Overview

Configuring for Recoverability

• Configuring Backup Retention
• Using the Recovery Manager (RMAN)
• Configuring Archivelog Mode
• Configuring your Database for B&R Operations
• Purposeof 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 andVirtual Private Catalog)
• Setting up a Recovery Catalog

Configuring Backup Settings

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

Creating Backups with RMAN

• -Fast Increment al Backup
• Creating and Using the following:
• RMANbackup 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
• Completeand Incomplete Recovery
• Causesof File Loss
• Restoring and Recovering
• AutomaticTempfile Recovery
• OtherRecovery 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
• IncompleteRecovery
• CompleteRecovery after Loss of a Critical or Noncritical Data File
• Restoring and Recovering the Database on a New Host

Monitoring and Tuning RMAN

• RMAN Multiplexing
• BalanceBetween Speed of Backup Versus Speed of Recovery
• Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES andBACKUP DURATION
• Monitoring RMAN Jobs
• Synchronousand Asynchronous I/O

Diagnosing the Database

• HealthMonitor
• DataRecovery Advisor (DRA)
• TheADR Command-Line Tool, ADRCI
• BlockCorruption
• AutomaticDiagnostic Repository (ADR)

Using Flashback Technology I

• FlashbackTechnology: Overview and Setup
• FlashbackTable
• Using Flashback Technology to Query Data
• Performing Flashback Transaction Backout
• FlashbackTransaction Query

Using Flashback Technology II

• FlashbackDrop and the Recycle Bin
• OracleTotal Recall

Performing Flashback Database

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

Managing Memory

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

Managing Database Performance

• Using Statistic Preferences
• Describing the Benefits of Database Replay
• OptimizerStatistics Collection
• Tuning Activities
• AutomaticWorkload Repository (AWR)
• Monitorthe Performance of Sessions and Services

Managing Performance by SQL Tuning

• SQLPerformance Analyzer Overview
• SQLTuning and SQL Advisors
• SQLAccess Advisor
• Using SQL Tuning Advisor

Managing Resources

• InstanceCaging
• DatabaseResource 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 ConsumerGroups
• Creating a Job, Program, and Schedule
• Multi-DestinationJobs

Managing Space in Blocks

• FreeSpace Management
• Compressing Data
• Monitoring Space

Managing Space in Segments

• AdditionalAutomatic Space-Saving Functionalit
• Managing Resumable Space Allocation
• SegmentAdvisor
• Shrinking Segments
• SegmentCreation on Demand

Managing Space for the Database

• Using4 KB-Sector Disks
• Transporting Databases
• Transporting Table spaces

Duplicating a Database

• Using RMAN to Create a Duplicate Database
• TargetlessDuplicating a Database
• Duplicatea Database Based on a Running Instance
• Cloning a Database from a Backup
• Purposeand Methods of Cloning a Database