Oracle in a Nutshell

Name

REPORT

Synopsis

Oracle9i syntax:

REPORT 
{ { NEED BACKUP [ { INCREMENTAL | DAYS } [=] integer 
                  | REDUNDANCY [=] integer 
                  | RECOVERY WINDOW OF integer DAYS
                } ] 
  | UNRECOVERABLE
  } 
  reportObject 
| SCHEMA [atClause] 
| OBSOLETE [obsoleteOpersList]
}
[ 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
}

Oracle8i syntax:

REPORT 
{ { NEED BACKUP [ { INCREMENTAL | DAYS } [=] integer 
                                          | REDUNDANCY [=] integer ] 
  | UNRECOVERABLE
  } 
  reportObject 
| SCHEMA [atClause] 
| OBSOLETE [obsoleteOpersList]
}

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 LOGSEQ [=] integer THREAD [=] integer
}

Provides detailed reports on database backup activity. These reports can provide information on backups that are required for restoration, that require a specified number of incremental backups for restoration, or that may be considered for deletion.

You can also use this command to display datafiles that require the application of a specified number of days worth of archived redo log ...