Easy way to set Oracle Active Dataguard
3.7 (17 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.
259 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Easy way to set Oracle Active Dataguard to your Wishlist.

Add to Wishlist

Easy way to set Oracle Active Dataguard

Learn how to create a physical DataGuard from a primary database, using Rman duplicate technology.
3.7 (17 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.
259 students enrolled
Created by Luis Diaz
Last updated 1/2016
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Install and configure Oracle active dataguard
  • Configure Listener for the comunication between Primary and Standby databases
  • Use Rman duplicate technology
  • Use Oracle Broker tool to perform switchovers
View Curriculum
Requirements
  • Students needs to set 2 virtual machines with all the Oracle requisits to install rdbms 11g
  • In first virtual machine, you need to have a database installed and running yet
  • In the other virtual machine, you need to have the binary installed only
Description

During this course, you will learn what is a DataGuard, what are the different settings and usage examples.

We will settup together active DataGuard using 2 separate virtual machines. This set allows us to simulate

a real case as much as possible because we will have 2 physical separate servers. We'll use advanced installation

techniques with rman duplicate for standby and the Oracle broker to manage the dataguard.

Come to this course you'll love it, not to be missed.

During the course you will see the folowing key words:

Dataguard (DG)

Rman duplicate

Listener

Oracle net

Broker

Password file

switchover

The course consists on videos, you will find the road map for the creation of DataGuard, in a txt file with all

the querys and useful commands.

The course is about four hours and a half and it's splited in 4 blocks. Each block with different chapters.

The 1st block is the description of the Primary set, and then the settup it self. We will use 2 virtual machines

to obtain a more realistic simulation, since each virtual machine will represent a diferent site.

We'll simulate a base in Madrid and another in Barcelona.

Then we'll create the standby database setting up Rman duplicate.

Then we'll speack about how the broker is configured and used. The broker is a tool that allows an easy and

intuitive management of DataGuard.

The last block is monitoring and managing backups and more specifically the archivers.

This course is a luxury ally for all DBA who want to set up a high availability system.

Thanks to this course you'll forget the doubts.

Who is the target audience?
  • To take this course, students need to know about Oracle database
  • Students need about Oracle Rman too
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 26 Lectures Collapse All 26 Lectures 03:23:21
+
Introduction
3 Lectures 16:42
+
Settup of Oracle Active Dataguard
11 Lectures 01:46:11
Topics of this section
01:32

Introduction setup Primary
03:10

In this section we'll see a txt file with all the steps to do.

Primary setup ; headlines
05:54

In this section, we'll execute in a database, all the steps seen in lecture 6

Primary setup practice
16:25

The creation of the standby instance is a basic step, very simple and fast.

Create the standby instance
13:58

Net configuration for RMAN Duplicate
09:20

Creation of the standby with Rman Duplicate
20:11

Post duplicate steps Part1
10:19

Post duplicate steps Part 2
11:26

Add on: Change tnsnames entry and check Redo apply
11:35

End of this section
02:21
+
Oracle Broker
7 Lectures 37:50
Topics of ths section
01:17

Move standby to read only mode
05:26

Active/Desactive the apply manager
03:09

Setup the broker ; Init parameters start and stop broker
07:01

Some broker commands
06:04

Let's make a switchover
13:27

End of block 3
01:26
+
Monitoring and archivers managment
5 Lectures 43:31
Topics of this section
00:44

Monitoring script
16:48

Backup managment and archivers
17:35

End of this course
01:03

Course material
07:21
About the Instructor
Luis Diaz
4.0 Average rating
130 Reviews
1,093 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