Re: onarchive question

satori..MSLO (miriam@clark.net) wrote: : hello out there in happt informix land : What is going on here!!!?? : I'm trying to run onarchive.. here is what i do... : first off here are the specs.. : we are using a sun/sparc 1000 runing informix online 6.0 : we have i-dba,viewpoint and 4gl loaded on a vew 486 pcs : here is what i'm trying to do : 1) I created a database with two tables using i-dba fromoneo fhte clinet : pc's. : 2) I went into ONARCHIVE on the server and ran a standared archvie : command for a dbset to disk(we don't have the tape drive configured yet) : 2.a) The table I created is in rootdbs : 3) I went in through dbaccess and deleted one of the tables in the : small test database. : 4) I ran a retreieve using ondatartr (retrieving from disk ofcourse) : 5) I see NO RESTORE!! the table i delted is stil not there.. : i t hen went in and chaged t he remaing talbe..and did retrieve again : STILL NOTING : HELP HELP!! : please excuse the caps..but hey... i'm pullingout my hair here.. : #:-) : "she's a child of the wild blue younder...flying outa here" Just a guess: Maybe you're doing a "warm restore", which does the following: 1. Restore the Archive from Disk (your tables are in the DB now). This is called "physical restore". 2. Rollforward the databases (i.e. repeating all committet transactions since the last archive, rolling back open transactions). This is called "logical restore" - and your tables are gone again. A possible solution is: doing a "cold restore" (the server has to be down). You cant't do that with onarchive (since onarchive needs the server to run), try ondatartr. Be careful: a cold restore cannot be limited to selected dbspaces, only the full system can be restored. Hope this helps, Peter