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.
RMAN recovery concepts - Oracle Database Tutorial
From the course: Oracle Database 12c: Backup and Recovery
RMAN recovery concepts
- There are four steps for using RMAN to perform major recovery of an Oracle database. These steps are: One, place the database in the appropriate state for recovery. For example, we need to close the PDB before we can recover it, or put the Oracle instance in Mount Mode in case we want to recover our entire CDB, or container database. This can be done as part of the RMAN recovery strip, as we'll see later in our chapter. Two, in order to perform incomplete recovery, which means recover the database up to a specific point in time, we will use the Set Until command to specify the time, SCN, system change number, or log sequence number at which the recovery terminate. Three, restore the necessary database files using the RMAN Restore command. This command copies the database data files from within the RMAN backup set and into their appropriate location in our database. Four, recover the data files using the Recover command. This rolls the database forward, after a Restore command by…
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)
-
-
-