Re: onarchive question

In article cqe@clarknet.clark.net, miriam@clark.net (satori..MSLO) writes: > 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 > Here's a stab... I haven't used the product in production yet, but I did just come back from training... Did you back up your logs, including your current log in use? And then, did you restore those logs? When you created your vset for the archive, did you include the rootdbs in your dbspaceset? I don't recommend creating things in the rootdbs. While in class I perfored an archive, created a table in a dbspace outside rootdbs, performed an archive on this dbspace, and performed a warm restore on that dbspace. I didn't have any problem getting this table back. good luck. -Debbie Shelton DBA McCaw Cellular Communications, Inc. debbie.shelton@mccaw.com