Visão Geral

Curso Oracle Database 19C Administration Workshop, você aprenderá sobre a experiência prática do administrador de banco de dados Oracle na administração, monitoramento, ajuste e solução de problemas de um banco de dados Oracle.

Por meio de uma combinação de laboratórios práticos e palestras interativas, você aprenderá como criar estruturas de armazenamento de banco de dados apropriadas para os aplicativos de negócios suportados pelo seu banco de dados. Além disso, você aprenderá a criar usuários e administrar a segurança do banco de dados para atender aos seus requisitos de negócios. Informações básicas sobre técnicas de backup e recuperação são apresentadas neste curso.

Objetivo

Após realizar este Curso Oracle Database 19c Administration, você será capaz de:

• Familiarize-se com a arquitetura do banco de dados Oracle para que possa descrever as muitas áreas que você precisa entender para gerenciá-la adequadamente e se beneficiar de seus recursos
• Compreender a arquitetura e os recursos do Oracle Database Cloud Service (DBCS)
• Gerenciar a segurança do banco de dados e implementar auditoria
• Implementar procedimentos básicos de backup e recuperação
• Mover dados entre bancos de dados e arquivos
• Empregue procedimentos básicos de monitoramento e gerencie o desempenho
• Planeje procedimentos eficazes de backup e recuperação
• Configure o banco de dados para capacidade de recuperação
• Use o Recovery Manager (RMAN) para criar backups e executar operações de recuperação
• Use o Data Recovery Advisor para diagnosticar e reparar falhas
• Use Oracle Flashback Technologies para se recuperar de erros humanos
• Execute um backup e restauração de banco de dados criptografado
• Execute a recuperação point-in-time do espaço de tabela Gerenciar instantâneos de PDB
• Criptografar dados em PDBs e isolar armazenamento de chaves PDB
• Monitore o desempenho em CDBs e PDBs
• Proteja os dados com políticas do Database Vault em CDB e PDBs
• Gerenciar uma frota de CDB
• Gerenciar a alocação de recursos entre PDBs e dentro de um PDB
• Use as operações do Data Pump de um não CDB ou CDB em um PDB
• Atualize os CDBs ou PDBs 12c para 18c
• Configure e crie um CDB
• Gerenciar usuários comuns e locais, funções, privilégios, perfis, objetos em CDBs e PDBs
• Faça backup, duplique, recupere e faça flashback de CDB e PDBs
• Montar e cabear um novo sistema de engenharia do Oracle Database Appliance
• Ligue o sistema pela primeira vez e defina as opções de rede
• Configurar Oracle Integrated Lights Out Manager (ILOM)
• Valide a versão do software Oracle Appliance Manager e recrie a imagem do sistema operacional, se necessário
• Baixe e instale o pacote de conjuntos de patches do Oracle Database Appliance mais recente
• Use a metodologia de ajuste do banco de dados Oracle adequada às ferramentas disponíveis
• Utilize consultores de banco de dados para ajustar proativamente uma instância de banco de dados Oracle
• Use as ferramentas baseadas no Automatic Workload Repository para ajustar o banco de dados
• Use as páginas relacionadas ao desempenho do Enterprise Manager para monitorar um banco de dados Oracle
• Descrever e determinar os requisitos de segurança do banco de dados
• Entenda as soluções de segurança da Oracle para ajudar a atender aos requisitos de segurança
• Implementar segurança básica de banco de dados
• Configure a segurança da rede
• Enumere as soluções de auditoria Oracle para monitorar os requisitos de segurança do banco de dados
• Implementar Oracle Audit Vault e Firewall de banco de dados
• Configurar e usar criptografia transparente de dados
• Compreenda e use as medidas de segurança do Oracle Key Vault
• Entenda o Oracle Data Redaction
• Entenda e use o Oracle Data Masking e Subsetting
• Compreenda os riscos de segurança em potencial e identifique as soluções Oracle apropriadas
• Configurar autenticação e autorização gerais
• Compreender e implementar usuários globais
• Configure e mantenha uma carteira simples
• Instale e use o Oracle Database Vault
• Configurar e usar proteção transparente de dados confidenciais
• Descreva os principais recursos do Exadata Database Machine
• Identifique os benefícios de usar o Exadata Database Machine para diferentes classes de aplicativos
• Descreva a arquitetura do Exadata Database Machine e sua integração com o Oracle Database, Clusterware e ASM
• Configure o gerenciamento de recursos de E / S
• Conclua a configuração inicial do Exadata Database Machine
• Descreva as abordagens recomendadas para migrar para o Exadata Database Machine
• Compreenda o Oracle Database Exadata Cloud Service
• Monitore a integridade do Exadata Database Machine e otimize o desempenho
• E mais…
•  

