Visão Geral

Curso Oracle Database 19c Backup and Recovery, Desenvolver, como capacidade mais rápida do Oracle Database, usar o ritmo e se manter à frente do banco de dados Oracle, o ritmo e se manter à frente do banco de dados Oracle.

Os seguintes especialistas da Oracle exploramos os seguintes:

• Novos recursos do banco de dados Oracle
• Múltiplos inquilinos
• Recursos de gerenciamento de frota
• Oracle Database Appliance (ODA)
• Máquina de banco de dados Exadata
• Implantar, atualizar e atualizar
• Restaurar e recuperar
• Segurança
• Alta disponibilidade
• Controles de detetive
• Controles Preventivos
• Firewall de banco de dados
• Cofre de Auditoria Oracle
• Cofre de Chaves Oracle

Objetivo

Após realizar este Curso Oracle Database 19c Backup and Recovery você será capaz de:

• Descrever os componentes da arquitetura do banco de dados Oracle relacionados às operações de backup e recuperação
• Planejar procedimentos eficazes de backup e recuperação
• Descrever os métodos de backup do banco de dados Oracle e as operações de recuperação que podem ser usados ​​para resolver falhas do banco de dados
• Configurar o banco de dados para capacidade de recuperação
• Usar o Recovery Manager (RMAN) para criar backups e executar operações de recuperação
• Usar o Data Recovery Advisor para diagnosticar e reparar falhas
• Usar as tecnologias Oracle Flashback para se recuperar de erros humanos
• Executar um backup e restauração do banco de dados criptografado
• Executar a recuperação point-in-time do espaço de tabela

Publico Alvo

• Data Warehouse Administrator
• Database Administrator
• Database Designer
• Support Engineer
• Technical Administrator 
• 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

Pre-Requisitos

• Curso Oracle Database Administration Workshop
• Conhecimento básico do sistema operacional Linux
• Conhecimento prático de pacotes SQL e PL/SQL
• Compreensão básica da arquitetura do banco de dados Oracle
• Familiaridade com procedimentos básicos de monitoramento de banco de dados

Informações Gerais

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

• Formato de entrega:

• 100% on-line ao vivo via Microsoft Teams na presença de um instrutor/consultor DBA Oracle atuando no mercado desde as primeiras versões do Oracle, além de vasta experiência no mercado nos mais vareados seguimentos de negócios, esses profissionais são expert em sala de aula, ministrando cursos em turmas abertas e turmas fechada para empresas de vários seguimentos público ou privado.
• Apostila + Lab Pratico para casa aluno,
• Cerificado de participação  

Materiais

Conteúdo Programatico

INTRODUCTION

1. Administration and Course Materials
2. Course Structure and Agenda
3. Delegate and Trainer Introductions

BACKUP AND RECOVERY CONSIDERATIONS

1. Plan and Implement a Backup and Recovery Strategy
2. Define a Disaster Recovery Plan
3. Test a Backup and Recovery Plan
4. Advantages and Disadvantages of Different Backup Methods
5. Backup Methods Comparison
6. Data Recovery Strategy
7. Backup Strategy
8. Validate the Recovery Strategy

ORACLE RECOVERY STRUCTURES AND PROCESSES

1. Architectural Components of Backup and Restore
2. Physical Database Structures
3. Logical Database Structures
4. Dynamic Performance Views
5. Redo Logs,Checkpoints and Archives
6. Use the Flash Recovery Area (FRA)
7. The Archivelog Modes of a Database

FLASHBACK

1. Configure and Use Flashback Database
2. Monitor Flashback Database
3. Flash Recovery Area Space Usage
4. Flashback Query
5. Retrieve Row History with Flashback Versions Query
6. Audit or Recover From Transactions with Flashback Transactions Query
7. Flashback Table
8. Recover Dropped Tables with Flashback Drop
9. The Recycle Bin
10. Recover Tables to a Point in Time With Flashback Table
11. Flashback Database
12. Flashback Restore Points
13. Flashback Transaction Backout
14. Flashback Data Archive

RECOVERY MANAGER OVERVIEW

1. RMAN Features and Components
2. The sysbackup Privilege
3. RMAN Commands
4. Connect to RMAN
5. Specify the Location of RMAN Output
6. Start Up and Shut Down a Target Database Using RMAN
7. Issue SQL Commands in RMAN

