Price 20,000.00 GST

Course Features
language
Language: English
access_time
50 hours
spellcheck
Study Level: Intermediate
terrain
Certificate of Completion

Oracle RAC, ASM, Data Guard Training

Table of Contents

Course Topics 

  • Oracle 12c Automatic Storage Management (ASM) – Install and setup 
  • Introduction and benefits of Oracle ASM. 
  • Oracle ASM 12c software installation and configuration (Grid Infrastructure) 
  • Partitioning Disks in LINUX using the fdisk utility 
  • What is device persistency and how Oracle ASMLib Utility can be used for device persistency
  • Oracle 12c ASMCA (ASM Configuration Assistant). 
  • ASM Parameter file, ASM Instance and working with DISKGROUPS.
  • Querying ASM Information using v$ views. 
  • Creating Database Files using ASM. 
  • Oracle Automatic Storage Management (ASM) – Mirroring Disks 
  • Understanding ASM Disk Redundancy (Mirroring). 
  • Learn about the three levels of ASM redundancy. 
  • How Oracle manages ASM Disk failures. 
  • How to replace a failed ASM disk with a new disk. 
  • ASM Disk Rebalancing operations. 
  • Oracle 12c Real Application Clusters (RAC) 
  • Components of an Oracle RAC environment. 
  • Understand the various storage, network and hardware requirements in Oracle RAC 

 

Oracle RAC, ASM, Data Guard Training

  • Setup two Linux servers in a network before creating a 2-Node Oracle RAC database. 
  • Pre-requisites for Oracle RAC installations. 
  • Installation and configuration of Oracle Grid Infrastructure in cluster mode.
  • Understand the functionality of Oracle Clusterware storage (Voting Disk, OCR Disk). 
  • How to backup and restore Oracle Clusterware storage (Voting Disk, OCR Disk). 
  • RAC Database connections 
  • Creation of an Oracle 12c Multi-tenant RAC database and instances using ASM storage. 8
  • Differences between a RAC database and the non-RAC database (single instance). 
  • How to change initialization parameters for an Oracle RAC database. 
  • Advantages of Oracle Single client access name (SCAN) in RAC database connections.
  • Understand and perform connection failovers of SCAN Listeners and Local Listeners. 
  • Understand database services for Oracle RAC in a multi-tenant architecture. 
  • Oracle Net Services configuration for a cluster database. . 
  • Oracle 12c RAC database backup and recovery  
  • How to backup Oracle RAC databases using RMAN Utility. 
  • Backup of Oracle RAC databases in a CDB (Multi-tenant) vs non-CDB environment. 
  • How to setup RMAN backup retention policies in an Oracle RAC database 
  • How to perform common administration operations in RAC databases 
  • How to use the cluster verify utility for performing health checks in Oracle RAC. 
  • How to utilize Global performance views (GV$ views) in monitoring RAC instances.
  • How to terminate database sessions in Oracle RAC. 
  • How to clear database transactional row level locks in Oracle RAC. 
  • How to perform Oracle database export and import operations in cluster mode.
  • Understand the new Oracle OPatchauto tool introduced in Oracle 12c
  • Oracle 12c Data Guard 
  • Introduction to Oracle 12c Data Guard and its various protection modes.
  • How to enable an Oracle database to belong to a Data Guard configuration. 
  • Understand the initialization parameter requirements of Primary and Standby databases.
  • Create a physical standby database using Primary database’s full RMAN backup. 
  • How to configure a Primary database to become a future standby database.
  • Managing a Data Guard Environment 

 

Oracle RAC, ASM, Data Guard Training

  • Understand Oracle data dictionary views for monitoring Log Shipping and Log Apply. 
  • Introduction to Oracle Data Guard broker (DGMGRL) utility 
  • Advantages of DGMGRL over the traditional sqlplus utility. 
  • How to create a Data Guard Broker configuration. 
  • How to perform a switchover operation using Data Guard Broker. 
  • Unique Teaching Methodology 

Overview

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today’s organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers.

All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle, Microsoft SQL Server, MySQL database etc.

DBAs play an important and responsible role in every company’s Information Technology (IT) department. DBAs are also very well paid and the average annual salary is more than $100,000 in the USA.

Furthermore, it is projected that the demand for DBAs will grow at the rate of 30% per year until 2023. www.cnn.com also published an article recently that Database Administrators are in the TOP TWENTY in-demand jobs for the next decade.

The leading technology job portal in the United States – www.dice.com often reports in its monthly job reports that DBAs are in the “Most Difficult to Fill” (due to shortage of qualified DBAs) IT job.

About DBA University, Inc.

DBA University, Inc. is a professionally run organization based in Chicago, USA specializing in training and services in computer database administration and development. We are currently offering training in Oracle DBA, Oracle RAC and ASM and Data Guard, Oracle SQL & PL/SQL, Microsoft SQL Server DBA, and Big Data with Hadoop using expert faculty and excellent REMOTE LAB access through affordable prices.

We are very dedicated and committed towards the success of our students. Our courses are very hands- on and aimed at job placement and preparing our students to face the real world with self-confidence and expert level technical skills in Oracle DBA, Oracle RAC and ASM and Data Guard, Oracle SQL & PL/SQL, SQL Server DBA and Big Data using Hadoop ar

