Re: How to reduce downtime

Must of the companies I have been in do a full backup once a week and incrementals nightly. They also use a three week rotation of tapes.

Wade Beasley
ext9jxb_at_air.ups.com

Eugene Krainov <dake_at_simcb.ru> wrote in article <211685506_at_gate.simcb.ru>...
>
> I have an Oracle server 7.3.5.1 running a number of
> instances on HP 9000 server here. Total database volume is about 8GB.
> I'm doing full backup once a month because of lack of space.
> Yesterday a developer made a typo that conducted a cascade deletion
> of business data. So, managers wanted me to restore database
> state on a two hours ago. I had to restore the full backup and
> then roll forward all transactions for about a month. It took
> some time of course. In case of rollback or single tablespace
> failure the recovery time is not so long and most job can be done
> online. So can anyone advice a good backup strategy to reduce
> down time in case of human error?
>
> --
> dake
>
Received on Fri Jun 12 1998 - 16:46:21 CEST