系统追踪日志-SYS_TRACE_LOG
📄字数 1.2K
👁️阅读量 加载中...
功能描述
SYS_TRACE_LOG系统表用于查询当前节点系统追踪日志信息，通过读取当前节点的TRACE.LOG日志文件的内容进行展示。
字段说明
| 序号 | 字段名 | 类型 | 说明 | V11 | V12 |
|---|---|---|---|---|---|
| 0 | NODEID | INTEGER | 节点ID | √ | √ |
| 1 | DB_ID | INTEGER | 库ID | √ | √ |
| 2 | TRACE_TYPE | VARCHAR | 事件类型 | × | √ |
| 3 | TRACE_TIME | DATETIME | 事件发生时刻 | × | √ |
| 4 | TRACE_STR | VARCHAR | 事件内容 | × | √ |
| 5 | INFO_TEXT | VARCHAR | 事件详细描述 | √ | × |
| 6 | TRANS_ID | BIGINT | 事务ID | √ | × |
| 7 | EVENT_TIME | DATETIME | 事件发生时刻 | √ | × |
应用举例
- 查询存储修复、表分析、备份恢复等信息
sql
-- 创建库级备份，再恢复库级备份
SQL> CREATE DATABASE db_reg_trace;
SQL> USE db_reg_trace;
SQL> CREATE TABLE tab_trace(c1 INT);
SQL> BACKUP DATABASE TO '/BACKUP/BACKUP.exp';
backup table SYSDBA.TAB_TRACE ---------------------------------------------- data rows 0 success
SQL> USE system;
Database switch to system
SQL> CREATE DATABASE db_res;
SQL> USE db_res;
Database switch to db_res
SQL> RESTORE DATABASE db_reg_trace FROM '/BACKUP/BACKUP.exp';
restore table SYSDBA.TAB_TRACE ---------------------------------------------- data rows 0 success
-- 查询系统表SYS_TRACE_LOG的最后4行
SQL> SELECT * FROM SYS_TRACE_LOG ORDER BY trace_time DESC LIMIT 4;
+--------+-------+------------+--------------------------+----------------------------------------------------------+
| NODEID | DB_ID | TRACE_TYPE | TRACE_TIME | TRACE_STR |
+--------+-------+------------+--------------------------+----------------------------------------------------------+
| 1 | 6 | RESTORE | 2025-06-30 09:52:34.000 | import table SYSDBA.TAB_TRACE data row 0 |
| 1 | 5 | BACKUP | 2025-06-30 09:50:09.000 | export table TAB_TRACE rows 0 |
| 1 | 5 | BACKUP | 2025-06-30 09:50:09.000 | backup database DB_REG_TRACE finish |
| 1 | 5 | BACKUP | 2025-06-30 09:50:09.000 | Backup database DB_REG_TRACE to /BACKUP/BACKUP.exp start |
+--------+-------+------------+--------------------------+----------------------------------------------------------+
-- 查询日志文件 TRACE.LOG 的最后4行
tail -4 TRACE.LOG
1 5 BACKUP 2025-06-30 09:50:09 Backup database DB_REG_TRACE to /BACKUP/BACKUP.exp start
1 5 BACKUP 2025-06-30 09:50:09 export table TAB_TRACE rows 0
1 5 BACKUP 2025-06-30 09:50:09 backup database DB_REG_TRACE finish
1 6 RESTORE 2025-06-30 09:52:34 import table SYSDBA.TAB_TRACE data row 0