Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn how to design and implement backup and recovery strategies that keep the data stored in your Oracle 12c databases safe and secure.
PowerBI Data Analyst - Create visualizations and dashboards from scratch
Free AI-powered learning to build in-demand skills
Overview
Syllabus
Introduction
- Welcome
- What you need to know
- Exercise files
- Complete vs. incomplete recovery
- Role of archived redo logs in backups
- Point-in-time recovery
- Requirements for PITR
- Database failure scenarios
- Logical and Physical backups
- Oracle Backup technologies
- Download the course VM
- Enable Archivelog Mode
- Configure the Fast Recovery Area
- User-managed backups overview
- Performing user-managed backups of datafiles
- Manual backup of control files and archived logs
- Steps to restore from manual backups
- 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
- 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
- Flashback Query requirements
- Flashback Database requirements
- Using Flashback Query
- Using Flashback Table
- Using Flashback Database
- Creating Restore Points
- What's next?
Taught by
David Yahalom
