Tam O'Shanter wrote:
> 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.

VERSION INFO IS SOOOOO HELPFUL!

If you are running a later release of IDS 9.40 or and IDS 10.00 release the
include archecker utility is capable of extracting a single table's data and
restoring it using SQL commands so that it can be filtered and restored to a
temporary tablename on the same or a different server.

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

Art S. Kagel