Restoring Projects from an Oracle Database Server

This section describes how to restore a project backed up on an Oracle database server.

For details, see this KB article.

To restore a project from an Oracle database server:

  1. Copy the backup file to the Oracle server machine.

  2. Using the SQL*Plus utility, log in to the Oracle server using the system account.

  3. Create a user for the ALM project. Make sure you create it with the same name as the project name (or the Oracle user name) when the project was exported.

    Use these SQL statements:

    CREATE USER [<project name>] IDENTIFIED BY tdtdtd DEFAULT TABLESPACE TD_data TEMPORARY TABLESPACE TD_TEMP;

    GRANT CONNECT,RESOURCE TO [<project name>];

  4. On the ALM installation DVD, locate the \Utilities\Databases\Scripts directory. Open the qc_project_db___oracle.sql file and follow the instructions.

  5. Using the command line, type imp to run the import utility.

  6. Follow the prompt, and log in to the Oracle server using the system account. Make sure you import all the dump files.

    After all tables have been successfully imported, a confirmation message displays.

  7. In Site Administration, restore the project. If you are restoring your project from a different directory, or if you renamed your schema, you must update the dbid.xml file accordingly. For details on restoring access to projects, see Restoring Access to Projects.

  8. If the backup was performed while the project was active, realign the project repository. For details, see Realigning Repositories.