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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- AWR: Automatic Workload Repository
- AWR(Automatic Workload Repository)
- Oracle AWR automatic workload repositoryOracle
- AWR(Automatic Workload Repository)——分析(4)!
- AWR(Automatic Workload Repository)——分析(3)!
- AWR(Automatic Workload Repository)——概述(1)!
- Oracle AWR(Automatic Workload Repository)使用Oracle
- Oracle AWR(Automatic Workload Repository) 說明Oracle
- Automatic Workload Repository (AWR)總結(1)
- Automatic Workload Repository (AWR)總結(2)
- Automatic Workload Repository (AWR)總結(3)
- Oracle AWR(Automatic Workload Repository)使用解析Oracle
- Oracle10g AWR (Automatic Workload Repository)Oracle
- 自動工作負載庫(Automatic Workload Repository,AWR)負載
- AWR(Automatic Workload Repository)——比較報告的生成(2)!
- Automatic Workload Repository ViewsView
- Oracle10g New Feature -- 10. AWR (Automatic Workload Repository)Oracle
- Automatic Manageability Features : Automatic Workload Repository (52)
- 自動工作負載庫理論與操作(Automatic Workload Repository,AWR)負載
- AWR (Automatic Workload Repository) - 不自動產生snapshot是怎麼回事
- Automatic Workload Repository Compare Period report
- DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE 手工清理awr
- iOS Core Data 資料遷移 指南iOS
- Elasticsearch 基於物件儲存使用快照資料遷移Elasticsearch物件
- 使用包DBMS_WORKLOAD_REPOSITORY修改AWR的預設設定
- 雲資料遷移(Cloud Data Migration,CDM)Cloud
- Core Data資料遷移及單元測試
- DBMS_WORKLOAD_REPOSITORY包
- oracle小知識點5--通過dbms_workload_repository.awr_report_html產生awr報告OracleHTML
- 遷移資料.
- Data Guard新特性:快照備用資料庫資料庫
- 【遷移】使用rman遷移資料庫資料庫
- Elasticsearch 叢集誇網路快照遷移Elasticsearch
- Automatic Diagnostic Repository (ADR)
- 【資料遷移】使用傳輸表空間遷移資料
- Kafka資料遷移Kafka
- 資料庫遷移資料庫
- redis資料遷移Redis