• Presencial

Oracle Database 18c: Backup and Recovery Workshop


In this course, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are included so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several database related failure situations.

The student begins by gaining a deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication.

Extensive hands-on practices and workshop scenarios provide the student with experience in a realistic technical environment. This course includes an interactive workshop that provide participants with opportunities to diagnose and recover from several failure scenarios, based on backup and recovery case studies.

Destinatários

  • Database Administrators
  • Support Engineer
  • Technical Consultant
  • Technical Administrator
  • Data Warehouse Administrator

Pré-requisitos

Suggested Prerequisite

  • Knowledge of SQL and PL/SQL (for DBA use)
  • Knowledge of Oracle Database 18c
  • Basic knowledge of Linux operating system

Required Prerequisite

  • Oracle Database 18c: Administration Workshop

Objetivos

Learn To:

  • Develop appropriate backup and recovery procedures to address your business needs.
  • Implement backup and recovery settings and perform backup operations to disk and tape.
  • Employ Oracle Database recovery procedures to recover from media and other failures.
  • Diagnose and repair data failures.
  • Use flashback technologies and data duplication to complement backup and recovery procedures.
  • Secure the availability of your database by appropriate backup and recovery strategies.

Programa

  • Introduction
  • Getting Started
  • Configuring for Recoverablility
  • Using the RMAN Recovery Catalog
  • Backup Strategies and Terminology
  • Performing Backups
  • Improving Your Backups
  • Using RMAN-Encrypted Backups
  • Diagnosing Failures
  • Restore and Recovery Concepts
  • Performing Complete Recovery
  • Performing Point-in-Time Recovery
  • Additional Recovery Operations
  • Using Flashback Technologies
  • Using Flashback Database
  • Transporting Data
  • Performing Point-in-Time Recovery
  • Duplicating a Database
  • RMAN Troubleshooting and Tuning
  • Backup and Recovery Workshop

Introduction

  • Oracle Maximum Availability Architecture
  • Assess your recovery requirements
  • Categories of failures
  • Basic Workshop Architecture
  • Curriculum Context
  • Oracle backup and recovery solutions
  • Overview of Oracle Secure Backup and Oracle Data Guard

Getting Started

  • Oracle DBA tools for backup and recovery
  • Connecting to Oracle Recovery Manager (RMAN)
  • Review of Oracle Database architecture

Configuring for Recoverablility

  • Configuring and managing persistent settings
  • Multiplexing the control file
  • RMAN commands
  • Archiving redo log files
  • Using the Fast Recovery Area (FRA)
  • Multiplexing redo log files

Using the RMAN Recovery Catalog

  • Creating and Configuring the Recovery Catalog
  • Using RMAN Stored Scripts
  • Using Virtual Private Catalogs
  • Managing Target Database Records in the Recovery Catalog
  • Maintaining and Protecting the Recovery Catalog

Backup Strategies and Terminology

  • Backing Up Read-Only Tablespaces
  • Balancing Backup and Restore Requirements
  • Backup Terminology
  • Data Warehouse Backup and Recovery: Best Practices

Performing Backups

  • RMAN Backup Types
  • Oracle-Suggested Backup
  • Reporting on Backups
  • Managing Backups
  • Fast Incremental Backup
  • Incrementally Updated Backups
  • Block Change Tracking

Improving Your Backups

  • Creating and Managing Archival Backups
  • Cataloging Additional Backup Files
  • Using a Media Manager
  • Compressing Backups
  • Backing Up Recovery Files
  • Backing Up the Control File to a Trace File
  • Backup and Restore for Very Large Files

Using RMAN-Encrypted Backups

  • Using Dual-Mode Encryption
  • Creating RMAN-Encrypted Backups
  • Restoring Encrypted Backups
  • Using Password-Mode Encryption
  • Using Transparent-Mode Encryption

Diagnosing Failures

  • Automatic Diagnostic Repository
  • Performing Block Media Recovery
  • Using the Data Recovery Advisor
  • Reducing Problem Diagnosis Time

Restore and Recovery Concepts

  • Complete Recovery (Overview)
  • Instance Failure and Instance/Crash Recovery
  • Restoring and Recovering
  • Point-in-Time Recovery (Overview)
  • Recovery with the RESETLOGS Option
  • Media Failure

Performing Complete Recovery

  • Using RMAN for Recovery in NOARCHIVELOG Mode
  • Performing Complete Recovery
  • Using Restore Points
  • Using Image Files for Recovery

