定时导出awr元数据脚本

-- crontab -l | grep databak/spool
10 22 */8 * * /databak/spool/awr.sh

-- awr.sh

source /home/oracle/.bash_profile

sqlplus / as sysdba << EOF

define dbid = '';
define num_days = '';
define begin_snap = 0;
define end_snap   = 1;
define directory_name = 'AWR_1';
define file_name      = '';

col v_filename new_value v_filename noprint
select '/databak/spool/'||to_char(sysdate,'yyyymmddhh24:mi')||'.log' v_filename from dual;
spool &v_filename
col min_snap new_value begin_snap
col max_snap new_value end_snap  
select dbid,
       max(snap_id) max_snap,
       min(snap_id) min_snap
  from dba_hist_snapshot
where begin_interval_time >= sysdate - 8
group by dbid;

spool off

@?/rdbms/admin/awrextr

exit;
EOF

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

转载于:http://blog.itpub.net/29843794/viewspace-1291613/