Curso Oclacle 12c RAC – Administração de Banco de Dados

Database

Curso Oclacle 12c RAC – Administração de Banco de Dados

32 horas
Visão Geral

O Curso Oclacle 12c RAC – Administração de Banco de Dados, sobre a arquitetura do banco de dados Oracle RAC. E ministrado por instrutores especializado e docente em Oracle. Apresentamos aqui uma breve descrição do que você irá aprender após concluir este Curso Oclacle 12c RAC – Administração de Banco de Dados:

  • Instale o software Oracle RAC.
  • Crie bancos de dados em cluster.
  • Configurar nós do Oracle RAC Reader.
  • Administre os bancos de dados Oracle RAC gerenciados pelo administrador e pelo policy-management.
  • Explicar os benefícios dos espaços de tabela temporários locais.
  • Monitore e resolva problemas de desempenho.
  • Aprenda sobre serviços em um ambiente RAC, bem como recursos de conexão altamente disponíveis, incluindo Application Continuity e Transaction Guard.
  • Crie e administre um banco de dados RAC One Node.
  • Crie e gerencie bancos de dados RAC com vários participantes.
  • Compreenda o Oracle Cloud Exadata Cloud Service.


Quais Benefícios para os participantes e para empresas:

Garanta um desempenho rápido, confiável, seguro e fácil de gerenciar.
Otimize as cargas de trabalho do banco de dados, reduza os custos de TI e forneça uma qualidade de serviço mais alta, permitindo a consolidação nas nuvens do banco de dados.

Objetivo

Curso Oclacle 12c RAC – Administração de Banco de Dados

  • Configurar nós do Oracle RAC Reader
  • Definir arquivos de log de redo em um ambiente RAC
  • Definir os espaços de tabela para desfazer em um ambiente RAC
  • Descrever os benefícios do Oracle RAC
  • Converter um banco de dados Oracle de instância única em RACs
  • Instalar o software do banco de dados Oracle
  • Crie um banco de dados de cluster
  • Definir espaços de tabela temporários locais em um ambiente RAC
  • Modifique os parâmetros de inicialização em um ambiente RAC
  • Executar tarefas de criação pós-banco de dados
  • Configurar o RMAN para o ambiente RAC
  • Configure o banco de dados RAC para usar o modo ARCHIVELOG e a área de recuperação rápida
  • Explicar a necessidade de recursos globais
  • Descrever a coordenação global do cache
  • Explicar os princípios e propósitos dos clusters
  • Descrever a arquitetura do Oracle Clusterware
Pre-Requisitos
  • Conhecimento de ADM Oracle 10 e 11g
  • Conhecimento de Clusteware
Conteúdo Programatico

Grid Infrastructure: Overview

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

RAC Databases Overview & Architecture

  • Overview of Oracle RAC
  • Oracle RAC One Node (High level)
  • Cluster-Aware Storage Solutions
  • Benefits of Using RAC
  • Scaleup and Speedup
  • I/O Throughput Balanced
  • Global Resources

Installing and Configuring Oracle RAC

  • Installing the Oracle Database Software
  • Installation options
  • Creating the Cluster Database
  • Configuring Oracle RAC Reader Nodes
  • Post-installation Tasks
  • Single Instance to RAC Conversion using DBCA and rconfig

Oracle RAC Administration

  • Separation of Duty for Administering Oracle RAC
  • Use Enterprise Manager Cluster Database Pages
  • RAC Alerts
  • RAC Metrics
  • Undo Tablespaces
  • Local Temporary Tablespaces
  • Redo Threads
  • Parameters and RAC – SPFILE, Identical and Unique Parameters

Upgrading and Patching Oracle RAC

  • Ovierview 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
  • Post Upgrade Tasks

Managing Backup and Recovery for RAC

  • Instance Failure And Recovery In RAC – LMON and SMON
  • Redo Threads and Archive Logs Configurations and Admin
  • Parameter Settings Affecting Parallel Recovery and MTTR
  • RAC and the Fast Recovery Area
  • RMAN Configuration
  • RMAN Admin for RAC: Channels, Instances, Backup 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
  • Monitoring RAC with Cluster Health Advisor (CHA)

Managing High Availability of Services in a RAC Environment

  • Oracle Services
  • Services for Policy – and Administrator-Managed Databases
  • Service-Oriented Buffer Cache Access
  • Creating Services
  • Managing Services
  • Use Services with Client Applications
  • Services and Connection Load Balancing
  • Services and Transparent Application Failover

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

Oracle Database In-Memory in RAC

  • Architecture of In-Memory Column Store
  • Implementing In-Memory Column Store in RAC
  • Implementing In-Memory FastStart
  • 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
  • Curso Oclacle 12c RAC – Administração de Banco de Dados
TENHO INTERESSE

Cursos Relacionados

Curso Oracle Database 12c Admin Install Upgrade

horas

Curso Oracle Database 12c Administração I

horas

Curso Oracle 12c Banco de Dados Introdução ao SQL

32 horas

Curso Oracle Fundamentos de Big Data

32 horas

Curso Oracle Database 12c Performance Tuning

horas

Curso Oracle 12c 10 Programa com PL/SQL

32 horas

Curso Oracle 12c Banco de Dados PL/SQL Advanced

24 horas

Curso Oracle 18c Database Backup and Recovery Workshop

32 horas

Curso Oracle GoldenGate 12c Fundamentos

32 horas