where db_name='abc'
and completion_time>=to_date('20081001','yyyymmdd')
and completion_time
rman catalog中看回以前某一天数据库的数据文件大小 (除temp)
-
kennyblues
2009-08-06 15:06:33 -
Oracle
- 原创
select sum(datafile_blocks*block_size)/1024/1024 from RC_BACKUP_DATAFILE
where db_name='abc'
and completion_time>=to_date('20081001','yyyymmdd')
and completion_time
where db_name='abc'
and completion_time>=to_date('20081001','yyyymmdd')
and completion_time