Get in Touch
 Duration 14 hours

Course Outline

Introduction

Overview of Backup and Recovery Principles

  • Recognizing the critical role of backup and recovery
  • Identifying failure types and their consequences for databases
  • The backup and recovery architecture of Oracle Database 19c

Setting Up Backup and Recovery Configurations

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

Executing Backups with RMAN

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

Backup Strategies and Best Practices

  • Selecting the optimal backup strategy: full, incremental, or differential
  • Adopting Oracle-recommended backup methodologies
  • Best practices for backup retention and verification

Understanding Recovery Procedures

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

Recovering from Database Failures

  • Overview of instance and media recovery
  • Recovering from the loss of control files and redo log files
  • Recovery scenarios in Multitenant environments (CDB and PDB)

Utilizing Flashback Technology for Database Recovery

  • Introduction to Oracle Flashback technology
  • Implementing Flashback Database, Flashback Table, and Flashback Drop
  • Configuring and managing Flashback capabilities

Executing Disaster Recovery

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

Conclusion and Future Steps

Requirements

  • Fundamental knowledge of Oracle database administration
  • Working familiarity with SQL and PL/SQL

Target Audience

  • Database administrators
  • IT professionals

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories