Contact Premier Online Trainings Today
Premier Online Trainings

Oracle RAC DBA

  • Home
  • Oracle RAC DBA
Courses Overview
Premier Online Trainings Institute provides best Oracle RAC DBA training in Hyderabad, Banglore by our Highly Professional certified trainers.

Oracle Real Application Clusters (Oracle RAC) is a clustered version of Oracle Database based on a comprehensive high-availability stack that can be used as the foundation of a database cloud system as well as a shared infrastructure, ensuring high availability, scalability, and agility for any application.

* We also provide Online Training for Normal Track, Fast Track and Weekend Batches
Course Curriculum
  • Describe the Automatic Storage Management (ASM) architecture
  • Describe the components of ASM
  • Benefits of Real Application Clusters (RAC)
  • What is a DB Cluster?
  • Architectures of DB Clusters
  • What is a Cluster Interconnect?
  • Problems with Other Architectures
  • Introduction and types of Clusters
  • Components of a Cluster
  • H/W Requirement for Clusters
  • Define Oracle Real Application Clusters
  • Operating System preparation for RAC/Grid Infrastructure
  • Configure Automatic Storage Management (ASM) disk groups
  • Configure ASM volumes
  • Make the ASM cluster file system
  • Mount ASM Cluster File System (ACFS) volumes
  • Introduction to Network, hardware.
  • Private and public network configuration
  • RAC, Groups and Users for Oracle software
  • Install Grid Infrastructure
  • Introduction to 12c/19c RAC, daemons.
  • Install Database Software.
  • Automatic Storage Management (ASM) architecture
  • Components of ASM
  • Create and delete Automatic Storage Management (ASM) disk groups
  • Set the attributes of an existing ASM disk group
  • Perform ongoing maintenance tasks on ASM disk groups
  • Explain key performance and scalability considerations for ASM disk groups
  • Administering ASM Instances
  • Explain and apply (ASM) initialization parameters
  • Manage ASM instances and associated processes
  • Monitor ASM using the V$ASM dynamic performance views
  • Overview of Oracle Real Application Clusters
  • RAC Scalability
  • High Availability Architecture
  • Oracle Basic Processes
  • Oracle Basic Internal Structures
  • Oracle RAC Additional Processes
  • Oracle RAC Additional SGA Areas
  • RAC Server Components
  • GCS Resource Modes and Roles
  • RAC Architecture and Concepts
  • Background processes.
  • Non-CDB Architecture
  • Multitenant Architecture: Benefits
  • CDB in a Non-RAC Environment
  • Containers
  • Terminology and Data Dictionary Views
  • Connection to a Non-RAC CDB
  • Oracle RAC and Multitenant Configuration
  • Oracle RAC and Multitenant Architecture
  • Introduction to ASM, Advantages of ASM
  • Parameters used to configure ASM
  • Creating ASM instance in RAC
  • Introduction to OCFS2
  • Advantages of OCFS
  • Database creation in RAC
  • Required RAC database files
  • Parameters used for RAC database
  • RAC Initialization Parameter Files
  • Creating the Cluster Database
  • Manage redo log groups in a RAC environment
  • Manage undo tablespaces in RAC Environment.
  • Enabling and Disabling instances
  • Working with spfile in RAC Environment
  • Archiving schemes in RAC
  • Management of OCR and Voting Disk.(Adding, Removing)
  • Overview and Benefits Cache Fusion
  • Concurrency and Consistency
  • Cache Coherency
  • Global Cache Service
  • Backing Up and Recovering the Voting Disk
  • Adding, Deleting, or Migrating Voting Disks
  • Locating the OCR Automatic Backups
  • Oracle Local Registry
  • Migrating OCR Locations to ASM
  • Managing Network Settings
  • Managing Oracle Clusterware
  • Consideration for Logical Backups in RAC.
  • Consideration of Flash Recovery Area in RAC
  • Physical Backup and Recovery in RAC through RMAN
  • 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
  • Standby Databases in RAC Configuration
  • Archive Log Gap Resolution and FAL (Fetch Archive Log)
  • Performing advanced backup/ recovery techniques with ASM
  • SWITCH DATABASE TO COPY
  • Configure client side connect-time load balancing
  • Configure server side connect-time load balancing
  • Fast Application Notification (FAN).
  • Configure server-side callouts, Configure Transparent Application Failover (TAF).
  • Configure and manage Services
  • Starting and stopping instances and database
  • Managing services with srvctl and crsctl commands.
  • Migration to RAC (single instance to multi-instance)
  • Prepare a New Node
  • Extend the Oracle Grid Infrastructure Home to the New Node
  • Extend the Oracle RAC Home Directory
  • Add the New Node to the Cluster
  • Create an Instance on the New Node
  • Delete an Instance from the Cluster Database
  • Remove a Node from the Cluster
  • RAC One Node Concepts
  • Online database migration
  • Adding Oracle RAC One Node Database to an Existing Cluster
  • Convert an Oracle RAC One Node database to a RAC database
  • Convert an Oracle RAC database to a RAC One Node database
  • Use DBCA to convert a single instance database to a RAC One Node database
  • Configure the EM Patch Interface
  • Compare software versions with the active version
  • Apply Rolling Patches to a RAC System
  • Apply a Patchset with the opatch Utility
  • Apply a Patchset with the Oracle Universal Installer (OUI) utility
  • Determine RAC specific tuning components.
  • Automatic Workload Repository and Automatic Database Diagnostic Monitor in RAC
  • EM Cluster Database Performance pages.
  • Analysis of Performance Issues
  • Monitoring RAC Cluster Interconnect
  • Using performance views
  • Using AWR (Automatic Workload Repository)
  • ADDM (Automatic Database Diagnostic Monitor) for RAC
  • Using DB Control to Monitor RAC