December 2002
Intermediate to advanced
928 pages
85h 29m
English
REPORT
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 ...