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

·       Convert a single instance Oracle database to RAC

 

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 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

·       Configure High Availability NFS