In addition to database backup and recovery, RMAN can also detect potential data corruptions. In this video, learn how to use the VALIDATE DATABASE CHECK LOGICAL command to detect potential data corruptions in your database and VALIDATE BACKUPSET to make sure your backups are intact.
- [Instructor] In addition to using RMAN…for database backup and recovery…and backup management,…RMAN can also check your database and detect…any corruptions in your data.…Either logical corruptions which can occur…if due to a software bug in the Oracle software,…Oracle requested the disc to write…an incorrect block of data,…or due to a physical corruption which can occur…if Oracle requested the disc to write a valid block…but due to a disc subsystem error,…either the disc controller or…the disc itself caused a bad data block to be written.…
It's very to easy to request RMAN…to scan, validate and check the state…of your database and detect any potential…logical or physical block corruptions…which can lead to data loss.…Detecting these corruptions early is very important.…So let's see this capability in action.…We'll start by opening RMAN and connecting…to our target database.…So I'll type RMAN target equals backslash…and then via a single command,…validate data base…check logical,…I will request RMAN to scan my database…
- 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.