RMAN can protect the integrity of your backups as part of its backup management features. In this video, learn about what EXPIRED BACKUPS mean in RMAN and how to use the CROSSCHECK BACKUP, LIST EXPIRED, and DELETE EXPIRED BACKUP commands to identify and delete backups that are missing from the disk.
- [Instructor] Expired backups in RMAN…are different compared to obsolete backups.…A status of expired means that…the backup piece or backup set…is not found in the directory…where RMAN is looking for it.…For example, if we manually deleted…one of our RMAN backup files.…By default, RMAN stores the status…and location of database backups…in the database control file.…If the database control file indicates…that a backup should exist under…a specific directory, but maybe someone…deleted that file using the Linux RMAN command,…RMAN will tag this backup as expired.…
In order for RMAN to detect if backup…files are missing or not,…we need to run a crosscheck command manually.…This command instructs RMAN to validate…that all of the backups of a database…it thinks that exists do indeed exist in our file system.…Let's see this in action.…So, going back to our RMAN prompt,…let's type the crosscheck backup command.…
This will cause RMAN to scan the directories…it knows backups were stored in…and check if any of those backup files…
- 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
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.