Oracle Database Administration: The Essential Refe

Recovery

These views provide information about the current status of the online and offline redo logs as well as backup processes controlled by the Recovery Manager (RMAN):

V$ARCHIVE

Lists redo logs that must be archived.

V$ARCHIVE_DEST

Shows the status of all archive log destinations specified for the instance. See the INIT.ORA parameters LOG_ARCHIVE_DEST, LOG_ARCHIVE_DUPLEX_DEST, and LOG_ARCHIVE_MIN_SUCCEED_DEST.

V$ARCHIVED_LOG

Provides information from the control file for all archive logs, using a time-based view of the log files.

V$BACKUP

Shows the backup status of all online datafiles. This is managed by RMAN.

V$BACKUP_CORRUPTION

Details any datafile corruption detected as part of a backup managed by RMAN.

V$BACKUP_DATAFILE

Shows the location of the backup datafile used by RMAN.

V$BACKUP_DEVICE

Provides a list of available backup devices supported by RMAN.

V$BACKUP_PIECE

Provides information about each backup piece. A backup piece is a subset of an RMAN backup set.

V$BACKUP_REDOLOG

Provides information about archived redo logs that have been backed up by RMAN.

V$BACKUP_SET

Provides information about all RMAN backup sets.

V$COPY_CORRUPTION

Details any datafile corruption detected as part of a datafile copy managed by RMAN.

V$DATAFILE_COPY

Provides information about datafile copies from the control file. This information is maintained by RMAN.

V$DELETED_OBJECT

Provides information about archived redo logs, datafile pieces, and datafile copies that have been deleted from the control file.

V$LOG

Contains ...