When using RMAN for backups, you can automate the deletion of backups that are no longer needed using a single command. In this video, learn about how you can use the DELETE BACKUP and DELETE BACKUPSET commands to delete RMAN backups as part of RMAN backup management.
- [Instructor] Another aspect of RMAN Backup Management…is that RMAN provides us with the capabilities…to manually delete backup sets as we see fit.…Remember that if you delete RMAN backups directly…on the OS or operating system level,…such as using the Linux RM command,…this will cause a discrepancy…between the backups that RMAN think that exist…and the backup files that actually do exist,…which is not ideal.…
It's better to use RMAN's own interface…when deleting backups, even manually.…Using RMAN commands,…we can instruct RMAN to delete a specific backup set…of a specific database.…Let's start by opening a RMAN prompt…to our target database.…So, we'll type RMAN target equals…and backslash.…Let's list any backups of the ORCL database,…which we have taken.…
So, list…backup…of…database…orcl.…And let's manually…instruct RMAN…to delete backup set 122,…which we can see is a full database backup…and is almost 1.4…gigabytes in size.…So, we'll type, delete…no prompt…backup set…and type the backup set number,…so 122, in my case.…
Remember that in your environment,…
- 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.