Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Oracle Database 12c: Backup and Recovery

via LinkedIn Learning

Overview

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.

Syllabus

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?

Taught by

David Yahalom

Reviews

4.7 rating at LinkedIn Learning based on 172 ratings

Start your review of Oracle Database 12c: Backup and Recovery

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.