Re: Allocate Channel ... Rate Not Working

On Tue, Jul 8, 2008 at 2:06 PM, Sam Bootsma <sbootsma_at_georgebrown.ca> wrote:

> $ cat dup_disk.rcv
>
> spool log to '../logs/dup_disk.log';
>
> run {
>
> set until time "2008-06-25 7:00:00";
>
> allocate auxiliary channel ch1 type DISK rate 512K;
>
> allocate auxiliary channel ch2 type DISK rate 512K;
> ...
>
> I was expecting this to duplicate my database at rate of 1 MB per second.
> But, the job had to be killed because it was killing performance. After
> about 50 minutes it had restored 47.68 GB worth of data files. When I did
> calculations, this came to 16.19 MB per seconds!!!
>
> Can anybody tell me why? Am I doing something wrong?
>
>
>

RATE does not work on disk devices, only on SBT devices.

You can use the SET LIMIT commands. These were introduced in 8i. They are not documented, but still work in 10g.

From my notes:

   ML notes 271979.1 and 342301.1
   specify number as MB P/S to read
   RMAN> set limit channel t1 readrate 2

And in another location the documentation said:
>
> depracated
>
> in release old syntax preferred
> current syntax
>
> 9.0.1 ALLOCATE CHANNEL ... READRATE CONFIGURE CHANNEL ... RATE
>
> RATE does not work at all in 9i. Never did, never will.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l