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.

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.

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...).

Thoughts?


Thanks.

Tam.