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 YouBy 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