Backup and Recovery with Oracle RMAN

Duration: 5 Half Days (~20 hours)

Teacher

Technical Requirements

Nothing is required for labs (workshops). SkillBuilders will provide everything you need for all hands-on labs. Modest PC or Mac specs are required to connect to the online class. Detailed specs can be found here.

Also, we strongly recommend using two monitors for this class.

Student Comments –

“The instructor’s willingness to work with us and our many questions surrounding how RMAN works with our new backup product – Actifio. He was phenomenal!”

“John [Watson], the instructor, is excellent!”

Click on the REVIEWS tab above to see many more student comments.

Course Features

Lectures 0
Quizzes 0
Duration 5 Half Days (~20 hours)
Skill level All levels
Language English
Students 67
Assessments Yes

Introduction to Recovery Manager

What is RMAN?
Basic Features
Use of Data Pump As Part Of A Backup Strategy

RMAN Architecture

RMAN Components
Component Releases
The Control File
Controlfile record keep time
Control File Size
NOCATALOG and CATALOG Mode
Recovery Catalog Creation And Maintenance

RMAN Setup

RMAN Installation
Necessary privileges
Password File
Oracle Net
Catalog Tablespace
Create Catalog
Register Database
RMAN Startup Options
The Fast Recovery Area

Executing RMAN Commands

RMAN Command Basics
Job Blocks
Command Syntax
Using SQL Statements from the RMAN Utility
Commonly Used Commands

RMAN Channels

Channel Concepts
Manual Allocation
Automatic Allocation
Parallelism

Backup with RMAN

Backup Concepts
Backup Set Concepts
Backupset Pieces
Using RMAN to Backup ASM Files
Control File and Spfile Backup
Deleting Archive Logs After Backup
Full Database, Tablespace, And Datafile Backup
Compressed Backup
Incremental and Cumulative Incremental Backup
Enabling Change Tracking
Using BACKUP for Image Copies
Incrementally Updated Copies
Backup Archive Logs
Retention Policies: Recovery Window And Redundancy
Overriding Retention Policy
Using the Duration Parameter

Restore & Recovery with RMAN

What Are We Protected Against?
Recovery-Related Commands
RESTORE Command
RESTORE PREVIEW
RECOVER Command
Recover Deleted Files
Recover Lost Tablespace
Restore to New Location
Incomplete (aka Point In Time) Recovery
Control File Recovery

Database duplication and auxiliary databases

For Standby
To create another primary
Duplication from backup or from the active database
Point In Time Tablespace Recovery
Table Recovery

Database flashback and the FRA

The Fast Recovery Area
Flashback technologies
Database flashback architecture
Configuring database flashback
Using database flashback
Database flashback and resetlogs

Scripting and Reporting

Scripting
Reporting
Reporting: LIST
Reporting: REPORT
Reporting: Views
Reporting: SHOW

Getting Started With Tapes

Media Management Concepts
Installing the MML
Backup to Tape
Environment Variables
Default Tape Channels
Configurable Tape Settings
Setting Default SBT Channels
Backup with Default Channels
Tape Restore

RMAN Maintenance

Expired Backups
Cross-Checking Backups
Listing Expired Backups
Status of All Backups
Deleting Expired Backups
Obsolete Backups
Deleting Obsolete Backups

RMAN Case Studies

Configure the database for recoverability in all circumstances
Diagnose problems
Use the Recovery Advisor
# 1 – Lost Control File
# 2 – Lost online or archive redolog file(s)
# 3 – Tuning
# 4 – Dropped Tablespace
# 5 – Damaged critical datafile
# 6 – Damaged non-critical datafile
# 7 – Dropped schema
# 8 – Damaged Temporary Tablespace
# 9 – Combinations of all the above

John Watson

https://skillbuilders.com/our_team/john-watson/

Student Reviews

T. Posner

October 8, 2021

I liked John and how he covered the material. He has a great personality and is obviously very knowledgeable. He was able to answer all our questions and broke down complicated topics into easy to understand steps and methods on how to resolve.

S. Guo

October 8, 2021

John is a great instructor – very knowledgeable and entertaining!

S. Balan

September 3, 2021

John explained the topic in detail.

C. Ermlich

September 3, 2021

Always a pleasure to work with John. His in-depth knowledge is just incredible and he always shows tons of examples and is always willing to go off-course a bit for any other questions we might have. Just an excellent experience every time.

B. Zeranski

January 29, 2021

Comprehensive view of all the particulars needed to design deploy and manage backup and recovery

Q. Vu

January 29, 2021

instructor is knowledgeable and communicates well; materials are well written and well presented

A. Wells

January 29, 2021

John made it relevant and entertaining. It’s good to get a handle on the new features that are coming out in the newer releases but he also ties it back into what we may already know from older releases.

A. Arya

April 9, 2020

I liked the course material and lab sessions.Training sessions were interactive.Last but not the least I was back for the trainer.

K. Csorgo

April 9, 2020

John is extremely prepared and he has a huge detailed knownledge in the topic. Answers every technical questions we have even if it is not one hundred percent connected to the topic. Very satisfied as always.

J. Challand

April 9, 2020

Everything was up to John’s usual high standard. Very satisfied.

Oracle DBA Training

Backup and Recovery with Oracle RMAN

Technical Requirements

Course Features

Student Reviews

T. Posner

S. Guo

S. Balan

C. Ermlich

B. Zeranski

Q. Vu

A. Wells

A. Arya

K. Csorgo

J. Challand

Login with your site account

Register a new account

Email preferences

Select your interests

Modal title