RE: Restore a table
The purpose of an Archive is to restore if there is a catastrophe. There are limitations and they are for consistency purposes - Informix SMI tables contain current chunk information. Each DBA needs to manage their own system within the constraints (and limitations) of the organisation. If you want to get back to a point in time, then you can start an Archive at that time and use it to restore if necessary. From your description it sounds like you should have another server on which you can restore to a point in time, unload the required data, then load it into your Live system. If you dont run into another server, then you are up to stop processing perform an archive restore from where you want your data unload your tables restore the archive just performed load the data continue processing Your choice! MW -----Original Message----- From: Carlos Kobashikawa C. [mailto:ckobashi@luzdelsur.com.pe] Sent: Friday, December 08, 2000 11:37 AM To: 'murray@quanta.co.nz'; informix-list@iiug.org Subject: RE: Restore a table Ok. Let's say, I need to restore some tables from historical tapes in order to feed my DWH. These tables are in specific dbspaces, so I think I wouldnt have to restore the full instance. But, as I dont store logical log backup tapes older than 8 days; do I have to restore the full instance? > -----Mensaje original----- > De: Murray Wood [SMTP:murray@quanta.co.nz] > Enviado el: Mi'rcoles 6 de Diciembre de 2000 09:28 PM > Para: informix-list@iiug.org > Asunto: RE: Restore a table > > If you dont backup logs you can never restore anything other than the full > instance. Any other situation would make the dbspace inconsistent with > the > informix in rootdbs and the SMI tables. > > MW > > -----Original Message----- > From: owner-informix-list@iiug.iiug.org > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Carlos > Kobashikawa C. > Sent: Thursday, December 07, 2000 1:57 PM > To: informix-list@iiug.org > Subject: RE: Restore a table > > > > eonder@my-deja.com wrote: > > > >>> I need to restore only a table from an archive; how can I do > this ? > > >It is possible only if this table is created in it's own dbspace. > >So, You can restore this particular dbspace. > > But, if I didnt have logical logs backup tapes (I only store level 0 > tapes), I couldnt restore only a particular dbspace. > Another way?