TREINAMENTO DE TI

Neste curso, os alunos irão aprender sobre RAC administração de banco de dados noambiente de infra-estrutura Oracle Grid. Os alunos irão aprender a administrar bancos de dados de cluster usando o Enterprise Manager e utilitários de linha de comandocomo srvctl, CRSCTL e SQL * Plus. Os alunos irão estudar a arquitetura nova ligação e como fazer essas conexões de alta disponibilidade. Problemas de backup erecuperação em relação aos ambientes de cluster de banco de dados também serãoestudados.

Este curso é baseado no Oracle Database 11g Release 2.

Aprenda a:
Administrar a política e as bases de dados gerenciado Administrador RAC
Instalar e configurar o software RAC 11gR2
Descrever de backup e recuperação em um ambiente RAC
Criar e configurar um banco de dados RAC.
Use Serviços
Descrever o banco de dados Oracle RAC 11gR2 melhorias e novas funcionalidades

·         Administrador de Data Warehouse

·         Consultor Técnico

·         Administrador de Banco de Dados

Pré-requisitos Obrigatórios:

·         Oracle Database Administration experience

·         Oracle Database 11g: Administration Workshop I DBA Release 2

Pré-requisitos Recomendados:

·         Oracle Database 11g: Administration Workshop II DBA Release 2

·         Oracle Database: Introduction to SQL

·         Install Oracle 11gR2 software and create RAC database

·         Manage RAC databases

·         Manage backup and recovery for RAC

·         Determine RAC-specific tuning components

·         Configure and manage services in a RAC environment

·         Describe high availability architectures

Real Application Clusters Database Installation

·         Installing The Oracle Database Software

·         Creating A Cluster Database

·         Post–database Creation Tasks

·         Single-Instance Conversion Using the DBCA

·         Single-Instance Conversion Using rconfig

·         Background Processes Specific to Oracle RAC

Oracle RAC Administration

·         Enterprise Manager Cluster Database Pages

·         Redo Log Files In A RAC Environment

·         Undo Tablespaces In A RAC Environment

·         Starting And Stopping RAC Databases And Instances

·         Initialization Parameters In A RAC Environment

·         Transparent Data Encryption and Wallets in RAC

·         Quiescing RAC Databases

Managing Backup and Recovery for RAC

·         Protecting Against Media Failure

·         Parallel Recovery in RAC

·         Archived Log File Configurations

·         RAC Backup and Recovery Using EM

·         Archived Redo File Conventions in RAC

·         Channel Connections to Cluster Instances

·         Distribution of Backups

Monitoring and Tuning the RAC Database

·         Determining RAC-Specific Tuning Components

·         Tuning Instance Recovery in RAC

·         RAC-Specific Wait Events, Global Enqueues, and System Statistics

·         Implementing the Most Common RAC Tuning Tips

·         Using the Cluster Database Performance Pages

·         Using the Automatic Workload Repository in RAC

·         Using Automatic Database Diagnostic Monitor in RAC

Services

·         Configure and Manage Services in a RAC environment

·         Using Services with Client Applications

·         Using Services with the Database Resource Manager

·         Use Services with the Scheduler

·         Configuring Services Aggregation and Tracing

·         Managing Services From the Command Line

·         Managing Services With Enterprise Manager

Design for High Availability

·         Designing a Maximum Availability Architecture

·         Determine the Best RAC and Data Guard Topologies

·         Data Guard Broker Configuration files in a RAC Environment

·         Identifying Successful Disk I/O strategies

Duração: 03 Dias