Oracle 11g Administration Training: Oracle 11g Backup & Recovery

Course Number: ORC-210
Duration: 3 days
view class outline

Oracle 11g Backup & Recovery Training Overview

Accelebrate's Oracle 11g Backup and Recovery training teaches attendees how to backup and recover a portion or all of an Oracle 11g database.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=oracle.

Oracle 11g Backup & Recovery Training Prerequisites

Oracle 11g Administration I Training, Oracle 11g SQL Training, and Oracle 11g PL/SQL Training or equivalent real-world experience.

Hands-on/Lecture Ratio

This Oracle^® course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.

Oracle 11g Backup & Recovery Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

A complete installation of Oracle 11g

Please contact us for detailed setup instructions if you have purchased this class.

Oracle 11g Backup & Recovery Training Objectives

All attendees will learn how to:

Use Oracle flashback technology to recover from user errors and from database failures, including flashback data archive and flashback transaction backout along with the Total Recall capability
Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flasback Transaction Backout wizard, database Recovery Wizard, Recovery Advisor interface, and others
Setup database instance recovery, tuning checkpoints, the Redo Log File Size Advisor, and the MTTR Advisor
Implement User-managed recovery scenarios, including recovery from temporary, read-only, and index tablespaces
Implement automatically managed backup strategies and database recovery operations using RMAN and other database facilities
Build upon basic RMAN capabilities with a centralized recovery catalog
Deploy standardized and consistent backup and recovery procedures throughout the enterprise by means of dynamic stored scripts and variable substitution
Optimize backups for faster performance and parallelization of operations, employing compression algorithms and other strategies for efficiency
Set up data preservation through archival backups
Implement security through transparent and explicit encryption features
Duplicate databases for regulatory compliance, Real Application Testing database replay, test configuration, and other purposes
Detect and handle failures and corruption, including the use of RMAN block recovery and the Data Recovery Advisor

Oracle 11g Backup & Recovery Training Outline

Recovery Concepts

About The Backup & Recovery Structures
Managing Redo Data
Managing Archived Redo Data
Creating A Foundation For Sound Recovery

Oracle Flashback Technology

About Flashback Technology
Flashback Query
Select...As Of Timestamp
Select...As Of SCN
Configuring Undo Management For Flashback
Undo_Retention
Flashback Table
Flashback Drop
Flashback Versions Query
Flashback Transaction Query
Flashback Transaction Backout

Flashback Database

About Flashback Database
Configuring The Flash Recovery Area
Performing Database Flashback
Monitoring Flashback Performance
Flashback Database Considerations
Configure Flashback Data Archive

Instance Recovery

About Instance Recovery
Instance Recovery Parallelism
Mttr Advisor & Tuning Checkpoints
Log_Checkpoints_To_Alert
Redo Logfile Size Advisor
Fast-Start On-Demand Parallelism

Configuring RMAN

RMAN Architecture
Launch & Use RMAN
Configure RMAN Settings
Allocate RMAN Channels

Backup With RMAN

About Backup File Types
Performing Full Backups
Performing Incremental Backups
Establishing A Backup Retention Policy
Generate Reports
Report Unrecoverable
Report Need Backup
List Incarnation

RMAN Management With EM

Monitoring The Flash Recovery Area
The EM Interface To RMAN
Scheduling RMAN Backups
Using The Oracle-Suggested Backup Strategy
Manage Current Backups
Backup Reports
Manage Restore Points

User-Managed Recovery Operations

Recovery Concepts
Recover Temporary Tablespaces
Recover Read-Only Tablespaces
Recover Index Tablespaces
Recover Redo Log Group Member
Recreate The Password File

Recovery With RMAN

Complete Media Recovery
Incomplete Media Recovery
Recovery Using EM

Using The RMAN Recovery Catalog

Understanding Catalog Concepts
Create The Recovery Catalog
Manage Virtual Private Catalogs
Data Protection Of The Recovery Catalog
Using RMAN Scripts

Database Duplication & Cloning

Why Perform Database Duplication?
RMAN Duplicate Database
RMAN Duplicate
Database Cloning

Advanced RMAN Capabilities

Backup Optimization
Enhancing Parallelism With Section Sizes
Archival Backups
Backup Set Encryption
Copying Files Between Databases

Transporting Tablespaces

About Tablespace Transportation
Read-Only Tablespace Transportation
Read-Write Tablespace Transportation
Transport Tablespaces Using EM

Recovering From Corruption With Data Recovery Advisor

How Does Corruption Occur?
Detecting Corruption
Analyze
V$Database_Block_Corruption View
Db_Block_Checking
Db_Block_Checksum
Db_Lost_Write_Protect
Db_Ultra_Safe
Recovery Using The Data Recovery Advisor
Block Media Recovery
Isolating Corruption With Dbms_Repair()

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.