Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow - OCP: Oracle Database 12c Administrator Certified Professional - page 240

Overview of the RMAN
Report and List Commands

RMAN provides a wealth of reporting with respect to backups, the database, and other vari-
ous RMAN-related information. In the following sections, we will discuss the RMAN REPORT
command and the RMAN LIST command. You will need to be familiar with both commands.

Exam objectives are subject to change at any time without prior notice and
at Oracle's sole discretion. Please visit Oracle's Training and Certification
website ( http://www.oracle.com/education/certification/) for the
most current exam-objectives listing.

Using the RMAN REPORT Command

First, we will cover the RMAN REPORT command. We will describe the purpose of the REPORT
command in RMAN, and then we will provide several examples of its use.

Introducing the RMAN REPORT Command
The RMAN REPORT command provides information on records within the database control
file or the RMAN recovery catalog. The REPORT command provides the following information:

Database, tablespace, or data files that need to be backed up

■

Obsolete backups. These are backups that do not meet the retention criteria and can be
removed with the DELETE OBSOLETE commands

■

Objects in the database that need to be backed up because of unrecoverable
SQL operations

■ ■

Information on the database schema
Let's look at some examples of how to use the REPORT command.

■

Seeing the RMAN REPORT Command in Action
Now we will show a number of examples of the use of the RMAN REPORT command. First, we
will show the REPORT BACKUP command, and then we will show the REPORT SCHEMA command.