Recover deleted objects

Hi all,

Is there a way to recover deleted objects and contents from the documentum repository? Any handy DQL/APIs?

My clients have deleted couple of objects with contents that was checked in sometime back. I have tried

finding these deleted objects under dmr_content table but no luck. Following is the query i used.

select r_object_id,set_client,set_file,set_time,full_format,full_content_size,storage_id from dmr_content where any parent_id is null and set_time > DATE('15/07/2008') and set_time < DATE('16/07/2008') and full_format = <FILE_FORMAT> and set_client = <Client machine name> ;

Thanks

Zaid

Find more posts tagged with

Comments

Francois Dauberlieu

If you have the FileReport job running and none of the cleaning jobs running (dmClean and dmFileScan) then you could look into the the file report logs and find the content file (it is not deleted), however, the metadata is gone so you will have to import the content again and reset its properties

PS: Remove the DELETE right in the ACL's for this user.

msroth

As long as DmClean and DmFileScan have NOT run and actually deleted the objects, this DQL and API can be used to recover content.

This will retrieve all of the objects flagged for deletion

select * from dmr_content where any parent_id is NULL and content_size > 0 order by set_time

This will retrieve the content and save it to a new object. Unfortunately, the object_id is not reusable.

create,c,dm_document

set,c,l,a_content_type, <format from above query>

setfile,c,l,<path from above query>

set,c,l,object_name,<r_object_id from above query>

link,c,l,’/Temp’

save,c,l