Performing Point-in-Time Recovery

  • Performing Database Point-in-Time Recovery
  • Performing Fully Automated TSPITR
  • When to use Tablespace Point-in-Time Recovery (TSPITR)
  • TSPITR Architecture
  • Recovering Tables from Backups

Additional Recovery Operations

  • Recovery of Server Parameter File (SPFILE)
  • Performing Disaster Recovery
  • Recovering from the Loss of a Redo Log File Group
  • Restoring the Database to a New Host
  • Restoring the Control File

Using Flashback Technologies

  • Flashback Transaction Query
  • Using Flashback Technology to Query Data
  • Flashback Table
  • Flashback Data Archive
  • Flashback Technology: Overview
  • Flashback Drop and the Recycle Bin

Using Flashback Database

  • Configuring Flashback Database
  • Performing Flashback Database
  • Flashback Database Architecture
  • Creating Guaranteed Restore Points
  • Best Practices for Flashback Database

Transporting Data

  • Transporting Data Across Platforms
  • Database Transport: Using Data Files
  • Transporting Data with Backup Sets

Performing Point-in-Time Recovery

  • Performing RMAN TS Point-in-time Recovery
  • When to use TSPITR
  • Recovering Tables from Backups
  • TSPITR Architecture

Duplicating a Database

  • Understanding the RMAN Duplication Operation
  • Comparing the “Push” and “Pull” Methods
  • Choosing Database Duplication Techniques
  • Creating a Backup-Based Duplicate Database
  • Using a Duplicate Database

RMAN Troubleshooting and Tuning

  • Interpreting RMAN Message Output
  • Tuning RMAN Backup Performance
  • Configuring RMAN Multiplexing
  • Diagnosing Performance Bottlenecks

Backup and Recovery Workshop

  • Workshop Structure and Approach
  • Diagnosing the Failures
  • Business Requirements for Database Availability and Procedures

Outras Edições

Inscreva-se

Dados Pessoais

Dados para faturação

Condições Gerais e Autorizações
  • Se a inscrição for cancelada com antecedência superior a 5 dias úteis da data de início do curso, a Rumos não efectuará qualquer facturação ao cliente.
  • Se a inscrição for cancelada com antecedência igual ou inferior a 5 dias, a Rumos procederá à facturação do valor da inscrição, dando no entanto ao cliente a possibilidade de transferir a sua inscrição para uma nova data. Esta garantia é válida por 6 meses, não se responsabilizando a Rumos se o curso não se repetir nesse período.
  • Pela não comparência do participante no curso sem cancelamento da inscrição a Rumos facturará o valor da inscrição, perdendo o formando o direito à participação no curso.
  • A viabilidade de realização de um curso depende de um número mínimo de inscrições. A Rumos reserva o direito de cancelar um curso por falta de viabilidade deste, notificando esse facto aos inscritos com o mínimo de 2 dias úteis de antecedência.

Os seus dados pessoais são recolhidos em conformidade com o Regulamento Geral de Proteção de Dados (RGPD).
Consente que os seus dados sejam utilizados, nos termos da nossa Politica de Privacidade, para o contacto/envio de:

Ações de informação, de marketing de produtos e serviços, como campanhas e eventos?

Para mais informações, consulte a Política de Privacidade do Grupo Rumos.
pode retirar o seu consentimento a qualquer momento através do botão Cancelar subscrição ou Unsubscribe que estão presentes em cada comunicação enviada, bem como exercer os direitos descritos na politica de privacidade

Para a subscrição da newsletter deverá desativar o bloqueio de pop-ups do seu browser.

Oracle Database 18c: Backup and Recovery Workshop

  • Datas
    09 Dez a 13 Dez 2019
    Lisboa
  • Horário
    Laboral
    das 09h30 às 17h30
  • Nº Horas
    30
  • Preço
    Sob Consulta €

Oracle Database 18c: Backup and Recovery Workshop

Área

Dados

Como chegou até nós

Os seus dados pessoais são recolhidos em conformidade com o Regulamento Geral de Proteção de Dados (RGPD).
Consente que os seus dados sejam utilizados, nos termos da nossa Politica de Privacidade, para o contacto/envio de:

Ações de informação, de marketing de produtos e serviços, como campanhas e eventos?

Para mais informações, consulte a Política de Privacidade do Grupo Rumos.
pode retirar o seu consentimento a qualquer momento através do botão Cancelar subscrição ou Unsubscribe que estão presentes em cada comunicação enviada, bem como exercer os direitos descritos na politica de privacidade

Para a subscrição da newsletter deverá desativar o bloqueio de pop-ups do seu browser.