Re: Emergemcy Chunks Offline - tbzero utility
Well said Kathy. We all want to point fingers for things we do not take the time or effort to plan for or do. As DBA's it is our responsibilty to list the reasons for management to purchase items like disk arrays so you can mirror a database, extra tape units to keep the logs backuped, reduntant CPU's, etc, to guard against various problems. Regards, On Sep 27, 9:08am, Cathy Kipp wrote: } Subject: Re: Emergemcy Chunks Offline - tbzero utility } Bill Jaeger writes: } -> ... } ->Instead of being able to mark up the chunk and make it available in a matter of } ->minutes, the system had to be down for a day to restore everything from } ->backups. } } And I'm sure your organization learned something from being down for a day. } Either they can re-visit their dial-in policy, or they can expect to be } down for a day when there are severe problems.... Or they can invest money } in those fancy multi-processing machines and versions of OnLine which allow } for (from what I hear) nifty and speedy parallel restore and get back OnLine } faster when they are down. } } No matter how many caveats and how much training is out there, Informix will } be blamed if tbzero is released and then used improperly. (Look at the number } of people who don't even do proper backups - something supposedly elementary!) } Sometimes the only appropriate fix is going to be restore from backup and if } someone runs tbzero and ends up with a corrupt database and then gripes about } it, who do you think is going to get the bad press coverage and the lawsuits? } } Regards, } } - Cathy } } -------------------------------------------------------------------------------- } Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (970) 491-1294 } Colorado State University Veterinary Teaching Hospital Fax: (970) 491-1205 }-- End of excerpt from Cathy Kipp -- Have A Wonderful Day!!! Michael N. Vaughan | Electronic: mvaughan@pamd.cig.mot.com MOTOROLA | Voice: (708) 435-7298 One Continental Towers (IL-35) | Fax: (708) 435-7367 1701 Golf Road, 8th Floor | Page: 800 SKY-PAGE Pin - 8624717 Rolling Meadows, IL, USA 60008 |