Using RMAN commands, you can easily perform database recovery from your RMAN backup sets. In this video, learn the steps required to restore your database from an RMAN backup, using the SET UNTIL clause to perform point-in-time recovery, the differences between RMAN RESTORE and RMAN RECOVER, and the purpose of the OPEN RESETLOGS command.
- 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 applying…the changes stored in our archived Redo Logs.…
- 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.