概述

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 <return> withoutspecifying a number lists all completed snapshots.Enter value for num_days: 2Listing the last 2 days of Completed SnapshotsSnapInstance DB Name Snap Id Snap Started Level------------ ------------ --------- ------------------ -----orcl ORCL 4759 29 Mar 2028 17:04 1現象：查看snapshot生成歷史，發現很長一段時間都沒有生成snapshot這是一個開發數據庫，經過和開發溝通，由于業務測試經常修改操作服務器系統時間。原因分析：由于修改操作系統時間，在修改成正確的時間后，snapshot 無法自動生成2. 解決辦法2.1 查看所有的snapshotSQL> select snap_id,dbid from dba_hist_snapshot order by 1;SNAP_ID DBID---------- ----------4752 13737680424753 13737680424754 13737680424755 13737680424756 13737680424757 13737680424758 13737680422.2 刪掉所有的已經存在的snapshotdbms_workload_repository.drop_snapshot_range(low_snap_id=>4752,high_snap_id=>4758,dbid=> 1373768042);2.3 手工創建新的snapshotexec dbms_workload_repository.create_snapshot();2.4 修改自動收集snapshot的周期測試收集間隔時間改為30 分鐘一次。并且保留5天時間exec dbms_workload_repository.modify_snapshot_settings(interval=>30, retention=>5*24*60);2.5 查看收集周期SQL> select * from dba_hist_wr_control;DBID SNAP_INTERVAL RETENTION TOPNSQL---------- --------------------------------------------------------------------------- --------------------------------------------------------------------------- ----------1373768042 +00000 00:30:00.0 +00008 00:00:00.0 DEFAULT2.6 查看新生成的snapshotSQL> select snap_id,dbid,BEGIN_INTERVAL_TIME from dba_hist_snapshot;SNAP_ID DBID BEGIN_INTERVAL_TIME---------- ---------- ---------------------------------------------------------------------------4759 1373768042 29-MAR-17 04.51.37.190 PM4760 1373768042 29-MAR-17 05.04.47.970 PM2.7 正常生成AWR報告SQL> @ $ORACLE_HOME/rdbms/admin/awrrpti.sqlSpecify the Report Type~~~~~~~~~~~~~~~~~~~~~~~Would you like an HTML report, or a plain text report?Enter 'html' for an HTML report, or 'text' for plain textDefaults to 'html'Enter value for report_type:Type Specified: htmlInstances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~DB Id Inst Num DB Name Instance Host------------ -------- ------------ ------------ ------------* 1373768042 1 ORCL orcl ceshiEnter value for dbid: 1373768042Using 1373768042 for database IdEnter value for inst_num: 1Using 1 for instance numberSpecify 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: 2

Listing the last 2 days of Completed Snapshots

Snap

Instance DB Name Snap Id Snap Started Level

---

orcl ORCL 4759 29 Mar 2017 17:04 1

4760 29 Mar 2017 17:13 1

Specify the Begin and End Snapshot Ids

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Enter value for begin_snap:

轉載于:https://www.cnblogs.com/xuchenliang/p/6994818.html

總結

以上是生活随笔為你收集整理的snapshot相关的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。