From the course: Oracle Database 12c: Backup and Recovery

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Viewing and reporting on RMAN backups

Viewing and reporting on RMAN backups - Oracle Database Tutorial

From the course: Oracle Database 12c: Backup and Recovery

Start my 1-month free trial

Viewing and reporting on RMAN backups

“

- [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…

Contents