Publico Alvo

• Administradores de banco de dados
• Arquitetos de banco de dados
• Desenvolvedores de banco de dados
• Desenvolvedores
• Gerentes de TI
• Administradores de segurança
• Administradores da web
• Cientistas de dados
• Desenvolvedores NoSQL

Informações Gerais

• Carga horaria 32h
• Se noturno este curso e ministrado de segunda-feira a sexta das 19h às 23h, total de 8 noites, 
• Se aos sábados este curso e ministrado das 09h às 18h, total de 4 sábados

Formato de entrega:

• Este curso e ministrado ON-LINE AO VIVO, em tempo real na presença de um instrutor/consultor Oracle database.
• In-comany - Ministrado ON-LINE AO VIVO, em tempo real na presença de um instrutor/consultor Oracle database.

Materiais

Conteúdo Programatico

 Module 1: Introduction to Oracle Database

• Objectives
• Oracle Database Server Architecture: Overview
• Oracle Multitenant Container Database: Introduction
• Oracle Multitenant Container Database: Architecture
• Oracle Database Instance Configurations
• Database Sharding: Introduction
• Oracle Database Server: Interactive Architecture Diagram
• Summary

 Module 2: Accessing an Oracle Database

• Objectives
• Connecting to an Oracle Database Instance
• Oracle Database Tools
• Database Tool Choices
• SQL*Plus
• Oracle SQL Developer
• Oracle SQL Developer: Connections
• Oracle SQL Developer: DBA Actions
• Database Configuration Assistant (DBCA)
• Oracle Enterprise Manager Database Express
• Enterprise Manager Cloud Control 13c Features
• Oracle Enterprise Manager Component Overview
• Single Pane of Glass for Enterprise Management
• Oracle Enterprise Manager Database Management
• Summary

 Module 3: Creating an Oracle Database by Using DBCA

• Objectives
• Planning the Database
• Choosing a Database Template
• Choosing the Appropriate Character Set
• How Are Character Sets Used?
• Setting NLS_LANG Correctly on the Client
• Using the Database Configuration Assistant
• Using DBCA in Silent Mode
• Summary
• Practice Overview

 Module 4: Creating an Oracle Database by Using a SQL Command

• Objectives
• Creating a Container Database (CDB)
• Creating a CDB by Using a SQL Command: Example
• Using the SEED FILE_NAME_CONVERT Clause
• Using the ENABLE PLUGGABLE DATABASE Clause
• Summary
• Practice Overview

 Module 5: Starting Up and Shutting Down a Database Instance

• Objectives
• Starting the Oracle Database Instance
• Shutting Down an Oracle Database Instance
• Comparing SHUTDOWN Modes
• Opening and Closing PDBs
• Configuring PDBs to Automatically Open
• Summary
• Practice Overview

 Module 6: Managing Database Instances

• Objectives
• Working with Initialization Parameters
• Initialization Parameters
• Modifying Initialization Parameters
• Viewing Initialization Parameters
• Working with the Automatic Diagnostic Repository
• Automatic Diagnostic Repository
• Viewing the Alert Log
• Using Trace Files
• Administering the DDL Log File
• Querying Dynamic Performance Views
• Considerations for Dynamic Performance Views
• Data Dictionary: Overview
• Querying the Oracle Data Dictionary
• Summary
• Practice Overview

 Module 7: Oracle Net Services: Overview

• Objectives
• Connecting to the Database Instance
• Oracle Net Services: Overview
• Defining Oracle Net Services Components
• Tools for Configuring and Managing Oracle Net Services
• Oracle Net Listener: Overview
• The Default Listener
• Comparing Dedicated and Shared Server Architecture
• Summary

 Module 8: Configuring Naming Methods

