查看rman备份数据文件量的sql,留此备忘。
[@more@]比较某2天的数据文件的备份量
select file#,recid,to_char(creation_time,'yyyymmdd hh24:mi:ss'),datafile_blocks,blocks,to_char(completion_time,'yyyymmdd hh24:mi:ss') from v$backup_datafile where trunc(completion_time)=to_date('20060126','yyyymmdd') or trunc(completion_time)=trunc(sysdate) order by file#,recid;
查看某天 数据文件总的备份量
select sum(blocks) from v$backup_datafile where trunc(completion_time)=to_date('20060126','yyyymmdd');
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19015/viewspace-890985/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19015/viewspace-890985/