Get in Touch
 Duration 14 hours

Course Outline

Introduction

Overview of Backup and Recovery Principles

  • Recognizing the critical importance of backup and recovery.
  • Analyzing different failure types and their database implications.
  • The backup and recovery architecture of Oracle Database 19c.

Configuring Backup and Recovery Parameters

  • Establishing the fast recovery area (FRA).
  • Defining backup and recovery policies.
  • Configuring the RMAN environment.

Executing Backups via RMAN

  • Performing full database backups.
  • Conducting incremental backups.
  • Backup approaches for multitenant databases (CDB and PDB).
  • Archiving and managing archived redo logs.

Backup Strategies and Recommended Practices

  • Selecting appropriate backup methods: full, incremental, or differential.
  • Applying Oracle-recommended backup strategies.
  • Best practices for backup retention and validation.

Navigating Recovery Operations

  • Addressing user-induced errors.
  • Media recovery: restoring datafiles, tablespaces, and blocks.
  • Implementing point-in-time recovery (PITR).

Recovering from Database Failures

  • An overview of instance and media recovery.
  • Recovering from lost control files and redo log files.
  • Recovery scenarios in multitenant environments (CDB and PDB).

Leveraging Flashback Technology for Recovery

  • An introduction to Oracle Flashback technology.
  • Utilizing Flashback Database, Flashback Table, and Flashback Drop.
  • Configuration and management of Flashback features.

Implementing Disaster Recovery

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

Conclusion and Future Directions

Requirements

  • Foundational knowledge of Oracle database administration.
  • Proficiency with SQL and PL/SQL.

Target Audience

  • Database administrators.
  • IT specialists.

Number of participants


Price per participant (excl. VAT)

Testimonials (1)

Upcoming Courses

Related Categories