Re: Backing up Informix

Paul Pathiakis <pathiaki@emc.com> wrote: >Hi, > I am not a database person by any means so excuse any >remarks I make that aren't well-informed. > I am looking at how to backup an Informix database. I >have issues with regards to how to roll in a transactions >log in the event of a DB crash. I'm sure (I hope) that you >can take the DB offline and perform a dump of the raw disks. >The problem I encounter is restoring this backup in the >event of disaster/failure and being able to take this restored >database state forward to where it crashed. Does anyone have >a procedure for rolling forward with the transaction log? > Thanks, > Paul >-- >Paul J. Pathiakis I took the road less travelled >pathiaki@emc.com and became totally lost! To backup informix you use and informix backup like ontape. To get and understanding of this you need to read the backup and archive manual and it explains how to do this. If you do take the database offline and dump the raw partitions you can not roll foward the logs. Informix does not work like oracle. Informix will also not insure data consistency if you do a backup this way. Informix builtin easy backup tool that can be ran online without any interuption in service to the user. Get the manuals and read about ontape. I would not tackle the onarchive feature if you are this new at Informix. Onarchive is not a user friendly utility at all. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com