ISQLGlobal Global Logo
Contact UsCertificationPlacementsCoursesCorporateHome

Oracle Database 11g Backup and Recovery Workshop 1.0 Training & Placements in Chennai ISQL Global

Oracle Database 11g: Backup and Recovery Workshop

(Government of India Approved Education Center –SQL Star)

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.
  • UseFlashback 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. The se 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 Universityinstructors 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
  • Configure the database for recoverability
  • Userecovery Manager (RMAN) to create backups and perform recoveryoperations
  • Use the Data Recovery Advisor to diagnose and repair failures
  • Use Oracle Flashback Technologies to recover from human error
  • Performan encrypted database backup and restore

Course Topics

Introduction
  • OracleMaximum Availability Architecture
  • OracleActive Data Guard (overview only)
  • OracleSecure Backup (overview only)
  • DataFailures Examples
  • OracleBackup and Recovery Solutions
  • Oracle Data Protection Solutions
  • AssessingYour Recovery Requirements
  • FailureCategories
Using Recovery Manager (RMAN) and Enterprise Manager
  • EnterpriseManager (backup and recoveryinterface overview)
  • Viewing and Managing RMAN Persistent Settings
  • ConfiguringRMAN Persistent Settings
  • Using the RMAN Command-Line
  • OracleRecovery 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
  • ControlFile 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
  • BestPractices for Data Warehouse Backups
  • Understanding RMAN Backup Data Flow
  • BalancingBackup and Restore Requirements
  • RMANBackup Types
  • ComparingBackup Strategies
  • BackupTerminology
  • BackupSolutions Overview
Creating Backups
  • BackupsSets & Image Copies (RMAN)
  • Control File Backups & Cataloging Backups Files
  • Read-OnlyTablespace Backups
  • OracleSuggested Backup Strategy
  • WholeDatabase Backups
  • BlockChange Tracking/Fast Incremental Backups
  • BackupCompression & RMAN Encrypted Backups
  • Checkingfor Block Corruption
Restore and Recovery Concepts
  • InstanceFailure and Instance/Crash Recovery
  • Recovery to 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
  • Restoreand Recovery Performance Best Practices
  • Data File Loss (file system and ASM)
  • BlockMedia Recovery
  • RestoringRMAN Encrypted Backups
  • RedoLog File Loss and Recovery, Index Tablespace Recovery &Read-Only Tablespace Recovery
  • ControlFile 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
  • BestPractices for Undo-Based Flashback Technologies
  • FlashbackTransaction
  • FlashbackTable
  • FlshbackTransaction Query
  • FlashbackDrop
  • FlashbackQuery & Flashback Version Query
  • Preparingto use Flashback Technologies
Flashback Database
  • FlashbackDatabase Architecture
  • Configuring Flashback Database
  • Best Practices for Flashback Database
  • Performing Flashback Database
RMAN Performance and Tuning
  • Restore and Recovery Performance Best Practices
  • RMANMultiplexing
  • Tuning Principles
  • Diagnosing Performance Bottlenecks
Backup and Recovery Workshop Scenarios
  • Workshop Approach to Solving Failure Scenarios
  • Workshop Structure
  • Business Requirements for Database Availability and Procedures

Govt approved Oracle Institute

All rights reserved. ©1999 - 2022, ISQL Global.

Terms of Service | Privacy Policy