Re: production archive

Maria L. Wilson wrote: > > Hi all > > 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? Yes, the entire instance must be at a consistent state, otherwise IDS gets very upset. If you want to restore a single dbspace, then it must be brought up to the same point in time as the other dbspaces. Otherwise, if you want a dbspace restored to a specific point in time, i.e.. just before the "delete", than all dbspaces must be restored to that same point in time, which means a cold restore of all dbspaces. You don't need logs in order to complete a cold restore by the way. > As far as production archive and restore procedures what do > most of you all out there use? Is ontape sufficient? OnTape is sufficient for most requirements, until you either want to make use of sophisticated tape devices or your level 2 archive take more than 12 hours. Then look at OnBar for archiving to such tape devices in parallel. > Do you also dbexport? The dbexport utility is mostly designed for data movement. Remember it only supports ASCII format which will be a lot slower than a binary archive. > What kind of cycle do you use? I use a car mostly...... oh I SEE.... :-) Now that depends. No one can predict the optimum archiving strategy for a site unseen. > 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. Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+