Best Oracle RAC DBA training 10daneces

Oracle RAC (Real Application Cluster)

4 Star Rating: Very Good 4.40 out of 5 based on 315 ratings.
  • Overview
  • Course

10Daneces is the best known for its “Oracle RAC (Real Application Cluster)” course for every kind of students whether freshers, College Students, Professionals or non professionals to fulfill the needs of dynamic IT companies. We focus on quality of practical knowledge and concept clarity. We have Oracle expertise trainers who are also working on real time projects. Moreover, Course completion and project completion certificates will also be provided on completion of the course. We have also association with major MNCs & Agencies to place our candidates.

Oracle RAC (Real Application Cluster) enables clustering of database from various servers, which aids in storage and enables high scalability, availability, and manageability. Students will learn how to install and manage Oracle Real time Application Clusters and Automatic Storage Management.

Benefits of Oracle RAC:-

  • Reliability
  • Recoverability
  • Error Detection
  • Continuous Operation

By the end of this training,the aspirants will acquire the knowledge in the following skillsets :

  • Identify Real Application Clusters components and Shared Storage Technologies
  • Install RAC database and create cluster database
  • Use Enterprise Manager Grid Control
  • Use configuration tools for RAC databases
  • Manage instances and determine RAC-specific wait events, global enqueues, and system statistics
  • Configure and manage services in a RAC environment
  • Determine and review applications high availability and mange workload
  • Plan and implement backup and recovery strategy
  • Configure and monitor Oracle Clusterware resources
  • Administer Oracle Clusterware resources
  • Add/Remove a node to/from a cluster.
  • Patch Oracle Clusterware and RAC software in a rolling fashion.

 

Target audience :

  • Database Designers
  • Database administrators
  • Data Warehouse Administrator
  • Technical Administrator
  • System Analyst
  • Support Engineer
  • Consultants

 

Prerequisites :

The candidates having familiarity with Oracle Database Architecture(DBA) and administration are the ideal participants for this course.

 

Exams for Certification :

Exam Name Exam Code
Oracle Real Application Clusters 11gR2 :Admin 1Z0-053

Introduction to RAC 11g

  • The Dynamic Business Environment
  • The Explosive Growth of Business Data
    • Online and Real-Time Access to Corporate Data
    • Data Warehousing, Packaged Applications, E-Commerce Operations
    • Dependence on Database Management Systems
    • High Performance Systems
  • Introduction to Cluster Technology
  • Benefits of Real Application Clusters (RAC)
    • What is a DB Cluster?
    • Architectures of DB Clusters
    • What is a Cluster Interconnect?
  • Problems with Other Architectures
    • The IBM Shared-Nothing Configuration
    • Microsoft Federated Servers Database
  • Seeing the High Availability Spectrum
  • Real Application Clusters
    • Processing Prior to Cache Fusion
  • Oracle Real Application Clusters
    • Attributes of an Oracle RAC Cluster
    • Building an Oracle RAC Cluster
    • RAC Performance and Scalability

RAC 11g High Performance and Highly Available Databases

  • Growth of Powerful Processors
  • Why Parallel Processing?
  • Opportunities for Parallelism
  • Scalability
  • Parallel Databases
    • Types of Parallelism
  • High Performance Computing Cluster HPCC
  • Clusterize Applications
    • How Do You Clusterize Applications?
  • Highly Available Databases
    • Need for Highly Available Data
    • Failure
    • Availability
    • Reliability and Serviceability
    • Fault-tolerant Systems
    • Database Availability
  • Clustered Systems
  • Databases Issues
  • Oracle RAC – High Performance and Highly Available Database

