AWR 导出/导入/生成报告

2024-04-02 19:04:59 224人浏览安东尼

摘要

客户的生产系统总是那么重要，一般不会让你长时间的在他们的生产机器上做操作，但是分析和生成AWR报告都是一个相对耗时的工作，当然只生成一个AWR报告是不费时的，但是

客户的生产系统总是那么重要，一般不会让你长时间的在他们的生产机器上做操作，但是分析和生成AWR报告都是一个相对耗时的工作，当然只生成一个AWR报告是不费时的，但是要对系统进行详细分析的时候，我们可能需要的是一段时间内的所有AWR数据，需要根据实际情况进行选取。这时我们就需要将客户的AWR数据导出，然后进行分析，这个操作主要涉及AWR数据导出、导入和生成报告三个阶段，下面对每个步骤进行详细描述。
1、导出

sql> @?/rdbms/admin/awrextr.sql
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Disclaimer: This SQL/Plus script should only be called under
the guidance of oracle Support.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~
AWR EXTRACT
~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ This script will extract the AWR data for a range of snapshots ~
~ into a dump file. The script will prompt users for the ~
~ following infORMation: ~
~ (1) database id ~
~ (2) snapshot range to extract ~
~ (3) name of directory object ~
~ (4) name of dump file ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Databases in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id DB Name Host
------------ ------------ ------------
* 2182516689 GYL rac01
* 2182516689 GYL rac02
The default database id is the local one: '2182516689'. To use this
database id, press <return> to continue, otherwise enter an alternative.
Enter value for dbid: 2182516689 <<<<<<<输入DBID
Using 2182516689 for Database ID
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.
Enter value for num_days: 7 <<<<<<<输入需要导出数据的天数
Listing the last 7 days of Completed Snapshots
DB Name Snap Id Snap Started
------------ --------- ------------------
GYL 37 07 Nov 2014 10:05
38 07 Nov 2014 11:00
39 07 Nov 2014 12:00
40 07 Nov 2014 13:00
41 07 Nov 2014 14:00
42 07 Nov 2014 15:00
43 07 Nov 2014 16:00
44 10 Nov 2014 13:51
45 10 Nov 2014 15:00
46 10 Nov 2014 16:00
47 12 Nov 2014 14:11
DB Name Snap Id Snap Started
------------ --------- ------------------
GYL 48 12 Nov 2014 14:37
49 12 Nov 2014 16:00
50 12 Nov 2014 17:00
51 12 Nov 2014 18:00
52 13 Nov 2014 10:16
53 13 Nov 2014 11:00
54 13 Nov 2014 12:00
55 13 Nov 2014 13:00
56 13 Nov 2014 14:00
57 13 Nov 2014 16:21
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 52 <<<<<<< 输入起始snap_id
Begin Snapshot Id specified: 52
Enter value for end_snap: 57 <<<<<<< 输入结束snap_id
End Snapshot Id specified: 57
Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name Directory Path
------------------------------ -------------------------------------------------
DATA_PUMP_DIR /oracle/app/oracle/product/10.2/db_1/rdbms/log/
ORACLE_OCM_CONFIG_DIR /oracle/app/oracle/product/10.2/db_1/ccr/state
Choose a Directory Name from the above list (case-sensitive).
Enter value for directory_name: DATA_PUMP_DIR
Using the dump directory: DATA_PUMP_DIR <<<<<<< 指定一个存放导出数据的directory（如果没有需要自己建立一个directory）
Specify the Name of the Extract Dump File
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The prefix for the default dump file name is awrdat_52_57.
To use this name, press <return> to continue, otherwise enter
an alternative.
Enter value for file_name: gyl_rac01
...........省略部分输出.............
Master table \"SYS\".\"SYS_EXPORT_TABLE_01\" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/oracle/app/oracle/product/10.2/db_1/rdbms/log/gyl_rac01.dmp
Job \"SYS\".\"SYS_EXPORT_TABLE_01\" successfully completed at 12:38:07