This course focuses on the backup and recovery facilities offered by the Oracle database. After a brief introduction discussing logging and archiving, we provide a detailed overview of the Oracle backup and recovery tool RMAN. Following a brief description of the tool's architecture, we discuss the various backup and recovery scenarios supported by this tool. Of course, correct backup and recovery scenarios are demonstrated and elaborated on the basis of a number of concrete cases. At the end of the course, the student is able to write a suitable recovery scenario for the most important 'disasters'!

This course:

• discusses Oracle database logging and archiving;
• introduces RMAN: architecture, tool, usage;
• discusses the alternative backup scenarios supported by the tool;
• discusses the restore/recovery possibilities - among other things in function of the selected backup scenarios;
• maps the most important 'types' of 'disasters', and how to deal with them in practice.

• Oracle logging - Archiving
• Strategy
  Backup and recovery scenarios • strategy
• RMAN - setup and architecture • configuration • scripting
• Backup
  Options • alternatives • backup command • scripts
  Alternative scenarios
• Recovery
  Recovery/Restore command • alternative possibilities
  Alternative scenarios
• Additional topics
  RMAN catalog • catalog management (scripts)
  Special techniques - table recovery, Point-In-Time recover

Live instructor-led training, with plenty of opportunities for hands-on exercises and discussion

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. 
Training can be implemented in English, Dutch, or French.
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.

Knowledge of Oracle (see courses Oracle fundamentals course and Oracle DBA 1 - Core competences).

Database and system administrators. Everyone responsible for the implementation of concrete back-up and recovery scenarios.