Data Dictionary Views For Backup and Recovery

The data dictionary views that contain information about the backups and recovery of Oracle databases are as follows.

We can get detailed or summary information about many processes with these views .

Information about the views can be found in the DICTIONARY main table as follows. It may not contain information for each view.

  • V$RMAN_BACKUP_SUBJOB_DETAILS
  • V$RMAN_BACKUP_JOB_DETAILS
  • V$BACKUP_SET_DETAILS
  • V$BACKUP_PIECE_DETAILS
  • V$BACKUP_COPY_DETAILS
  • V$BACKUP
  • V$RECOVERY_STATUS
  • V$RECOVERY_FILE_STATUS
  • V$BACKUP_SET
  • V$BACKUP_PIECE
  • V$BACKUP_DATAFILE
  • V$BACKUP_REDOLOG
  • V$BACKUP_CORRUPTION
  • V$BACKUP_DEVICE
  • V$BACKUP_SPFILE
  • V$BACKUP_SYNC_IO
  • V$BACKUP_ASYNC_IO
  • V$RECOVER_FILE
  • V$RMAN_STATUS
  • V$RMAN_OUTPUT
  • V$BACKUP_DATAFILE_DETAILS
  • V$BACKUP_CONTROLFILE_DETAILS
  • V$BACKUP_ARCHIVELOG_DETAILS
  • V$BACKUP_SPFILE_DETAILS
  • V$BACKUP_DATAFILE_SUMMARY
  • V$BACKUP_CONTROLFILE_SUMMARY
  • V$BACKUP_ARCHIVELOG_SUMMARY
  • V$BACKUP_SPFILE_SUMMARY
  • V$BACKUP_SET_SUMMARY
  • V$RECOVERY_PROGRESS
  • V$RMAN_BACKUP_TYPE
  • V$RMAN_CONFIGURATION
  • DBA_DATAPUMP_SESSIONS
  • DBA_DATAPUMP_JOBS