Wednesday, November 9, 2011

RMAN Backup Views

The following Oracle dynamic views can be used to obtain RMAN information stored in the control file:
  •  V$ARCHIVED_LOG:    show which archives have been created, backed up, and      cleared in the database
  •  V$BACKUP_CORRUPTION:    show which blocks have been found to be corrupt during a backup of a backup set             

  • V$BACKUP_DATAFILE:   useful for creating equal-sized backup sets by determining the number of blocks in each datafile. It can also help you find the number of corrupt blocks in the datafile 

  •    V$BACKUP_DEVICE:   display information about supported backup devices. DISK is  not returned because it is always available

  •  V$BACKUP_FILES:   display information about all RMAN backups (image copies and backup sets) and archived logs. The view simulates the LIST BACKUP and LIST COPYcommands

  •  V$BACKUP_PIECE:    show backup pieces created for backup sets 
  • V$BACKUP_REDOLOG:   show archived logs stored in backup sets 

  •  V$BACKUP_SET :    show backup sets that have been created 

  •  V$BACKUP_SPFILE:   display information about server parameter files in backup sets 
  • V$COPY_CORRUPTION:     show which blocks have been found to be corrupt during an image copy 

  • V$DATABASE_BLOCK_CORRUPTION:    list database blocks marked as corrupt during the most recent RMAN backup 

  • V$RMAN_CONFIGURATION:    list information about RMAN persistent configuration settings 

  • V$PROXY_ARCHIVEDLOG, V$PROXY_DATAFILE:     proxy settings for RMAN
  • V$BACKUP_ASYNC_IO, V$BACKUP_SYNC_IO:    backup performance statistics


oraclebase said...

it is useful thanks for yous post

Post a Comment

Auto Scroll Stop Scroll