![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
RMAN备份信息查询脚本
WarriorTan
这个作者很懒,什么都没留下…
展开
-
查看每天RMAN备份大小
通过动态性能视图v$backup_set_details或v$backup_piece都可以查询RMAN每天的备份大小信息:查询v$backup_set_detailsselect to_char(start_time,'yyyy-mm-dd') start_time,to_char(start_time,'day') day, round(sum(OUTPUT_原创 2016-05-19 14:04:02 · 3675 阅读 · 0 评论 -
RMAN备份进度查询
查看已经完成和未完成的RMAN备份进度set line 9999col opname for a35col start_time for a19SELECT SID, SERIAL#,opname, to_char(start_time,'yyyy-mm-dd HH24:MI:SS') start_time, SOFAR, TOTALWORK,ROUND(SOFAR/TOTALWORK*1原创 2016-05-07 22:19:04 · 5502 阅读 · 2 评论 -
RMAN备份FORMAT参数说明
SyntaxformatSpec::=Description of the illustration formatspec.gifSemanticsformatSpecThe following table lists RMAN substitution variables that are valid in format strings.原创 2016-05-13 15:48:19 · 571 阅读 · 0 评论