cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Can we recover data from Vaults without oracle dumps

VivekUchekar
2-Guest

Can we recover data from Vaults without oracle dumps

Hi All,

our windchill server was creashed,

at time we have one month old Oracle dumps, latest vaults,one mmonth old LDAP dumps with us.

we rstore system by using one month old data from dumps.

in this case our one month data is lose.

but same time we have all vaults data.

is there is any method to retrive the data from vaults?

Thanks and Regards,

Vivek Uchekar

2 REPLIES 2

Its difficult. But here is what you can try.

You should be able to get the last file that was checked in and intact in old oracle dump. Refer Application_data and fvitem table.

In fvitem you will have uniquesequencenumber convert that to hexa decimal and look for that file in the vault dir.

So after that timestamp whatever file that is available in you vault is the delta you lost.

Now, you have a smaller set of files from which you need to find out what exact file it is. Which is very difficult.

Try opening in Notepad or something and look for some signature. Suppose you think its a pdf file, just change that particular file to pdf extension and try to open it. If you can make any sense of it, you are lucky. But the history all those stuff is gone.

You need to rebuild everything manually again, but as long as you have the file, it might help a bit. But its manually time consuming work and not sure how for you can get the data integrity back.

Hope this helps. I guess your process to backup is fixed atleast now 🙂

Assuming you get your db up and running, this will help you find discrepancies. At wc shell: windchill wt.fv.tools.WContentVerify

Top Tags