Oracle Database Administrator - Oracle Database 12c

Introduction

This 3-day Oracle Database 12c: RAC Administration training course, will introduce delegates about the Oracle RAC database architecture, covering how to install the software and the key administration features. Delegates will learn in detail about cluster databases and troubleshooting performance issues. This course is intended for database administrators and by the end of the course users will be competent with the key functionality of the system, as well as being able to optimise performance

Pre-Requisites

Delegates should:

• Have working knowledge of Oracle Database
• Completed: “Oracle Database 12c: Grid Infrastructure Administration” and “Oracle Database 12c: Oracle Automatic Storage Management Administration”
• Be familiar with Clusterware and ASM administration

Who Should Attend

• This course is aimed at database administrators who maintain an Oracle Database

Course Objectives

Upon completion of this course, candidates should gain knowledge on:

• Oracle database software
• Oracle Clusterware architecture
• Necessity of global resources
• Global cache coordination
• ARCHIVELOG mode
• Grid Plug and Play
• Benefits of Oracle RAC
• RMAN for the RAC environment
• Principles and purposes of clusters
• Modifying initialisation parameters in a RAC environment
• Cluster databases
• Post-database-creation tasks
• Single-instance Oracle database to RACs

Course Outline

• Grid Infrastructure Overview and Review
• RAC Databases Overview & Architecture
• Installing and Configuring Oracle RAC
• RAC Databases Overview & Architecture
• RAC Backup and Recovery
• RAC Global Resource Management and Cache Fusion
• RAC Monitoring and Tuning
• Managing High Availability of Services in a RAC Environment
• Managing High Availability of Connections
• Upgrading and Patching RAC
• Application Continuity
• Quality of Service Management
• RAC One Node
• Design for High Availability