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

RECID

NUMBER

Record ID for this row; it is an integer that identifies this row

STAMP

NUMBER

Timestamp used with RECID to uniquely identify this row

SET_STAMP

NUMBER

One of the foreign keys for the row of the V$BACKUP_SET table that identifies this backup set

SET_COUNT

NUMBER

One of the foreign keys for the row of the V$BACKUP_SET table that identifies this backup set

THREAD#

NUMBER

Thread number for the log

SEQUENCE#

NUMBER

Log sequence number

RESETLOGS_CHANGE#

NUMBER

Change number of the last resetlogs before the log was written

RESETLOGS_TIME

DATE

Change time of the last resetlogs before the log was written. These will be the same for all logs in a backup set.

FIRST_CHANGE#

NUMBER

SCN when the log was switched into. The redo in the log is at this SCN and greater.

FIRST_TIME

DATE

Time allocated when the log was switched into

NEXT_CHANGE#

NUMBER

SCN when the next log in this thread was switched into. The redo in the log is below this SCN.

NEXT_TIME

DATE

Time when the next log in this thread was switched into

BLOCKS

NUMBER

Size of the log in logical blocks including the header block

BLOCK_SIZE

NUMBER

Size of the log blocks in bytes

TERMINAL

VARCHAR2(3)

Indicates whether this record corresponds to a terminal archived redo log, as defined in V$ARCHIVED_LOG (YES) or not (NO)

SECTION_SIZE

NUMBER

Number of blocks in each section of a multisection log. The value is 0 for whole file logs.

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 V$BACKUP_REDOLOG 官方解释,作用,如何使用详细说明