Database Clusters 

  • Overview of the Cluster Technology
    • How Clusters Differ from Distributed Systems
    • Clusters are Different from Fault-tolerant Systems
    • Database Clusters
    • Why Clusters?
  • Types of Clusters
    • Failover Clusters
    • Scalable High Performance Clusters
    • Application Server Clusters
    • Other Types of Clusters
  • Components of a Cluster
    • Cluster Nodes
    • Emerging Server Cluster Architectures
    • Cluster Interconnect
    • Essentials for Parallel Database Clusters
    • Cluster Interconnect Products
    • Infiniband Interconnect
    • ClusterWare
    • Concurrent Database Access
  • Failover Database Clusters
    • Resources, Resource Type
    • Resource Groups
    • The Concept of a Virtual Server
    • Failover Process
    • Examples
    • Failover Cluster Architecture
    • Oracle Database Service in HA Cluster
    • Issues with FO Clusters Hidden Risks
  • Parallel Database Clusters
    • Shared-Nothing Model
    • Shared-Disk Model
    • Microsoft SQL Server Federated Database
    • IBM Offerings
    • Requirements for Parallel Clusters
    • Oracle's Instance Membership Recovery
    • Cache Coherency and Lock Management

Real Application Cluster Architecture

  • Overview of Oracle Real Application Clusters
    • RMAN for RAC
    • RAC Workload Management
    • RAC Scalability
    • High Availability
  • Architecture
    • Oracle11g Basic Processes
    • Oracle11g Basic Internal Structures
    • Oracle11g RAC Additional Processes
    • Oracle11g RAC Additional SGA Areas
  • RAC Server Components
    • GCS Resource Modes and Roles
    • Accessing RAC

RAC Server and Disk Technology

  • Overview
  • Oracle11g RAC Disk System
  • Understanding Disks, LUNs, Volumes
    • Raw Volumes
    • File Systems
  • Storage Technology and Redundancy
    • Disk Systems
    • Understanding I/O Path
    • Host Bus Adapters (HBA)
    • Storage Redundancy Components
    • RAID and RAID Administration
    • High Availability of Storage
    • Logical Volume Managers
  • Storage Areas
    • OCFS/OCFS2
    • RAW Volumes
    • ASM
    • Other CFS Solutions
  • Redundancy
    • Understanding RAID Redundancy
  • Capabilities
    • Server Redundancy
    • Redundancy Types

RAC Installation and Configuration

  • Architecture and Components
    • Servers and Operating System
    • Cluster Interconnect and Public Switch
    • Oracle Clusterware
    • Shared Storage Subsystem
  • Overview of Installation Steps
    • Installation of Oracle Clusterware
    • Installation of Oracle for use with ASM
    • Installation of Oracle for production database use
  • Oracle RAC Tools
    • crs_stat
    • olsnodes
    • srvctl
    • dbca
    • netca

Internals of Real Application Clusters

  • Overview of Cache Fusion
    • Evolution of Cache Fusion
    • Nature of Cache Fusion
    • Benefits of Cache Fusion
    • Concurrency and Consistency
    • Cache Coherency
    • Global Cache Service
  • SGA Components and Locking
    • SGA System Global Area
    • Program Global Area (PGA)
    • Buffer Cache Management
    • What is a Dirty Block?
    • Multi Version Consistency Model
  • RAC Components
    • Global Cache Service
    • Global Enqueque Service
    • Row-Level Locks
    • Global Resource Directory
    • RAC Processes
  • Resource Coordination
    • Synchronization
    • GCS Resource Modes and Roles
    • Concept of Past Image
    • Lock Modes
    • Block Access Modes and Buffer States
    • Cache Fusion Scenarios
    • Block transfers using Cache Fusion Examples
    • Block Access, Grants, and Interrupts
  • Cache Fusion and Recovery
    • Recovery Features
    • Recovery Methodology and Steps
    • Recovery Process Re-mastering Resources

