Workshop

Digicomp Code ODBACK

Oracle Database – Backup and Recovery with RMAN («ODBACK»)

In this workshop we convey the knowledge about the importance of database backup. This is the basis for a successful recovery of the entire database - or parts of it - if necessary.
Duration 3 days
Price 2'950.–
Course documents Digicomp digital courseware
Register

Course facts

  • Knowing the importance of database backup
  • Restoring the database
  • Creating a database clone for different tasks
  • Creating online/offline backups and incremental backups using Oracle RMAN - Backup and Recover Manager
  • Integrating 3rd party backup solutions

This workshop also covers practical requirements, such as creating a database clone for various tasks, and shows how to implement this. The tool of choice is Oracle RMAN - Backup and Recover Manager. This allows online/offline backups as well as incremental backups, no matter if you use single instances, RAC, Dataguard environments or even Multitenant Databases. Integration with 3rd party backup solutions is also covered.

  • Backup & Recovery Overview
  • RMAN Architecture
  • RMAN Repository
  • Backup and database copy with RMAN
  • Backup to DISK and SBT_TAPE (incl. 3rd party backup integration)
  • Backup of pluggable databases
  • Backup management with SHOW, CONFIGURE, LIST and REPORT
  • Backup encryption and compression
  • Restore
  • Recovery
  • TSPITR - Point in Time Recovery for Tablespaces
  • Table Point in Time Recovery
  • Flashback Database
  • RMAN Duplicate Database
  • RMAN Performance Tuning
  • Storage Based Backup Implementation and Integration
  • Backup of RAC and Data Guard Environments

The participants receive theoretical knowledge, which is consolidated with many practical exercises. 

This workshop is intended for prospective Oracle database administrators, operating system administrators, and individuals involved in operating tasks.

Basic SQL knowledge is helpful, but not required. Understanding of operating system processes is required.

Course environment (and Oracle license requirements)

  • This workshop is based on Oracle Database 23ai Free. Further information on the course environment and Oracle licensing can be found here.
  • SQL*Plus is used as the front end. The use of Oracle SQL*Developer or one of the numerous third party tools (Toad, SolarWind etc) is partially possible, but leads to different exercise sequences.

Download

Download course details as PDF

Questions

Choose your date