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

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *