V$BACKUP_REDOLOG 淡淡的烟草味﹌ 2023-10-18 21:35 28阅读 0赞 ## V$BACKUP\_REDOLOG ## `V$BACKUP_REDOLOG` displays information about archived logs in backup sets from the control file. Note that online redo logs cannot be backed up directly; they must be archived first to disk and then backed up. An archive log backup set can contain one or more archived logs. <table> <thead> <tr> <th>Column</th> <th>Datatype</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td><code>RECID</code></td> <td><code>NUMBER</code></td> <td>Record ID for this row; it is an integer that identifies this row</td> </tr> <tr> <td><code>STAMP</code></td> <td><code>NUMBER</code></td> <td>Timestamp used with RECID to uniquely identify this row</td> </tr> <tr> <td><code>SET_STAMP</code></td> <td><code>NUMBER</code></td> <td>One of the foreign keys for the row of the <code>V$BACKUP_SET</code> table that identifies this backup set</td> </tr> <tr> <td><code>SET_COUNT</code></td> <td><code>NUMBER</code></td> <td>One of the foreign keys for the row of the <code>V$BACKUP_SET</code> table that identifies this backup set</td> </tr> <tr> <td><code>THREAD#</code></td> <td><code>NUMBER</code></td> <td>Thread number for the log</td> </tr> <tr> <td><code>SEQUENCE#</code></td> <td><code>NUMBER</code></td> <td>Log sequence number</td> </tr> <tr> <td><code>RESETLOGS_CHANGE#</code></td> <td><code>NUMBER</code></td> <td>Change number of the last resetlogs before the log was written</td> </tr> <tr> <td><code>RESETLOGS_TIME</code></td> <td><code>DATE</code></td> <td>Change time of the last resetlogs before the log was written. These will be the same for all logs in a backup set.</td> </tr> <tr> <td><code>FIRST_CHANGE#</code></td> <td><code>NUMBER</code></td> <td>SCN when the log was switched into. The redo in the log is at this SCN and greater.</td> </tr> <tr> <td><code>FIRST_TIME</code></td> <td><code>DATE</code></td> <td>Time allocated when the log was switched into</td> </tr> <tr> <td><code>NEXT_CHANGE#</code></td> <td><code>NUMBER</code></td> <td>SCN when the next log in this thread was switched into. The redo in the log is below this SCN.</td> </tr> <tr> <td><code>NEXT_TIME</code></td> <td><code>DATE</code></td> <td>Time when the next log in this thread was switched into</td> </tr> <tr> <td><code>BLOCKS</code></td> <td><code>NUMBER</code></td> <td>Size of the log in logical blocks including the header block</td> </tr> <tr> <td><code>BLOCK_SIZE</code></td> <td><code>NUMBER</code></td> <td>Size of the log blocks in bytes</td> </tr> <tr> <td><code>TERMINAL</code></td> <td><code>VARCHAR2(3)</code></td> <td>???</td> </tr> </tbody> </table>
还没有评论，来说两句吧...