RMAN provides an interface for easy reporting on existing backups that were created. In this video, learn how utilize RMAN’s reporting capability and list existing RMAN backups using LIST BACKUP OF DATABASE, LIST ARCHIVELOG, and LIST BACKUP OF CONTROLFILE commands.
- [Instructor] RMAN is not just a tool…for running backups and recovering your database,…RMAN also allows a database administrator…to manage their database backups…directly via the RMAN interface.…We can for example, view all available backups,…delete backups which are no longer required…and much much more.…Let's see some of those capabilities in action.…We'll start by opening an RMAN connection…to our target database,…so I'll type rman target =/.…
If you want to see a list of all available backups…of this database we are connected to,…we can simply type list backup of database.…The output for this command will show us…a detailed list of all RMAN backups…performed for all databases,…including pluggable databases…as well as various additional useful information,…such as the name of the pluggable database…that was backed up,…any tags we have specified as part of the backup command,…the status of the backup, the date of the backup,…the time it took the backup to complete,…the size of the backup,…and the destination of the backup piece.…
- 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?
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.