Re: Backup Strategy

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