Oracle RAC, ASM, Data Guard Training

Eligibility

Below is our recommended target audience for the Oracle RAC ASM and Data Guard course. This is considered an advanced course and the skills that are learnt from this training have a huge demand in the job marketplace.

  1. Students and Professionals who already have at least 1 year of experience in Oracle Database

Administration.

(OR)

  1. Students and Professionals who have already taken Oracle DBA Training course from DBA

 

REMOTE LAB Access

  • We provide a dedicated Remote Desktop Connection to each student to gain access to our Linux servers for performing Oracle 12c ASM lab practice exercises. This access time can be purchased for either 6 months or 12 months during the online course
  • DBA University provides remote LAB servers for the Oracle ASM topics. But for Oracle RAC topics and Oracle Data Guard topics, students will be provided with a special virtual machine developed by DBA University. We will give you the link to download it through a Dropbox folder. This will also help you to have a continued 2 node Oracle 12c RAC and Data Guard setup on your PC even after the training course is completed. Our training material screenshots and resources will make it very easy to build this 2 node Oracle RAC cluster. Students must have at least 8 GB of memory on their desktop (or) laptop. We support both Windows PC and Apple MAC computers.

Course Topics

Oracle RAC, ASM, Data Guard Training

Oracle 12c Automatic Storage Management (ASM) – Install and setup

  • Introduction and benefits of Oracle ASM.
  • Oracle ASM 12c software installation and configuration (Grid Infrastructure)
  • Partitioning Disks in LINUX using the fdisk utility
  • What is device persistency and how Oracle ASMLib Utility can be used for device persistency.
  • Oracle 12c ASMCA (ASM Configuration Assistant).
  • ASM Parameter file, ASM Instance and working with DISKGROUPS.
  • Querying ASM Information using v$ views.
  • Creating Database Files using ASM.

Oracle Automatic Storage Management (ASM) – Mirroring Disks

  • Understanding ASM Disk Redundancy (Mirroring).
  • Learn about the three levels of ASM redundancy.
  • How Oracle manages ASM Disk failures.
  • How to replace a failed ASM disk with a new disk.
  • ASM Disk Rebalancing operations.

Oracle 12c Real Application Clusters (RAC)

Oracle RAC, ASM, Data Guard Training

  • Components of an Oracle RAC environment.
  • Understand the various storage, network and hardware requirements in Oracle RAC
  • Setup two Linux servers in a network before creating a 2-Node Oracle RAC database.
  • Pre-requisites for Oracle RAC installations.
  • Installation and configuration of Oracle Grid Infrastructure in cluster mode.
  • Understand the functionality of Oracle Clusterware storage (Voting Disk, OCR Disk).
  • How to backup and restore Oracle Clusterware storage (Voting Disk, OCR Disk).

RAC Database connections

  • Creation of an Oracle 12c Multi-tenant RAC database and instances using ASM storage.
  • Differences between a RAC database and the non-RAC database (single instance).
  • How to change initialization parameters for an Oracle RAC database.
  • Advantages of Oracle Single client access name (SCAN) in RAC database connections.
  • Understand and perform connection failovers of SCAN Listeners and Local Listeners.
  • Understand database services for Oracle RAC in a multi-tenant architecture.
  • Oracle Net Services configuration for a cluster database. .

Oracle 12c RAC database backup and recovery

  • How to backup Oracle RAC databases using RMAN Utility.
  • Backup of Oracle RAC databases in a CDB (Multi-tenant) vs non-CDB environment.
  • How to setup RMAN backup retention policies in an Oracle RAC database

Oracle RAC, ASM, Data Guard Training

  • How to use the cluster verify utility for performing health checks in Oracle RAC.
  • How to utilize Global performance views (GV$ views) in monitoring RAC instances.
  • How to terminate database sessions in Oracle RAC.
  • How to clear database transactional row level locks in Oracle RAC.
  • How to perform Oracle database export and import operations in cluster mode.
  • Understand the new Oracle OPatchauto tool introduced in Oracle 12c.

Oracle 12c Data Guard

  • Introduction to Oracle 12c Data Guard and its various protection modes.
  • How to enable an Oracle database to belong to a Data Guard configuration.
  • Understand the initialization parameter requirements of Primary and Standby databases.
  • Create a physical standby database using Primary database’s full RMAN backup.
  • How to configure a Primary database to become a future standby database.

Managing a Data Guard Environment

  • Understand Oracle data dictionary views for monitoring Log Shipping and Log Apply.
  • Introduction to Oracle Data Guard broker (DGMGRL) utility
  • Advantages of DGMGRL over the traditional sqlplus utility.
  • How to create a Data Guard Broker configuration.
  • How to perform a switchover operation using Data Guard Broker.

Unique Teaching Methodology

We use a DIGITAL WHITE BOARD for teaching our online courses. Teaching with a DIGITAL WHITE BOARD gives our students a traditional classroom like experience. The faculty writes and draws by free hand on the DIGITAL WHITE BOARD and all our students can see it in real time in the online classroom.

chat_bubble_outlineReviews

Average Rating

0
No Votes 0 Votes
20,000.00 GST
0 Ratings

Detailed Rating

5 Stars
0
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0

There are no reviews yet.

Be the first to review “RAC & DATAGUARD”

Your email address will not be published. Required fields are marked *