V$BACKUP_DATAFILE_DETAILS Myth丶恋晨 2023-10-18 21:33 4阅读 0赞 ## V$BACKUP\_DATAFILE\_DETAILS ## `V$BACKUP_DATAFILE_DETAILS` contains information about restorable datafiles. It will include all datafiles backed in the backup set, image copies, and proxy copies. <table> <thead> <tr> <th>Column</th> <th>Datatype</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td><code>BTYPE</code></td> <td><code>CHAR(9)</code></td> <td>Backup type container. Possible values are: <code>BACKUPSET</code>, <code>IMAGECOPY</code>, <code>PROXYCOPY</code>.</td> </tr> <tr> <td><code>BTYPE_KEY</code></td> <td><code>NUMBER</code></td> <td>Unique identifier for the backup type. For <code>BACKUPSET</code>, it is <code>BS_KEY</code>.</td> </tr> <tr> <td><code>SESSION_KEY</code></td> <td><code>NUMBER</code></td> <td>Session identifier</td> </tr> <tr> <td><code>SESSION_RECID</code></td> <td><code>NUMBER</code></td> <td>Session record ID</td> </tr> <tr> <td><code>SESSION_STAMP</code></td> <td><code>NUMBER</code></td> <td>Session stamp</td> </tr> <tr> <td><code>ID1</code></td> <td><code>NUMBER</code></td> <td>If <code>BACKUPSET</code>, it contains <code>SET_STAMP</code>. <p>If <code>IMAGECOPY</code> or <code>PROXYCOPY</code>, it is <code>RECID</code> from the control file.</p> </td> </tr> <tr> <td><code>ID2</code></td> <td><code>NUMBER</code></td> <td>If <code>BACKUPSET</code>, it contains <code>SET_COUNT</code>. <p>If <code>IMAGECOPY</code> or <code>PROXYCOPY</code>, it is <code>STAMP</code>.</p> </td> </tr> <tr> <td><code>FILE#</code></td> <td><code>NUMBER</code></td> <td>File number</td> </tr> <tr> <td><code>CREATION_CHANGE#</code></td> <td><code>NUMBER</code></td> <td>File creation change SCN</td> </tr> <tr> <td><code>CREATION_TIME</code></td> <td><code>DATE</code></td> <td>File creation time</td> </tr> <tr> <td><code>RESETLOGS_CHANGE#</code></td> <td><code>NUMBER</code></td> <td>Resetlogs change SCN</td> </tr> <tr> <td><code>RESETLOGS_TIME</code></td> <td><code>DATE</code></td> <td>Resetlogs change time</td> </tr> <tr> <td><code>INCREMENTAL_LEVEL</code></td> <td><code>NUMBER</code></td> <td>Incremental level</td> </tr> <tr> <td><code>INCREMENTAL_CHANGE#</code></td> <td><code>NUMBER</code></td> <td>Incremental change SCN</td> </tr> <tr> <td><code>CHECKPOINT_CHANGE#</code></td> <td><code>NUMBER</code></td> <td>Checkpoint change SCN</td> </tr> <tr> <td><code>CHECKPOINT_TIME</code></td> <td><code>DATE</code></td> <td>Checkpoint change time</td> </tr> <tr> <td><code>MARKED_CORRUPT</code></td> <td><code>NUMBER</code></td> <td>Number of blocks marked corrupt</td> </tr> <tr> <td><code>FILESIZE</code></td> <td><code>NUMBER</code></td> <td>File size, in bytes</td> </tr> <tr> <td><code>COMPRESSION_RATIO</code></td> <td><code>NUMBER</code></td> <td>Compression ratio</td> </tr> <tr> <td><code>TS#</code></td> <td><code>NUMBER</code></td> <td>Tablespace number</td> </tr> <tr> <td><code>TSNAME</code></td> <td><code>VARCHAR2(30)</code></td> <td>Tablespace name</td> </tr> <tr> <td><code>FILESIZE_DISPLAY</code></td> <td><code>VARCHAR2(4000)</code></td> <td>Same value as the <code>FILESIZE</code> column, but converted to a user-displayable format, for example <code>n</code>M, <code>n</code>G, <code>n</code>T, <code>n</code>P, and so on</td> </tr> </tbody> </table>
还没有评论，来说两句吧...