one command 一鍵收集 oracle 巡檢資訊(包含dbhc,awr reports),dbhcawr

來源:互聯網
上載者:User

one command 一鍵收集 oracle 巡檢資訊(包含dbhc,awr reports),dbhcawr

 

初步如下

 

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




相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.