Home -> Usenet -> comp.databases.oracle -> How to reduce downtime

How to reduce downtime

From: Eugene Krainov <dake_at_simcb.ru>
Date: 2 Jun 1998 18:30:54 +0400
Message-ID: <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 Tue Jun 02 1998 - 16:30:54 CEST












Original text of this message