Course Description
Prepare to pass exam: Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration
The Oracle Certified Expert, Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administrator certification is for Database production Systems Administrators and Database Administrators with 12-18 months of experience utilizing RAC, ASM, and Grid Infrastructure. Your worth to your business and the market is increased by passing this exam, which assesses your knowledge and abilities in installation, setup, backup and recovery, monitoring, and tuning of these components.
The Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration exam requires in-depth knowledge of Oracle’s Real Application Clusters (RAC), Automatic Storage Management (ASM), and Grid Infrastructure technologies. To prepare effectively, it is essential to focus on key areas like RAC architecture, ASM, and Clusterware, while also gaining practical hands-on experience through setting up a practice lab.
Exam topics covered
RAC Databases and Architecture
- Describe the benefits of Oracle RAC
- Explain the necessity of global resources
- Describe global cache coordination
Installing and Configuring Oracle RAC
- Install the Oracle database software
- Create a cluster database
Administering Oracle RAC
- 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
Managing Backup and Recovery for RAC
- Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
- Configure RMAN for the RAC environment
Managing Global Resources
- Explain the need for global concurrency control
- Describe the Global Resource Directory
- Explain how global resources are managed
- Explain global enqueue and instance lock management
- Explain global buffer cache management
- Explain use of Affinity to reduce Global Resource Contention
RAC Database Monitoring and Tuning
- Identify RAC-specific tuning components
- Determine RAC-specific wait-events, global enqueues and system statistics
- Implement the most common RAC tuning practices
- Use the Cluster Database Performance pages
- Use the Automatic Workload Repository (AWR) in RAC
- Use Automatic Database Diagnostic Monitor (ADDM) in RAC
- RAC Database SGA Runtime Management
Managing High Availability of Services
- Configure and manage services in a RAC environment
- Use services with client applications
- Configure services aggregation and tracing
Managing High Availability for Connections and Applications
- Configure client-side connect-time load balancing and failover
- Configure server-side connect-time load balancing
- Use the Load Balancing Advisory (LBA)
- Explain the benefits of Fast Application Notification (FAN)
- Configure Transparent Application Failover (TAF)
- Co-location Tag for Client Routing
- Transparent Application Continuity
- Dynamic Services Fallback
Upgrading and Patching Oracle RAC
- Plan for rolling patches and rolling updates
- Install a patchset with the Oracle Universal Installer (OUI) utility
- Install a patch with the opatch utility
Managing Oracle RAC One Node
- Convert an Oracle RAC One Node database to a RAC database
- Use DBCA to convert a single-instance database to a RAC One Node database
Using Oracle Database Quality of Service Management (QoS)
- Explain the purpose and benefits of using QoS
- Explain the operation of QoS
Using Multitenant Architecture in a RAC Environment
- Describe the multitenant architecture in RAC and non-RAC environments
- Create a RAC multitenant container database (CDB)
- Create a pluggable database (PDB) in a RAC CDB
- Use the default CDB and PDB services
- Create PDB services to associate PDB services with server pools
- Automated PDB Patching and Relocation
Grid Infrastructure Administration
Introduction to Clusterware
- Explain the principles and purposes of clusters
- Describe Cluster hardware best practices
- Describe how Grid Plug and Play affects Clusterware
Oracle Clusterware Architecture
- Explain the Oracle Clusterware architecture
- Describe Oracle Clusterware startup details
Flex Clusters
- Explain the Flex Cluster architecture and components
- Describe the effect of node failure in a Flex Cluster
Grid Infrastructure Installation Planning and Pre-Tasks
- Plan for Grid Infrastructure installation
- Verify system and network requirements
- Create groups and users
- Create directories
Grid Infrastructure Installation
- Install Grid Infrastructure
- Verify the installation
- Configure ASM disk groups
- Optional Install for the Grid Infrastructure Management Repository
Managing Cluster Nodes
- Perform the prerequisite steps to extend a cluster
- Delete a node from a cluster
- Use DBCA to ADD new nodes to extend the cluster
Traditional Clusterware Management
- Perform day to day Clusterware administration tasks
- Perform Oracle Cluster Registry (OCR) backup and recovery
- Manage network settings
- Explain the scope and capabilities of what-if command evaluation
- Secure Cluster Communication
Policy-Based Cluster Management
- Explain the architecture and components of policy-based cluster management
- Administer server categorization
- Administer a policy set
- Activate a policy
Upgrading and Patching Grid Infrastructure
- Explain the types of patches and upgrades available
- Plan for rolling patches and rolling upgrades
- Compare software versions with the active version
- Install a patchset with the Oracle Universal Installer (OUI)
- Install a patch with the opatch utility
- Zero-Downtime Oracle Grid Infrastructure Patching
Troubleshooting Oracle Clusterware
- Locate the Oracle Clusterware log files and use diagcollection.pl
- Enable resource debugging
- Enable component-level debugging
- Troubleshoot the Oracle Cluster Registry (OCR) file
Making Applications Highly Available with Oracle Clusterware
- Explain the high availability components of Oracle Clusterware
- Explain policy-managed and administration-managed databases
- Create an application Virtual IP (VIP)
- Manage application resources
- Automatic Storage Management (ASM) Administration
Overview of ASM
- Explain the Automatic Storage Management (ASM) architecture
- Describe the components of ASM
Administering ASM Instances
- Explain and apply initialization parameters for ASM instances
- Manage ASM instances and associated processes
- Monitor ASM instances using the V$ASM dynamic performance views
FLEX ASM
- Describe the architecture and components of Flex ASM
- Install and configure Flex ASM
- Manage Flex ASM
Administering ASM Disk Groups
- Create and delete 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 Files, Directories and Templates
- Use client tools to access ASM files
- Describe the format of a fully qualified ASM file name
- Explain how ASM files, directories and aliases are created and managed
- Describe and manage disk group templates
Administering Oracle CloudFS
- Administer ASM Dynamic Volume Manager
- Manage ASM volumes
- Implement ASM Cluster File System (ACFS)
- Use ACFS snapshots
Oracle CloudFS Advance Topics
- Configure ACFS auditing
- Implement ACFS encryption
- Configure and manage ACFC replication
- Implement ACFS tagging
- Configure High Availability NFS
3 reviews for Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration
Quinn
December 17, 2024 at 01:23 pm
The thoroughness of these Oracle practice questions is what makes them the best.
Leander
December 11, 2024 at 01:21 pm
The practice questions were designed to offer practical insights into the 1Z0-078 exam structure.
Nico
December 05, 2024 at 04:38 pm
These practice questions helped me get a feel for the exam structure, and they were very useful in managing time effectively.