Oracle Database 11g Backup and Recovery Workshop 1.0 Training & Placements in Chennai SQL STAR

Oracle Database 11g: Backup and Recovery Workshop
(The Course materials and Course Completion Certificates are directly delivered from Oracle University to those seeking for Foreign Opportunity)

(Government of India Approved Education Center)

This Database 11g Backup & Recovery training will teach you to evaluate your own recovery requirements & develop an appropriate strategy for backup & recovery procedures. Get hands-on practices and workshops in a realistic technical environment.
This Oracle Database 11g: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll learn to develop an appropriate strategy for backup and recovery procedures; please note that this course is based on Oracle Database 11g Release 2 Patch Set 1.
Learn To:

• Developappropriate backup and recovery procedures to address yourbusiness needs.
• EmployOracle Database recovery procedures to recover from media failure.
• Use Flashback Technologies to complement backup and recoveryprocedures.

Benefits to You By enrolling in this course, you'll get a chance to participate in hands-on practices and workshops that give you experience working within a realistic technical environment. These interactive workshops give you the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies.
Backup & Recovery Techniques This course reviews the backup and recovery techniques discussed in the Oracle Database 11g: Administration Workshop I and II courses. Expert Oracle University instructors will help you examine various backup, failure, restore and recovery scenarios. Recovery Manager (RMAN) & Enterprise Manager.
Please note that you're expected to have some knowledge of Recovery Manager (RMAN) and Enterprise Manager, as you'll use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are also described as an additional way to recover from various errors.
Suggested Prerequisite

• Knowledgeof Oracle Database administration
• Knowledgeof RMAN and Enterprise Manager

Required Prerequisite

• Oracle Database 11g: Administration Workshop I Release 2
• Oracle Database 11g: Administration Workshop II Release 2

Audience

• Database Administrators
• Technical Consultant
• Technical Administrator

Course Objectives

• Performtablespace point-in-time recovery
• Describe the Oracle Database architecture components related to backup andrecovery operations
• Describeadditional high availability features such as Oracle Data Guardand Oracle Secure Backup
• Planeffective backup and recovery procedures
• DescribeOracle Database backup methods and recovery operations that can beused to resolve database failure
• Configurethe database for recoverability
• Userecovery Manager (RMAN) to create backups and perform recoveryoperations
• Use the Data Recovery Advisor to diagnose and repair failures
• UseOracle Flashback Technologies to recover from human error
• Performan encrypted database backup and restore

Course Topics
Introduction

• OracleMaximum Availability Architecture
• OracleActive Data Guard (overview only)
• Oracle Secure Backup (overview only)
• DataFailures Examples
• OracleBackup and Recovery Solutions
• Oracle Data Protection Solutions
• Assessing Your Recovery Requirements
• FailureCategories

Using Recovery Manager (RMAN) and Enterprise Manager

• Enterprise Manager (backup and recovery interface overview)
• Viewing and Managing RMAN Persistent Settings
• Configuring RMAN Persistent Settings
• Using the RMAN Command-Line
• Oracle Recovery Manager (architecture overview)
• RMANCommands (overview)

Configuring for Recoverability

• RCHIVELOGMode and the Archiver Process
• FastRecovery Area (overview)
• UndoRetention
• FastRecovery Area Sizing and Configuration
• ArchivedRedo Log Files
• RedoLog File Multiplexing
• RedoLog Files and the LGWR Process
• Control File Multiplexing & Autobackup

Using the RMAN Recovery Catalog

• Managing Records in the Catalog
• Registering the Database
• Creating the Recovery Catalog
• Backing Up the Recovery Catalog
• RepositoryComparison
• CatalogResynchronization
• RecoveryCatalog Overview

Backup Concepts and Strategies

• Best Practices for Data Warehouse Backups
• Understanding RMAN Backup Data Flow
• Balancing Backup and Restore Requirements
• RMAN Backup Types
• Comparing Backup Strategies
• BackupTerminology
• BackupSolutions Overview

Creating Backups

• Backups Sets & Image Copies (RMAN)
• Control File Backups & Cataloging Backups Files
• Read-OnlyTablespace Backups
• Oracle Suggested Backup Strategy
• WholeDatabase Backups
• BlockChange Tracking/Fast Increment al Backups
• BackupCompression & RMAN Encrypted Backups
• Checking for Block Corruption

Restore and Recovery Concepts

• InstanceFailure and Instance/Crash Recovery
• Recoveryto an Abandoned Incarnation
• CompleteRecovery (Overview)
• Point-in-TimeRecovery (Overview)
• Employing the Best Oracle Technology for Recovery
• MediaFailure
• RecoveryThrough RESETLOGS

Using Data Recovery Advisor

• Using the Data Recovery Advisor (overview)
• Using the Data Recovery Advisor RMAN Command-Line Interface
• Using the Data Recovery Advisor in Enterprise Manager
• DataRecovery Advisor Overview

Performing Recovery

• Restore and Recovery Performance Best Practices
• Data File Loss (file system and ASM)
• BlockMedia Recovery
• Restoring RMAN Encrypted Backups
• RedoLog File Loss and Recovery, Index Tablespace Recovery &Read-Only Tablespace Recovery
• Control File Loss and Recovery & RMAN Recovery: Backup Control File
• RMANRecovery: NOARCHIVELOG Mode, Complete, Image Files &Point-in-Time (Incomplete recovery)
• PasswordAuthentication File Re-creation, Server Parameter File Recovery &Tempfile Recovery

Using Flashback Technologies

• FlashbackTechnologies Overview
• Best Practices for Undo-Based Flashback Technologies
• FlashbackTransaction
• FlashbackTable
• FlshbackTransaction Query
• FlashbackDrop
• FlashbackQuery & Flashback Version Query
• Preparing to use Flashback Technologies

Flash back Database

• Flashback Database Architecture
• Configuring Flashback Database
• Best Practices for Flashback Database
• Performing Flashback Database

RMAN Performance and Tuning

• Restore and Recovery Performance Best Practices
• RMAN Multiplexing
• Tuning Principles
• Diagnosing Performance Bottlenecks

Backup and Recovery Workshop Scenarios

• WorkshopApproach to Solving Failure Scenarios
• WorkshopStructure
• BusinessRequirements for Database Availability and Procedures