在测试库上导入其他库的AWR 记录：
--AWR导出没有问题：
SQL> @ /rdbms/admin/awrextr.sql
--但是导入的时候，报错了：
SQL> @ /rdbms/admin/awrload.sql
~~~~~~~~~~
AWR LOAD
~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ This script will load the AWR data from a dump file. The ~
~ script will prompt users for the following information: ~
~ (1) name of directory object ~
~ (2) name of dump file ~
~ (3) staging schema name to load AWR data into ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name Directory Path
-------------------------------------------------------------------------------
BACKUP /u01/backup
DATA_PUMP_DIR /u01/app/oracle/11.2.0/db_1/rdbms/log/
ORACLE_OCM_CONFIG_DIR /u01/app/oracle/11.2.0/db_1/ccr/state
XMLDIR /u01/app/oracle/11.2.0/db_1/rdbms/xml
Choose a Directory Name from the list above(case-sensitive).
Enter value for directory_name: BACKUP
Using the dump directory: BACKUP
Specify the Name of the Dump File to Load
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please specify the prefix of the dump file(.dmp) to load:
Enter value for file_name: awrdat_160_192
Loading from the file name:awrdat_160_192.dmp
Staging Schema to Load AWR Snapshot Data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The next step is to create the stagingschema
where the AWR snapshot data will be loaded.
After loading the data into the stagingschema,
the data will be transferred into the AWRtables
in the SYS schema.
The default staging schema name isAWR_STAGE.
To use this name, press
an alternative.
Enter value for schema_name:
Using the staging schema name: AWR_STAGE
Choose the Default tablespace for the AWR_STAGEuser
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE users's defaulttablespace. This is the
tablespace in which the AWR data will bestaged.
TABLESPACE_NAME CONTENTS DEFAULT TABLESPACE
------------------------------ ---------------------------
DAVE PERMANENT
DAVE2 PERMANENT
DAVE3 PERMANENT
DAVE4 PERMANENT
SYSAUX PERMANENT *
USERS PERMANENT
Pressing
tablespace (identified by *) being used.
Enter value for default_tablespace:
Using tablespace SYSAUX as the defaulttablespace for the AWR_STAGE
Choose the Temporary tablespace for theAWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE user's temporarytablespace.
TABLESPACE_NAME CONTENTS DEFAULT TEMP TABLESPACE
------------------------------ --------------------------------
TEMP TEMPORARY *
Pressing
tablespace (identified by *) being used.
Enter value for temporary_tablespace:
Using tablespace TEMP as the temporarytablespace for AWR_STAGE
... Creating AWR_STAGE user
|
|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Loading the AWR data from the following
| directory/file:
| /u01/backup
| awrdat_160_192.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| *** AWR Load Started ...
|
| This operation will take a few moments. The
| progress of the AWR load operation can be
| monitored in the following directory/file:
| /u01/backup
| awrdat_160_192.log
|
Data Pump job startfailed
ORA-39002: invalidoperation
Exception encountered inAWR_LOAD
begin
*
ERROR at line 1:
OR