I am working on doing data refresh from our prod to uat on-premise instance which is on 188.8.131.52 and Oracle db. I could find a document Performing a Manual Data Refresh on Virtual Machine which is pretty old and is targeted for Postgres and jive version of 4 to 7. It would be very much helpful if anyone can share the process on how to do data refresh for jive 9 and oracle db.
We regularly (every 3-4 months) copy our production env down to Staging + Dev servers. We ask the dba's to copy all the d/b tables an omit a few, like jiveProperty which contain env specific config. As part of the process we set all the email addresses for users to an invalid address (to stop email notifications getting sent out from test envs).