Are your 7.1 backups/restores ok?
Posted in 1995
Topics: Backup & Restore, Storage & Space Management, Cloud, Docker & Containers
Hello,
I'm desperately trying to use onarchive/ontape on informix online 7.1
but both utilities seem to have serious problems. In the beginning
onarchive seemed to be the ideal utility but somehow the requests
were never executed by onautovop for automatic backups scheduling...
Informix support themselves admitted that onarchive has serious flaws.
So I turned to ontape which seems to do the backups fine until the
point where I actually had to restore something. Ontape took the
ridiculous amount of 8 hours to restore a 1.5 Gb dbspace! That essentially
means that restoring a 100Gb database would send the whole derivatives
trading floor home for a few days! This is unacceptable!
I noticed that informix would only read from tape (exabyte) once every
7-10 secs so I also considered shutting down informix to speedup the
processing of dbspaces...well, can't be done as the manual says, you
need informix up if you want to restore individual dbspaces.
I'd apreciate it if you can tell me how you do backups with informix
online 7.1 & if you're happy with your current strategy. At this
point I'm even thinking of offloading tables and compressing them
if all else fails....
Thank you very much,
Petros
--
Petros Michalis // email:
Derivative Products Group \\\\ // michalis@dpg.rnb.com
Republic National Bank of New York \\X/ michalis@panix.com