You can use this Oracle 1Z0-078 exam study guide to collect all the information about the Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administration exam. The Oracle 1Z0-078 certification exam is mainly targeted to those candidates who have some experience or exposure to Oracle Database technology and want to flourish their career with Oracle Certified Professional, Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administrator (OCP) credential.
The Oracle 1Z0-078 certification exam validates your understanding of the Oracle Database technology and sets the stage for your future progression. Your preparation plan for Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administration Certification exam should include hands-on practice or on-the-job experience performing the tasks described in following certification exam syllabus topics.
Oracle 1Z0-078 Exam Details:
| Exam Name | Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administration |
| Exam Code | 1Z0-078 |
| Exam Price | USD $245 (Pricing may vary by country or by localized currency) |
| Duration | 120 minutes |
| Number of Questions | 77 |
| Passing Score | 65% |
| Format | Multiple Choice Questions (MCQ) |
| Recommended Training |
Oracle Database 19c: RAC Administration Workshop Oracle Database 19c: ASM Administration Workshop Oracle Database 19c: Clusterware Administration Workshop |
| Schedule Exam | Buy Oracle Training and Certification |
| Sample Questions | Oracle Certified Professional, Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administrator (OCP) |
| Recommended Practice | 1Z0-078 Online Practice Exam |
Oracle 1Z0-078 Syllabus Topics:
| RAC Databases and Architecture |
- Describe the benefits of Oracle RAC - Describe global cache coordination - Explain the necessity of global resources |
| Installing and Configuring Oracle RAC |
- Install the Oracle database software - Convert a single instance Oracle database to RAC - Create a cluster database |
| Administering Oracle RAC |
- Define redo log files in a RAC environment - Start and stop RAC databases and instances - Define undo tablespaces in a RAC environment - 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 - Explain global enqueue and instance lock management - Describe the Global Resource Directory - Explain global buffer cache management - Explain how global resources are managed - Explain use of Affinity to reduce Global Resource Contention |
| RAC Database Monitoring and Tuning |
- Identify RAC-specific tuning components - Use the Automatic Workload Repository (AWR) in RAC - Determine RAC-specific wait-events, global enqueues and system statistics - Use Automatic Database Diagnostic Monitor (ADDM) in RAC - Implement the most common RAC tuning practices - RAC Database SGA Runtime Management - Use the Cluster Database Performance pages |
| Managing High Availability of Services |
- Configure and manage services in a RAC environment - Configure services aggregation and tracing - Use services with client applications |
| Managing High Availability for Connections and Applications |
- Configure client-side connect-time load balancing and failover - Configure Transparent Application Failover (TAF) - Configure server-side connect-time load balancing - Co-location Tag for Client Routing - Use the Load Balancing Advisory (LBA) - Transparent Application Continuity - Explain the benefits of Fast Application Notification (FAN) - Dynamic Services Fallback |
| Upgrading and Patching Oracle RAC |
- Plan for rolling patches and rolling updates - Install a patch with the opatch utility - Install a patchset with the Oracle Universal Installer (OUI) 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 - Use the default CDB and PDB services - Create a RAC multitenant container database (CDB) - Create PDB services to associate PDB services with server pools - Create a pluggable database (PDB) in a RAC CDB - Automated PDB Patching and Relocation |
Grid Infrastructure Administration |
|
| Introduction to Clusterware |
- Explain the principles and purposes of clusters - Describe how Grid Plug and Play affects Clusterware - Describe Cluster hardware best practices |
| 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 - Create groups and users - Verify system and network requirements - Create directories |
| Grid Infrastructure Installation |
- Install Grid Infrastructure - Configure ASM disk groups - Verify the installation - Optional Install for the Grid Infrastructure Management Repository |
| Managing Cluster Nodes |
- Perform the prerequisite steps to extend a cluster - Use DBCA to ADD new nodes to extend the cluster - Delete a node from a cluster |
| Traditional Clusterware Management |
- Perform day to day Clusterware administration tasks - Explain the scope and capabilities of what-if command evaluation - Perform Oracle Cluster Registry (OCR) backup and recovery - Secure Cluster Communication - Manage network settings |
| Policy-Based Cluster Management |
- Explain the architecture and components of policy-based cluster management - Administer a policy set - Administer server categorization - Activate a policy |
| Upgrading and Patching Grid Infrastructure |
- Explain the types of patches and upgrades available - Install a patchset with the Oracle Universal Installer (OUI) - Plan for rolling patches and rolling upgrades - Install a patch with the opatch utility - Compare software versions with the active version - Zero-Downtime Oracle Grid Infrastructure Patching |
| Troubleshooting Oracle Clusterware |
- Locate the Oracle Clusterware log files and use diagcollection.pl - Enable component-level debugging - Enable resource debugging - Troubleshoot the Oracle Cluster Registry (OCR) file |
| Making Applications Highly Available with Oracle Clusterware |
- Explain the hivh availability components of Oracle Clusterware - Create an application Virtual IP (VIP) - Explain policy-managed and administration-managed databases - 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 - Monitor ASM instances using the V$ASM dynamic performance views - Manage ASM instances and associated processes |
| FLEX ASM |
- Describe the architecture and components of Flex ASM - Manage Flex ASM - Install and configure Flex ASM |
| Administering ASM Disk Groups |
- Create and delete ASM disk groups - Perform ongoing maintenance tasks on ASM disk groups - Set the attributes of an existing ASM disk group - Explain key performance and scalability considerations for ASM disk groups |
| Administering ASM Files, Directories and Templates |
- Use client tools to access ASM files - Explain how ASM files, directories and aliases are created and managed - Describe the format of a fully qualified ASM file name - Describe and manage disk group templates |
| Administering Oracle CloudFS |
- Administer ASM Dynamic Volume Manager - Implement ASM Cluster File System (ACFS) - Manage ASM volumes - Use ACFS snapshots |
| Oracle CloudFS Advance Topics |
- Configure ACFS auditing - Implement ACFS tagging - Implement ACFS encryption - Configure High Availability NFS - Configure and manage ACFC replication |
The Oracle Database RAC, ASM, and Grid Infrastructure Administration Certification Program certifies candidates on skills and knowledge related to Oracle Database products and technologies. The Oracle 1Z0-078 is granted based on a combination of passing exams, training, and performance-based assignments, depending on the level of certification. Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administration certification is a real benchmark of experience and expertise that helps you stand out in a crowd among employers. To ensure success, Oracle recommends combining education courses, practice exams, and hands-on experience to prepare for your Oracle Certified Professional, Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administrator (OCP) certification exam as questions will test your ability to apply the knowledge you have gained in hands-on practice or professional experience.