Oracle Database 10g DBA Backup & Recovery with RMAN

3 days @ £1,495.00 exc. VAT

Course Code: O10GDBABR

Virtual Events You can attend your training virtually using the London dates shown above. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.

Oracle Database 10g DBA Backup & Recovery with RMAN Course Overview

Delegates will learn how to plan and implement a backup and recovery strategy using Recovery Manager. They will perform backup and recovery operations using RMAN and Enterprise Manager. They will use Flashback features to recover from human error.

This Oracle Database 10g DBA Backup & Recovery with RMAN course is suitable for users of Oracle Database 10g and Oracle Database 11g Release 1 and Release 2.

The delegate will learn and acquire skills as follows:

Planning a backup and recovery strategy and a disaster recovery strategy
Altering a database to archivelog and noarchivelog modes
Creating and managing a recovery catalog database
Using Recovery Manager to perform backups
Using Recovery Manager to perform recoveries
Monitor and Tune Recovery Manager
Performing tablespace point-in-time recovery
Creating a duplicate database
Using Flashback technology to recover from errors

Who will the Course Benefit?

The Oracle Database 10g DBA Backup & Recovery with RMAN course is designed for database administrators, data warehouse administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle Database 10g or Oracle Database 11g Release 1 and Release 2 databases.

Course Objectives

The Oracle Database 10g DBA Backup & Recovery with RMAN course is designed to provide the skills needed to plan and implement backup and recovery strategies for Oracle Database 10g or Oracle Database 11g Release 1 and Release 2 databases using RMAN and Flashback.

Requirements

A working knowledge of Oracle SQL and Oracle Database Administration is required to attend the Oracle Database 10g DBA Backup & Recovery with RMAN course. This can be obtained by attendance on the Oracle SQL and Oracle Database 10g DBA - Part I or Oracle Database 11g DBA - Part I courses.

Pre-Requisite Courses

Follow-On Courses

Oracle Database 10g DBA Performance & Tuning

Notes:

Course technical content is subject to change without notice.
Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

View Course Contents - DAY 1

Oracle Database 10g DBA Backup & Recovery with RMAN Training Course

Course Introduction

Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions

Session 1: BACKUP AND RECOVERY CONSIDERATIONS

Plan and Implement a Backup and Recovery Strategy
Define a Disaster Recovery Plan
Test a Backup and Recovery Plan
Advantages and Disadvantages of Different Backup Methods
Data Recovery Strategy
Backup Strategy
Validate the Recovery Strategy

Session 2: ORACLE RECOVERY STRUCTURES AND PROCESSES

Architectural Components of Backup and Restore
Redo logs, Checkpoints and Archives
Multiplexing Control files and Redo Logs
Types of Failure in an Oracle Database
Flash Recovery Area

Session 3: USING ARCHIVELOG AND NOARCHIVELOG MODES

The Archive Modes of a Database
Configure a Database in Archivelog Mode
Configure a Database in Noarchivelog Mode
Configure Multiple Redo Log Archive Processes
Configure Multiple Archival Destinations

Session 4: FLASHBACK

Configure and Use Flashback Database
Monitor Flashback Database
Flash Recovery Area Space Usage
Flashback Query
Retrieve Row History with Flashback Versions Query
Audit or Recover From Transactions with Flashback Transactions Query
Flashback Table
Recover Dropped Tables with Flashback Drop
The Recycle Bin
Recover Tables to a Point In Time With Flashback Table
Flashback Database
Flashback Restore Points
Flashback Transaction Backout
Oracle Total Recall

Session 5: RECOVERY MANAGER OVERVIEW

RMAN Features and Components
Connect to RMAN
Start Up and Shut Down a Target Database Using RMAN

View Course Contents - DAY 2

Oracle Database 10g DBA Backup & Recovery with RMAN Training Course

Session 6: CREATE AND CONFIGURE A RECOVERY CATALOG

Session 7: BACKUP WITH RMAN

Session 8: MAINTAIN A RECOVERY CATALOG

Reset Command
Change the Availability Status of Backups and Copies
Catalog Backups Made with Operating System Commands
Generate Reports and Lists
Cross Check Backups and Copies
Delete Backups
Update the Repository after Backup Deletion
Drop Database and Archival Backups
Use Data Dictionary Tables

Session 9: RESTORE AND RECOVER WITH RMAN

Perform Recovery in Noarchivelog Mode
Perform Complete Recovery in Archivelog Mode
Perform Incomplete Recovery
Use the Flash Recovery Area for Fast Recovery
Restore and Recover a tablespace
Automatic Tempfile Recovery
Restore and Recover Datafiles
Recover a Datafile Not Backed Up
Restore the Server Parameter File
Restore the Control File from Auto-Backup
Restore and Recover the Database on a New Host

View Course Contents - DAY 3

Oracle Database 10g DBA Backup & Recovery with RMAN Training Course

Session 10: TABLESPACE POINT IN TIME RECOVERY (TSPITR)

Tablespace-Point-in-Time Overview
Tablespace-Point-in-Time Example

Session 11: CREATE A DUPLICATE DATABASE WITH RMAN

Database Duplication
Duplication Options
Create Files for the Duplicate Database
Prepare the Auxiliary Instance for Duplication
Create a Duplicate Database
Create a Duplicate Database with Enterprise Manager
Clone a Running Database
Use EM to Clone a Running Database
Targetless Duplication of a Database

Session 12: MONITOR, TUNE AND TROUBLESHOOT BACKUP AND RECOVERY

Tune recovery Manager Overview
Tune RMAN Backup Performance
Instance Recovery Performance Tuning
Understand RMAN Output Messages
Troubleshoot RMAN

Appendix: OVERVIEW OF ORACLE SECURE BACKUP

Oracle Secure Backup Overview
Oracle Secure Backup Product Family
Encrypted Backups
Oracle Secure Backup Interfaces
Oracle Secure Backup Web Tool
Oracle Secure Backup Command Line Tool
Oracle Enterprise Manager and Grid Control
Recovery Manager Command Line Interface
Media Management Expiration Policies
Domain Security
Overview of Backup to Amazon Simple Storage Service using OSB Cloud Computing

Home Let Us Call You Enquiry

Place A booking

97.35%
Instructor
Quality
Rating

92.54%
Course
Practical
Rating

94.35%
Overall
Courseware
Rating

96.29%
Overall
Course
Rating

Print Friendly

97.35%
Instructor
Quality
Rating

96.29%
Overall
Course
Rating

Course Reviews

Instructor was very knowledge about not only the course material but other material connected; he was also able to tailor the material to our needs.

Chris - Control Systems Engineer - Utilities

Overall facilities very good and instructor tailored the course to our requirements.

Tony - Control System Engineer - Utilities

Good course - targeted at the correct level for me certainly and I kept pace comfortably. Handy as there were only two of us on the course. Marian made sure we understood and were comfortable with what we were being shown

Mike - Oracle DBA - IT Services

More Course Reviews....

I studied the Oracle Backup & Recovery course because I needed to know more about it for my job. It was a great course. Good presentation, material and very well explained. Highly recommended to anyone!

Suki - Oracle DBA - IT Services

Please call for Dates

Request a Centre .......

If the course you require is not scheduled at your preferred centre, please contact us on 020 7600 6116 or sales@stayahead.com to enquire if we can accommodate your venue requirements.

Enquiry