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