Author
Released
10/16/2017- Complete vs. incomplete recovery
- Point-in-time recovery
- Failure categories
- Preparing the virtual machine
- Performing user-managed backups
- Restoring from manual backups
- Performing full and incremental backups with RMAN
- Recovering a PDB and CDB
- Exporting and importing data with Oracle Data Pump
- Performing logical backups with Data Pump
- Using Flashback Query, Table, and Database
- Creating restore points
Skill Level Intermediate
Duration
Views
- [David] Hey, I'm David Yahalom and welcome to my Oracle 12c Backup and Recovery course. In this course, you will learn all of the fundamentals you need to start becoming an expert in Oracle database backup and recovery. We will take a hands-on approach and learn about Oracle backup and recovery core concepts, how to create bulletproof database backup and recovery strategies, and of course how to implement these strategies using a combination of Oracle tools such as RMAN, Flashback and Data Pump.
We will start by reviewing the core concepts on how Oracle database backup and recovery works. We will then continue and learn how to perform full and incremental database backups using RMAN. We'll also learn about performing Point-in-Time Recovery, how to use Oracle's Flashback database, Flashback query, and Flashback table capabilities, and learn how to create logical database backups using Data Pump. So get comfortable, grab a good cup of coffee or tea, and let's start mastering Oracle 12c backup and recovery.
Related Courses
-
Database Foundations: Core Concepts
with Adam Wilbert2h 14m Beginner -
Database Foundations: Administration
with Adam Wilbert1h 14m Beginner -
Oracle 12c Database: Administration
with David Yahalom3h 58m Beginner
-
Introduction
-
Welcome1m 11s
-
What you need to know1m 8s
-
Exercise files42s
-
-
1. Backup and Recovery Core Concepts
-
Point-in-time recovery2m 37s
-
Requirements for PITR3m 12s
-
2. Failure Categories and Backup Types
-
Database failure scenarios3m 48s
-
Logical and Physical backups2m 38s
-
Oracle Backup technologies6m 53s
-
-
3. Preparing the Course VM
-
Download the course VM5m 35s
-
Enable Archivelog Mode4m 24s
-
-
4. User-Managed Backups
-
5. Recovery Manager (RMAN)
-
RMAN concepts6m 4s
-
Configuring RMAN parameters9m 14s
-
Full backups using RMAN6m 13s
-
Using RMAN to delete backups2m 55s
-
Using RMAN scripts8m 3s
-
RMAN recovery concepts2m 31s
-
Recovering a PDB4m 43s
-
Recovering the entire CDB2m 18s
-
-
6. Oracle Data Pump
-
Specifying export directory5m 49s
-
Viewing Data Pump log files4m 29s
-
Advanced object filtering3m 56s
-
Using parameter files5m 23s
-
7. Oracle Flashback
-
Flashback Query requirements3m 11s
-
Using Flashback Query6m 1s
-
Using Flashback Table6m 56s
-
Using Flashback Database7m 18s
-
Creating Restore Points6m 42s
-
-
Conclusion
-
What's next?2m 7s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome