one command一键收集 oracle 巡检信息(包括dbhc,awr reports)

it2025-06-12  34

 

初步效果图例如以下

 

SQL> @nb

------Oracle Database health Check STRAT ------Starting Collect Data Information!

------Part 1.DB Overview... ------Part 2.DB File Overview... ------Part 3.Perfermance Overview... ------Part 4.Security and Privilege Overview... ------Part 5.Objects Overview... ------Part 6.RAC Overview... ------Part 7.Backup Controlfile... --------------start collect AWR reports

 

Enter value for trace_file_name:

------Oracle Database Health Check END /home/oracle

-rw-r--r-- 1 oracle oinstall 242088 Jul 28 16:58 ./dbhc.lixora.2014-07-28/awr.lixora.html -rw-r--r-- 1 oracle oinstall 280758 Jul 28 16:58 ./dbhc.lixora.2014-07-28/db_health_check_lixora.2014-07-281658.html

SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options [oracle@lixora ~]$ ls -trl

-rw-r--r-- 1 oracle oinstall    48803 Jul 28 16:58 nb.sql drwxr-xr-x 2 oracle oinstall     4096 Jul 28 16:58 dbhc.lixora.2014-07-28

[oracle@lixora ~]$ cd dbhc.lixora.2014-07-28/ [oracle@lixora dbhc.lixora.2014-07-28]$ ls -trl total 524 -rw-r--r-- 1 oracle oinstall 280758 Jul 28 16:58 db_health_check_lixora.2014-07-281658.html -rw-r--r-- 1 oracle oinstall 242088 Jul 28 16:58 awr.lixora.html

转载于:https://www.cnblogs.com/bhlsheji/p/5175274.html

相关资源:数据结构—成绩单生成器
最新回复(0)