NOTE :This approach is useful only when dm_DMClean and dm_DMFilescan jobs are not run on the repository after the document is deleted.
1. Query the dmr_content table to find the details of the deleted file
SYNTAX :
select r_object_id from dmr_content where full_format='<deleted document format>’ and set_file like ‘<Deleted document name>’
Example :
select r_object_id from dmr_content where full_format=’msw8′ and set_file like ‘%RHH-PRC-0044%’
Result :
0600a85b800012eb
2. Next, get the path of the deleted document lying on the content server
SYNTAX :
API> apply,c,<r_object_id of deleted dmr_content object>,GET_PATH
<Returned result>
API> next,c,<Returned result>
<ok>
API> get,c,<Returned result>,result
<Path of file on Content Server>
Example :
API> apply,c,0600a85b800012eb,GET_PATH
…
q0
API> next,c,q0
…
OK
API> get,c,q0,result
…
J:\Data\Documentum\test_docbase\content_storage_01000a85b\800eb.doc
3. To restore the document, create a document object of the deleted type as below
SYNTAX :
CREATE “<deleted document object_type>” OBJECT
SET “object_name” = ‘<Name of deleted document>’
SETFILE ‘<Path of file on Content Server recovered in Step 2>’
with content_format = ‘<deleted document format>’
Example :
CREATE “custom_doc” OBJECT
SET “object_name” = ‘RHH-PRC-0043’,
SETFILE ‘J:\Data\Documentum\test_docbase\content_storage_01000a85b\800eb.doc’
with content_format = ‘msw8’
Result :
object_created
0900a85b800223ae <r_object_id of newly created document>
4. Link the newly created object to the deleted document as below
SYNTAX :
API> link,c,<r_object_id of newly created document returned in Step 3>,<temp location to recover the deleted document in docbase cabinets>
Example :
API> link,c,0900a85b800223ae,/Temp/Recovered
Result :
OK
5. Save the document
SYNTAX :
API> save,c,<r_object_id of newly created document returned in Step 3>
Example :
API> save,c,0900a85b800223ae
Result :
…
OK