> Formations > Oracle Database 19c: Backup and Recovery Workshop

Publication date : 08/22/2024

Course : Oracle Database 19c: Backup and Recovery Workshop

OFFICIAL COURSE: DIGITAL SUPPORT AVAILABLE FOR 90 DAYS ONLY

Practical course - 5d - 35h00 - Ref. ODB

Oracle Database 19c: Backup and Recovery Workshop

OFFICIAL COURSE: DIGITAL SUPPORT AVAILABLE FOR 90 DAYS ONLY



With this training course, you'll learn how to perform backup and recovery based on the associated Oracle database architecture components. You'll also gain the skills needed to assess your own recovery needs and develop an appropriate strategy for backup and recovery procedures.


INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class
Available in English on request

Ref. ODB
  5d - 35h00
Contact us




With this training course, you'll learn how to perform backup and recovery based on the associated Oracle database architecture components. You'll also gain the skills needed to assess your own recovery needs and develop an appropriate strategy for backup and recovery procedures.


Teaching objectives
At the end of the training, the participant will be able to:
Develop appropriate backup and restore procedures to meet your business needs
Implement backup and restore parameters
Perform disk and tape backup operations
Use Oracle database recovery procedures in the event of media failure or other breakdowns
Diagnose and repair data faults
Use Flashback technologies and data duplication
Secure the availability of your database with appropriate backup and restore strategies

Intended audience
Database and data warehouse administrators, database designers, support engineers and technical administrators.

Prerequisites
Completion of Oracle Database: Administration Workshop or equivalent knowledge and skills. Understanding of English and IT-specific English vocabulary.

Certification
Successful completion of the exam qualifies you for Oracle Database Administration II certification.
Comment passer votre examen ?

Practical details
Teaching methods
Animation de la formation en français. Support de cours et travaux pratiques en anglais, au format numérique et ACCESSIBLE UNIQUEMENT PENDANT 90 JOURS. Bonne compréhension de l’anglais à l’écrit.

Course schedule

1
Introduction and configuration

  • Introduction and first steps.
  • Configure for recovery.
  • Use the RMAN recovery catalog.

2
Backup

  • Backup strategies and terminology.
  • Make backups.
  • Improve backups.
  • Use encrypted RMAN backups.

3
Recovery

  • Diagnose faults.
  • Restoration and recovery concepts.
  • Perform a full recovery.
  • Make a one-off recovery.
  • Perform additional recovery operations.

4
Additional technologies

  • Use Flashback technologies.
  • Use the Flashback database.
  • Data transport.
  • Duplicate a database.
  • Troubleshoot and optimize RMAN.

5
Practical work

  • Backup and recovery workshop.