Oracle RMAN Pocket Reference

Name

REPORT

Synopsis

Provides detailed reports on database backup activity. These reports can provide information on backups that:

• Are required for restoration

• Require a specified number of incremental backups for restoration

• May be considered for obsolescence

REPORT can also display those datafiles that require the application of a specified number of days worth of archived redo log files in order to recover.

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]
}

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

Keywords

NEED BACKUP

Reports on datafiles that require a backup based on a redundancy factor, incremental level, or recovery window

UNRECOVERABLE

Reports on all unrecoverable datafiles

SCHEMA [atClause]

Reports on tablespaces ...