在知识库中专注阅读，并随时返回相关工具与课程
大家好，这里是 Lucifer三思而后行，专注于提升数据库运维效率。 @TOC目录 上两周，偶然看到小墨发布的 墨天轮智能巡检v2.3发布，适配Oracle PDB并支持12c-23aihttps://www.modb.pro/db/1844598359162716160，想起之前也使用过白求恩。于是，抱着好奇的心态，看了一下新版更新了哪些功能。 Oracle 数据库智能巡检是从 2018 年就立
大家好，这里是 Lucifer三思而后行，专注于提升数据库运维效率。
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
上两周，偶然看到小墨发布的 墨天轮智能巡检v2.3发布，适配Oracle PDB并支持12c-23ai，想起之前也使用过白求恩。于是，抱着好奇的心态，看了一下新版更新了哪些功能。
Oracle 数据库智能巡检是从 2018 年就立项的，很快就在墨天轮社区上线开通了这个功能。据说至今已经为大家生成了 1800 多份巡检报告。除了智能巡检外，还推出了 SQL 格式化、SQL 静态审核、PL/SQL 解密、AWR 分析、数据库实训环境、数据库 SQL 运行平台，数据库 AI 智能问答助手。
最近墨天轮智能巡检发布了新版本，新增特性如下：
CDB_ 视图采集、并适配 10g、11g 老版本优化调整：
修复BUG：
智能巡检工具下载十分简单，打开 墨天轮智能巡检 即可跳转：
支持 Oracle、PostgreSQL 和 MySQL 三种类型的数据库：
这里我以 Oracle 为例，下载对应的采集程序：BTRobot-v2.3.0.zip，如果主机可以联网，还可以使用 wget 直接获取：
1wget https://oss-emcsprod-public.modb.pro/tools/BTRobot-v2.3.0.zip下载完成后，直接上传到对应的数据库主机即可。
在开始操作前，需要先解压采集程序包：
1## root 用户授权2[root@oracle11g:/root]# chown oracle:oinstall /home/oracle/BTRobot-v2.3.0.zi34## oracle 用户解压5[oracle@oracle11g:/home/oracle]$ unzip -q BTRobot-v2.3.0.zip67## 进入解压文件夹8[oracle@oracle11g:/home/oracle]$ cd BTRobot-v2.3.09[oracle@oracle11g:/home/oracle/BTRobot-v2.3.0]$ ls10conf data lib ReadMe_CN.txt ReadMe_EN.txt runMe.pl执行巡检命令前，需要先检查一下数据库的环境变量是否设置：
1## 检查设置环境变量，如果没有设置，需要先设置环境变量2[oracle@oracle11g:/home/oracle]$ echo $ORACLE_HOME3/u01/app/oracle/product/11.2.0/db4[oracle@oracle11g:/home/oracle]$ echo $ORACLE_SID5lucifer67## 确保 perl 命令存在8[oracle@oracle11g:/home/oracle/BTRobot-v2.3.0]$ type perl9perl is /u01/app/oracle/product/11.2.0/db/perl/bin/perl执行采集：
1## 默认 -S 不会采集 DG 信息，若需采集 DG 信息，请去掉 -S 参数，并在 DG 库按照提示执行语句2[oracle@oracle11g:/home/oracle/BTRobot-v2.3.0]$ perl runMe.pl -e 7 -L 7 -S -t 7 -T 7311:53:38 runMe: Running in Local Mode411:53:38 runMe: Library [/u01/app/oracle/product/11.2.0/db/lib32:/u01/app/oracle/product/11.2.0/db/lib:.]511:53:38 runMe: Perl Lib [/u01/app/oracle/product/11.2.0/db/perl/lib:/u01/app/oracle/product/11.2.0/db/perl/lib/site_perl:./lib:/u01/app/oracle/product/11.2.0/db/perl/lib]611:53:38 runMe: Get Perl [/u01/app/oracle/product/11.2.0/db/perl/bin/perl]711:53:38 parseArgs: Parse Arguments811:53:38 parseArgs: OPTION: OS Error Collect Day [7]911:53:38 parseArgs: OPTION: Log History Limit [7]1011:53:38 parseArgs: OPTION: not Collect DG Data1111:53:38 parseArgs: OPTION: Alert Collect Day [7]1211:53:38 parseArgs: OPTION: Listener Collect Day [7]1311:53:38 checkENV: OS Type : [linux]1411:53:38 checkENV: OS Hostname : [oracle11g]1511:53:38 checkENV: OS HostIP : [192.168.6.60]1611:53:38 checkENV: OS Login User (ENV:USER): [oracle]1711:53:38 checkENV: Check Running Environments1811:53:38 checkENV: Script Version: [2.3.0]1911:53:38 checkENV: Oracle SID: [lucifer]2011:53:38 checkENV: Oracle Home: [/u01/app/oracle/product/11.2.0/db]2111:53:38 checkENV: Library Path: [/u01/app/oracle/product/11.2.0/db/lib32:/u01/app/oracle/product/11.2.0/db/lib]2211:53:38 checkENV: Oracle Version [11]2311:53:38 getBasic: Test DB Logging2411:53:38 connDB: Get DB Character Set [UTF8], Session Reconnected2511:53:38 getBasic: Check DB Privilege for [sys]2611:53:39 getBasic: Get DB Basic Information2711:53:39 getBasic: DBID: [4034009431]2811:53:39 getBasic: DB Name: [LUCIFER]2911:53:39 getBasic: Unique Name: [lucifer]3011:53:39 getBasic: Role: [PRIMARY]3111:53:39 getBasic: Time: [20241023115339]3211:53:39 getBasic: Language: [AMERICAN_AMERICA.AL32UTF8]3311:53:39 getBasic: OS Time: [2024-10-16 11:53:39]3411:53:39 getBasic: Alert Time: [2024-10-16 11:53:39]3511:53:39 getBasic: Listener Time: [2024-10-16 11:00:00]3611:53:39 getBasic: Minimum Snap: [956]3711:53:39 getBasic: Read OS-Instance Mapping from DB3811:53:39 getBasic: Instance Count: 13911:53:39 getBasic: OS-Inst mapping item (Single): [oracle11g] ==> [1.lucifer]4011:53:39 checkEncode: Set OS Character [UTF8]4111:53:39 checkEncode: Set Alert Character [UTF8]4211:53:39 checkEncode: Set Listener Character [UTF8]4311:53:39 checkDIR: Parse and Check Result Directory4411:53:39 checkDIR: Result Directory Set to [data/LUCIFER_20241023115339]4511:53:39 checkDIR: Check Free Space of Result Directory4611:53:39 checkDIR: Result Directory Free Space [76882 MB)], Meet Requirement4711:53:39 checkASM: no ASM instance found for Unix4811:53:39 checkSSH: for Non-RAC Database, No Need to Check SSH Equivalent4911:53:39 selfMonitor: Start Self-Monitor [7069]5011:53:39 Monitor: Monitor Get Parent Process [7069]5111:53:42 collectDB: Collect Data for [BX_MD_DB_SYSTEM]5211:53:42 getALoc: Get Alert Locations5311:53:42 getALoc: Get DB Alert [/u01/app/oracle/diag/rdbms/lucifer/lucifer/trace/alert_lucifer.log] for Node [oracle11g]5411:53:42 cltNodRes: Begin Node Resources Collection5511:53:42 openSocket: Open Socket to Collect Node Resources5611:53:42 openSocket: Started Listen on Port [12345]5711:53:42 cltNodRes: Starting Collection Robot on Local [oracle11g]5811:53:42 cltNodRes: Current Node IP Address [192.168.6.60]5911:53:42 cltNodRes: Do Nothing Mode [MANUAL]6011:53:42 cltNodRes: Loop to read node resource informations6111:53:42 openSocket: HOSTNAME -> Connected to Node [127.0.0.1]6211:53:42 NodeRobot: oracle11g -> Host Name [oracle11g]6311:53:42 NODE_PARAMS: oracle11g -> Node Parameters have been sent Remote6411:53:42 selfMonitor: oracle11g -> Start Self-Monitor [7081]6511:53:42 Monitor: oracle11g -> Monitor Get Parent Process [7081]6611:53:45 NodeRobot: oracle11g -> Collect Node Resources for [oracle11g]6711:53:45 Checker: oracle11g -> Check Passed for [oracle11g]6811:53:45 NodeRobot: oracle11g -> Node Check Passed in Primary Node6911:53:45 osMemory: oracle11g -> Begin Memory Collection7011:53:45 osMemory: oracle11g -> Complete Memory Collection7111:53:45 osInstance: oracle11g -> Begin Extra-Instance Collection7211:53:45 osInstance: oracle11g -> Search Extra-Instance for Linux/Unix7311:53:45 osInstance: oracle11g -> Extra-Instance List : lucifer7411:53:45 osInstance: oracle11g -> Checker for: [lucifer] [/u01/app/oracle/product/11.2.0/db]7511:53:45 osInstance: oracle11g -> Collection for: [lucifer] [/u01/app/oracle/product/11.2.0/db]7611:53:45 connDB: oracle11g -> Get DB Character Set [UTF8], Session Reconnected7711:53:45 collectDB: oracle11g -> Collect Data for [RD_DB_EXTINST]7811:53:45 sendFile: oracle11g -> Sending Result File [./nirvana_db_extInst.txt]7911:53:45 sendFile: oracle11g -> File Sending Completed8011:53:45 osInstance: oracle11g -> Complete Extra-Instance Collection8111:53:45 osError: oracle11g -> Begin OS Error Collection8211:53:45 Warn: oracle11g -> No Permision to Read Linux Error Log8311:53:45 osError: oracle11g -> Complete OS Error Collection8411:53:45 osCrontab: oracle11g -> Begin OS Crontab Collection8511:53:45 osCrontab: oracle11g -> Complete OS Crontab Collection8611:53:45 osAlert: oracle11g -> Begin Alert Collection8711:53:45 osAlert: oracle11g -> Collect Alert [/u01/app/oracle/diag/rdbms/lucifer/lucifer/trace/alert_lucifer.log] for Instance [lucifer]8811:53:45 osAlert: oracle11g -> Finding Position of [2024-10-16 11:53:39], File Size is [266177]8911:53:45 osAlert: oracle11g -> Read Alert from [256398], Size is [9.55 KB]9011:53:45 osAlert: oracle11g -> Expand Error Message Range9111:53:45 osAlert: oracle11g -> Read Alert Contents9211:53:45 osAlert: oracle11g -> Begin Transfer Trace [lucifer_j001_2586.trc]9311:53:45 osAlert: oracle11g -> Complete Alert Collection9411:53:45 osBasic: oracle11g -> Begin OS Information Collection9511:53:45 osBasic: oracle11g -> Complete OS Information Collection9611:53:45 osNIC: oracle11g -> Begin OS NIC Collection9711:53:45 osNIC: oracle11g -> Collect NIC Info by [ifconfig -a]9811:53:45 osNIC: oracle11g -> Complete OS NIC Collection9911:53:45 osParameter: oracle11g -> Begin OS Parameter Collection10011:53:45 osParameter: oracle11g -> Complete OS Parameter Collection10111:53:45 osFS: oracle11g -> Begin Disk Collection10211:53:45 osFS: oracle11g -> Complete Disk Collection10311:53:45 cltStatus: oracle11g -> Begin Listener Status Collection10411:53:45 cltStatus: oracle11g -> Get Running Listener Info10511:53:45 cltStatus: oracle11g -> Get Listener [LISTENER] PATH [/u01/app/oracle/product/11.2.0/db]10611:53:45 cltStatus: oracle11g -> Collect Listener Status10711:53:45 cltStatus: oracle11g -> Complete Listener Status Collection10811:53:45 osListener: oracle11g -> Begin Listener Collection10911:53:45 osListener: oracle11g -> Collect listener log [/u01/app/oracle/diag/tnslsnr/oracle11g/listener/trace/listener.log]11011:53:45 osListener: oracle11g -> Check File Encoding11111:53:45 osListener: oracle11g -> Check Result: Lines = [16405] Warns = [0]11211:53:45 osListener: oracle11g -> Finding Position of [2024-10-16 11:00:00], File Size is [650765]11311:53:45 osListener: oracle11g -> Read Log from [621424], Size is [28 KB]11411:53:45 osListener: oracle11g -> Reading Listener Log11511:53:45 osListener: oracle11g -> Complete Listener Collection11611:53:45 cltConfig: oracle11g -> Begin Oracle Network Config Collection11711:53:46 cltConfig: oracle11g -> Complete Oracle Network Config Collection11811:53:46 osHosts: oracle11g -> Begin OS Hosts Collection11911:53:46 osHosts: oracle11g -> Hosts File Location [/etc/hosts]12011:53:46 osHosts: oracle11g -> Complete OS Hosts Collection12111:53:46 osOPatch: oracle11g -> Begin Oracle Patch Collection12211:53:48 osOPatch: oracle11g -> Complete Oracle Patch Collection12311:53:48 COMPLETE: oracle11g -> Collection Completed12411:53:48 Monitor: oracle11g -> Stop Monitor Process [7082]12511:53:48 cltNodRes: Complete Node Resources Collection12611:53:48 cltDGDat: Collect DG Data12711:53:48 cltDGDat: User Request not Collect DG Data12811:53:48 collectDB: Use SQL Statement for DB Version [11]12911:53:48 collectDB: Collect Data for [RD_DB_TFILE]13011:53:48 collectDB: Collect Data for [RD_DB_AWR_TIMEMODEL]13111:53:48 collectDB: Collect Data for [RD_DB_LOGFILE]13211:53:48 collectDB: Collect Data for [RD_DB_USER]13311:53:48 collectDB: Use SQL Statement for DB Version [11]13411:53:48 collectDB: Collect Data for [RD_DB_TS]13511:53:48 collectDB: Collect Data for [RD_DB_OBJ]13611:53:48 collectDB: Collect Data for [RD_DB_AWR_SYSSTAT]13711:53:48 collectDB: Use SQL Statement for DB Version [11]13811:53:48 collectDB: Collect Data for [RD_DB_CONTAINER]13911:53:48 collectDB: Collect Data for [RD_DB_AWR_INSTANCE]14011:53:48 collectDB: Collect Data for [RD_DB_ASMDSK]14111:53:48 collectDB: Use SQL Statement for DB Version [11]14211:53:48 collectDB: Collect Data for [RD_DB_INST]14311:53:48 collectDB: Collect Data for [RD_DB_BAKSET]14411:53:49 collectDB: Collect Data for [RD_DB_ROLE]14511:53:49 collectDB: Use SQL Statement for DB Version [11]14611:53:49 collectDB: Collect Data for [RD_DB_PROPS]14711:53:49 collectDB: Collect Data for [RD_DB_REGISTRY]14811:53:49 collectDB: Collect Data for [RD_DB_DICTSTAT]14911:53:49 collectDB: Collect Data for [RD_DB_JOB]15011:53:49 collectDB: Collect Data for [RD_DB_LINKS]15111:53:49 collectDB: Collect Data for [RD_DB_AWR_RESLIMIT]15211:53:49 collectDB: Collect Data for [RD_DB_SYSUSER]15311:53:49 collectDB: Collect Data for [RD_DB_SPPAR]15411:53:49 collectDB: Use SQL Statement for DB Version [11]15511:53:49 collectDB: Collect Data for [RD_DB_DFILE]15611:53:49 collectDB: Collect Data for [RD_DB_AWR_SGA]15711:53:49 collectDB: Collect Data for [RD_DB_AWR_SNAPSHOT]15811:53:49 collectDB: Collect Data for [RD_DB_SYSPRIV]15911:53:49 collectDB: Collect Data for [RD_DB_AWR_CONTROL]16011:53:49 collectDB: Collect Data for [RD_DB_TRIGGER]16111:53:49 collectDB: Collect Data for [RD_DB_AWR_OSSTAT]16211:53:49 collectDB: Use SQL Statement for DB Version [11]16311:53:49 collectDB: Collect Data for [RD_DB_SCHEDULER]16411:53:49 collectDB: Collect Data for [RD_DB_PAR]16511:53:49 collectDB: Collect Data for [RD_DB_BAKFILE]16611:53:49 collectDB: Collect Data for [RD_DB_BAKSPFILE]16711:53:49 collectDB: Collect Data for [RD_DB_ROLEPRIV]16811:53:49 collectDB: Collect Data for [RD_DB_SCN]16911:53:49 collectDB: Collect Data for [RD_DB_AWR_TOPEVENT]17011:53:49 collectDB: Collect Data for [RD_DB_PROFILE]17111:53:49 collectDB: Collect Data for [RD_DB_LOGHIST]17211:53:49 collectDB: Collect Data for [RD_DB_DSKGRP]17311:53:49 collectDB: Collect Data for [RD_DB_REGHIST]17411:53:49 collectDB: Collect Data for [RD_DB_BAKARCH]17511:53:49 collectDB: Use SQL Statement for DB Version [11]17611:53:49 collectDB: Collect Data for [RD_DB_SEGSUMM_SIZE]17711:53:50 collectDB: Collect Data for [RD_DB_TOPSEGS]17811:53:50 collectDB: Use SQL Statement for DB Version [11]17911:53:50 collectDB: Collect Data for [RD_DB_INFO]18011:53:50 collectDB: Collect Data for [RD_DB_LOG]18111:53:50 cltAWRSqlS: Collect AWR SQL Statistics18211:53:50 cltAWRSqlT: Collect AWR SQL Text18311:53:50 cltAWRSqlP: Collect AWR SQL Plan18411:53:50 collectDB: Collect Data for [RD_DB_AWR_SQLPLAN]18511:53:50 collectDB: Collect Data for [RD_DB_AWR_SQLPLAN]18611:53:51 cltAWRSqlO: Collect AWR SQL Objects18711:53:51 cltAWRSqlO: Collect Table-Related Informations18811:53:51 cltAWRSqlO: Collect Table for [APEX_030200], Size [1]18911:53:51 collectDB: Collect Data for [RD_DB_TABLES]19011:53:51 collectDB: Collect Data for [RD_DB_COLUMNS]19111:53:51 collectDB: Collect Data for [RD_DB_TABPART]19211:53:51 collectDB: Collect Data for [RD_DB_TABSUBPART]19311:53:51 cltAWRSqlO: Collect Table for [CTXSYS], Size [1]19411:53:51 collectDB: Collect Data for [RD_DB_TABLES]19511:53:51 collectDB: Collect Data for [RD_DB_COLUMNS]19611:53:51 collectDB: Collect Data for [RD_DB_TABPART]19711:53:51 collectDB: Collect Data for [RD_DB_TABSUBPART]19811:53:51 cltAWRSqlO: Collect Table for [SYSTEM], Size [2]19911:53:51 collectDB: Collect Data for [RD_DB_TABLES]20011:53:51 collectDB: Collect Data for [RD_DB_COLUMNS]20111:53:51 collectDB: Collect Data for [RD_DB_TABPART]20211:53:51 collectDB: Collect Data for [RD_DB_TABSUBPART]20311:53:51 cltAWRSqlO: Collect Table for [DBSNMP], Size [3]20411:53:51 collectDB: Collect Data for [RD_DB_TABLES]20511:53:51 collectDB: Collect Data for [RD_DB_COLUMNS]20611:53:51 collectDB: Collect Data for [RD_DB_TABPART]20711:53:51 collectDB: Collect Data for [RD_DB_TABSUBPART]20811:53:51 cltAWRSqlO: Collect Index-Related Informations20911:53:51 cltAWRSqlO: Collect Index for [FLOWS_FILES], Size [1]21011:53:51 collectDB: Collect Data for [RD_DB_INDEXES]21111:53:51 collectDB: Collect Data for [RD_DB_INDCOL]21211:53:51 collectDB: Collect Data for [RD_DB_INDPART]21311:53:51 collectDB: Collect Data for [RD_DB_INDSUBPART]21411:53:51 collectDB: Collect Data for [RD_DB_INDEXP]21511:53:51 cltAWRSqlO: Collect Index for [APEX_030200], Size [3]21611:53:51 collectDB: Collect Data for [RD_DB_INDEXES]21711:53:51 collectDB: Collect Data for [RD_DB_INDCOL]21811:53:51 collectDB: Collect Data for [RD_DB_INDPART]21911:53:51 collectDB: Collect Data for [RD_DB_INDSUBPART]22011:53:51 collectDB: Collect Data for [RD_DB_INDEXP]22111:53:51 cltAWRSqlO: Collect Index for [CTXSYS], Size [2]22211:53:51 collectDB: Collect Data for [RD_DB_INDEXES]22311:53:51 collectDB: Collect Data for [RD_DB_INDCOL]22411:53:51 collectDB: Collect Data for [RD_DB_INDPART]22511:53:51 collectDB: Collect Data for [RD_DB_INDSUBPART]22611:53:51 collectDB: Collect Data for [RD_DB_INDEXP]22711:53:51 cltAWRSqlO: Collect Index for [SYSTEM], Size [4]22811:53:51 collectDB: Collect Data for [RD_DB_INDEXES]22911:53:51 collectDB: Collect Data for [RD_DB_INDCOL]23011:53:51 collectDB: Collect Data for [RD_DB_INDPART]23111:53:51 collectDB: Collect Data for [RD_DB_INDSUBPART]23211:53:51 collectDB: Collect Data for [RD_DB_INDEXP]23311:53:51 cltAWRSqlO: Collect Index for [DBSNMP], Size [5]23411:53:51 collectDB: Collect Data for [RD_DB_INDEXES]23511:53:51 collectDB: Collect Data for [RD_DB_INDCOL]23611:53:51 collectDB: Collect Data for [RD_DB_INDPART]23711:53:51 collectDB: Collect Data for [RD_DB_INDSUBPART]23811:53:51 collectDB: Collect Data for [RD_DB_INDEXP]23911:53:51 cltAWRSqlO: Collect Object-Related Informations24011:53:51 cltAWRSqlO: Collect Object for [FLOWS_FILES], Size [1]24111:53:51 collectDB: Collect Data for [RD_DB_OBJECT]24211:53:51 collectDB: Collect Data for [RD_DB_SEGMENT]24311:53:51 collectDB: Collect Data for [RD_DB_PARTKEY]24411:53:51 collectDB: Collect Data for [RD_DB_SUBPARTKEY]24511:53:51 cltAWRSqlO: Collect Object for [APEX_030200], Size [4]24611:53:51 collectDB: Collect Data for [RD_DB_OBJECT]24711:53:51 collectDB: Collect Data for [RD_DB_SEGMENT]24811:53:51 collectDB: Collect Data for [RD_DB_PARTKEY]24911:53:51 collectDB: Collect Data for [RD_DB_SUBPARTKEY]25011:53:51 cltAWRSqlO: Collect Object for [CTXSYS], Size [3]25111:53:51 collectDB: Collect Data for [RD_DB_OBJECT]25211:53:52 collectDB: Collect Data for [RD_DB_SEGMENT]25311:53:52 collectDB: Collect Data for [RD_DB_PARTKEY]25411:53:52 collectDB: Collect Data for [RD_DB_SUBPARTKEY]25511:53:52 cltAWRSqlO: Collect Object for [SYSTEM], Size [6]25611:53:52 collectDB: Collect Data for [RD_DB_OBJECT]25711:53:52 collectDB: Collect Data for [RD_DB_SEGMENT]25811:53:52 collectDB: Collect Data for [RD_DB_PARTKEY]25911:53:52 collectDB: Collect Data for [RD_DB_SUBPARTKEY]26011:53:52 cltAWRSqlO: Collect Object for [DBSNMP], Size [8]26111:53:52 collectDB: Collect Data for [RD_DB_OBJECT]26211:53:52 collectDB: Collect Data for [RD_DB_SEGMENT]26311:53:52 collectDB: Collect Data for [RD_DB_PARTKEY]26411:53:52 collectDB: Collect Data for [RD_DB_SUBPARTKEY]26511:53:52 cltRACSta: Collect RAC crs_stat26611:53:52 cltRACSta: no CRS instance running26711:53:52 cltASMDat: Begin ASM-Related Data Collection26811:53:52 cltASMDat: No ASM Instance Found for Current DB System26911:53:52 cltASMDat: Completed ASM-Related Data Collection27011:53:52 cltTopAWR: Collect DB AWR Report27111:53:52 cltTopAWR: Get Top AWR [1 of 3]27211:53:56 cltTopAWR: Get Top AWR [2 of 3]27311:54:01 cltTopAWR: Get Top AWR [3 of 3]27411:54:05 cltTopAWR: Complete DB AWR Report Collection27511:54:05 cltSegStats: Collect AWR Segment Stats and Objects27611:54:05 collectDB: Collect Data for [RD_DB_AWR_SEGSTATS]27711:54:05 cltSegStats: Segment Obj Info Location [2/3/4]27811:54:05 cltSegStats: Collect Segment Object for Batch [1]27911:54:05 collectDB: Collect Data for [RD_DB_AWR_SEGOBJ]28011:54:05 cltSegStats: Collect Segment Object for Batch [2]28111:54:05 collectDB: Collect Data for [RD_DB_AWR_SEGOBJ]28211:54:05 cltSegStats: Complete AWR Segment Stats and Objects28311:54:05 cltSCNCompat: Collect SCN Compat Version28411:54:05 cltSCNCompat: Complete SCN Compat Version28511:54:05 postProcess: do Post Process28611:54:05 closeSocket: Close Socket on Port [12345]28711:54:05 postProcess: 28811:54:05 postProcess: +====================== [ Summary Information ] ======================+28911:54:05 postProcess: | Table Name File Name Size |29011:54:05 postProcess: | -------------------- ----------------------------------- -------- |29111:54:05 postProcess: | RD_DB_LINKS nirvana_db_links.txt 36 B |29211:54:05 postProcess: | RD_DB_CRSSTAT nirvana_db_crsstat.txt 49 B |29311:54:05 postProcess: | RD_DB_LSNR nirvana_db_lsnr.txt 51 B |29411:54:05 postProcess: | RD_DB_PARTKEY nirvana_db_partKey.txt 51 B |29511:54:05 postProcess: | RD_DB_SUBPARTKEY nirvana_db_subPartKey.txt 51 B |29611:54:05 postProcess: | RD_DB_SYSUSER nirvana_db_sysUser.txt 54 B |29711:54:05 postProcess: | RD_OS_ERR nirvana_os_err.txt 70 B |29811:54:05 postProcess: | RD_DB_DICTSTAT nirvana_db_dictStat.txt 74 B |29911:54:05 postProcess: | RD_DB_INDEXP nirvana_db_indExp.txt 80 B |30011:54:05 postProcess: | RD_OS_MEMSTAT nirvana_os_memStat.txt 94 B |30111:54:05 postProcess: | RD_DB_AWR_CONTROL nirvana_db_awr_control.txt 98 B |30211:54:05 postProcess: | RD_DB_SCN_COMPAT nirvana_db_scn_compat.txt 102 B |30311:54:05 postProcess: | RD_DB_SCN nirvana_db_SCN.txt 105 B |30411:54:05 postProcess: | BX_MD_DB_SYSTEM nirvana_md_database.txt 116 B |30511:54:05 postProcess: | RD_OS_CRONTAB nirvana_os_crontab.txt 135 B |30611:54:05 postProcess: | RD_DB_ALERT_TRACE nirvana_db_alert_trace.txt 161 B |30711:54:05 postProcess: | RD_DB_DSKGRP nirvana_db_dskGrp.txt 180 B |30811:54:05 postProcess: | RD_OS_HOSTS nirvana_os_hosts.txt 210 B |30911:54:05 postProcess: | RD_DB_BAKSPFILE nirvana_db_bakSPfile.txt 235 B |31011:54:05 postProcess: | RD_DB_TFILE nirvana_db_tFile.txt 257 B |31111:54:05 postProcess: | RD_OS_INFO nirvana_os_info.txt 271 B |31211:54:05 postProcess: | RD_DB_ASMDSK nirvana_db_asmDsk.txt 288 B |31311:54:05 postProcess: | RD_DB_REGHIST nirvana_db_regHist.txt 293 B |31411:54:05 postProcess: | RD_DB_INST nirvana_db_inst.txt 373 B |31511:54:05 postProcess: | RD_DB_AWR_INSTANCE nirvana_db_awr_instance.txt 378 B |31611:54:05 postProcess: | RD_DB_TABSUBPART nirvana_db_tabSubPart.txt 392 B |31711:54:05 postProcess: | RD_DB_TABPART nirvana_db_tabPart.txt 400 B |31811:54:05 postProcess: | RD_DB_CONTAINER nirvana_db_container.txt 401 B |31911:54:05 postProcess: | RD_OS_FS nirvana_os_FS.txt 412 B |32011:54:05 postProcess: | RD_DB_LOGHIST nirvana_db_logHist.txt 417 B |32111:54:05 postProcess: | RD_DB_INDSUBPART nirvana_db_indSubPart.txt 437 B |32211:54:05 postProcess: | RD_DB_LOGFILE nirvana_db_logFile.txt 456 B |32311:54:05 postProcess: | RD_DB_INDPART nirvana_db_indPart.txt 490 B |32411:54:05 postProcess: | RD_DB_AWR_REPORT nirvana_db_awr_report.txt 554 B |32511:54:05 postProcess: | RD_DB_EXTINST nirvana_db_extInst.txt 555 B |32611:54:05 postProcess: | RD_OS_PAR nirvana_os_par.txt 633 B |32711:54:05 postProcess: | RD_DB_SEGSUMM_SIZE nirvana_db_segSumm_size.txt 845 B |32811:54:05 postProcess: | RD_OS_ORANET nirvana_os_oraNet.txt 888 B |32911:54:05 postProcess: | RD_DB_DFILE nirvana_db_dFile.txt 917 B |33011:54:05 postProcess: | RD_DB_LOG nirvana_db_log.txt 965 B |33111:54:05 postProcess: | RD_OS_NIC nirvana_os_NIC.txt 1.084 KB |33211:54:05 postProcess: | RD_DB_ROLE nirvana_db_role.txt 1.223 KB |33311:54:05 postProcess: | RD_DB_TS nirvana_db_ts.txt 1.240 KB |33411:54:05 postProcess: | RD_DB_JOB nirvana_db_job.txt 1.257 KB |33511:54:05 postProcess: | RD_OS_RAW nirvana_os_raw.txt 1.368 KB |33611:54:05 postProcess: | RD_OS_LSN_STATUS nirvana_os_lsnStatus.txt 1.468 KB |33711:54:05 postProcess: | RD_DB_TOPSEGS nirvana_db_topsegs.txt 1.477 KB |33811:54:05 postProcess: | RD_DB_INFO nirvana_db_info.txt 1.517 KB |33911:54:05 postProcess: | RD_DB_PROFILE nirvana_db_profile.txt 1.805 KB |34011:54:05 postProcess: | RD_DB_SEGMENT nirvana_db_segment.txt 1.980 KB |34111:54:05 postProcess: | RD_DB_BAKARCH nirvana_db_bakArch.txt 2.035 KB |34211:54:05 postProcess: | RD_DB_BAKSET nirvana_db_bakSet.txt 2.127 KB |34311:54:05 postProcess: | RD_DB_PROPS nirvana_db_props.txt 2.136 KB |34411:54:05 postProcess: | RD_DB_INDCOL nirvana_db_indCol.txt 2.290 KB |34511:54:05 postProcess: | RD_DB_REGISTRY nirvana_db_registry.txt 2.353 KB |34611:54:05 postProcess: | BX_BATCH_STATUS nirvana_batch_status.txt 2.576 KB |34711:54:05 postProcess: | RD_DB_BAKFILE nirvana_db_bakFile.txt 2.646 KB |34811:54:05 postProcess: | RD_DB_TABLES nirvana_db_table.txt 2.907 KB |34911:54:05 postProcess: | RD_DB_SPPAR nirvana_db_spPar.txt 3.346 KB |35011:54:05 postProcess: | RD_DB_ROLEPRIV nirvana_db_rolePriv.txt 4.763 KB |35111:54:05 postProcess: | RD_DB_OBJ nirvana_db_obj.txt 4.796 KB |35211:54:05 postProcess: | RD_DB_OBJECT nirvana_db_obj.txt 4.796 KB |35311:54:05 postProcess: | RD_DB_TRIGGER nirvana_db_trigger.txt 5.755 KB |35411:54:05 postProcess: | RD_OS_FILESIZE nirvana_os_fileSize.txt 5.771 KB |35511:54:05 postProcess: | RD_DB_INDEXES nirvana_db_index.txt 5.883 KB |35611:54:05 postProcess: | RD_DB_USER nirvana_db_user.txt 9.420 KB |35711:54:05 postProcess: | RD_DB_AWR_SEGOBJ nirvana_db_awr_segObj.txt 10.31 KB |35811:54:05 postProcess: | RD_DB_AWR_SNAPSHOT nirvana_db_awr_snapshot.txt 11.22 KB |35911:54:05 postProcess: | BX_BATCH_CONTROL nirvana_batch_control.txt 14.25 KB |36011:54:05 postProcess: | RD_DB_AWR_RESLIMIT nirvana_db_awr_resLimit.txt 15.13 KB |36111:54:05 postProcess: | RD_DB_SCHEDULER nirvana_db_scheduler.txt 16.54 KB |36211:54:05 postProcess: | RD_DB_COLUMNS nirvana_db_column.txt 21.19 KB |36311:54:05 postProcess: | RD_DB_ALERT nirvana_db_alert.txt 22.57 KB |36411:54:05 postProcess: | RD_DB_SYSPRIV nirvana_db_sysPriv.txt 27.99 KB |36511:54:05 postProcess: | RD_DB_AWR_SEGSTATS nirvana_db_awr_segStats.txt 29.59 KB |36611:54:05 postProcess: | RD_DB_AWR_TOPEVENT nirvana_db_awr_topEvent.txt 39.44 KB |36711:54:05 postProcess: | RD_DB_AWR_OSSTAT nirvana_db_awr_osStat.txt 44.36 KB |36811:54:05 postProcess: | RD_DB_AWR_SYSSTAT nirvana_db_awr_sysstat.txt 53.58 KB |36911:54:05 postProcess: | RD_DB_AWR_TIMEMODEL nirvana_db_awr_timeModel.txt 55.09 KB |37011:54:05 postProcess: | RD_DB_PAR nirvana_db_par.txt 60.08 KB |37111:54:05 postProcess: | RD_DB_AWR_SGA nirvana_db_awr_sga.txt 70.05 KB |37211:54:05 postProcess: | RD_DB_AWR_SQLTEXT nirvana_db_awr_sqlText.txt 128.7 KB |37311:54:05 postProcess: | RD_DB_AWR_SQLSTAT nirvana_db_awr_sqlStat.txt 221.3 KB |37411:54:05 postProcess: | RD_DB_AWR_SQLPLAN nirvana_db_awr_sqlPlan.txt 604.5 KB |37511:54:05 postProcess: +=====================================================================+37611:54:06 postProcess: Stop Monitor Process [7078]377378Collection Tasks all Completed, Result File:379 [ Bethune ] --> data/LUCIFER_20241023115339.zip采集完成后，生成一个巡检文件：LUCIFER_20241023115339.zip：
1[oracle@oracle11g:/home/oracle/BTRobot-v2.3.0/data]$ ll2total 4563-rw-r--r-- 1 oracle oinstall 466674 Oct 23 11:54 LUCIFER_20241023115339.zip在当前目录的 data 文件夹下，下载巡检文件到本地主机。
巡检文件需要上传到墨天轮智能巡检工具进行报告分析和生成：
点击上传文件，上传巡检文件：
上传成功后，会自动跳转到报告分析和生成页面。
等待一会儿，报告就可以生成了：
点击查看报告就可以预览：
会给出一些数据库建议：
报告是 HTML 格式，目前仅支持在线预览，没有提供下载按钮。
墨天轮当初定的的愿景“乐知乐享，同心共济”就是要面向 DBA 及数据库从业者构建一个学习、分享的社区，大家互帮互助共同成功。
作为一个免费的智能巡检工具，已经非常不错了，建议大家都可以玩玩~
❤️ 最后再分享推荐一下我自己写的 Oracle 一键巡检工具：
感兴趣的朋友，可以添加微信：Lucifer-0622 咨询，支持正版，打击盗版！！！
Oracle 一键巡检自动生成 Word 报告
Oracle 一键安装合集
Oracle一键安装脚本的 21 个疑问与解答
Oracle一键巡检脚本的 21 个疑问与解答
全网首发：Oracle 23ai 一键安装脚本（非 RPM）
Oracle 19C 最新 RU 补丁 19.24 ，一键安装！
Oracle Linux 7.9 一键安装 Oracle 19C
RedHat 9.4(aarch64) 一键安装 Oracle 19C
openEuler 22.03 LTS SP4 一键安装 Oracle 19C RAC
RHEL 7.9 一键安装 Oracle 19C 19.23 RAC
Oracle DataGuard GAP 修复手册
优化 Oracle：最佳实践与开发规范
DBA 必备：Linux 软件源配置全攻略
Linux 一键配置时钟同步全攻略
感谢您的阅读，这里是 Lucifer三思而后行，欢迎点赞+关注，我会持续分享数据库知识、运维技巧。