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博客 ” ，链接：https://blog.itpub.net/29802484/viewspace-2131451/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
安装Mongo（社区版）
下一篇：
AWR导出过程中报ORA-04063
请登录后发表评论
登录
全部评论
