RMAN allows for easy management of backups including deleting backups that are no longer needed automatically. In this video, learn what OBSOLETE BACKUPS mean in RMAN, how to set the backup retention using the CONFIGURE RETENTION POLICY command, and how to delete backups that are no longer required using the DELETE OBSOLETE command.
- [Instructor] RMAN provides building capabilities…for automatic backup management,…meaning that there is no need for us to manually…hunt down and delete all backups, but instead…RMAN can take care of all of that for us all by itself.…In order to accomplish that,…RMAN introduces two core concepts…in backup management known as obsolete backups…and expired backups.…RMAN considers backups of data files and control files…as obsolete, meaning that they are no longer needed…for recovery, based on their retention criteria…we configured for RMAN.…
For example, if we set our RMAN retention policy…to a redundancy of one, which means that RMAN is instructed…to only keep a single backup copy…of each one of our databases, then after the second backup…of a database, the first backup will be considered obsolete…by RMAN because we now have two backups…but we specified that RMAN should only keep one.…
Let's see this example in action.…We'll start by opening an RMAN connection…to our target database.…So I'll type rman target=, and /.…
- 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
Oracle 12c Database: Administrationwith David Yahalom3h 58m Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
1. Backup and Recovery Core Concepts
2. Failure Categories and Backup Types
3. Preparing the Course VM
4. User-Managed Backups
5. Recovery Manager (RMAN)
6. Oracle Data Pump
7. Oracle Flashback
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.Cancel
Take 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.