使用RDA巡檢MYSQL資料庫

RDA(RemoteDiagnostic Agent)是oracle用來收集、分析資料庫的工具，執行該工具不會改變系統的任何引數，RDA收集的相關資料非常全面，可以簡化我們日常監控、分析資料庫的工作。
一般Oracle 原廠的人巡檢也是使用RDA工具。 不過一般國內的DBA 巡檢時很少使用這個工具，一般都是通過AWR 或者自己整幾個指令碼，跑了在分析一下就ok了。
在MOS 上建立SR(Service Request)時（我08年剛接觸Oracle時，那是MOS 上還是稱呼Tar，後來改成了SR了）。 Oracle 也會要求客戶上傳RDA的資訊。 通過RDA 可以快速的瞭解系統的狀況。
RDA 是用Perl 指令碼寫出來的。 可以通過MOS 下載RDA。 RDA 是一個客戶端，解壓縮之後就可以直接使用了。
同樣RDA也可以對mysql資料庫進行簡單的檢查，並生成檢查報告。

參考文件：
Using Remote Diagnostic Agent (RDA) 4 with MySQL Server and MySQL Cluster (文件 ID 1437541.1)

實驗環境：
Server version: 5.6.37

命令
RDA模組配置
./rda.sh -S  MYSQ
生成巡檢結果
./rda.sh -v MYSQ

實驗過程
[mysql@jing1 rda]$ ./rda.sh -S  MYSQ
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "zh_CN.CB18030"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Enter the network domain name for this server
> jing1


------------------------------------------------------------------------------
RDA.BEGIN: Initializes the Data Collection
------------------------------------------------------------------------------
Enter the Oracle home to be used for data analysis
> /usr/local/mysql


------------------------------------------------------------------------------
RDA.CONFIG: Collects Key Configuration Information
------------------------------------------------------------------------------
------------------------------------------------------------------------------
DB.MYSQ: Collects Oracle MySQL Server Information
------------------------------------------------------------------------------
Do you want RDA to collect Oracle MySQL Server information (Y/N)?
Press Return to accept the default (Y)
> 


Enter the full path of the Oracle MySQL Server configuration file
Press Return to accept the default (/etc/my.cnf)
> /data/mysqldata/3306/my.cnf


Enter the user name for the Oracle MySQL Server connection
> system


------------------------------------------------------------------------------
RDA.OCM: Set up the Configuration Manager Interface
------------------------------------------------------------------------------
------------------------------------------------------------------------------
RDA.STATUS: Produces the Remote Data Collection Reports
------------------------------------------------------------------------------
------------------------------------------------------------------------------
RDA.LOAD: Produces the External Collection Reports
------------------------------------------------------------------------------
------------------------------------------------------------------------------
RDA.FILTER: Controls Report Content Filtering
------------------------------------------------------------------------------
------------------------------------------------------------------------------
RDA.END: Finalizes the Data Collection
------------------------------------------------------------------------------
[mysql@jing1 rda]$ 
[mysql@jing1 rda]$ 
[mysql@jing1 rda]$ ./rda.sh -v MYSQ
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "zh_CN.CB18030"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Collecting diagnostic data ...
------------------------------------------------------------------------------
RDA Data Collection Started 04-Dec-2017 10:26:01
------------------------------------------------------------------------------
Processing RDA.BEGIN module ...
 Inside BEGIN module, testing the RDA engine code build
 Inside BEGIN module, testing the report directory
 Inside BEGIN module, testing the module targets
 Inside BEGIN module, launching parallel executions
Processing RDA.CONFIG module ...
 Inside CONFIG module, listing Oracle homes
 Inside CONFIG module, getting Oracle home inventory (can take time)
Processing DB.MYSQ module ...
 Inside MYSQ module, gathering database information (can take time)
Enter password: 
 Inside MYSQ module, collecting the configuration files
 Inside cat_report, looking for my.cnf in /data/mysqldata/3306
 Inside MYSQ module, listing the files in /data/mysqldata/3306/data directory
 Inside MYSQ module, collecting the log files
Processing RDA.LOAD module ...
 Inside LOAD module, running CRS diagnostic collection tool
 Inside LOAD module, gathering system comparison reports
 Inside LOAD module, gathering EPM validation reports
 Inside LOAD module, gathering HCVE reports
 Inside LOAD module, gathering JRockit tool reports
 Inside LOAD module, gathering jvm tool reports
 Inside LOAD module, gathering Trace Merge reports
 Inside LOAD module, gathering Network Advisor reports
 Inside LOAD module, gathering Oracle Configuration Manager information
 Inside LOAD module, gathering ORA600 reports
 Inside LOAD module, gathering ORADDC reports
 Inside LOAD module, gathering OSWatcher information
 Inside LOAD module, gathering database performance reports
 Inside LOAD module, gathering the most recent redo tool results
 Inside LOAD module, gathering the most recent TLsecure report
 Inside LOAD module, gathering Siebel crash reports
 Inside LOAD module, gathering siga/sosreport/sysreport reports
Processing RDA.END module ...
 Inside END module, gathering system information
 Inside END module, getting CPU information (linux)
 Inside END module, getting memory information (linux)
 Inside END module, producing the file catalog
 Inside END module, producing target overview
 Inside END module, waiting for parallel execution completion
 Inside END module, producing setting overview
------------------------------------------------------------------------------
RDA Data Collection Ended 04-Dec-2017 10:29:57
------------------------------------------------------------------------------
Generating the reports ...
        - collect/DB_MYSQ_datadir_overview.txt ...
        - collect/RDA_END_report.txt ...
        - collect/DB_MYSQ_db_info.txt ...
        - collect/RDA_END_system.txt ...
        - collect/RDA_END_target.txt ...
        - collect/RDA_END_files.txt ...
        - collect/DB_MYSQ_cfg_my_cnf.txt ...
        - collect/DB_MYSQ_log_files.txt ...
        - Report index ...
Packaging collection results ...
  You can review the reports by transferring the
  /data/mysqldata/scripts/rda/output directory structure to a location where
  you have web-browser access. Then, point your browser at this file to
  display the reports:
    RDA__start.htm


  Based on your server configuration, some possible alternative approaches
  are:
  - If your client computer with a browser has access to a web-shared
    directory, copy the /data/mysqldata/scripts/rda/output directory structure
    to the web-shared directory and visit this URL:
    http://machine:port/web_shared_directory/RDA__start.htm
  or
  - If your client computer with a browser has FTP access to the server
    computer with the /data/mysqldata/scripts/rda/output directory, visit this
    URL:
    ftp://root@jing1.jing1//data/mysqldata/scripts/rda/output


  If this file was generated to assist in resolving a Service Request, send
  /data/mysqldata/scripts/rda/RDA_output_jing1.zip to Oracle Support by
  uploading the file via My Oracle Support. When sending with FTP, make sure
  you send it in BINARY format.


  Note: Do not submit any health, payment card or other sensitive production
  data that requires protections greater than those specified in the Oracle
  GCS Security Practices
  (http://www.oracle.com/us/support/library/customer-support-security-practices-069170.pdf).
  Information on how to remove data from your submission is available at
  https://support.oracle.com/rs?type=doc&id=1227943.1


RDA-00033: Warning - 2 command(s) not executed in RDA.CONFIG, RDA.END module(s)

操作完成後生成如下檢查結果

下載解壓後可以進行相關檢視：

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29135257/viewspace-2148244/，如需轉載，請註明出處，否則將追究法律責任。