دوره ها

Oracle Database 11g: Backup and Recovery Workshop

• کد دوره : OR224
• مدت دوره : 24 ساعت
• شهریه : 0 ریال

برای این دوره ، کلاس عمومی برنامه ریزی نشده است.
لطفا پیش ثبت نام نمایید

What you will learn:

After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course reviews the backup and recovery techniques that are discussed in the Oracle Database 11g: Administration Workshop I and II courses, and examines various backup, failure, restore, and recovery scenarios. Students are expected to have some knowledge of Recovery Manager (RMAN) and Enterprise Manager, as they will 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.

Extensive hands-on practices and workshops provide the student with experience in a realistic technical environment. This course includes interactive workshops that provide participants with the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies.

This course is based on Oracle Database 11g Release 2 Patch Set 1.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification and Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.

Learn To:

Develop appropriate backup and recovery procedures to address your business needs
Employ Oracle Database recovery procedures to recover from media failure
Use Flashback Technologies to complement backup and recovery procedures Technologies

Audience:

Database Administrators
Technical Consultant
Technical Administrator

Prerequisites:

Required Prerequisites:

Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Administration Workshop II

Course Objectives:

Perform tablespace point-in-time recovery
Describe the Oracle Database architecture components related to backup and recovery operations
Describe additional high availability features such as Oracle Data Guard and Oracle Secure Backup
Plan effective backup and recovery procedures
Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure
Configure the database for recoverability
Use Recovery Manager (RMAN) to create backups and perform recovery operations
Use the Data Recovery Advisor to diagnose and repair failures
Use Oracle Flashback Technologies to recover from human error
Perform an encrypted database backup and restore

Course Topics:

Introduction

Assessing Your Recovery Requirements
Data Failures Examples
Failure Categories
Oracle Data Protection Solutions
Oracle Backup and Recovery Solutions
Oracle Maximum Availability Architecture
Oracle Secure Backup (overview only)
Oracle Active Data Guard (overview only)

Using Recovery Manager (RMAN) and Enterprise Manager

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

Configuring for Recoverability

Fast Recovery Area (overview)
Fast Recovery Area Sizing and Configuration
Control File Multiplexing & Autobackup
Redo Log Files and the LGWR Process
Redo Log File Multiplexing
RCHIVELOG Mode and the Archiver Process
Archived Redo Log Files
Undo Retention

Using the RMAN Recovery Catalog

Repository Comparison
Recovery Catalog Overview
Creating the Recovery Catalog
Managing Records in the Catalog
Registering the Database
Catalog Resynchronization
Backing Up the Recovery Catalog

Backup Concepts and Strategies

Backup Solutions Overview
Backup Terminology
RMAN Backup Types
Understanding RMAN Backup Data Flow
Balancing Backup and Restore Requirements
Comparing Backup Strategies
Best Practices for Data Warehouse Backups

Creating Backups

Oracle Suggested Backup Strategy
Backups Sets & Image Copies (RMAN)
Whole Database Backups
Read-Only Tablespace Backups
Checking for Block Corruption
Block Change Tracking/Fast Incremental Backups
Backup Compression & RMAN Encrypted Backups
Control File Backups & Cataloging Backups Files

Restore and Recovery Concepts

Employing the Best Oracle Technology for Recovery
Instance Failure and Instance/Crash Recovery
Media Failure
Complete Recovery (Overview)
Point-in-Time Recovery (Overview)
Recovery Through RESETLOGS
Recovery to an Abandoned Incarnation

Using Data Recovery Advisor

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

Performing Recovery

Data File Loss (file system and ASM)
RMAN Recovery: NOARCHIVELOG Mode, Complete, Image Files & Point-in-Time (Incomplete recovery)
Control File Loss and Recovery & RMAN Recovery: Backup Control File
Redo Log File Loss and Recovery, Index Tablespace Recovery & Read-Only Tablespace Recovery
Password Authentication File Re-creation, Server Parameter File Recovery & Tempfile Recovery
Restoring RMAN Encrypted Backups
Block Media Recovery
Restore and Recovery Performance Best Practices