Re: production archive

Mark D. Stock wrote: >Maria L. Wilson wrote: >> I am currently preparing a Solaris 2.6 / Informix DS 7.23.UC4 >> machine for production with respect to archive and restore procedures. >> I am >> currently using ontape ( to a tape drive) to do this with....my only >> "beef" is the fact that I need logical logs to do a warm restore. (Or >> cold ). What if a user *accidently* deletes a database and frantically >> wants it back? In doing a warm restore of the space, it will recover >> just fine until you apply the logs that contain the "delete" transaction >> which will just remove it. Any ideas? >> I'd like to use onbar except I don't have a storage manager on >> this machine. > >You could get 7.30 which I believe includes ISM. 7.30 will take care of the storage manager problem (it includes one) and onbar lets you restore to a point in time, so upgrading is really the best solution here. Technically, using a cold restore you could perform a logical recovery but not apply the last tape's worth of logical logs (you can stop the logical recovery at any particular log *tape*, but that will likely contain log files that you'd want to restore.) -- Dave Kosenko davek@summitdata.com Director of Training Services (732) 469-4070 Summit Data Group (an Informix Authorized Education Center)