Take advantage of spring savings with up to 50% off ILT training.

MyGK
Support
Canada Canada - English
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Contact Sales
Course  
Contact Sales
Support
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Request Group Training

Oracle 19c Backup, Recovery, & Tuning

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.

GK# 100726 Vendor# Oracle 19c Database
Vendor Credits:
No matching courses available.
Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.
Access Period:
Scheduling a custom training event for your team is fast and easy! Click here to get started.
$
Your Selections:
Location:
Access Period:
No available dates
Add To Cart

BUY NOW

Request a quote

Who Should Attend?

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

What You'll Learn
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

 

Course 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

 

 

BUY NOW

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