我们可以将AWR元数据迁移(导入)到其他数据库，低版本的导入到高版本，再用高版本的数据库生成AWR报告，也能使用一些新特性，如

SQL ordered by Physical Reads (UnOptimized)
SQL ordered by User I/O Wait Time

?

导出：

testnode:/home/oracle$export ORACLE_SID=wy1
testnode:/home/oracle$sqlplus / as sysdba
SQL> @?/rdbms/admin/awrextr.sql
~~~~~~~~~~~~~
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
------------ ------------ ------------
* 3988169241 WY testnode1
* 3988169241 WY testnode2

The default database id is the local one: '3988169241'. To use this
database id, press to continue, otherwise enter an alternative.

Enter value for dbid:

Using 3988169241 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 without
specifying a number lists all completed snapshots.

Enter value for num_days:

Listing all Completed Snapshots

...
DB Name Snap Id Snap Started
------------ --------- ------------------
WY 4706 18 Mar 2015 18:00
4707 18 Mar 2015 19:00 <<<
4708 18 Mar 2015 20:00 <<<

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 4707 <<<<起始SNAP
Begin Snapshot Id specified: 4707 <<<<结束SNAP

Enter value for end_snap: 4708
End Snapshot Id specified: 4708

Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~

Directory Name Directory Path
------------------------------ -------------------------------------------------
DATA_PUMP_DIR /u01/app/oracle/product/11.2.0/db_1/rdbms/log/
EXPDP /tmp/expdp <<<<<<<<<<<<<<<<
ORACLE_OCM_CONFIG_DIR /u01/app/oracle/product/11.2.0/db_1/ccr/state
ORACLE_OCM_CONFIG_DIR2 /u01/app/oracle/product/11.2.0/db_1/ccr/state
XMLDIR /u01/app/oracle/product/11.2.0/db_1/rdbms/xml

Choose a Directory Name from the above list (case-sensitive).

Enter value for directory_name: EXPDP <<<<<<<<<输入DIRECTORY,右边是目录所对应的物理路径.注: 如果SNAP跨度大,需要较大的空间来存放文件

Using the dump directory: EXPDP

Specify the Name of the Extract Dump File
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The prefix for the default dump file name is awrdat_4707_4708.
To use this name, press to continue, otherwise enter
an alternative.

Enter value for file_name:

Using the dump file prefix: awrdat_4707_4708
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| The AWR extract dump file will be located
| in the following directory/file:
| /tmp/expdp <<<<目录
| awrdat_4707_4708.dmp <<<<文件名称
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| *** AWR Extract Started ...
|
| This operation will take a few moments. The
| progress of the AWR extract operation can be
| monitored in the following directory/file:
| /tmp/expdp
| awrdat_4707_4708.log
|

导入:
导入过程也类似