Restoring RefDb from another environment

When restoring the RefDb from another environment please ensure the following:

1. The data in DATABASECHANGELOG and DATABASECHANGELOGLOCK tables must be copied from the source database to the target RefDb.

   1. For multi-schema projects, the schema for these tables can be found by checking the datical.project file for the trackingSchema attribute on row 2.

      1. 

   2. For single schema projects the tables will be present in the managed schema.

2. In the event of server outage or unexpected shutdown which requires a restore of the RefDb, check that no orphan datapump jobs remain on the server.

   1. https://www.oracle-scripts.net/cleanup-orphaned-datapump-jobs

   2. Orphan jobs may result in the following error during the restore operation of a Packager job:

      1. ORA-06512: at "SYS.DBMS_DATAPUMP", line 7143
         ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
         ORA-06512: at "SYS.DBMS_DATAPUMP", line 4932
         ORA-06512: at "SYS.DBMS_DATAPUMP", line 7137