Oracle 12c Real Application Clusters Part 2: Performance Tuning, Administration and Backup

 

Course Description

 

In this Oracle 12c Real Application Clusters Part 2: Performance Tuning, Administration and Backup course, you will learn how to backup and tune the Oracle clustered environment. In order to be prepared for this course, you’ll need to have completed Oracle 12c Real Application Clusters Part 1: Installation and Configuration.

 

 

 

In this course you will learn:

  • The differences between Oracle RAC and RAC One Node.
  • Application continuity and how it works and applies in an Oracle 12c Database and applications
  • RAC and RAC consolidation
  • SRVCTL, CRSCTL, Sql Advisor
  • Real Time ADDM
  • Cluster optimization

 

Oracle’s Database with Real Application Clusters (RAC) is and has been a top solution for thousands of customers worldwide. With Oracle’s Real Application Cluster 12c you now have a more flexible architecture that is able to fulfill numerous requirements using different configurations. It is also capable of providing the infrastructure to host other applications.

 

In This Course You Will Learn How To:

  • Configure the Cluster in archivelog mode
  • Backup the RAC Cluster
  • Use SRVCTL and CRSCTL
  • Define Application Continuity
  • Extending the RAC environment
  • Reducing the RAC environment
  • Utilizing AWR Reports

 

Prerequisites

 

In order to effectively understand and use the knowledge provided in these courses, you should have a minimum of 1 year Oracle DBA experience, knowledge of Oracle’s database architecture or completed of the following courses:

  • Oracle 12c Database Administration I Part 1
  • Oracle 12c Database Administration I Part 2
  • Oracle 12c Database Administration II Part 1
  • Oracle 12c Database Administration II Part 2
  • Oracle 12c: Real Application Clusters Installation and Configuration

 

Outline

 

Module 00: Course Introduction – Oracle 12c Real Application Clusters Part 2: Installation and Configuration

 

 

 

Module 01: System Requirements

 

 

 

Module 02: Backup Oracle 12c

  • Identify RAC Backup Needs
  • Configure RAC Backups with RMAN
  • Identify RAC Channels with RMAN

 

Module 03: Lab Exercise and Solution: Configure RAC Archivelog

 

 

 

Module 04: Lab Exercise and Solution: Backup Database

 

 

 

Module 05: Tuning RAC

  • Identify RAC Performance Tuning Needs
  • Tune the RAC Environment
  • Identify RAC Specific Tuning Parameters

 

Module 06: Lab Exercise and Solution: Run AWR Reports

 

 

 

Module 07: Diagnosis RAC Issues

  • Identify CRS Log Files
  • Understand the Directory Structure
  • Review RAC Dictionary Views

 

Module 08: Lab Exercise and Solution: Diagnosis RAC

 

 

 

Module 09: Using CRSCTL/OCRCHECK

  • Overview of Cache Fusion
  • Oracle 12c New Features to Cache Fusion
  • Overview of CRSCTL

 

Module 10: Lab Exercise and Solution: Use CRSCTL/OCRCHECK

 

 

 

Module 11: High Availability of Services

  • Define Oracle 12c RAC Services
  • Policy Managed Databases
  • Admin Managed Databases
  • Load Balancing Client Side/Server Side
  • Fast Application Notification

 

Module 12: Lab Exercise and Solution: Create and Use Services Container/Pluggable

 

 

 

Module 13: RAC Node One

  • What is Oracle’s RAC Node One
  • Converting a RAC Database to RAC Node One
  • Converting a RAC Node One Database to RAC Database
  • Benefits of RAC Node One
  • Quiz: RAC Node One

 

Module 14: Node Management

  • Reasons for Extending RAC
  • Extending the RAC
  • Reasons for Reducing the RAC
  • Reducing the RAC

 

Module 15: Lab Exercise and Solution: Reducing the RAC

 

 

 

Module 16: Lab Exercise and Solution: Extending the RAC

 

 

 

Module 17: Application Continuity (AC)

  • What is Application Continuity?
  • How is AC Configured?
  • Benefits of AC
  • AC Requirements
  • AC Restrictions
  • Quiz: Application Continuity

 

Module 18: Where Do You Go From Here?