How do you copy a LARGE Oracle project in QC?

  • Questions
  • How do you copy a LARGE Oracle project in QC?
Question ID: 107487

We have a project in our QC instance that is well over 3Gb (Database + repository) and we want to create a copy in the same QC server/instance.

We have done this before with large projects and the "internal" copy process (create a new project by copying data from an existing project) takes a long time and makes the source project performance very slow (and sometimes the whole server).

We are using Oracle as the back-end, can we just "copy" the database and repository to get a copy of the project? How would/should we do that?

Marked as spam
Posted by (Questions: 93, Answers: 6)
Asked on March 3, 2017 4:20 am
Answers (1)
Private answer

1) backup Project DB/Schema/user (HP recommends EXP/Data ''dump'')

2) restore/copy in ORACLE to NEW/unique schema/user name (less than 30 characters), AND give exact same rights, password and settings

3) COPY project repository from source to NEW/Target location (under appropriate domain parent folder) in repository - name the copied repository folder uniquely to match (mostly) the implied project name in the new Schema/user name.

4) EDIT the copied project repository's DBID.XML file to indicate the NEW project name, DB-connection string, DB name (and Oracle instance if different), and Project directory.

5) IMPORTANT! -- DELETE the Project UID tag from the DBID.xml file (a new one will be created by QC on restore).

6) restore project from Site Admin into appropriate domain using DBID.xml file.

Marked as spam
Posted by (Questions: 3, Answers: 472)
Answered on March 3, 2017 4:22 am