• Objectives
• Establishing Oracle Network Connections
• Connecting to an Oracle Database Instance
• Name Resolution
• Establishing a Connection
• User Sessions
• Naming Methods
• Easy Connect
• Local Naming
• Directory Naming
• Using Database Services to Manage Workloads
• Creating Database Services
• Summary
• Practice Overview

 Module 9: Configuring and Administering the Listener

• Objectives
• Review: Oracle Net Services Overview
• Oracle Net Listener: Overview
• The Default Listener
• Configuring Dynamic Service Registration
• Configuring Static Service Registration
• Summary
• Practice Overview

 Module 10: Configuring a Shared Server Architecture

• Objectives
• Shared Server Architecture: Overview
• Comparing Dedicated and Shared Server Architecture: Review
• Enabling Shared Server
• Controlling Shared Server Operations
• SGA and PGA Usage
• Shared Server Configuration Considerations
• Summary
• Practice Overview

 Module 11: Configuring Oracle Connection Manager for Multiplexing and Access Control

• Objectives
• Oracle Connection Manager: Overview
• Oracle Connection Manager Processes
• Oracle Connection Manager: Architecture
• Using Filtering Rules
• Implementing Intranet Access Control
• Implementing Internet Access Control
• Using Session Multiplexing
• Configuring Oracle Connection Manager
• Configuring the cman.ora File
• Example of a cman.ora File
• Configuring Clients
• Configuring the Database Server
• Configuring the Database Server for Multiplexing (Optional)
• Using the Oracle Connection Manager Control Utility
• Review of Oracle Connection Manager Features
• Summary
• Practice Overview

 Module 12: Creating PDBs from Seed

• Objectives
• Provisioning New Pluggable Databases
• Tools
• Creating a New PDB from PDB$SEED
• Using the FILE_NAME_CONVERT Clause
• Using OMF or the PDB_FILE_NAME_CONVERT Parameter
• Summary
• Practice Overview

 Module 13: Using Other Techniques to Create PDBs

• Objectives
• Cloning Regular PDBs 3Migrating Data from a Non-CDB into a CDB
• Plugging a Non-CDB into CDB Using DBMS_PDB
• Replicating a Non-CDB into a CDB by Using GoldenGate
• Cloning a Non-CDB or Remote PDB
• Using DBCA to Clone a Remote PDB
• Plugging an Unplugged Regular PDB into CDB
• Plugging in a PDB Using an Archive File
• Cloning Remote PDBs in Hot Mode
• Near-Zero Downtime PDB Relocation
• Using DBCA to Relocate a Remote PDB
• Proxy PDB: Query Across CDBs Proxying Root Replica
• Creating a Proxy PDB
• Summary
• Practice Overview

 Module 14: Managing PDBs

• Objectives
• Changing the PDB Mode
• Modifying PDB Settings
• Impact of Changing Initialization Parameters
• Changing Initialization Parameters: Example
• Using the ALTER SYSTEM Command in a PDB
• Configuring Host Name and Port Number per PDB
• Dropping PDBs
• Summary
• Practice Overview

 Module 15: Database Storage Overview

• Objectives
• Database Storage Architecture
• Logical and Physical Database Structures
• Segments, Extents, and Blocks
• Tablespaces and Data Files
• Default Tablespaces in a Multitenant Container Database
• SYSTEM and SYSAUX Tablespaces
• Types of Segments
• How Table Data Is Stored
• Database Block Content
• Understanding Deferred Segment Creation
• Controlling Deferred Segment Creation
• Monitoring Tablespace Space Usage
• Summary

 Module 16: Creating and Managing Tablespaces

• Objectives
• Creating Tablespaces
• Creating a Tablespace: Clauses
• Creating Permanent Tablespaces in a CDB
• Defining Default Permanent Tablespaces
• Temporary Tablespaces
• Altering and Dropping Tablespaces
• Viewing Tablespace Information
• Implementing Oracle Managed File (OMF)
• Enlarging the Database
• Moving or Renaming Online Data Files
• Examples: Moving and Renaming Online Data Files
• Summary
• Practice Overview

 Module 17: Improving Space Usage

