Tam O'Shanter said:
> Hello All,
> We are encountering a situation where backups of our database take far to
> long to complete (IMHO).
>
> Upwards of two hours to tape with a two hour restore time.

How big is it? (Your database, I mean!)

I have a client who backs up 110GB onto DLT in 20 minutes.

> This is fine from a protection standpoint as it is the most complete
> option,
> however, I'm looking for something that would give us more agility.
> For example, during a recent outage caused by running out of data pages on
> one particular table one of our options was to restore from tape, at a
> cost
> of two hours.
>
> Optimally, I would have liked to have been able to restore simply the data
> in the offending table to another disk/space etc without performing a full
> restore from tape.

You should attend one of the many IIUG sessions on this topic. ;o)

> What option would give me this flexibility (hardware independent)?
> I say hardware independent because I was recently in a data center with
> new
> Net App gear capable (unbelievable as it sounds..) of fully restoring a
> 1TB
> Oracle instance in approximately 10 seconds ("flashing" a snapshot if you
> will...).

Have you considered something like an IBM ESS array which will allow you
to fully restore a 1TB IDS instance in approximately 10 seconds? ?

> Thoughts?

onbar will allow parallel backups to improve speed of backup and restore,
but there are all sorts of consequences of this. What mechanism are you
using? What kind of tape are you backing up to? What block size are you
using?

--
Bye now,
Obnoxio

"... no bill is required as no value was provided."
-- Christine Normile

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.