The Oracle Recovery Manager is the main tool for backup and recovery of the Oracle database. It is very important for all DBAs to understand how its working and how to resolve an issue with backups and more importantly to understand how to recover the database in different scenarios.
My work experience shows me that junior DBAs are using Recovery Manager mostly through Oracle Enterprise Manager and some of them are afraid or dont know how to use the command line interface.
This presentation is going to cover RMAN concepts and show examples of how to deal with typical backup and recovery scenarios and how to interpret scripts and RMAN output logs. It will cover a concept of Recovery Manager channel and typical backup, restore and recover commands. In addition to that catalog, cross check and delete commands will be explained in the typical scenarios.
The following examples will be presented during a session:
- basic backup and recovery for single and multitenant database (CDB/PDB)
- disaster recovery (from empty server to fully recovered database)
- point in time recovery for database, tablespace and table (CDB/PDB)
- cloud integration (Oracle Cloud backup / AWS S3)
- incremental backups and block check tracking
- catalog and uncatalog of backupset from disk and tape
The main goal of this presentation is to show that RMAN is the best friend of the DBA and using a command line DBA can fully control it and become a RMAN hero.