RMAN Report Clause

Report backup status: database files, status of files and backups (obsolete or unrecoverable.)
The REPORT command performs more complex analysis than LIST.

Syntax:

   REPORT 
   { { NEED BACKUP [ { INCREMENTAL | DAYS } [=] integer 
                     | REDUNDANCY [=] integer 
                     | RECOVERY WINDOW OF integer DAYS)
                     ] 
     | UNRECOVERABLE
     } 
     reportObject 
   | SCHEMA [atClause] 
   | OBSOLETE [obsOperandList]
   }
   [ DEVICE TYPE deviceSpecifier [,deviceSpecifier]… ] 

   reportObject::=
     [ DATAFILE datafileSpec [, datafileSpec]… 
     | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]… 
     | DATABASE [SKIP TABLESPACE ['] tablespace_name [']
                  [, ['] tablespace_name [']]…]
     ]

   atClause::=
     { AT TIME [=] 'date_string'
     | AT SCN [=] integer
     | AT SEQUENCE [=] integer THREAD [=] integer
     }

   obsOperandList::= 
     [ REDUNDANCY [=] integer | RECOVERY WINDOW OF integer DAYS | ORPHAN ]…

"Our Constitution is in actual operation; everything appears to promise that it will last; but in this world nothing is certain but death and taxes" ~ Benjamin Franklin.

Related Oracle Commands:

CROSSCHECK - Check whether backup items still exist.
LIST - List backups and copies
SET - Settings for the current RMAN session.
SHOW - Display the current configuration