ITPub博客

首页 > 数据库 > Oracle > V$ARCHIVE_PROCESSES

V$ARCHIVE_PROCESSES

原创 Oracle 作者:sunwgneuqsoft 时间:2007-12-01 09:17:45 0 删除 编辑

V$LOGMNR_PARAMETERS

This view contains log information.

[@more@]

V$LOGMNR_PARAMETERS

This view contains log information.

Column

Datatype

Description

START_DATE

DATE

The date to start search at

END_DATE

DATE

The date to end search at

START_SCN

NUMBER

The system change number to start search

END_SCN

NUMBER

The system change number to end search

INFO

VARCHAR2(32)

An informational message

STATUS

NUMBER

The status. A NULL value indicates parameters are valid. A non-NULL value indicates further information is contained in the INFO column as a text string.

说明:这个视图里面的信息是前一次logmnr时候的分析参数,主要包括日志查找的开始时间,终止时间,日志查找的开始scm号,终止scn号。

V$LOGMNR_LOGS

This view contains log information.

Column

Datatype

Description

LOG_ID

NUMBER

Log file identifier

FILENAME

VARCHAR2(513)

Name of the log file

LOW_TIME

DATE

Oldest date of any records in the file

HIGH_TIME

DATE

Most recent date of any records in the file

DB_ID

NUMBER

Database ID

DB_NAME

VARCHAR2(8)

Name of the database

RESET_SCN

NUMBER

Reset log SCN when the log was created

RESET_SCN_TIME

DATE

Time when the reset log SCN was obtained to create the log

THREAD_ID

NUMBER

Thread number

THREAD_SQN

NUMBER

Thread sequence number

LOW_SCN

NUMBER

SCN allocated when log switched into

NEXT_SCN

NUMBER

SCN after this log. Low SCN of the next log.

INFO

VARCHAR2(32)

Informational message. A value of MISSING_LOGFILE will be assigned to a row entry where a needed logfile is missing from the list of log files.

STATUS

NUMBER

Indicates the status of a logfile. A NULL value indicates a valid logfile; a non-NULL value indicates further information is contained in the INFO column as a text string. All logfiles successfully added to the file list will have a status value of NULL.

说明:

1, 其中的RESET_SCNRESET_SCN_TIME是上一次重置日志的时间。如果未进行过不完全恢复那么这个时间和scn就是数据库创建的时间和scn号;如果进行过不完全恢复那么这个时间和scn号就是上次恢复后的时间和scn号。

V$LOGMNR_DICTIONARY

This view contains log history information.

Column

Datatype

Description

TIMESTAMP

DATE

Date the dictionary was created

DB_ID

NUMBER

Database ID

DB_NAME

VARCHAR2(8)

Name of the database

FILENAME

VARCHAR2(513)

Dictionary filename

DICTIONARY_SCN

NUMBER

System change number when the dictionary was created

RESET_SCN

NUMBER

Reset log SCN when the dictionary was created

RESET_SCN_TIME

DATE

Time when the reset log SCN was obtained to create the dictionary

ENABLED_THREAD_MAP

RAW(16)

Bit map of currently enabled threads when the dictionary was created

INFO

VARCHAR2(32)

Informational/Status message BAD_DATE indicates that the SCN of the dictionary file does not match the SCN range of the log files

STATUS

NUMBER

A NULL indicates a valid dictionary file for the list of log files. A non-NULL value indicates further information is contained in the INFO column as a text string.

V$LOGMNR_CONTENTS

This view contains log history information.

When a SELECT statement is executed against the V$LOGMNR_CONTENTS view, the archive redo log files are read sequentially. Translated records from the redo log files are returned as rows in the V$LOGMNR_CONTENTS view. This continues until either the filter criteria specified at startup (EndTime or endScn) are met or the end of the archive log file is reached.

Column

Datatype

Description

SCN

NUMBER

System change number (SCN) when the redo record was generated

CSCN

NUMBER

Commit scn

TIMESTAMP

DATE

Timestamp

COMMIT_TIMESTAMP

DATE

THREAD#

NUMBER

Number of the thread which generated the redo record

LOG_ID

NUMBER

Number of the log file which contains the redo record. This number is generated by LogMiner to uniquely identify a log, and corresponds to the LOG_ID column in V$LOGMNR_FILES.

XIDUSN

NUMBER

Transaction ID undo segment number of the transaction which generated the change

XIDSLT

NUMBER

Transaction ID slot number of the transaction which generated the change

XIDSQN

NUMBER

Transaction ID sequence number of the transaction which generated the change

RBASQN

NUMBER

RBA sequence number of the log that contained this redo record

RBABLK

NUMBER

RBA block number within the log file

RBABYTE

NUMBER

RBA byte offset within the block

UBAFIL

NUMBER

UBA file number identifying the file containing the undo block

UBABLK

NUMBER

UBA block number for the undo block

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8394333/viewspace-987132/,如需转载,请注明出处,否则将追究法律责任。

上一篇: v$log
下一篇: v$mystat
请登录后发表评论 登录
全部评论
  • 博文量
    56
  • 访问量
    758680