Advanced Oracle DBA Training Syllabus – RAC
Session : 1 – Oracle 11g R2 Grid Infrastructure Concepts
- What is a Cluster
- Grid Foundation Components
- Oracle Clusterware Architecture
- Oracle Clusterware Software and Storage
- Describe ASM Architecture
- Creating and Managing ASM Disk Groups
- Creating and Managing ASM Cluster File systems
- Administering Oracle Clusterware
- Troubleshooting Oracle Clusterware
Session : 2 – Grid Infrastructure Installation and Configuration
- Hardware Requirements
- Network Requirements
- Software Requirements
- DNS and DHCP Configuration
- Grid Plug and Play Considerations
- Single Client Access Names
- Post installation tasks
Session : 3 – Oracle Automatic Storage Management concepts
- ASM Instance
- ASM Disks
- ASM Disk Groups
- ASM Redundancy
Session : 4 – Cluster installation Prerequisite for Oracle 11g R2 RAC
- Linux OS Software Installation
- Create OS Group and User Accounts
- Networking
- Synchronizing the Time on ALL Nodes
- Configuring Kernel Parameters
- Set shell limits for the oracle & grid user
- Create the Oracle Inventory Directory
- Creating the Oracle Grid Infrastructure Home Directory
- Creating the Oracle Base Directory
- Creating the Oracle RDBMS Home Directory
- Stage the Oracle Software
- Check OS Software Requirements
- Cluster Verification Utility
Session : 5 – Shared Storage Configuration
- Types of Shared Storage
- Partition the Shared Disks
- Installing and Configuring ASMLib
- Using ASMLib to Mark the Shared Disks as Candidate Disks
Session : 6 – Oracle 11g Grid Infrastructure Installation
- Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)…
- Grid Infrastructure Home Patching
- RDBMS Software Install
- Run ASMCA to create diskgroups
Session : 7 – Oracle 11g R2 RAC Database Software Installation
- Installing The Oracle Database Software
- Creating A Cluster Database
- Post database Creation Tasks
Session : 8 Administering Oracle Clusterware
- Managing Clusterware with Enterprise Manager
- Determining the Location of the Oracle Clusterware Configuration Files
- 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
Session : 9 – Administering ASM Instances
- ASM Initialization Parameters
- Adjusting ASM Instance Parameters in SPFILEs
- Starting and Stopping ASM Instances Using srvctl
- Starting and Stopping ASM Instances Using ASMCA and ASMCMD
- Starting and Stopping ASM Instances Containing Cluster Files
- Starting and Stopping the ASM Listener
- Administering ASM Disk Groups
- Creating and Deleting ASM Disk Groups
- ASM Disk Group Attributes
- ASM Disk Group Maintenance Tasks
- Viewing ASM Disk Statistics
Session : 10 – Prerequisite Steps for Extending a Cluster
- Using addNode.sh to add a Node to a Cluster
- Rolling Patches and Rolling Upgrades
- Installing a Patchset with the OUI Utility
- Installing a Patch With The opatch Utility
Session : 11 – Cluster Node Management
- Add/Deleting the instance
- Add the Node
- Remove the Node
- Single-Instance Conversion Using rconfig
- Single-Instance Conversion Using DBCA
Session : 12 – Troubleshooting Oracle Clusterware
- Oracle Clusterware Log Files
- Gathering Log Files Using diagcollection.pl
- Component-level Debugging
- RAC-Specific Wait Events, Global Enqueues, and System Statistic
- Implementing the Most Common RAC Tuning Tips
- Using the Cluster Database Performance Pages
- Using the Automatic Workload Repository in RAC
- Using Automatic Database Diagnostic Monitor in RAC
Oracle Data Guard Training Syllabus
Session : 1 – Overview
- What Is Oracle Data Guard?
- Oracle Data Guard Architecture
- Types of Standby Databases
- Types of Services
- Benefits of Implementing Oracle Data Guard
Session : 2 – Understanding the Oracle Data Guard Architecture
- Data Guard Redo Apply Architecture
- Data Guard SQL Apply Architecture
- Standby Database Modes
Session : 3 – Configuring Data Protection Modes
- Maximum Protection
- Maximum Availability
- Maximum Performance
- Comparisons
- How to Set the Mode
Session : 4 – Creating a Physical Standby Database by Using SQL
- Preparing the Primary Database
- Setting Initialization Parameters on the Primary Database
- Backing Up the Primary Database
- Creating a Control File for the Standby Database
- Setting Initialization Parameters on the Standby Database
- Setting Up the Environment to Support the Standby Database
- Starting the Physical Standby Database
- Performing Additional Configuration Tasks
Session : 5 – Creating a Logical Standby Database by Using SQL
- Preparing to Create a Logical Standby Database
- Creating a Physical Standby Database
- Preparing the Primary Database
- Transitioning to a Logical Standby Database
- Opening the Logical Standby Database
- Verifying the Logical Standby Database
Session : 6 – Performing Switchover and Failover
- Choosing the Best Role Transition Operation
- Performing a Switchover by Using SQL
- Performing a Failover by Using SQL
Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.