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
-- dake
Original text of this message