• Objectives
• Space Management Features
• Block Space Management
• Row Chaining and Migration
• Free Space Management Within Segments
• Allocating Extents
• Using Unusable Indexes
• Using Temporary Tables
• Creating Global Temporary Tables
• Creating Private Temporary Tables
• Table Compression: Overview
• Table Compression: Concepts
• Compression for Direct-Path Insert Operations
• Advanced Row Compression for DML Operations
• Specifying Table Compression
• Using the Compression Advisor
• Resolving Space Usage Issues
• Reclaiming Space by Shrinking Segments
• Shrinking Segments
• Results of a Shrink Operation
• Managing Resumable Space Allocation
• Using Resumable Space Allocation
• Resuming Suspended Statements
• What Operations Are Resumable?
• Summary
• Practice Overview

 Module 18: Managing Undo Data

• Objectives
• Undo Data: Overview
• Transactions and Undo Data
• Storing Undo Information
• Comparing Undo Data and Redo Data
• Managing Undo
• Comparing SHARED Undo Mode and LOCAL Undo Mode
• Configuring Undo Retention
• Categories of Undo
• Guaranteeing Undo Retention
• Changing an Undo Tablespace to a Fixed Size
• Temporary Undo: Overview
• Temporary Undo Benefits
• Enabling Temporary Undo
• Monitoring Temporary Undo
• Summary
• Practice Overview

 Module 19: Creating and Managing User Accounts

• Objectives
• Database User Accounts
• Oracle-Supplied Administrator Accounts
• Creating Oracle Database Users in a Multitenant Environment
• Creating Common Users in the CDB and PDBs
• Creating Schema Only Accounts
• Authenticating Users
• Using Password Authentication
• Using Password File Authentication
• Using OS Authentication
• OS Authentication for Privileged Users
• Assigning Quotas
• Summary
• Practice Overview

 Module 20: Configuring Privilege and Role Authorization

• Objectives
• Privileges
• System Privileges
• System Privileges for Administrators
• Object Privileges
• Granting Privileges in a Multitenant Environment
• Granting Privileges: Example
• Using Roles to Manage Privileges
• Assigning Privileges to Roles and Assigning Roles to Users
• Oracle-Supplied Roles
• Granting Roles in a Multitenant Environment
• Granting Roles: Example
• Making Roles More Secure
• Revoking Roles and Privileges
• Granting and Revoking System Privileges
• Granting and Revoking Object Privileges
• Summary
• Practice Overview

 Module 21: Configuring User Resource Limits

• Objectives
• Profiles and Users
• Creating Profiles in a Multitenant Architecture
• Creating Profiles: Example
• Profile Parameters: Resources
• Profile Parameters: Locking and Passwords
• Oracle-Supplied Password Verification Functions
• Assigning Profiles in a Multitenant Architecture
• Summary
• Practice Overvie

 Module 22: Implementing Oracle Database Auditing

• Objectives
• Database Security
• Monitoring for Compliance
• Types of Activities to be Audited
• Mandatorily Audited Activities
• Understanding Auditing Implementation
• Viewing Audit Policy Information
• Value-Based Auditing
• Fine-Grained Auditing
• FGA Policy
• Audited DML Statement: Considerations
• FGA Guidelines
• Archiving and Purging the Audit Trail
• Purging Audit Trail Records
• Summary
• Practice Overview

 Module 23: Introduction to Loading and Transporting Data

• Objectives
• Moving Data: General Architecture
• Oracle Data Pump: Overview
• Oracle Data Pump: Benefits
• SQL Loader: Overview
• Summary

 Module 24: Loading Data

• Objectives
• SQL Loader: Review
• Creating the SQL*Loader Control File
• SQL*Loader Loading Methods
• Protecting Against Data Loss
• SQL*Loader Express Mode
• Using SQL*Loader to Load a Table in a PDB
• Summary
• Practice Overview

 Module 25: Transporting Data

