Î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.
- Administrator
- Administrator baze de date
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.
- 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.
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
Nu există cursuri recomandate după finalizarea acestui curs.
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
Oracle Database 12c R2 – RAC Administration Ed 2
