Catalog > All Topics

Oracle 19c Backup Recovery and Tuning (Oracle 19c BRT)

Oracle
3 Days
Download Course Outline
$1,795.00
Request a Quote
Credit not applicable
Share
Schedule
Export to CSV
  • No schedule events found for this course.
      • PC
        Private Class
        Privately train a group of your employees at your facility, virtually, or any of our locations.
    Request
  • LCLive Classroom
    Live Classroom
    Learn and interact with your instructor and peers in-person in our classrooms.
  • VCVirtual Classroom
    Virtual Classroom
    Attend any of our instructor-led classes virtually regardless of your physical location.
  • PCPrivate Class
    Private Class
    Privately train a group of your employees at your facility, virtually, or any of our locations.
  • GTRGuaranteed to Run
    Guaranteed to Run
    GTR classes are guaranteed to run as promised and delivered.
Course Summary
Show All

Description

Learn to implement basic backup and recover procedures, move data between databases and files, and employ basic monitoring procedures

Oracle Database 19c Backup and Recovery is a comprehensive, hands-on course that allows DBAs to develop appropriate backup and recovery procedures to address their business model and requirements. Students will explore how to implement basic backup and recover procedures, move data between databases and files, and employ basic monitoring procedures. Students will also learn how to secure the availability of their database by using appropriate backup and recovery strategies.

Objectives

Our engaging instructors and mentors are highly-experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will learn to:

  • Implement backup and recovery settings and perform backup operations to the media of your choice.
  • Move data between databases and files
  • Use Oracle Database recovery processes 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 their database using backup and recovery strategies

Prerequisites

Incoming students should possess:

  • Knowledge of SQL and PL/SQL (for DBA use)
  • Knowledge of Oracle Database 18c or newer
  • Linux skills, including familiarity with command-line options such as ls, cd, cp, and su

Who Should Attend

This hands-on course is geared for experienced DBAs already working with Oracle.

  •  

  •  

Outline

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience needs and skill-level.

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 Recoverability

  • 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 Backup