• Objectives
• Data Pump Export and Import Clients
• Data Pump Interfaces and Modes
• Data Pump Import Transformations
• Using Oracle Data Pump with PDBs
• Exporting from a Non-CDB and Importing into a PDB
• Exporting and Importing Between PDBs
• Full Transportable Export/Import
• Full Transportable Export/Import: Example
• Transporting a Database Over the Network: Example
• Using RMAN to Transport Data Across Platforms
• RMAN CONVERT Command
• Transporting Data with Minimum Down Time
• Transporting a Tablespace by Using Image Copies
• Determining the Endian Format of a Platform
• Transporting Data with Backup Sets
• Transporting a Tablespace
• Transporting Inconsistent Tablespaces
• Database Transport: Data Files
• Transporting a Database
• Transporting a Database: Conversion
• Transporting a Database: Example
• Transporting a Database: Considerations
• Transporting a Database with Backup Sets
• Summary
• Practice Overview

 Module 26: Using External Tables to Load and Transport Data

• Objectives
• External Tables
• External Tables: Benefits
• ORACLE_LOADER Access Driver
• ORACLE_DATAPUMP Access Driver
• External Tables
• Viewing Information About External Tables
• Summary
• Practice Overview

 Module 27: Automated Maintenance Tasks: Overview

• Objectives
• Proactive Database Maintenance Infrastructure
• Automated Maintenance Tasks: Components
• Predefined Automated Maintenance Task
• Maintenance Windows
• Predefined Maintenance Windows
• Viewing Maintenance Window Details
• Automated Maintenance Tasks
• Summary

 Module 28: Automated Maintenance Tasks: Managing Tasks and Windows

• Objectives
• Configuring Automated Maintenance Tasks
• Enabling and Disabling Maintenance Tasks
• Creating and Managing Maintenance Windows
• Resource Allocations for Automated Maintenance Tasks
• Changing Resource Allocations for Maintenance Tasks
• Summary
• Practice Overview

 Module 29: Database Monitoring and Tuning Performance Overview

• Objectives
• Performance Management Activities
• Performance Planning Considerations
• Database Maintenance
• Automatic Workload Repository (AWR)
• Automatic Database Diagnostic Monitor (ADDM)
• Configuring Automatic ADDM Analysis at the PDB Level
• Advisory Framework
• Performance Tuning Methodology
• Summary

 Module 30: Monitoring Database Performance

• Objectives
• Server-Generated Alerts
• Setting Metric Thresholds
• Reacting to Alerts
• Alert Types and Clearing Alerts
• Database Server Statistics and Metrics
• Performance Monitoring
• Viewing Statistics Information
• Monitoring Wait Events
• Monitoring Sessions
• Monitoring Services
• Summary
• Practice Overview

 Module 31: Database Processes

• Objectives
• Process Architecture
• Process Structures
• Database Writer Process (DBWn & BWnn)
• Log Writer Process (LGWR & LGnn)
• Checkpoint Process (CKPT)
• System Monitor Process (SMON)
• Process Monitor Process (PMON)
• Process Manager (PMAN)
• Recoverer Process (RECO)
• Listener Registration Process (LREG)
• Manageability Monitor Process (MMON)
• Archiver Processes (ARCn)
• Interacting with an Oracle Database: Memory, Processes, and Storage
• Summary
• Practice Overview

 Module 32: Managing Memory

• Objectives
• Managing Memory Components
• Shared Pool
• Database Buffer Cache
• Redo Log Buffer
• Large Pool
• Java Pool
• Streams Pool
• Program Global Area (PGA)
• Managing Memory Components
• Efficient Memory Usage: Guidelines
• Automatic Memory Management
• Monitoring Automatic Memory Management
• Automatic Shared Memory Management
• Understanding Automatic Shared Memory Management
• Oracle Database Memory Parameters
• Managing the SGA for PDBs
• Managing the Program Global Area (PGA)
• Managing the PGA for PDBs
• Summary
• Practice Overview

 Module 33: Analyzing SQL and Optimizing Access Paths

• Objectives
• SQL Tuning Process
• Oracle Optimizer
• Optimizer Statistics
• Optimizer Statistics Collection
• Setting Optimizer Statistics Preferences
• Optimizer Statistics Advisor
• Optimizer Statistics Advisor Report
• Executing Optimizer Statistics Advisor Tasks
• SQL Plan Directives
• Adaptive Execution Plans
• SQL Tuning Advisor: Overview
• SQL Access Advisor: Overview
• SQL Performance Analyzer: Overview
• Managing Automated Tuning Tasks
• Summary
• Practice Overview