Best way to backup Oracle QC project Schemas/DB’s?

  • Questions
  • Best way to backup Oracle QC project Schemas/DB's?
Question ID: 105553

We have our ALM/QC running with Oracle.
What is the best/recommended way to backup our Oracle Project Schemas?

Our DBAs want to use something called "Data Pump", is that OK?

Marked as spam
Posted by (Questions: 98, Answers: 7)
Asked on July 31, 2014 4:01 pm
Answers (2)
Private answer

For some reason Oracle DBAs really like ''Data Pump'', but it is known to **corrupt** the QC Project (and qcsiteadmin_db) Schemas.

So, it is instead recommended to use the Oracle ''original export'' command ''exp'' to generate a backup of a specific Schema.

Later, if you need to restore, let's say to a different Oracle instance, you would need to use the corresponding ''Imp'' command to import the data -- but, you must create an oracle ''Schema-user'' with the same name as the schema and apply the same privileges to them as in the starting instance (Oracle Privs for the ''schema-user'' can be found in the Install Guide). It is also assumed that you have the same named tablespace defined for the schema to be imported to.

If you are doing backups, don't forget to also backup your project's corresponding repository from the QC server.

Marked as spam
Posted by (Questions: 4, Answers: 496)
Answered on July 31, 2014 4:10 pm
Private answer

We are in the phase of upgrading from HP ALM 11 to HP ALM 12.20, where we have successfully installed and upgraded few projects in TEST Env. But we are facing some issues like ''Failed to Restore project - Unable to load data from Extensions'' table, where we have Extensions table in both source and destination oracle instalce with same data.

We have followed EXP and IMP process while backup and restore of oracle user-schemas.

please suggest us the right solution on how to resolve the issue. As I say we upgraded few projects successfully from Prod to TEST and most of them failed at restore at site administration page it self.

Jayaprakash S

Marked as spam
Posted by (Questions: 0, Answers: 2)
Answered on August 3, 2015 7:10 am