1Z0-068: Oracle Database 12c - RAC and Grid Infrastructure Administration


Full Name: Oracle Database 12c - RAC and Grid Infrastructure Administration

Exam Code: 1Z0-068


Oracle 1Z0-068 Exam Details:


Exam Name
Oracle Database 12c - RAC and Grid Infrastructure Administration
Exam Code
1Z0-068
Exam Product Version
Oracle Database 12c 
Exam Price 
USD $245 (Price may vary by country or by localized currency)
Duration 
140 minutes 
Number of Questions 
90
Passing Score 
Section 1 - 60%
Section 2 - 45%
Section 3 - 33%
Recommended Training  
Format 
Multiple Choice Questions (MCQ)
Recommended Training 
Recommended Practice 

Oracle 1Z0-068 Syllabus Topics:


Oracle Database 12c: RAC Administration
Grid Infrastructure - Explain the principles and purposes of clusters
- Describe the Oracle Clusterware architecture
- Describe how Grid Plug and Play affects Clusterware
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
- Perform post-database-creation tasks
- Convert a single instance Oracle database to RAC
Administering Oracle RAC - 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
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
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
Managing High Availability of Services - 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
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 server-side callouts
- Configure the server- and client-side ONS
- Configure Transparent Application Failover (TAF)
Upgrading and Patching Oracle RAC - Describe the different types of patches - 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 - Perform an online database migration
- Add an Oracle RAC One Node database to an existing cluster
- 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 - Describe the components of 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
- Drop a PDB from a RAC CDB
Oracle Database 12c: 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
- Install required OS packages
- Set kernel parameters
- Create groups and users
- Create directories
- Configure shell limits
Grid Infrastructure Installation - Install Grid Infrastructure
- Verify the installation
- Configure ASM disk groups
Managing Cluster Nodes - Perform the prerequisite steps to extend a cluster
- Use addNode.sh to add a node to a cluster
- Delete a node from a 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
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
Troubleshooting Oracle Clusterware - Locate the Oracle Clusterware log files and use diagcollection.pl
- Enable resource debugging
- Enable component-level debugging
- Enable tracing for Java-based tools
- Troubleshoot the Oracle Cluster Registry (OCR) file
Making Applications Highly Available with Oracle Clusterware - Explain the hivh 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
- Describe the ASCF plug-in architecture
- Configure High Availability NFS

0 comments:

Post a Comment