AWR快照数据迁移（Transporting Automatic Workload Repository Data）

concepts:

Oracle Database enables you to transport AWR data between systems. This is useful in cases where you want to use a separate system to perform analysis of the AWR data. To transport AWR data, you must first extract the AWR snapshot data from the database on the source system, then load the data into the database on the target system, as described in the following sections:

■ Extracting AWR Data

■ Loading AWR Data

methods:

Extracting AWR Data

运行脚本@$ORACLE_HOME/rdbms/admin/awrextr.sql，根据提示做相应操作

Loading AWR Data

运行脚本@$ORACLE_HOME/rdbms/admin/awrload.sql，根据提示做相应操作

导入完成后，查看dba_hist_snapshot查看导入的情况

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29802484/viewspace-2131451/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29802484/viewspace-2131451/