Practice with Oracle RMAN
3.9 (48 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
623 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Practice with Oracle RMAN to your Wishlist.

Add to Wishlist

Practice with Oracle RMAN

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
3.9 (48 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
623 students enrolled
Created by Luis Diaz
Last updated 2/2016
English
Price: $20
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 2 Articles
  • 13 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • 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.
Compare to Other Oracle RMAN Courses
Curriculum For This Course
46 Lectures
06:32:28
+
Recovery Manager brief presentation
5 Lectures 34:31


This is a description of this fantastic tool. What can we do with it, what are the situations we'll need it.

Preview 16:26

NLS and SHOW ALL
15:51

End of the first block
3 pages
+
Create a Rman catalog in 5 minutes
7 Lectures 52:22
Topics of block 2
3 pages

Overview of the rman catalog
10:07

Configure the Recovery Manager catalog instance
08:49

Create the Catalog schema owner
07:53

Example of register and unregister a database
13:00

Get your Rman catalog safe, and make an export in order to have a backup.

Make a backup of your backup system
12:33

Summary of the second block
3 pages
+
Rman maintenance
6 Lectures 46:49
Topics of third block
3 pages

In this topic, we'll see how the catalog get the information from control file to be always syncronized with.

Get Rman synchronized, part I
10:09

Get Rman synchronized, part II
11:29

What happend if you change de db_unique_name in your dataguard environment ? Response here

Update catalog after db_unique_name modification
05:34

This section show the relation between backup sets and the reset of the redo log files

About database incarnation
19:37

Summary of the third block
3 pages
+
Backups with Rman
10 Lectures 01:47:36
Topics of block 4
3 pages

Simple backup of database with and without FRA
12:29

Backup of datafiles, tablespaces, controlfile and spfile
11:10

Backup archivelogs options
10:50

Compression concepts
19:11

Retention policy
10:00

Consistent or inconsistent concepts with Rman
11:33

Incremental backups: Differential and cumulative Part I
19:33

Incremental backups: Differential and cumulative Part II
12:50

End of block 4
3 pages
+
Restore and Recover your database with Rman
5 Lectures 30:09
Topics of block 5
3 pages

Restore process: Restore init file
12:04

Restore process: Restore the control file
06:19

Restore datafiles, recover database and open resetlogs
11:46

What we learn in block 5
3 pages
+
Use Rman to duplicate a database
9 Lectures 59:00
Topics of the block 6
3 pages

This preparation is valid for both duplicate techniques (backup of active)

Create password file and start new instance
08:35

Manage listener and tnsname config
06:44

List datafiles and redologs, create ASM directories
04:48

Make a duplicate database from backup
16:45

Make a duplicate database from active database, part I
13:24

Make a duplicate database from active database, part II
08:44

End of the course
3 pages

Annexe, all the scripts
9.1 kB
+
Some backup scripts
2 Lectures 03:01
Cold backup on disk
01:31

Backup database to Fra
01:30
+
Add on
2 Lectures 19:01
Add on: Presentation
3 pages

In this lecture, we'll learn how to use backup files stored in ASM diskgroup, and restore them into a standard file system

Move backup files from ASM to FS
19:01
About the Instructor
Luis Diaz
3.7 Average rating
168 Reviews
1,276 Students
9 Courses
Database dba since 2005

I was born in Spain and then travel to Paris where I start studying databases.

Then I go back to Spain and since 2005 I work exclusivly as Oracle dba. During several years I work in diferents environments and I touch a lot of Oracle technology. Here is part of this knowledge. Most recently, I work with Oracle 12c grid version, Oracle dataguard 11g and some other technologies as Rman o Oracle FlashBack.

Citare aqui unas de las operaciones que realize con exito:

- Mantenimiento de las instancias de Oracle

- Migración Grid control de 10G a 11G

- Migración de datos de un diskgroup a otro. (Cambiar discos de cabina)

- Copia de seguridad diseño de las políticas de recuperación de las bases de datos

- Instalación diseño e instalación de nuevo RAC entornos ASM ersión 11gR2

- Seguimiento con las herramientas de monitoring de OVO, Grid Control y Ganglia

- Creación de nuevas alarmas para OVO

- Restoración de bases de datos con RMAN duplicate

- Formación de un equipo de desarolladores con Oracle FlashBack. Simulamos perdidas de datos tras una release y recuperamos los datos perdidos gracias a FB