使用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:
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
RDA-00033: Warning - 2 command(s) not executed in RDA.CONFIG, RDA.END module(s)
操作完成後生成如下檢查結果
下載解壓後可以進行相關檢視:
一般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:
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
RDA-00033: Warning - 2 command(s) not executed in RDA.CONFIG, RDA.END module(s)
操作完成後生成如下檢查結果
下載解壓後可以進行相關檢視:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29135257/viewspace-2148244/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL資料庫健康檢查--MySQL巡檢MySql資料庫
- oracle巡檢工具-RDAOracle
- Oracle巡檢工具RDA使用手冊Oracle
- 【RDA】使用RDA(Remote Diagnostic Agent)工具對資料庫進行健康檢查REM資料庫
- 資料庫巡檢模版資料庫
- Oracle資料庫巡檢Oracle資料庫
- oracle資料庫巡檢(轉)Oracle資料庫
- SQL Server資料庫巡檢SQLServer資料庫
- DB健康檢查使用RDA收集資料
- 資料庫巡檢參考項資料庫
- oracle資料庫巡檢內容Oracle資料庫
- oracle資料庫巡檢(二)全面檢查Oracle資料庫
- MSSQL資料庫健康檢查--SQL Server巡檢SQL資料庫Server
- Oracle資料庫(RAC)巡檢報告Oracle資料庫
- Oracle資料庫巡檢參考項Oracle資料庫
- Oracle資料庫(單機)巡檢報告Oracle資料庫
- 資料庫巡檢常用的SQL語句資料庫SQL
- oracle資料庫巡檢優化-快速定位資料庫瓶頸Oracle資料庫優化
- oracle資料庫巡檢最佳化-使用sql語句快速定位資料庫瓶頸Oracle資料庫SQL
- oracle資料庫巡檢(一)基本sql語句Oracle資料庫SQL
- oracle資料庫巡檢優化-快速定位資料庫瓶頸(轉)Oracle資料庫優化
- oracle資料庫巡檢最佳化-快速定位資料庫瓶頸Oracle資料庫
- 小麥苗資料庫巡檢指令碼V7.0,支援Oracle、MySQL、SQL Server和PG資料庫資料庫指令碼OracleMySqlServer
- mysql巡檢指令碼MySql指令碼
- 資料庫相關的系統巡檢參考項資料庫
- 陌生Oracle的資料庫環境的巡檢內容Oracle資料庫
- 檢視mysql資料庫空間使用情況MySql資料庫
- Windows使用Apche並檢視MySQL資料庫(轉)WindowsMySql資料庫
- 從巡檢備份失敗排查解決資料庫故障資料庫
- MySQL檢視當前資料庫庫MySql資料庫
- 從零開始實現資料庫自動化巡檢(一)資料庫
- 檢視MySQL資料庫的命令MySql資料庫
- mysql 伺服器巡檢指令碼MySql伺服器指令碼
- Oracle 資料庫巡檢指令碼 單例項 RAC 輸出HTML格式Oracle資料庫指令碼單例HTML
- MySQL資料庫使用(二)MySql資料庫
- 資料庫檢視的使用資料庫
- mysql binlog檢視指定資料庫MySql資料庫
- 墨天輪最受DBA歡迎的資料庫技術文件-巡檢篇資料庫