Mike,
I will be interested if you can provide us with this info please ...
- effective bytes per second from v$backup_async_io for sbt_tape and
type of D or L.
- Your RMAN configuration and script.
- Output of code below to show your transfer rates from RMAN. Show us
the mb_sec column please.
select
bs.completion_time,bs.set_stamp,bs.set_count,bs.backup_type,bs.incremental_level,bs.elapsed_seconds,round((sum(bd.blocks*bd.block_size)/1048576)/bs.elapsed_seconds,2)
mb_sec,count(bd.file#),bd.pieces
,round(sum((bd.datafile_blocks*bd.block_size))/1048576,2)
db_size_mb,round(sum((bd.blocks*bd.block_size))/1048576,2) Rman_size_mb
from
rc_backup_set bs,
rc_backup_datafile bd
where
bs.set_stamp = bd.set_stamp
and bs.set_count = bd.set_count
and bs.db_id=4269907151
group by
bs.completion_time,bs.set_stamp,bs.set_count,bd.pieces,bs.elapsed_seconds,bs.backup_type,bs.incremental_level
ORDER By bs.completion_time ;
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 13 2007 - 10:57:11 CST
