Oracle Database 19c - Backup and Recovery

• Basic understanding of Oracle database administration
• Familiarity with SQL and PL/SQL

Audience

• Database administrators
• IT professionals

Oracle Database 19c: Backup and Recovery refers to the processes and strategies used to safeguard data stored in Oracle Database 19c and to restore that data in the event of a failure, corruption, or loss.

This instructor-led, live training (online or onsite) is aimed at beginner-level database administrators who wish to manage backup and recovery tasks in Oracle Database 19c.

By the end of this training, participants will be able to:

• Understand the essential concepts of backup and recovery in Oracle Database 19c, including the architecture and various types of failures.
• Gain hands-on experience in configuring backup and recovery settings, including the RMAN environment and fast recovery area.
• Develop practical skills in performing different types of backups and recovery operations, including full, incremental, and point-in-time recovery.
• Learn how to utilize Oracle's Flashback technology for effective database recovery and manage disaster recovery scenarios.
• Apply best practices for backup, recovery, and disaster recovery to ensure data availability and minimize downtime in Oracle Database 19c.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction

Overview of Backup and Recovery Concepts

• Understanding the importance of backup and recovery
• Types of failures and their impact on databases
• Oracle Database 19c backup and recovery architecture

Configuring Backup and Recovery Settings

• Configuring the fast recovery area (FRA)
• Setting up backup and recovery policies
• Configuring the RMAN environment

Performing Backups Using RMAN

• Full database backups
• Incremental backups
• Multitenant database (CDB and PDB) backup strategies
• Archiving and managing archived redo logs

Backup Strategies and Best Practices

• Choosing the right backup strategy: full, incremental, differential
• Implementing Oracle-suggested backup strategies
• Best practices for backup retention and validation

Understanding Recovery Operations

• Recovering from user errors
• Media recovery: datafile, tablespace, and block recovery
• Point-in-time recovery (PITR)

Recovering from Database Failures

• Instance recovery and media recovery overview
• Recovering from control file and redo log file loss
• Multitenant environment recovery scenarios (CDB and PDB recovery)

Flashback Technology for Database Recovery

• Overview of Oracle Flashback technology
• Using Flashback Database, Flashback Table, and Flashback Drop
• Configuring and managing Flashback technology

Performing Disaster Recovery

• Planning and implementing disaster recovery strategies
• Data Guard integration with RMAN for disaster recovery
• Best practices for disaster recovery in Oracle Database 19c

Summary and Next Steps