Automating Informix Database Environment Restore
Posted in 1999
Our IDS V7.3.TC3 NT4 (RAID5) environment is setup to perform a nightly level 0 Informix backup to a disk-file which is then saved to tape via 3rd party backup software. Transaction logs are continuously copied to tape throughout the day. I would like to create, and automate a procedure that daily restores the level 0 backup onto another inquiry-only server. By the way, replication has been ruled out as an option due to the negative aspects placed upon the production server. Some thoughts would be to first perform a manual initial Informix db environment load from the production server's level 0 backup on the inquiry-only server. From that point forward, I would want to automate a procedure to execute the same reload daily. This process might include copying the level 0 backup (currently 7+ GB) across the network to the inquiry-only server at night, and executing a scheduled UNIX-type of script (utilizing ONTAPE or ONBAR?). Is this possible to automate? If so, how? Any examples, or other ideas would be very helpful since I am relatively new to the Informix environment. I can be reached at jhimschoot@crowechizek.com. Thanks for your time.