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博客 ” ,链接:http://blog.itpub.net/8394333/viewspace-987132/,如需转载,请注明出处,否则将追究法律责任。 ![]()
请登录后发表评论
登录
全部评论
<%=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%>
还有<%=items[i].items.total-5%>条评论
) data-count=1 data-flag=true>点击查看
<%}%>
|
转载于:http://blog.itpub.net/8394333/viewspace-987132/