Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Practice with Oracle RMAN

Name: Practice with Oracle RMAN
Rating: 3.7 (131 reviews)

This is a practice course. Here you'll find a lot of interesting demos and how to. Just to learn all the facets of RMAN

Created byLuis Diaz

Last updated 2/2016

English

What you'll learn

Set rman catalog
Make all type of database backups
Understand concepts as compression and retention policy
Make a restoration of your database from scratch
Use duplicate command

Course content

8 sections • 46 lectures • 6h 32m total length

Topics of block 13:00
Short introduction on what we'll do2:14
Explore practice-focused Oracle RMAN workflows by simulating rare scenarios and applying best practices to backups, restores, and duplicates across conceptual and hands-on blocks.
RMAN equal Recovery Manager16:26
This is a description of this fantastic tool. What can we do with it, what are the situations we'll need it.
NLS and SHOW ALL15:51
Learn how to configure RMAN backups with formats, redundancy, and recovery windows, including keeping two to three backups, pruning old backups, and managing backup sets, archived logs, and encryption.
End of the first block3:00

Topics of block 23:00
Overview of the rman catalog10:07
Explore how the RMAN catalog provides redundancy, centralizes backup metadata, and enables easy restoration, reporting, and script sharing across multiple databases.
Configure the Recovery Manager catalog instance8:49
Configure the recovery manager catalog to store backups and metadata by setting up a dedicated database and allocating space for production use.
Create the Catalog schema owner7:53
Example of register and unregister a database13:00
Make a backup of your backup system12:33
Get your Rman catalog safe, and make an export in order to have a backup.
Summary of the second block3:00

Topics of third block3:00
Get Rman synchronized, part I10:09
In this topic, we'll see how the catalog get the information from control file to be always syncronized with.
Get Rman synchronized, part II11:29
Learn to synchronize the RMAN catalog with the database, performing full synchronization after changes and accounting for a seven-day catalog delay. Understand matching metadata and database naming considerations.
Update catalog after db_unique_name modification5:34
What happend if you change de db_unique_name in your dataguard environment ? Response here
About database incarnation19:37
This section show the relation between backup sets and the reset of the redo log files
Summary of the third block3:00

Topics of block 43:00
Simple backup of database with and without FRA12:29
Backup of datafiles, tablespaces, controlfile and spfile11:10
Backup archivelogs options10:50
Compression concepts19:11
Retention policy10:00
Consistent or inconsistent concepts with Rman11:33
Explore the difference between consistent and inconsistent backups, noting that a closed database yields matching control and data files, while open backups need log files for recovery.
Incremental backups: Differential and cumulative Part I19:33
Incremental backups: Differential and cumulative Part II12:50
End of block 43:00

Topics of the block 63:00
Create password file and start new instance8:35
This preparation is valid for both duplicate techniques (backup of active)
Manage listener and tnsname config6:44
List datafiles and redologs, create ASM directories4:48
Learn to list datafiles and redo logs, gather metadata with a simple query, and create asm directories to prepare for duplicating a database with RMAN.
Make a duplicate database from backup16:45
Make a duplicate database from active database, part I13:24
Learn to duplicate an Oracle RMAN database from an active source without backups, connecting to the source and pumping data to a remote clone at sites like Madrid and Barcelona.
Make a duplicate database from active database, part II8:44
End of the course3:00
Annexe, all the scripts

Requirements

All you need to know will be explained in this course
Oracle managment is a good point to start this course

Description

Welcome to this Oracle Rman course !!

First of all I would like to say that this course is a mix of real situations plugged into blocks and lectures. You'll not find a copy paste of the Oracle documentation, even if I always use it to create the lessons, and I'll give you a lot of oficial documentation references. So yes, if you pick up this course you'll find a lot of way to make properly all you need to do in your day by day as Oracle dba.

During this course we'll se the following topics:

- Short Rman presentation

- How to create a Rman catalog

- How to configure all the options of Rman

- How to make maintenance of Rman in order it works always fine

- Make some backups

- Restore a full database from scratch

- Use Rman to duplicate database

All this topics will be demos... You'll get all the technics usefull to make this and additionally to the videos, you'll have the sql sentences and rman commands into a txt file.

The course is structured to go from the most easy task to the most complicated one. The evlolution of the topics is done to make it easy for all the students.

The main caracteristic of why you need this course is the fact that I'll not speack about theory, just practice. This is all the students wants, how to make something and make it properly, with always the Oracle best practices methods.

The target that should take this course are all the Oracle dba that start using this database and need more skills to get a job or to consolidate themselves in this complicated job. It can be usefull for all the people that need to improove the looseness when you are facing a complicated situation.

If production database is lost, you need to know how to restore it from a backup. If your departement need a copy of the production database to test some new release code, then you can use the duplicate command to create it. There are a lot of situation that the Rman skills of the dba are required and this course is perfect to get the Oracle knowledge.

So do not have more doubts, let take this course and get the control of RMAN.

Who this course is for:

This course is perfect for junior dba that want to start using Rman.
This course is not a preparation for the certification.
This course is a group of real situation and the technical resolution steps.

Practice with Oracle RMAN

What you'll learn

Explore related topics

Course content

Recovery Manager brief presentation5 lectures • 41min

Create a Rman catalog in 5 minutes7 lectures • 58min

Rman maintenance6 lectures • 53min

Backups with Rman10 lectures • 1hr 54min

Restore and Recover your database with Rman5 lectures • 36min

Use Rman to duplicate a database9 lectures • 1hr 5min

Some backup scripts2 lectures • 4min

Add on2 lectures • 22min

Requirements

Description

Who this course is for: