Topic
  • No replies
pocoto
pocoto
1 Post

Pinned topic Recovering data via ARCHECKER

‏2013-12-05T08:51:27Z | archecker clob

Hi everyone in the forum ,

FOA our informix is the version 11.50 and let me put in situation i am facing: one of the colleagues working with the database deleted one register of a table without permission so ...  i have been asked to recover the data again.

At least we perform ontape of all system all days so i got one of the ontape copies, and all the info was recovered  except the clob data, i have not idea why or how to do it.

The command archecker -tdvs -f recover_data_clob

and the recover_data_clob is as follows 

database bdimages2;
create table observa 
  (
    relacion char(10),
    observaciones "informix".clob
  )in images2dbs 
  put observaciones in (sbimagen);     
create table "informix".salva_observa 
  (
    relacion char(10),
    observaciones "informix".clob
  )in images2dbs 
  put observaciones in (sbimagen); 
insert into salva_observa select observaciones from observa where relacion = 'BM095/2013';
RESTORE TO CURRENT WITH NO LOG; 

question is the archecker is being executed and do the process without problem but the clob are empty (NULL values) and no idea how to recover it cuz the info is there, (i have already tested recovering all the info with an ontape)

Thanks in advanced