Introduction
Welcome
()
What you need to know
()
Exercise files
()
1. Backup and Recovery Core Concepts
Complete vs. incomplete recovery
()
Role of archived redo logs in backups
()
Point-in-time recovery
()
Requirements for PITR
()
2. Failure Categories and Backup Types
Database failure scenarios
()
Logical and Physical backups
()
Oracle Backup technologies
()
3. Preparing the Course VM
Download the course VM
()
Enable Archivelog Mode
()
Configure the Fast Recovery Area
()
4. User-Managed Backups
User-managed backups overview
()
Performing user-managed backups of datafiles
()
Manual backup of control files and archived logs
()
Steps to restore from manual backups
()
5. Recovery Manager (RMAN)
RMAN concepts
()
Configuring RMAN parameters
()
Full backups using RMAN
()
Incremental backup using RMAN
()
Viewing and reporting on RMAN backups
()
Managing obsolete RMAN backups
()
Managing expired RMAN backups
()
Using RMAN to delete backups
()
Using RMAN for backups of archived redo log
()
Using RMAN for deleting archived redo logs
()
Using RMAN to check for data corruptions
()
Using RMAN scripts
()
RMAN recovery concepts
()
Recovering a PDB
()
Performing point-in-time recovery of a PDB
()
Recovering the entire CDB
()
Performing point-in-time recovery of the CDB
()
6. Oracle Data Pump
Exporting data using Data Pump
()
Specifying export directory
()
Exporting a PDB in Oracle 12c
()
Viewing Data Pump log files
()
Importing data using Data Pump
()
Object filtering during import and export
()
Advanced object filtering
()
Using parameter files
()
Monitoring and controlling Data Pump jobs
()
7. Oracle Flashback
Flashback Query requirements
()
Flashback Database requirements
()
Using Flashback Query
()
Using Flashback Table
()
Using Flashback Database
()
Creating Restore Points
()
Conclusion
What's next?
()
Ex_Files_Oracle_12c_Backup.zip
(61 KB)