We use a third party utility called RoadRunner/UX to back up our entire
system to DDS. I believe this tool gives greater flexibility than the
standard UNIX programs. There may be a similar tool for whatever platform
you're on (we're on HPUX).
Whatever you use there will probably be a trade off between speed of
backup/restore and the amount of data you can cram on your DDS, i.e.
compression slows you up but gets more on one DDS. Compression can be done
at hardware or software level - might be worth asking a few questions about
your DDS drive.
I'm no expert on this stuff but our operations dept. backup all our systems
every night to DDS, scheduled automatically, and they can always get my
database files back when I need them.
As a DBA what you can do to give yourself an extra level of security is to
keep more than one backup cycle's worth of archive log files on the system.
That way you can go back to the previous dump and roll forward if a restore
fails.
--
Steve_Markham_at_amersham.co.uk
DB Technical Analyst,
Amersham International PLC
JP Soria <jpsoria_at_saxe.com> wrote in article <32E78ADA.4752_at_saxe.com>...
> I am attempting to come up with a solution for backup/recovery.(duh!)
> Wondering if anyone has had experience with Cold backups using dd? Can
> I write more than one disk to a tape?
> --
>
> JP Soria
> Oracle7 DBA/Software Tester
> Email: jpsoria_at_saxe.com
> "Failing to plan = planning to fail"
>
Received on Thu Jan 30 1997 - 00:00:00 CST
