RMAN allows for taking database backups using a single command. In this video, learn how to perform your first RMAN backup to disk using the BACKUP DATABASE PLUS ARCHIVELOG command, how to backup individual PDBs in Oracle 12c, and how to tag your backups for easier management.
- [Instructor] Now it's finally time for us…to roll up our sleeves, get our hands dirty,…and start using RMAN.…Our first example would be using RMAN…to perform a full database backup.…All RMAN commands for performing database backups,…as well as recovery will be done directly via…the RMAN command line prompt.…In order for RMAN to backup or restore a database,…we need to first connect it to the database in question.…
So let's connect RMAN to the local database instance,…running on this VM.…To accomplish that, I'll type RMAN which opens…the RMAN prompt, target, which instruct RMAN…to which database it should connect to,…equals and backslash.…Again this connects RMAN to the local database instance.…To run a full backup of our Oracle database,…we can just type backup database plus archive log.…
This runs a backup of the entire Oracle database,…and in an Oracle 12 C multi-tenant environment…all of the containers, including all of the PDBs.…This command also instruct RMAN to backup…the archive logs for all of these databases,…
- 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.