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 |
|
| The identifier for the ARCH process for the instance, numbered from 0-9 |
|
| The status of the ARCH process, displayed as a keyword. Possible values are: |
|
| This is the online redo log sequence number currently being archived, if |
|
| This is the current state of the ARCH process, displayed as a keyword. Possible keywords are |
说明：
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 of the archived log |
|
| Sequence number of the archived log |
|
| Time of first entry (lowest SCN) in the log. This column was previously named |
|
| Lowest SCN in the log. This column was previously named |
|
| Highest SCN in the log. This column was previously named |
|
| Control file record ID |
|
| Control file record stamp |
V$LOGFILE
This view contains information about redo log files.
Column | Datatype | Description |
|
| Redo log group identifier number |
|
| Status of the log member:
|
|
| |
|
| 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 |
|
| Log thread number |
|
| Log sequence number |
|
| Lowest SCN in the log |
|
| Time of first SCN in the log |
|
| 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 |
|
| Archived log record ID |
|
| Archived log record stamp |
|
| Archived log file name. If set to |
|
| Original destination from which the archivelog was generated. The value is |
|
| Redo thread number |
|
| Redo log sequence number |
|
| Resetlogs change# of the database when this log was written |
|
| Resetlogs time of the database when this log was written |
|
| First change# in the archived log |
|
| Timestamp of the first change |
|
| First change in the next log |
|
| Timestamp of the next change |
|
| Size of the archived log (in blocks) |
|
| 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 of the archivelog:
|
|
| Registrar of the entry:
|
|
| ( |
|
| Indicates that the online redo log was archived ( See Also: Oracle9i Recovery Manager User's Guide. |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8394333/viewspace-987131/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
由FILE$想到的
下一篇：
V$ARCHIVE_PROCESSES
请登录后发表评论
登录
全部评论
北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区 广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员 违法和不良信息举报电话:18101376593 |
