Re: ?: Table Restore/Backup :?

In <1993May7.121212.23160@pyra.co.uk> graeme@pyra.co.uk (Graeme Sargent) writes: >In <1993May05.131535.949@sco.com> chrisw@sco.COM (Christopher J. Wood) writes: >>Is it possible to perform table backups/restores with >>Informix? >No. 6.0 is reputed to have dbspace level backup support. Hurrah! >>... would I have to restore the entire database to recover from one (1) >>disk going bad? >... A table does not normally reside on only >one disk. A disk does not normally contain only one table. Even if you >design *your* system that way, there is no way for OnLine to know that >you have done so. Even if it did, what would you rollforward from? Maybe I'm being simplistic, but wouldn't it make some sense to address this issue? Regardless of mirroring or raid5 type recovery ability, Informix still *ought* to provide a way to rebuild a table or all tables on a chunk that goes down. It sounds simple to me: Have informix keep track of which chunks a table is on (kept redundantly on different chunks); if a chunk is lost, it could report: you need to restore tables A, B, and C. Informix should then be able to restore from archives and logs such that all tables are brought forward as needed (i.e., ignore restoring tables that are already current). Ideally, it would be nice for informix to keep track of what *pages* are on what chunk, both in the archive and logs, so that a restore could put that chunk back together. So, where's the hole in this dike? -- Andrew Burt aburt@du.edu "But if he was dying he wouldn't bother to carve "Aaaaargh", he'd just say it."