Re: Readable: Logical logs not backed up

Barbara, Grant wrote: > > Sorry - forgot the hard returns > > > >We have an Informix Online 7.10 database with over 500GB of images. > The database activity is mainly selects, with relatively few inserts. Our ltapedev > is /dev/null - we do not back up the logical logs. The data is divided into 8GB > dbspaces and we write to 1 dbspace at a time. When that dbspace is full we > take onsite and offsite level 0 archives and move to the next dbspace. Our > dbspace archive collection spans a year, as we refresh dbspace backups > annually. Nightly we archive the rootdbs, the index dbspace and the active > data dbspace. > > > >We are trying to understand the restoration implications of this scenario and to > determine whether there is a practical alternative. Any suggestions/comments > appreciated. > > > > >Thanks, > >Barbara Grant > >bgrant@attcapital.com I assume that you're using onarchive to effect your back-ups? If so, the recovery implications seem clear. You can use your most recent "dbspace full" archive to recover each of the inactive dbspaces to their precise state, then your nightly archives to recover the active dbspaces to their state at the time of the last back-up. This seems obvious; am I missing something in your question? What is the thinking behind this unorthodox approach? What are the requirements that you are so satisfying? Neil Truby Chase Manhattan Bank Bournemouth, UK