Oracle backup and recovery

In this 2-day classroom ABIS course, the alternative backup, recovery and restore options offered by the Oracle RMAN tool are thoroughly discussed and practically practiced. Useful for anyone responsible for developing and implementing backup/recovery scenarios. Prior knowledge of SQL, and basic knowledge of Oracle databases, is recommended.

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.

Schedule a training?

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.

REQUEST IN-COMPANY TRAINING

 

Public training calendar

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

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

Background

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

You can test for yourself to see if you have enough background by filling out the on-line self-test "Oracle fundamentals".

Main topics

  • 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

Training method

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

Certificate

At the end of the course session, the participant receives a 'Certificate of Completion'.

Duration

2 days.

Course leader

Kris Van Thillo (ABIS).


SESSION INFO AND ENROLMENT