Re: How to hurt an Informix DB?
Wow, is there any comparable book out there now? I could really use that. Do you cover basic system backups too (eg. Solaris 2.6 on Sparc)? Please let me know if you are aware of any similar titles already published and also please send me an email regarding publishing date in case I miss an announcement from you on the newsgroup. Thanks a million. Kevin Carroll GTE Wireless Curtis Preston wrote: > I am writing a book called "Essential Backup & Recovery," and O'Reilly > and Associates is publishing it. > > I am now working on the Informix backup and recovery chapter. I have > administered Informix and done many backups and restores, but I would > like to here some data from around the world about what can happen > during an Informix restore. > > For example, I just finished doing the Oracle backup/restore chapter. > In an Oracle restore, there are a number of things that can go wrong > that require you do different things to fix them: > 1. Data file damaged > 2. Archived redolog damaged > 3. ONLINE redolog damaged (nasty) > 4. system datafile damaged > 5. Control file damaged > > SO, Informix folk, what can happen during an INFORMIX restore? (Or what > can happen to a running Informix database that would cause a restore?) > 1. Sysmaster dbspace blown away > 2. Logging device blown away > 3. ??? > > What kind of nasty things have happened to your Informix databases that > required a restore? I want to cover every scenario.
There have been several reports of serious bugs in the archive utility for Informix OnLine 5.x engines particularly on the SCO/Intel platform, even though this product has been in maintenance mode for several years. The last archive bug was reported only a few months ago -- problems just seem to continue to crop up. While it is an obvious point, you can't stress enough the need to keep your engine up-to-date with the latest maintenance release. I believe Informix has released no fewer than 10 maintenance upgrades for the 5.x engine on SCO. Kevin M. Carroll wrote: > > Wow, is there any comparable book out there now? I could really use that. Do > you cover basic system backups too (eg. Solaris 2.6 on Sparc)? Please let me > know if you are aware of any similar titles already published and also > please send me an email regarding publishing date in case I miss an > announcement from you on the newsgroup. Thanks a million. > > Kevin Carroll > GTE Wireless > > Curtis Preston wrote: > > > I am writing a book called "Essential Backup & Recovery," and O'Reilly > > and Associates is publishing it. > > > > I am now working on the Informix backup and recovery chapter. I have > > administered Informix and done many backups and restores, but I would > > like to here some data from around the world about what can happen > > during an Informix restore. > > > > For example, I just finished doing the Oracle backup/restore chapter. > > In an Oracle restore, there are a number of things that can go wrong > > that require you do different things to fix them: > > 1. Data file damaged > > 2. Archived redolog damaged > > 3. ONLINE redolog damaged (nasty) > > 4. system datafile damaged > > 5. Control file damaged > > > > SO, Informix folk, what can happen during an INFORMIX restore? (Or what > > can happen to a running Informix database that would cause a restore?) > > 1. Sysmaster dbspace blown away > > 2. Logging device blown away > > 3. ??? > > > > What kind of nasty things have happened to your Informix databases that > > required a restore? I want to cover every scenario.