Workshop
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
Course facts
Key Learnings
- 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
Content
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
Methodology & didactics
The participants receive theoretical knowledge, which is consolidated with many practical exercises.
Target audience
This workshop is intended for prospective Oracle database administrators, operating system administrators, and individuals involved in operating tasks.
Requirements
Basic SQL knowledge is helpful, but not required. Understanding of operating system processes is required.
Additional information
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
Questions
We currently do not have any dates scheduled.
But we can arrange one for you. We will be happy to advise you individually on your course planning.
Contact us