The REPORT command performs more complex analysis than LIST. Some of the main options are:


Parameter

Example

Explanation

NEED BACKUP

REPORT NEED BACKUP DATABASE

Shows which files need backing up under current retention policy. Use optional REDUNDANCY and RECOVERY WINDOW parameters to specify different criteria.

OBSOLETE

REPORT OBSOLETE

Lists backups that are obsolete under the configured retention policy. Use optional REDUNDANCY and RECOVERY WINDOW parameters to specify criteria.

UNRECOVERABLE

REPORT UNRECOVERABLE

Lists all datafiles for which an unrecoverable operation has been performed against an object in the datafile since the last backup of the datafile.

SCHEMA

REPORT SCHEMA

Reports the tablespaces and datafiles in the database at the current time (default) or a different time.

Go to top
JSN Boot template designed by JoomlaShine.com