v$log

V$ARCHIVE_PROCESSES

This view provides information about the state of the various ARCH processes for the instance.

[@more@]

V$ARCHIVE_PROCESSES

This view provides information about the state of the various ARCH processes for the instance.

Column	Datatype	Description
PROCESS	NUMBER	The identifier for the ARCH process for the instance, numbered from 0-9
STATUS	VARCHAR2(10)	The status of the ARCH process, displayed as a keyword. Possible values are: STOPPED, SCHEDULED, STARTING, ACTIVE, STOPPING, and TERMINATED.
LOG_SEQUENCE	NUMBER	This is the online redo log sequence number currently being archived, if STATE="BUSY"
STATE	VARCHAR2(4)	This is the current state of the ARCH process, displayed as a keyword. Possible keywords are IDLE or BUSY.

说明：

1， 其中是否存在STATUS为ACTIVE的进程是由初始化参数中的log_archive_start决定的。

如果log_archive_start设置为false，则所有的归档进程的STATUS均为STOPPED，此时系统不会进行自动归档，如果数据库处于归档模式下，需要用户手工归档，否则系统会给出要求手工归档的提示。

2，其中STATUS为ACTIVE的进程数量是由初始化参数log_archive_max_processes所设置的数量决定的，跟当前数据库是否处于归档状态无关，即使当前数据库为非归档模式，也会存在相应数量的STATUS为ACTIVE的进程，只不过这些进程一直处于idle状态而已。

3，其中LOG_SEQUENCE表示目前正在进行归档的日志的序列号，该日志的详细信息可以通过查询v$log_history得到。

V$LOG_HISTORY

This view contains log history information from the control file.

Column	Datatype	Description
THREAD#	NUMBER	Thread number of the archived log
SEQUENCE#	NUMBER	Sequence number of the archived log
FIRST_TIME	DATE	Time of first entry (lowest SCN) in the log. This column was previously named TIME.
FIRST_CHANGE#	NUMBER	Lowest SCN in the log. This column was previously named LOW_CHANGE#.
NEXT_CHANGE#	NUMBER	Highest SCN in the log. This column was previously named HIGH_CHANGE#.
RECID	NUMBER	Control file record ID
STAMP	NUMBER	Control file record stamp

V$LOGFILE

This view contains information about redo log files.

Column	Datatype	Description
GROUP#	NUMBER	Redo log group identifier number
STATUS	VARCHAR2(7)	Status of the log member: INVALID - File is inaccessible STALE - File's contents are incomplete DELETED - File is no longer used blank - File is in use
TYPE	VARCHAR2(7)
MEMBER	VARCHAR2(513)	Redo log member name

V$LOGHIST

This view contains log history information from the control file. This view is retained for historical compatibility. Oracle recommends that you use V$LOG_HISTORY instead.

Column	Datatype	Description
THREAD#	NUMBER	Log thread number
SEQUENCE#	NUMBER	Log sequence number
FIRST_CHANGE#	NUMBER	Lowest SCN in the log
FIRST_TIME	DATE	Time of first SCN in the log
SWITCH_CHANGE#	NUMBER	SCN at which the log switch occurred; one more than highest SCN in the log

V$ARCHIVED_LOG

This view displays archived log information from the control file, including archive log names. An archive log record is inserted after the online redo log is successfully archived or cleared (name column is NULL if the log was cleared). If the log is archived twice, there will be two archived log records with the same THREAD#, SEQUENCE#, and FIRST_CHANGE#, but with a different name. An archive log record is also inserted when an archive log is restored from a backup set or a copy and whenever a copy of a log is made with the RMAN COPY command.

Column	Datatype	Description
RECID	NUMBER	Archived log record ID
STAMP	NUMBER	Archived log record stamp
NAME	VARCHAR2(513)	Archived log file name. If set to NULL, the log file was cleared before it was archived.
DEST_ID	NUMBER	Original destination from which the archivelog was generated. The value is 0 if the destination identifier is not available.
THREAD#	NUMBER	Redo thread number
SEQUENCE#	NUMBER	Redo log sequence number
RESETLOGS_CHANGE#	NUMBER	Resetlogs change# of the database when this log was written
RESETLOGS_TIME	DATE	Resetlogs time of the database when this log was written
FIRST_CHANGE#	NUMBER	First change# in the archived log
FIRST_TIME	DATE	Timestamp of the first change
NEXT_CHANGE#	NUMBER	First change in the next log
NEXT_TIME	DATE	Timestamp of the next change
BLOCKS	NUMBER	Size of the archived log (in blocks)
BLOCK_SIZE	NUMBER	Redo log block size. This is the logical block size of the archived log, which is the same as the logical block size of the online log from which this archived log was copied. The online log logical block size is a platform-specific value that is not adjustable by the user.
CREATOR	VARCHAR2(7)	Creator of the archivelog: ARCH - ARCH process FGRD - Foreground process RMAN SRMN - RMAN at standby LGWR - LGWR process
REGISTRAR	VARCHAR2(7)	Registrar of the entry: RFS ARCH - ARCH process FGRD - Foreground process RMAN SRMN - RMAN at standby LGWR - LGWR process
STANDBY_DEST	VARCHAR2(3)	(YES|NO) Indicates if the entry is an archivelog destination
ARCHIVED	VARCHAR2(3)	Indicates that the online redo log was archived (YES) or that RMAN only inspected the log and created a record for future application of redo logs during recovery. See Also: Oracle9i Recovery Manager User's Guide.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8394333/viewspace-987131/，如需转载，请注明出处，否则将追究法律责任。 0 0 分享到： 上一篇： 由FILE$想到的 下一篇： V$ARCHIVE_PROCESSES 请登录后发表评论 登录 全部评论 <%=items[i].createtime%> <%=items[i].content%> <%if(items[i].items.items.length) { %> <%for(var j=0;j <%=items[i].items.items[j].createtime%> 回复 <%=items[i].items.items[j].username%>   回复   <%=items[i].items.items[j].tousername%>： <%=items[i].items.items[j].content%> <%}%> <%if(items[i].items.total > 5) { %> 还有<%=items[i].items.total-5%>条评论 ) data-count=1 data-flag=true>点击查看 <%}%> <%}%> <%}%> sunwgneuqsoft 博文量 56 访问量 758256 最新文章 10g新特性——Data Pump(转) 10g新特性——表空间重命名 10g新特性——回滚监视 10g新特性——闪回版本查询 cbo心得(选择率,基数,直方图)(五) cbo心得(选择率,基数,直方图)(四) cbo心得(选择率,基数,直方图)(三) cbo心得(选择率,基数,直方图)(二) cbo心得(选择率,基数,直方图)(一) oracle的学习方法——关于测试的两点体会 支持我们 作者招募 用户协议 FAQ Contact Us 北京盛拓优讯信息技术有限公司. 版权所有  京ICP备09055130号-4  北京市公安局海淀分局网监中心备案编号：11010802021510 广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

转载于:http://blog.itpub.net/8394333/viewspace-987131/