If you are on Oracle, you can export from Oracle using parity files (par files) to tell oracle what you want to export..
Export all structures first, of the entire database. Then use these par files to limit the export of data to only meta data and configuration data. Import the structures first by creating and specifying import parameters in these par files, and then import the data again by creating and importing the exported data.. I have attempted this before and it works like a charm.. even cuts down the whole export and import time from a few hours to a few minutes.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Shyam Attavar Sent: Thursday, March 04, 2010 5:00 PM To: [email protected] Subject: Refreshing the DB for ITSM 7.1.0 ** Dear Listers, I have a need to refresh the production database back onto a test environment we are building. Since there have been quite a few customizations, we would like to get to a point where we can start leveraging the Test environment without having to individually migrate the customizations over. If refreshing the DB from production environment is considered risky due to the various notifications, escalations and approvals that might be pending, we can even refresh from our development server. Here's the environment: ITSM 7.1.0 (except SRM) ARS 7.1.0 Patch 6 running in a server group with four nodes on RHEL Oracle 10gR3 RAC running on RHEL Has anyone attempted something like this and has been comfortable with the refresh process. I have done this in the past on ITSM 6.x running on Oracle. I do realize exporting the ARADMIN schema from one instance and importing into another instance would get me started. However, I am more concerned with the data driven nature of ITSM 7.1.0 and there is more to the refresh process than meets the eye. I have never attempted this on ITSM 7.1.0 - hence my concern and posting to the list. Any words of advice, things "to do", things "not to do", things to "watch out for", or not do this at all. Any feedback is welcome. Thanks in advance, -- Shyam _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