CREATE AND CONFIGURE A RECOVERY CATALOG

1. Create a Recovery Catalog
2. Register a Database
3. Unregister a Database
4. Control File Information
5. Virtual Private Catalogs
6. Backup a Recovery Catalog
7. Use a Flashback Recovery Area with RMAN
8. Configure Persistent RMAN Settings
9. Set Retention Policies
10. Configure Control File Autobackups
11. Integrate RMAN with a Media Manager

BACKUP WITH RMAN

1. Channel Allocation
2. Types of RMAN Backup
3. Recovery Manager Commands
4. Performing Backups
5. Closed and Open Backups
6. Incremental Backups
7. Fast Incremental Backups using Block Change Tracking
8. Backup File Image Copies
9. Oracle Suggested Backup
10. Validate Backups
11. Listing Backups

ADVANCED BACKUP TECHNIQUES

1. Create Multisection Backups
2. Create Duplexed Backup Sets
3. Create Compressed Backups
4. Backup the Control File to a Trace File
5. Backup Recovery Files
6. Backup up ASM Metadata

MAINTAIN A RECOVERY CATALOG

1. Change the Availability Status of Backups and Copies
2. Catalog Backups Made with Operating System Commands
3. Generate Backup Reports and Lists
4. Cross Check Backups and Copies
5. Delete Backups
6. Update the Repository after Backup Deletion
7. Drop Database and Archival Backups
8. Import and Export the Recovery Catalog
9. Use Data Dictionary Tables

ENCRYPTED RMAN BACKUPS

1. Create an Encrypted RMAN Backup
2. Transparent Encryption
3. Password Encryption
4. Use Different Encryption Modes

DATABASE FAILURE DIAGNOSTICS

1. The Automatic Diagnostic Repository
2. The Data Recovery Advisor
3. Understanding RMAN Messages and the Error Stack
4. Diagnose Data File Loss
5. Recovery with RESETLOGS
6. Dealing with Block Corruption

 OVERVIEW OF RESTORE AND RECOVERY

1. Restore and Recover
2. Instance Failure and Crash Recovery
3. Media Failure
4. An Overview of Complete Recovery
5. An Overview of Point in Time Recovery
6. Recovery with RESETLOGS

BASIC RESTORE AND RECOVER WITH RMAN

1. Perform Recovery in Noarchivelog Mode
2. Perform Complete Recovery in Archivelog Mode
3. Use the Flash Recovery Area for Fast Recovery
4. Automatic Tempfile Recovery
5. Identify the Database Files to Restore and Recover
6. Preview Backups used in Restore Operations
7. Apply Incremental Backups to Restore Datafile Image Copies
8. The Switch Command
9. The Data Recovery Advisor
10. Perform Incomplete Recovery (PITR)
11. Restore and Recover a tablespace
12. Restore and Recover Datafiles
13. Recover a Datafile Not Backed Up
14. Table Recovery from Backups
15. Recover Individual Data Blocks
16. The Data Recovery Advisor

ADVANCED RESTORE AND RECOVER WITH RMAN

1. Restore the Server Parameter File
2. Restore the Control File
3. Re-create the Password File
4. Handling Redo Log File Loss
5. Restore and Recover the Database on a New Host
6. Restore RMAN Encrypted Backups
7. Disaster recovery

TABLESPACE POINT IN TIME RECOVERY (TSPITR)

1. Tablespace-Point-in-Time Overview
2. Tablespace-Point-in-Time Example

TRANSPORT DATA

1. Transport Tablespaces
2. Transport Databases

CREATE A DUPLICATE DATABASE WITH RMAN

1. Database Duplication
2. Duplication Options
3. Create Files for the Duplicate Database
4. Prepare the Auxiliary Instance for Duplication
5. Create a Duplicate Database
6. Clone a Running Database
7. An Overview of Using Cloud Control to Clone a Running Database
8. Targetless Duplication of a Database
9. Duplication Enhancements from 18c

MONITOR,TUNE AND TROUBLESHOOT BACKUP AND RECOVERY

1. Tune Recovery Manager Overview
2. Restore and Recovery Performance Best Practices
3. Multiplexing in RMAN
4. Diagnosing Performance Bottlenecks