Name
REPORT
Synopsis
Oracle9i syntax:
REPORT { { NEED BACKUP [ { INCREMENTAL | DAYS } [=]integer
| REDUNDANCY [=]integer
| RECOVERY WINDOW OFinteger
DAYS } ] | UNRECOVERABLE }reportObject
| SCHEMA [atClause
] | OBSOLETE [obsoleteOpersList
] } [ DEVICE TYPEdeviceSpecifier
[,deviceSpecifier
...]]; reportObject := [ DATAFILEdatafileSpec
[,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
:= [ DATAFILEdatafileSpec
[,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 ...
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.