Duración

4 días - 24 horas

Descripción

This Oracle Database 12c: Real Application Cluster (RAC) Administration training teaches you about Oracle RAC database architecture. Explore Global Resources and Cache Fusion and more. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Objetivos

  1. Configure RMAN for the RAC environment
  2. Describe the benefits of Oracle RAC
  3. Explain the necessity of global resources
  4. Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
  5. Convert a single-instance Oracle Database to RACs
  6. Create a cluster database
  7. ain an understanding of the Oracle Database Exadata Cloud Service
  8. Explain the principles and purposes of clusters
  9. Install the Oracle Database software
  10. Modify initialization parameters in a RAC environment
  11. Perform post-database-creation tasks
  12. Define redo log files in a RAC environment
  13. Define undo tablespaces in a RAC environment
  14. Describe global cache coordination
  15. Describe how Grid Plug and Play affects Clusterware
  16. Describe the Oracle Clusterware architecture

Contenidos del curso

  1. Grid Infrastructure Overview and Review
    • What is a Cluster?
    • What is a Flex Cluster
    • Clusterware Characteristics
    • Oracle Clusterware
    • Hardware and Software Concepts (High level)
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. Application Continuity
    • What is AC?
    • What problem does it solve?
    • Benefits of AC
    • How AC works
    • AC Architecture
    • Side Effects
    • Restrictions
    • Application requirements
  12. 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
  13. 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
  14. Quality of Service Management
    • QOS Management concepts
    • Describe the benefits of using QoS Management
    • QoS Management components
    • QoS Management functionality
  15. 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


Información extra

Learn to

This Oracle Database 12c: Real Application Cluster (RAC) Administration training teaches you about Oracle RAC database architecture. Explore Global Resources and Cache Fusion and more. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

  • Install Oracle RAC software.
  • Create cluster databases.
  • Administer both administrator and policy-managed Oracle RAC databases.
  • Monitor and address performance issues.
  • Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard.
  • Create and administer a RAC One Node Database.
  • Create and manage multitennant RAC databases.
  • Gain an understanding of the Oracle Database Exadata Cloud Service.

Benefits to you

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Audience

  • Administrator
  • Database Administrators

Related Training

Suggested Prerequisite

  • Oracle Database 12c R2: Clusterware Administration
  • Working knowledge of Oracle Database 11g: Release 2, including Clusterware, ASM and RAC
  • Working knowledge of Oracle Clusterware, ASM & RAC on Linux

Required Prerequisite

  • Oracle Database 12c R2: Clusterware Administration

 

Información general

Área formativa

Oracle Base de Datos

Fabricante

Oracle

Metodología

Presencial

Certificación

Garantía juvenil

 

¿TIENES DUDAS? PREGÚNTANOS

He leído y acepto la del sitio y las condiciones de tratamiento de mis datos de carácter personal

 

 

Fecha y precios de nuestros cursos

Fecha Horario de impartición Ubicación Precio por alumno Previsto en fecha
23 Sep 2019
De 9.00 a 15.00h
Core Madrid
2268€ +IVA
11 Nov 2019
De 9.00 a 15.00h
Core Madrid
2268€ +IVA

¿Necesitas Ayuda?

Consúltanos si necesitas información de nuestros cursos o masters.

 

Contacta con Core Networks