Go to Mydas1 and download the desired backup file from Data Pump director Mydas1:/home/oracle/sb file will be named as starhub-yyyymmddHH.zip, verify if downloaded file size match the file in in server

Go to Mydas-Lab and upload your downloaded file to Mydaslab:/home/oracle/sb

Unzip the file and the result is 2 files (starhub- yyyymmddHH.dmp and starhubLOG- yyyymmddHH.log)

1. Log in to Mydaslab server under starhublab user and shutdown the application using (tomcatvctl stop) command.

Check if there are any running processes by typing (jps) command, if you see a bootstrap process then wait until the process is dead otherwise kill it manually using kill command and process ID for example for the below bootstrap use (kill 23043)

Running process

Dead process

2. Log in to Database using SQLPLUS or SQL Developer and delete user (STARHUB) but please do not delete (STARHUB_G).

If using SQLPLUS then log in using oracle user in mydaslab server then type:

sqlplus system/cataneo01

DROP USER STARHUB CASCADE;

Commit;

After that you can exit and log off sqlplus

3. Log in to Mydaslab server using oracle user and go to /home/oracle/sb directory (where you uploaded the backup files earlier).

4. Make sure the uploaded files are owned by oracle user and oracle group.

5. Then run the following command to import the data pump file (impdp / directory=sb schemas=starhub dumpfile=starhub-yyyymmddHH.dmp logfile=starhubLOG- yyyymmddHH.log).

• Oracle will ask for username/password which will be (system/cataneo01)
• Wait until import is completed and check if there are any errors after the import is completed.

Log to oracle using SQL Developer or SQLPLUS and reset the password of starhub DB user to (starhub) and try to access the newly imported schema (starhub/starhub)

If using SQLPLUS then log in using oracle user in mydaslab server then type:

sqlplus system/cataneo01

ALTER USER STARHUB IDENTIFIED BY starhub ACCOUNT UNLOCK;

Commit;

Oracle will show you if the files are altered or not.

Log in to Mydaslab using (starhublab) user and run (update-build -m) command, this command will apply mydas scripts to the DB schema to match the requirements of the release to the newly imported dump. This should take some time then it will show a message (Build Successful) or (Build failed) in case of failure please contact Cataneo support team.

After liquibase ran successfully run (tomcatvctl start) and wait until you see (Tomcat Started)

Then run the (jps) command and it should show you a running bootstrap like below.

Log in to Mydas-lab then in the UI Navigate to email settings (right click and delete) the available settings to avoid unnecessary emails sent.