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
Certificate Yes
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/

5/5

What did you particularly like about the course?
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.

Please describe your suggestions for improvement of the course.
More focus on multi-tenant. Though he did this when requested. I loved the 1/2 day layout. It was less mentally fatiguing and let me balance training and work.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
I think that platform worked well. We had no issues connecting and systems worked as expected.

Tracy Posner

October 8, 2021

5/5

What did you particularly like about the course?
John is a great instructor - very knowledgeable and entertaining!

Please describe your suggestions for improvement of the course.
Include more multitenant content into most of the chapters.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

Shaojing Guo

October 8, 2021

5/5

What did you particularly like about the course?
John explained the topic in detail.

Please describe your suggestions for improvement of the course.
I would appreciate if we had more hands-on

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
This is good enough

Shilpi Balan

September 3, 2021

5/5

What did you particularly like about the course?
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.

Please describe your suggestions for improvement of the course.
can't think of any. It is also very nice to have a full-size printed manual shipped ahead of time to work with and write notes in.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
no suggestions, works just fine. Audio and video works fine across the atlantic.

Chris Ermlich

September 3, 2021

5/5

What did you particularly like about the course?
Comprehensive view of all the particulars needed to design , deploy, and manage backup and recovery

Please describe your suggestions for improvement of the course.
Include the prompts in the examples so it is clearer if commands are to be run against os, sqlplus, or rman

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
Explicitly put all commands in exercises and change font or color to delineate it from other text.

Brian Zeranski

January 29, 2021

5/5

What did you particularly like about the course?
instructor is knowledgeable and communicates well; materials are well written and well presented

Please describe your suggestions for improvement of the course.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

Quoc Vu

January 29, 2021

5/5

What did you particularly like about the course?
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.

Please describe your suggestions for improvement of the course.
=) get my company to invest in more of them?

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
no, it was great!

April Wells

January 29, 2021

5/5

What did you particularly like about the course?
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.

Please describe your suggestions for improvement of the course.
Maybe more examples of usage from real life - working production systems.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

krisztian.csorgo@ni.com Csorgo

April 9, 2020

5/5

What did you particularly like about the course?
Excellent course and instructor! Thank you John W!

Please describe your suggestions for improvement of the course.
If you can provide some exercise answers, it will be great to compare our result with instructor\'s answers.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

Yan Jiang

April 9, 2020

5/5

What did you particularly like about the course?
There was plenty of information in this course to digest and lots to consider and reconsider for implementing an oracle backup strategy.

Please describe your suggestions for improvement of the course.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

Adam Kendrick

April 9, 2020

Details Price Qty

05/08/23 - 05/12/23show details +hide details - $3,200.00 (USD) Quantity

Details

Price

Name	Description	Amount
05/08/23 - 05/12/23		$3,200.00 (USD)
Total		$3,200.00 (USD)

Sale Dates

- The dates when this option is available for purchase.
Goes On Sale: February 13, 2023 8:00 am
Sales End: May 8, 2023 8:00 am

Access

- This option allows access to the following dates and times.

Date	Time
05/08/23 - 05/12/23 May 8, 2023 to May 12, 2023	9:00 am to 1:00 pm

please do not enter anything in this input

Oracle DBA Training

Backup and Recovery with Oracle RMAN

Technical Requirements

Course Features

Details

Price

Sale Dates

Access

Login with your site account

Register a new account

Email preferences

Select your interests

Modal title