Oracle Database 19c: Backup and Recovery

Price
$4,000.00

Duration
5 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Course Overview

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. After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. Versions Supported: 19c, 18c, 12c

Course Objectives

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

Who Should Attend?

Oracle Database Administrator Data Warehouse Administrator Support Engineer Technical Consultant Technical Administrator

United Training is committed to working as a partner with our clients. Choose United Training and take advantage of the following benefits.

  • Robust Public Enrollment Schedule. Enjoy access to hundreds of Guaranteed to Run dates across a diverse catalog of course titles.
  • Private Group Training. Let our world-class instructors come to you to deliver training at your place of business or we can present to your team online using our Virtual Instructor-Led Training platform.
  • Custom Training Solutions. Our subject matter experts can customize the class to specifically address the unique goals of your team.
  • Free Re-Takes. Most completed United Training courses carry our unbeatable Learning Guarantee. This guarantee allows students to repeat most United Training courses, if they are the same version, FREE OF CHARGE, within six months of completion of the courses. Exceptions: Cisco, Citrix, VMware, Red Hat, and courses provided by affiliated 3rd party training providers.

Course Prerequisites

Oracle Database 19c: Administration Workshop Oracle database administration experience

Agenda

1 - Outline

  • Backup and Recovery: Overview
  • Backup and Recovery Configuration
  • Using Recovery Manager (RMAN)
  • Backup Strategies
  • Creating Database Backups
  • Using Optional Backup Features
  • Tuning RMAN Backup Performance
  • Recovery Catalog Overview
  • Creating a Recovery Catalog
  • Managing Target Database Records
  • Using Stored Scripts
  • Creating and Using Virtual Private Catalogs
  • Restore and Recovery Concepts
  • Diagnosing Failures
  • Performing Complete Recovery
  • Performing Point-in-Time Recovery
  • Performing Block Media Recovery
  • Performing Additional Recovery Operations
  • Oracle Flashback Technology: Overview
  • Using Logical Flashback Features
  • Using Flashback Database
  • Using PDB Snapshots
  • Database Duplication Overview
  • Creating a Backup-Based Duplicate Database
 

There are no open enrollment courses currently scheduled.
Inquire about scheduling this course when it’s best for your team. Learn More about Private Group Training

 


Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
 
Contact Us about Starting Your Business Training Strategy with United Training