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.
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