Oracle RAC 12c | 19c Certification Training

✔ Explain the principles and purposes of clusters
✔ Describe Cluster hardware best practices
✔ Describe the Oracle Clusterware architecture
✔ Describe how Grid Plug and Play affects Clusterware
✔ Describe the Automatic Storage Management (ASM) architecture
✔ Describe the components of ASM

✔ Perform preinstallation tasks for Grid Infrastructure
✔ Install Grid Infrastructure
✔ Verify the installation
✔ Configure Automatic Storage Management (ASM) disk, groups
✔ Configure ASM volumes
✔ Make the ASM cluster file system
✔ Mount ASM Cluster File System (ACFS) volumes

✔ Display Clusterware management proficiency
✔ Demonstrate Oracle Cluster Registry (OCR) backup and recovery techniques
✔ Manage network settings

✔ Adding and Deleting Oracle Clusterware Homes

✔ Perform the prerequisite steps for extending a cluster
✔ Use addNode.sh to add a node to a cluster
✔ Delete a node from a cluster

✔ Patching Oracle Clusterware

✔ Describe the types of patches and upgrades available
✔ Design for rolling patches and rolling upgrades
✔ Compare software versions with the active version
✔ Install a patchset with the Oracle Universal Installer (OUI) utility
✔ Install a patch with the opatch utility

✔ Describe the high availability components of Oracle Clusterware
✔ Contrast policy-managed and administration-managed databases
✔ Describe the functionality of server pools
✔ Describe application-placement policies
✔ Create an application Virtual IP (VIP)
✔ Manage application resources

✔ Locate Oracle Clusterware log files
✔ Gather all log files using diagcollection.pl
✔ Enable resource debugging
✔ Enable component-level debugging
✔ Enable tracing for Java-based tools
✔ Troubleshoot the Oracle Cluster Registry (OCR) file

✔ Explain and apply (ASM) initialization parameters
✔ Manage ASM instances and associated processes
✔ Monitor ASM using the V$ASM dynamic performance views

✔ Explain the necessity of global resources
✔ Describe global cache coordination
✔ Explain object affinity and dynamic remastering

✔ Install the Oracle database software
✔ Create a cluster database
✔ Perform post-database-creation tasks
✔ Perform a single instance to RAC conversion

✔ Use Enterprise Manager Cluster Database pages
✔ Define redo log files in a RAC environment
✔ Define undo tablespaces in a RAC environment
✔ Start and stop RAC databases and instances
✔ Modify initialization parameters in a RAC environment

✔ The RAC database to use ARCHIVELOG mode and the fast recovery area
✔ RMAN for the RAC environment

✔ Determine RAC-specific tuning components
✔ Tune instance recovery in RAC
✔ Determine RAC-specific wait events, global enqueues, and system statistics
✔ Implement the most common RAC tuning tips
✔ Use the Cluster Database Performance pages
✔ Use the Automatic Workload Repository (AWR) in RAC
✔ Use Automatic Database Diagnostic Monitor (ADDM) in RAC

✔ Configure and manage services in a RAC environment
✔ Use services with client applications
✔ Use services with the Database Resource Manager
✔ Use services with the Scheduler
✔ Configure services aggregation and tracing

✔ Design a Maximum Availability Architecture in your environment
✔ Determine the best RAC and Data Guard topologies for your environment
✔ Configure the Data Guard Broker configuration files in a RAC environment
✔ Identify successful disk I/O strategies