Oracle GoldenGate 12c

Course Duration: 50 Hours

Course Highlights:

  • Introduction to Oracle Real Application Cluster (RAC)
  • Install Oracle 11gR2 grid Software on both RAC Nodes on VMWare
  • Create database using DBCA on RAC
  • SRVCTL and CRSCTL tools
  • Single Instance to RAC migration
  • ASM (Automatic Storage Management)
  • Managing Backup and Recovery for RAC
  • High Availability of Connections
  • Administration activities on RAC

Required Prerequisites:

  • Basic Knowledge of Unix.
  • Oracle Database: Introduction to SQL
  • Good knowledge of Oracle Database Administrator 11g

Target Audience:

  • Oracle DBA who want to learn Oracle Real Application Cluster (RAC) which provide solution for High Availability and better Performance.

Download Oracle RAC 11g Brochure

Course Content

timeline_pre_loader

What is a cluster?

What is Oracle Real Application Cluster?

Benefits of using RAC

Oracle Clusterware

Oracle Grid Infrastructure

RAC Software Principles

RAC Software Storage Principles

Oracle Clusterware Architecture and Services

Goals for Oracle Clusterware

Oracle Grid Infrastructure for a Cluster

Oracle Clusterware Networking

Grid Plug and Play

Grid Naming Service

Single Client Access Name

Software Download 1 - VMWare , Putty, WinSCP

Software Download 2 –  Oracle Linux 6.4 32bit, Oracle GRID Software 11g

Software Download 3 – Oracle Database Software 11g, Xming (Optional)

Installation of VMWare on Windows O.S.

Installation of Oracle Linux 6.4 – 32bit on VMWare

Installation of VMWare Tool on Oracle Linux 6.4

Configure two IP Address – Private and Public

Connect with Putty to Oracle Linux 6.4

Perform pre-requisites activity to install Oracle GRID Software on Linux 6.4

Add Row Disks for ASM Configuration to Current Machine (called as Node 1)

Clone Node 1 to Node 2

Modify Configuration on Node 2

Copy GRID Software to Node 1 and install Clusterware on both the Nodes.

Install database software on both the server from Node 1

Create Disk Group in ASM for database

Create Database using DBCA

Check Cluster and DB Process using Linux Command.

What is SRVCTL and CRSCTL tool ?

What is difference between CRSCTL and SRVCTL?

Global Dynamic Performance View

SQL with Dynamic Performance view

SRVCTL Command

CRSCTL Command

SRVCTL RAC Administration Basic Activity

CRSCTL RAC Administration Basic Activity

Background process and Components of cluster

Database Background Processes

Prerequisites for Converting to Oracle RAC Databases

Oracle Clusterware Initialization

Startup process of cluster

Redolog files in RAC

Automatic Undo Management in RAC

Start Stop RAC instances with SQLplus

Start Stop RAC instances with SRVCTL

Initialization parameters in RAC

SPFILE Parameter Values and RAC

Identical parameters between nodes

Distinct parameters between nodes

Quiecing RAC databases

Terminate sessions in RAC

SQLplus commands and Instances

Find the Thread numbers of instances

ASM general architecture

ASM instance and crash recovery in RAC

SPFILE Parameter Values and RAC

ASM initialization parameters

ASM and SRVCTL with RAC

Need for Global Concurrency Control

Global Resource Directory (GRD)

Global Resource Management

Global Resource Remastering

Global Resource Recovery

Global Resource Background Processes

Global Resource Access Coordination

Global Enqueues

Instance Locks

Global Cache Management: Overview

Global Cache Management Components

Global Cache Buffer States

RAC and Instance Recovery

Instance Recovery and Database Availability

Instance Recovery and RAC

Protecting Against Media Failure

Media Recovery in Oracle RAC

Parallel Recovery in RAC

Archived Log File Configurations

RAC and the Fast Recovery Area

Archived Redo File Conventions in RAC

Oracle Recovery Manager

Configuring RMAN Snapshot Control File Location

Configuring Control File and SPFILE Autobackup

Crosschecking on Multiple RAC Clusters Nodes

Channel Connections to Cluster Instances

RMAN Channel Support for the Grid

RMAN Default Autolocation

Distribution of Backups

Shared Storage Backup Scheme: One Local Drive

Shared Storage Backup Scheme: Multiple Drives

Restoring and Recovering

RAC and Instance Recovery

Crash Node 1/Node 2 and check the availability of database

Setting Parallel_min_servers parameter

Enable and disable archivelog mode in RAC

Configure FRA to ASM disk group

Configure FRA to generate Archive logs

Configure proper naming convention to archive log files

Configure proper snapshot control file location

Configure Snapshot control file location

Configure AUTOBACKUP SPFILE and controlfile backups

Full database backup (No parallel slaves)

Full database backup with parallel slaves on same node

Full database backup with parallel slaves on other nodes(In run block)

Full database backup with parallel slaves on same node(Configured RMAN)

Full database backup with parallel slaves on other nodes(Configured RMAN)

Restore and recover a lost datafile.

Restore and recover database – With SPFILE

Restore and recover database – With LOST SPFILE

Crash Node 1/Node 2 and check the availability of database

Client-Side Connect-Time Load Balancing

Client-Side Connect-Time failover

Server-Side Connect-Time Load Balancing

Fast Application Notification: Overview

Fast Application Notification: Benefits

FAN-Supported Event Types

FAN Event Status

FAN Event Reasons

FAN Event Format

Connection Load Balancing in RAC

Transparent Application Failover: Overview

Example connection without TAF:

TAF Basic Configuration Without FAN: Example

Exercise demonstrating connection using service from windows

Relocating services

Bringing cluster down

Starting cluster

deleting services

Modifying services

Killing sessions

Monitoring blocks,LOCKS, DEADLOCKS

Starting cluster components

View number of nodes in cluster:

Check Cluster status:

identify OCR

Identify location of voting disk

OCR backups

adding additional voting disk

Shutting down all oracle services for any maintenance

Adding, Deleting, or Migrating Voting Disks

Locating the OCR Automatic Backups

Changing the Automatic OCR Backup Location

Adding, Replacing, and Repairing OCR Locations

Removing an Oracle Cluster Registry Location

Performing Manual OCR Backups

Recovering the OCR by Using Physical Backups

Recovering the OCR by Using Logical Backups

Oracle Local Registry

Determining the Current Network Settings

Methods of migrating single instance database to RAC.

Migrate a single Instance to 2 node RAC setup.

Configuration Changes During Oracle RAC Conversion Using rconfig

Prerequisites for Converting to Oracle RAC Databases

Scenarios to Oracle RAC Using rconfig

Converting non-RAC database files to ASM

Converting Databases to Oracle RAC Using rconfig

Download Oracle RAC 11g Brochure

Signup today and get latest Videos and Upcoming Courses for free and be the first to get notified on new updates.

Subscribe to our mailing list