11g RAC Administration

  • Parameter Management
    • Overview
    • RAC and Initialization Parameters
  • UNDO Management
    • UNDO Management in RAC
    • UNDO Tablespace Features
    • System Rollback Segment
  • Concept of Thread
    • Thread Features
    • Redo Thread Maintenance
  • Segment Space Management
    • Automatic Segment Space Management
    • Manual Space Management
    • Oracle Managed Files
  • Using SQL*Plus
    • Starting the Database in Cluster Mode
  • Using Oracle DB Control for Clusters
    • Configuration of DB control w/RAC

RAC 11g Backup and Recovery

  • Overview of RAC backup and Recovery
    • Export
    • Cold Backup using Scripts
    • Hot Backups using Scripts
    • RMAN (Recovery Manager)
    • Third Party Solutions
  • Backup of RAC Database
    • Using RMAN for Backups
    • Backup Procedures RMAN and RAC
  • Recovery in the RAC Environment
    • Media Recovery in RAC Instances
    • Using RMAN to Recover a RAC Environment
    • Recovery in an OCFS Environment
    • Recovery in a Raw File System Environment
    • Parallel Recovery
  • Standby Databases in RAC Configuration
    • Setting up a Standby Database for a RAC Cluster to a Single-Instance (One Node)
    • Configuration when the Standby Database is a Single Node System
    • Cross-Instance Archival
    • Archive Log Gap Resolution and FAL
  • ASM and RMAN
    • Performing advanced backup/ recovery techniques with ASM
    • SWITCH DATABASE TO COPY
    • Keeping ASM Clean

Failover and Load Balancing

  • Services In-depth
    • Failover
    • Load Balancing
    • Planning and Configuration
  • Connection Pools and Services
  • The Load Balancing Advisory
  • Monitoring Services

RAC Performance Monitoring and Tuning

  • Analysis of Performance Issues
    • Monitoring RAC Cluster Interconnect
    • Using performance views
    • Using AWR
    • ADDM for RAC
  • Using DB Control to Monitor RAC

RAC Design Consideration

  • Designing equipment for RAC
    • Effects of component failure
    • Redundancy at every level
    • Choosing Service/Nodes for Work
  • Sequences in RAC
    • Tablespace Design Considerations
    • Solid State Disk Considerations
    • Table Locks and Latch Waits
    • Scalability and Unpredictable Loads

Migration to RAC Databases

  • Overview
  • Migration Methodology
    • Moving from Single Instance to RAC
    • Cloning Overview
    • Migrating to Oracle 11g
    • Rolling Upgrades

Oracle 11g RAC parallel upgrades

  • Oracle 11g RAC has a rolling upgrade features whereby RAC database can be upgraded without any downtime.

Oracle 11g hot patching

  • Oracle 11g RAC has the ability to apply patches on a node-by-node basis without service interruption.

Oracle 11g RAC load balancing advisor

  • Starting in 10gr2 we see a RAC load balancing advisorutility. Oracle says that the 11g RAC load balancing advisor is only available with clients which use .NET, ODBC, or the Oracle Call Interface (OCI).

ADDM for RAC 11g

  • In Oracle 11g, ADDM has been extended to include RAC, and provides information on the entire cluster including latency issues on the cluster interconnect, global cache hot blocks (blocks with concurrency issues across multiple nodes), and general object usage information across multiple nodes.

11g RAC cache fusion protocols

  • 11g RAC improves the cache fusion layer for faster and more efficient pinging between nodes
  • 11g RAC ASMCA
  • Oracle 11g offers an ASM configuration assistant allows you to install cluster file systems (ACFS), ASM instances, ASM volumes and disk groups.

Optimized 11g RAC cache fusion protocols

  • Extends the general cache fusion protocols in 10g to deal with specific scenarios where the protocols could be further optimized.

Oracle 11g RAC Grid provisioning

  • The Oracle 11g grid control provisioning pack allows you to blow-out; a RAC node without the time-consuming install, using a pre-installed footprint.

Drop us a query

Contact us : +918851281130

Course Features

Real-Life Case Studies
Assignments
Lifetime Access
Expert Support
Global Certification
Job Portal Access