Oracle 视图 V$BACKUP_REDOLOG 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图V$BACKUP_REDOLOG提供了有关活动和完成的日志备份的信息的总揽。该视图提供的元数据可用于管理日志备份作业,以确保在可恢复性灾难发生时,数据库可以被恢复。包括以下信息:
1. 红色日志文件的名称,柱号码,软件状态和状态
2. 备份日志的块然后备份,要备份多少块,已备份多少块
3. 备份日志的时间,备份是否成功
要使用该视图,只需执行SELECT语句,其中指定要查询的列,例如:
SELECT THREAD#, STATUS, START_TIME, END_TIME, INPUT_BYTES, SUCCESS FROM 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.
Column | Datatype | Description |
---|---|---|
|
|
Record ID for this row; it is an integer that identifies this row |
|
|
Timestamp used with RECID to uniquely identify this row |
|
|
One of the foreign keys for the row of the |
|
|
One of the foreign keys for the row of the |
|
|
Thread number for the log |
|
|
Log sequence number |
|
|
Change number of the last resetlogs before the log was written |
|
|
Change time of the last resetlogs before the log was written. These will be the same for all logs in a backup set. |
|
|
SCN when the log was switched into. The redo in the log is at this SCN and greater. |
|
|
Time allocated when the log was switched into |
|
|
SCN when the next log in this thread was switched into. The redo in the log is below this SCN. |
|
|
Time when the next log in this thread was switched into |
|
|
Size of the log in logical blocks including the header block |
|
|
Size of the log blocks in bytes |
|
|
Indicates whether this record corresponds to a terminal archived redo log, as defined in |
|
|
Number of blocks in each section of a multisection log. The value is |
|
|
The ID of the container to which the data pertains. Possible values include:
|