Recuperating Lost Collab Documents

Seldom does everything work out fine in life. It might so happen that one fine day you wake up and you find that some how something screwed up and some of your collab projects have done a dissapearing act. And for some reasons which sometimes even the mighty Oracle analysts is not able to find, the documents in the collab projects have been lost. How to restore them back to the working environment?

Solution:

The deleted files can be restored back to the production environment by using the migration utility of Plumtree.

1. Restore the backup of the production portal and collab database for that particular date in the "Recovery" environment as well as also the "PTDR" folder. "PTDR" folder is actually the repository for all the collab documents.
2. Configure the Portal in the "Recovery" environment for the restored portal and the collab database.
3. Once steps 1 and 2 is completed, Test the portal to be functioning similar to the Production environment since all the related files and database have been restored.
4. Using the migration utility of the Plumtree portal, select the Projects which have lost their files and opt for the "export "option.
Once you initiate the migration utility, what it does is it creates an export file which can be imported to any other portal environment.
5. On successful execution of Step 4, Log into the migration utility of the Target (Production in this case) portal environment and select the "Import" option. That will import the collab project details back to the target environment.
6. As a crosscheck measure, log into the target portal and check the collab project for the lost files. If they are present then everything is in order. If not then need to proceed further to Step 7.
7. This step can be carried out after completion of step 1 and 2. Query the Collab database in these tables [CSFOLDERS][CSFILES][CSFILEHISTORY] to figure out the deleted files based on the inputs from the user/business as to what all files or projects have been affected.
On querying the tables, detailed information about the Projects and their corresponding documents can be obtained such as which is the Parent folder for the Project and also the different versions of the document.
8. Based on the information procured on step 7 with reference to the lost files, open windows explorer and access the "PTDR\ documents\PTCollab\Active" from the recovery environment and copy the

Note: People please do take full backups of "PTDR" folder (D:/Plumtree/ptdr) from the environment wherein the documents have been deleted along with a complete backup of the SQL database for the Collab server ("Collabdb" – from the source environment).