抓取Oracle数据快照
进入到oracle安装目录下的admin(找到这个目录)
开启cmd
键入sqlplus system/mima@实例名
>@awrrpt.sql
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
输入 report_type 的值: --------------------html
Type Specified: html
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> without
specifying a number lists all completed snapshots.
输入 num_days 的值: 1 -------------------- 1
Listing the last day's Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
hurodb ORCL10G 142 03 7月 2009 08:11 1
143 03 7月 2009 09:00 1
144 03 7月 2009 10:00 1
145 03 7月 2009 11:00 1
146 03 7月 2009 12:01 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
输入 begin_snap 的值: 142
Begin Snapshot Id specified: 142
输入 end_snap 的值: 146
End Snapshot Id specified: 146
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_142_146.html. To use this name,
press <return> to continue, otherwise enter an alternative.
输入 report_name 的值: c:\test.html
Report written to c:\test.html
最新文章
- python基础之内置函数
- css3简单的图片轮播
- 【iOS】Quartz2D截屏
- hdu2594 KMP
- 房子里的K2 BPM业务流程管理
- chmod u+x ./j2sdk-1_4_2_04-linux-i586.bin的含义
- ASP.NET中的ViewState
- 关于Eclipse的工作空间设置默认个数和配置
- WCF配置文件详解 【转】
- Django架设blog步骤
- 支付宝“订单交易失败 ALI64” 报错的原因
- matlab 2014a 改为英文版本号
- ng-init小解
- log4go的精确定时程序(带自动延迟补偿)
- 基于jQuery 3D旋转明星人物展示特效
- vander范德蒙德行列式
- Python3正则表达式(2)
- Java 求两个数百分比%
- zabbix自定义触发器进行监控
- 16.linux常用查看命令