V$ARCHIVE_PROCESSES
V$LOGMNR_PARAMETERS
This view contains log information.
V$LOGMNR_PARAMETERS
This view contains log information.
Column | Datatype | Description |
|
| The date to start search at |
|
| The date to end search at |
|
| The system change number to start search |
|
| The system change number to end search |
|
| An informational message |
|
| 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 file identifier |
|
| Name of the log file |
|
| Oldest date of any records in the file |
|
| Most recent date of any records in the file |
|
| Database ID |
|
| Name of the database |
|
| Reset log SCN when the log was created |
|
| Time when the reset log SCN was obtained to create the log |
|
| Thread number |
|
| Thread sequence number |
|
| SCN allocated when log switched into |
|
| SCN after this log. Low SCN of the next log. |
|
| Informational message. A value of |
|
| Indicates the status of a logfile. A NULL value indicates a valid logfile; a non-NULL value indicates further information is contained in the |
说明：
1， 其中的RESET_SCN和RESET_SCN_TIME是上一次重置日志的时间。如果未进行过不完全恢复那么这个时间和scn就是数据库创建的时间和scn号；如果进行过不完全恢复那么这个时间和scn号就是上次恢复后的时间和scn号。
V$LOGMNR_DICTIONARY
This view contains log history information.
Column | Datatype | Description |
|
| Date the dictionary was created |
|
| Database ID |
|
| Name of the database |
|
| Dictionary filename |
|
| System change number when the dictionary was created |
|
| Reset log SCN when the dictionary was created |
|
| Time when the reset log SCN was obtained to create the dictionary |
|
| Bit map of currently enabled threads when the dictionary was created |
|
| Informational/Status message |
|
| 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 |
|
| System change number (SCN) when the redo record was generated |
|
| Commit scn |
|
| Timestamp |
|
| |
|
| Number of the thread which generated the redo record |
|
| 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 |
|
| Transaction ID undo segment number of the transaction which generated the change |
|
| Transaction ID slot number of the transaction which generated the change |
|
| Transaction ID sequence number of the transaction which generated the change |
|
| RBA sequence number of the log that contained this redo record |
|
| RBA block number within the log file |
|
| RBA byte offset within the block |
|
| UBA file number identifying the file containing the undo block |
|
| UBA block number for the undo block |
|
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8394333/viewspace-987132/ ，如需转载，请注明出处，否则将追究法律责任。 
请登录后发表评论
登录
全部评论
北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区 广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员 违法和不良信息举报电话:18101376593 |
