Oracle Database 12c R2 – RAC Administration Ed 2

Acest curs nu mai face parte din portofoliul vendorului. Contactați-ne pentru detalii suplimentare.

În cursul Oracle Database 12c: Real Application Cluster (RAC) Administration participanții învață despre arhitectura bazelor de date Oracle RAC, să exploreze resursele globale, Cache Fusion și Oracle Database Exadata Cloud Service.

Participând la acest curs, studenții deprind cunoștințe despre cum să asigure o performanță rapidă, fiabilă, sigură și ușor de gestionat, sa optimizeze fluxurile de lucru ale bazelor de date, să reducă costurile IT, oferind astfel o calitate superioară a serviciului si consolidarea în cloud a bazelor de date.

Acest curs este susținut de exerciții practice de laborator.

Cui i se adresează?

Administrator
Administrator baze de date

Ce vei învăța?

Participanții la acest curs vor învăța să:

Configureze RMAN pentru mediul RAC;
Descrie beneficiile Oracle RAC;
Explice necesitatea resurselor globale;
Configureze baza de date RAC pentru a utiliza modul ARCHIVELOG și zona de recuperare rapidă;
Creeze conversia unei baze de date Oracle cu o singură instanță în RAC;
Creeze o bază de date cluster;
Înțeleagă serviciul Oracle Database Exadata Cloud Service;
Explice principiile și scopurile clusterelor;
Instaleze software-ul Oracle Database;
Modifice parametrii de inițializare într-un mediu RAC;
Efectueze activități post-creare a bazei de date;
Definească fișierelor jurnal de refacere într-un mediu RAC;
Definească spațiile de tabel anulate într-un mediu RAC;
Descrie coordonarea globală a memoriei cache;
Descrie modul în care Grid Plug and Play afectează un Clusterware;
Descrie arhitectura Oracle Clusterware.

Cerințe preliminare:

Participarea la cursul Oracle Database 12c R2: ASM Administration Ed 2;
Participarea la cursul Oracle Database 12c R2: Clusterware Administration Ed 2;
Cunoștințe de lucru despre Oracle Clusterware, ASM și RAC pe Linux.

Agenda cursului:

Materialele de curs sunt în limba Engleză. Predarea se face în limba Română.

Grid Infrastructure Overview and Review

What is a Cluster?
What is a Flex Cluster
Clusterware Characteristics
Oracle Clusterware
Hardware and Software Concepts (High level)

RAC Databases Overview & Architecture

Overview of Oracle RAC
RAC One Node
Cluster-Aware Storage Solutions
Benefits of Using RAC
Scaleup and Speedup
I/O Throughput Balanced
Global Resources
RAC and Flex ASM

Installing and Configuring Oracle RAC

Installing the Oracle Database Software
Installation options
Creating the Cluster Database
Post-installation Tasks
Single Instance to RAC Conversion
Cleaning Up Unsuccessful Installs

Oracle RAC Administration

Parameters and RAC – SPFILE, Identical and Unique Parameters
Instance Startup, Shutdown and Quiesce
Undo Tablespaces
Redo Threads
Use Enterprise Manager Cluster Database Pages
RAC Alerts
RAC Metrics

Managing Backup and Recovery for RAC

Overview of Upgrades and Patching
Release and Patch Set Upgrades
PSU, CPU and Interim Patches
Merge Patches
Performing Out Of Place Database Upgrades
Planning and Preparing for Upgrade
Performing Out of Place Release Install or Upgrade
Post Upgrade Tasks

RAC Backup and Recovery

Instance Failure And Recovery In RAC – LMON and SMON
Redo Threads and Archive Log Configurations and Admin
Parameter Settings Affecting Parallel Recovery and MTTR
Instance Failure And Recovery In RAC – LMON and SMON
RAC and the Fast Recovery Area
RMAN Configuration
RMAN Admin For RAC: Channels, Instances, Backup Distribution
RMAN Restore And Recovery RAC Considerations

RAC Global Resource Management and Cache Fusion

Globally Managed Resources and Management
Library Cache Management
Row cache management
Buffer cache fusion
Buffer Cache Management Requirements
Accessing single blocks in RAC
Multi-block read considerations in RAC
Undo and read consistency considerations in RAC

RAC Database Monitoring and Tuning

OCPU and Wait Time Latencies
Wait Events for RAC
Common RAC Tuning
Session and System Statistics
RAC specific V$ Views
Automatic Database Diagnostic Monitor for RAC

Managing High Availability of Services in a RAC Environment

Oracle Services
Services for Policy – and Administrator-Managed Databases
Creating Services
Managing Services
Use Services with Client Applications
Services and Connection Load Balancing
Services and Transparent Application Failover
Services and the Resource Manager

Managing High Availability of Connections

Types of Workload Distribution
Client-Side Load Balancing
Server-Side Load Balancing
Runtime Connection Load Balancing and Connection Pools
Fast Application Notification
The Load Balancing Advisory FAN Event
Server-Side Callouts
Configuring the Server-Side ONS

Application Continuity

What is AC?
What problem does it solve?
Benefits of AC
How AC works
AC Architecture
Side Effects
Restrictions
Application requirements

RAC One Node

RAC One Node Concepts
Online database migration
Adding Oracle RAC One Node Database to an Existing Cluster
Convert an Oracle RAC One Node database to a RAC database
Convert an Oracle RAC database to a RAC One Node database
Use DBCA to convert a single instance database to a RAC One Node database

Multitenant Architecture and RAC

Non-CDB Architecture
Multitenant Architecture: Benefits
CDB in a Non-RAC Environment
Containers
Terminology and Data Dictionary Views
Connection to a Non-RAC CDB
Oracle RAC and Multitenant Configuration
Oracle RAC and Multitenant Architecture

Quality of Service Management

QOS Management concepts
Describe the benefits of using QoS Management
QoS Management components
QoS Management functionality

Oracle Database Exadata Cloud Service Overview

Introducing Exadata Cloud Service
Service Configuration Options & Service Connection Options
Service Architecture & Availability
Management Responsibilities
Storage Configuration & Management Details
Simple Web-Based Provisioning & Management
REST APIs
Migrating to Exadata Cloud Service

Recomandăm să continui cu:

Nu există cursuri recomandate după finalizarea acestui curs.

Programe de certificare

Cursul Oracle Database 12c R2: RAC Administration Ed 2 face parte din planul de învățare pentru susținerea examenului de certificare Oracle Database 12c: RAC and Grid Infrastructure Administration 1Z0-068, devenind astfel Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator.
Candidații trebuie să urmeze toate cele trei cursuri independente enumerate pentru a se pregăti pentru acest examen:
• Oracle Database 12c R2: ASM Administration Ed 2
• Oracle Database 12c R2: Clusterware Administration Ed 2
• Oracle Database 12c R2: RAC Administration Ed 2