Re: Selective Restore w Online 5

Frank Dauns (dauns@andrews.edu) wrote: : When archiving with tbtape it seems you cannot restore a single table. : Is it really either restore the whole system or nothing??!??! : What do you do when midday some careless programmer drops a crucial : table and you need to get it back without loosing all the other work : that may have been done in other tables that day ? : Any suggestions or tips are appreciated. Frank, Welcome to Informix. The archive process is not designed (pre 6.0 anyway) to protect you on individual tables. It's a catastrophic recovery tool that, in combination with the OnLine logging tools, will allow you to bring your database back up to the point of your last crash. If this really happened, and if you were not making other backups with dbexport or the like to protect you in this instance, you would have to restore from your last archive and then apply all of your subsequent log tapes to the archive. What, you say? That would just restore you with the deleted table still gone? Here's where you would call Informix Support. They have a utility that would allow them to go into your log files, null out (or change to an innocuous command) the offending "drop table" statement, and continue with your application of logfiles. It's a real pain. If you can't wait for it to be fixed in 6.0, try a product called Intelligencia. It is a backup product that allows you to do fast row-level backups and restores for OnLIne. Intelligencia DCC/4GL 1256 Cabrillo Ave Suite 250 Torrance, Ca., 90501 310-320-4300 (office) 310-320-3579 (fax) : Thanks : -- : Frank Dauns Programmer/Support : dauns@andrews.edu Lake Michigan College Later, Joe -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) BancTec Service Corportation 214-450-9896 Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Sept '94 from Prentice Hall! (Informix Press, ISBN 0-13-124314-1) ===========================================================================