I have taken a full database backup of a SD 5.1 install from one location and when I import to identical installation at another location the data is missing. All System administrative configurations are accessible (users, roles, etc...). No Workspaces are visible or accessible. The only difference is the oracle database name is orcl from backup location and sd at the restore location. Is there a environment variable that needs to be altered to point to the different oracle home location?
No backup and restore should work, it might be license related. Is the instant on license still in the database?
If so take the following steps;
1. stop SD with ovc -kill 2. go to C:\Program Files\Common Files\Hewlett-Packard\data and edit licfile.txt and remove the line with the instant on licenses. 3.Then go into the database as the sd db user and run command to clear rep_licenses. like 'delete from rep_licenses'. 4.Than start everything again.
HP Support If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
So if you are talking about an Oracle backup, can I ask a few questions
By export do you actually mean an Oracle export and import? or are you refering to something else?
If you mean Oracle exp/imp then what version DB are you using? When you did the export did you do via command line or GUI? What options did you use. Have you looked at the import log ( or export log ) to see if there are any error? Did you export/import with "rows=n"? That would cause you to loose all data.
If you did a database clone what kind of back did you do to clone?
In my experience its much easier to take a clone of the production database and drop it over another instance, this way you have an exact copy of the schema/indexes etc... Are your application tiers identical? are they at the same Service Pack level?
Have you pointed your application server to this new database name via the server settings editor?