From the course: Oracle Database 12c: Backup and Recovery
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using RMAN to check for data corruptions - Oracle Database Tutorial
From the course: Oracle Database 12c: Backup and Recovery
Using RMAN to check for data corruptions
- [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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
RMAN concepts6m 4s
-
Configuring RMAN parameters9m 14s
-
(Locked)
Full backups using RMAN6m 13s
-
(Locked)
Incremental backup using RMAN5m 52s
-
(Locked)
Viewing and reporting on RMAN backups4m 1s
-
(Locked)
Managing obsolete RMAN backups5m 22s
-
(Locked)
Managing expired RMAN backups3m 11s
-
(Locked)
Using RMAN to delete backups2m 55s
-
(Locked)
Using RMAN for backups of archived redo log4m 35s
-
(Locked)
Using RMAN for deleting archived redo logs4m 22s
-
(Locked)
Using RMAN to check for data corruptions4m 17s
-
(Locked)
Using RMAN scripts8m 3s
-
(Locked)
RMAN recovery concepts2m 31s
-
(Locked)
Recovering a PDB4m 43s
-
(Locked)
Performing point-in-time recovery of a PDB3m 36s
-
(Locked)
Recovering the entire CDB2m 18s
-
(Locked)
Performing point-in-time recovery of the CDB3m 22s
-
(Locked)
-
-
-