V$BACKUP_FILES

电玩女神 2023-10-18 21:35 29阅读 0赞

### V$BACKUP\_FILES ###

`V$BACKUP_FILES` displays information about all RMAN backups (both image copies and backup sets) and archived logs.

This view simulates the `LIST BACKUP` and `LIST COPY` RMAN commands. This view requires that the database be set using the `DBMS_RCVMAN.SETDATABASE` procedure.

<table> 
 <thead> 
 <tr> 
 <th>Column</th> 
 <th>Datatype</th> 
 <th>Description</th> 
 </tr> 
 </thead> 
 <tbody> 
 <tr> 
 <td><code>PKEY</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Primary key for the backup</td> 
 </tr> 
 <tr> 
 <td><code>BACKUP_TYPE</code></td> 
 <td><code>VARCHAR2(32)</code></td> 
 <td>Type of the backup: 
 <ul> 
 <li> <code>BACKUP SET</code> </li> 
 <li> <code>COPY</code> </li> 
 <li> <code>PROXY COPY</code> </li> 
 </ul></td> 
 </tr> 
 <tr> 
 <td><code>FILE_TYPE</code></td> 
 <td><code>VARCHAR2(32)</code></td> 
 <td>Type of the file: 
 <ul> 
 <li> <code>DATAFILE</code> </li> 
 <li> <code>CONTROLFILE</code> </li> 
 <li> <code>SPFILE</code> </li> 
 <li> <code>REDO LOG</code> </li> 
 <li> <code>COPY</code>&nbsp;(for an image copy backup) </li> 
 <li> <code>PIECE</code>&nbsp;(for a backup piece) </li> 
 </ul></td> 
 </tr> 
 <tr> 
 <td><code>KEEP</code></td> 
 <td><code>VARCHAR2(3)</code></td> 
 <td>Indicates whether the backup has a retention policy different from the value for&nbsp;<code>CONFIGURE RETENTION POLICY</code>&nbsp;(<code>YES</code>) or not (<code>NO</code>)</td> 
 </tr> 
 <tr> 
 <td><code>KEEP_UNTIL</code></td> 
 <td><code>DATE</code></td> 
 <td>If the&nbsp;<code>KEEP UNTIL TIME</code>&nbsp;clause of the&nbsp;<code>BACKUP</code>&nbsp;command was specified, then this column shows the date after which the backup becomes obsolete. If the column is null and&nbsp;<code>KEEP_OPTIONS</code>&nbsp;is not null, the backup never becomes obsolete.</td> 
 </tr> 
 <tr> 
 <td><code>KEEP_OPTIONS</code></td> 
 <td><code>VARCHAR2(13)</code></td> 
 <td><code>KEEP</code>&nbsp;options for the backup: 
 <ul> 
 <li> <code>LOGS</code>&nbsp;- RMAN keeps the logs needed to recover the backup </li> 
 <li> <code>NOLOGS</code>&nbsp;- RMAN does not keep the logs needed to recover the backup </li> 
 </ul>If this column is null, then the backup has no KEEP options and will be made obsolete based on the retention policy. </td> 
 </tr> 
 <tr> 
 <td><code>STATUS</code></td> 
 <td><code>VARCHAR2(16)</code></td> 
 <td>Status of the backup: 
 <ul> 
 <li> <code>AVAILABLE</code> </li> 
 <li> <code>UNAVAILABLE</code> </li> 
 <li> <code>EXPIRED</code> </li> 
 <li> <code>OTHER</code> </li> 
 </ul></td> 
 </tr> 
 <tr> 
 <td><code>FNAME</code></td> 
 <td><code>VARCHAR2(1024)</code></td> 
 <td>Name of the file</td> 
 </tr> 
 <tr> 
 <td><code>TAG</code></td> 
 <td><code>VARCHAR2(32)</code></td> 
 <td>Tag of the piece, copy, or proxy copy</td> 
 </tr> 
 <tr> 
 <td><code>MEDIA</code></td> 
 <td><code>VARCHAR2(80)</code></td> 
 <td>Media ID of the piece or proxy copy</td> 
 </tr> 
 <tr> 
 <td><code>RECID</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Recid of the record in the controlfile</td> 
 </tr> 
 <tr> 
 <td><code>STAMP</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Stamp of the record in the controlfile</td> 
 </tr> 
 <tr> 
 <td><code>DEVICE_TYPE</code></td> 
 <td><code>VARCHAR2(255)</code></td> 
 <td>Type of media device that stores the backup</td> 
 </tr> 
 <tr> 
 <td><code>BLOCK_SIZE</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Block size for the backup (in bytes)</td> 
 </tr> 
 <tr> 
 <td><code>COMPLETION_TIME</code></td> 
 <td><code>DATE</code></td> 
 <td>Time when the backup completed</td> 
 </tr> 
 <tr> 
 <td><code>COMPRESSED</code></td> 
 <td><code>VARCHAR2(3)</code></td> 
 <td>Indicates whether the backup piece is compressed (<code>YES</code>) or not (<code>NO</code>); valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>PIECE</code>. Image copies cannot be compressed.</td> 
 </tr> 
 <tr> 
 <td><code>OBSOLETE</code></td> 
 <td><code>VARCHAR2(3)</code></td> 
 <td>Indicates whether the backup piece or copy is obsolete (<code>YES</code>) or not (<code>NO</code>); valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>PIECE</code>&nbsp;or&nbsp;<code>COPY</code></td> 
 </tr> 
 <tr> 
 <td><code>BYTES</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Size of the file (in bytes)</td> 
 </tr> 
 <tr> 
 <td><code>BS_KEY</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Primary key of the backup set (valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>)</td> 
 </tr> 
 <tr> 
 <td><code>BS_COUNT</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Count of the backup set from the controlfile record (valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>)</td> 
 </tr> 
 <tr> 
 <td><code>BS_STAMP</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Stamp of the backup set from the controlfile record (valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>)</td> 
 </tr> 
 <tr> 
 <td><code>BS_TYPE</code></td> 
 <td><code>VARCHAR2(32)</code></td> 
 <td>Type of the backup set (valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>): 
 <ul> 
 <li> <code>DATAFILE</code> </li> 
 <li> <code>ARCHIVED LOG</code> </li> 
 </ul></td> 
 </tr> 
 <tr> 
 <td><code>BS_INCR_TYPE</code></td> 
 <td><code>VARCHAR2(32)</code></td> 
 <td>Incremental type of the backup set (valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>)</td> 
 </tr> 
 <tr> 
 <td><code>BS_PIECES</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Number of backup pieces in the backup set (valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>)</td> 
 </tr> 
 <tr> 
 <td><code>BS_COPIES</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Number of copies of the backup set (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>PIECE</code>&nbsp;and&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>)</td> 
 </tr> 
 <tr> 
 <td><code>BS_COMPLETION_TIME</code></td> 
 <td><code>DATE</code></td> 
 <td>Completion time of the backup set (valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>)</td> 
 </tr> 
 <tr> 
 <td><code>BS_STATUS</code></td> 
 <td><code>VARCHAR2(16)</code></td> 
 <td>Status of the backup set (valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>): 
 <ul> 
 <li> <code>AVAILABLE</code> </li> 
 <li> <code>UNAVAILABLE</code> </li> 
 <li> <code>EXPIRED</code> </li> 
 <li> <code>OTHER</code>&nbsp;- Pieces which are part of the backup set do not have uniform status (that is, some of them are available, some not) </li> 
 </ul></td> 
 </tr> 
 <tr> 
 <td><code>BS_BYTES</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Sum of all backup piece sizes in the backup set (valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>)</td> 
 </tr> 
 <tr> 
 <td><code>BS_COMPRESSED</code></td> 
 <td><code>VARCHAR2(3)</code></td> 
 <td>Indicates whether the backup pieces of the backup set are compressed (<code>YES</code>) or not (<code>NO</code>); valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code></td> 
 </tr> 
 <tr> 
 <td><code>BS_TAG</code></td> 
 <td><code>VARCHAR2(1024)</code></td> 
 <td>Tags of the backup set. If pieces have different tags, then all piece tags are concatenated and separated by commas. Valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>)</td> 
 </tr> 
 <tr> 
 <td><code>BS_DEVICE_TYPE</code></td> 
 <td><code>VARCHAR2(255)</code></td> 
 <td>Device type of the backup set. If there is more than one device type, then they are separated by commas. Valid only if&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code></td> 
 </tr> 
 <tr> 
 <td><code>BP_PIECE#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Number of pieces inside the backup set (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>PIECE</code>&nbsp;and&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>)</td> 
 </tr> 
 <tr> 
 <td><code>BP_COPY#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Number of copies of the backup set (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>PIECE</code>&nbsp;and&nbsp;<code>BACKUP_TYPE</code>&nbsp;is&nbsp;<code>BACKUP SET</code>)</td> 
 </tr> 
 <tr> 
 <td><code>DF_FILE#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Absolute file number of the datafile (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>DATAFILE</code>)</td> 
 </tr> 
 <tr> 
 <td><code>DF_TABLESPACE</code></td> 
 <td><code>VARCHAR2(30)</code></td> 
 <td>Tablespace name of the datafile (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>DATAFILE</code>)</td> 
 </tr> 
 <tr> 
 <td><code>DF_RESETLOGS_CHANGE#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>System change number (SCN) of the most recent&nbsp;<code>RESETLOGS</code>&nbsp;when the control file or datafile was created (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>DATAFILE</code>)</td> 
 </tr> 
 <tr> 
 <td><code>DF_CREATION_CHANGE#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Creation SCN of the control file or datafile (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>DATAFILE</code>)</td> 
 </tr> 
 <tr> 
 <td><code>DF_CHECKPOINT_CHANGE#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>System change number (SCN) of the most recent control file or datafile checkpoint (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>DATAFILE</code>)</td> 
 </tr> 
 <tr> 
 <td><code>DF_CKP_MOD_TIME</code></td> 
 <td><code>DATE</code></td> 
 <td>Modification time in case of SPFILE, otherwise time when the control file or datafile was checkpointed (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>DATAFILE</code>)</td> 
 </tr> 
 <tr> 
 <td><code>RL_THREAD#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Redo log thread number of the archived log (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>REDO LOG</code>)</td> 
 </tr> 
 <tr> 
 <td><code>RL_SEQUENCE#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>Redo log sequence number of the archived log (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>REDO LOG</code>)</td> 
 </tr> 
 <tr> 
 <td><code>RL_RESETLOGS_CHANGE#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>System change number (SCN) of the most recent&nbsp;<code>RESETLOGS</code>&nbsp;when the record was created (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>REDO LOG</code>)</td> 
 </tr> 
 <tr> 
 <td><code>RL_FIRST_CHANGE#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>First SCN of the redo log (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>REDO LOG</code>)</td> 
 </tr> 
 <tr> 
 <td><code>RL_FIRST_TIME</code></td> 
 <td><code>DATE</code></td> 
 <td>Time when the Oracle Database switched into the redo log (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>REDO LOG</code>)</td> 
 </tr> 
 <tr> 
 <td><code>RL_NEXT_CHANGE#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>First SCN of the next redo log in the thread (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>REDO LOG</code>)</td> 
 </tr> 
 <tr> 
 <td><code>RL_NEXT_TIME</code></td> 
 <td><code>DATE</code></td> 
 <td>First timestamp of the next redo log in the thread (valid only if&nbsp;<code>FILE_TYPE</code>&nbsp;is&nbsp;<code>REDO LOG</code>)</td> 
 </tr> 
 </tbody> 
</table>

V$BACKUP_FILES

发表评论取消回复

还没有评论，来说两句吧...

相关阅读