Re: Backup: 3 hours & Restore: 10 hours????

Forte Agent wrote:
>
> I am not a RMAN expert, so here is a question.
>
> We have a database that takes about 3 hours to backup to tape device
> using RMAN. When we restore it, often times it takes more than 10
> hours, even though backup took only about 3 hours. I was told the
> reason is the fact that RMAN is restoring datafiles out of order that
> they were backed up. Therefore, tape device has to travel back and
> forth looking for files in tapes, taking up times much longer than it
> took to back them up. Is there some way to prevent it, somehow direct
> RMAN to restore files in order they were backed up, regardless what
> kind of database recovery you are performing? Thank you in advance.

A factor of 2 or 3 increase in time on a tape restore is pretty standard. I don't know RMAN well enough to know if you can direct the order in which the files are restore to speed up the process. However, you'll still be spending time mounting and umounting the various media, scanning to find the first block of the datafile in question, etc. All of this takes time.

Regards,
Sean Received on Tue Aug 27 2002 - 14:28:43 CDT