Linking a PDB staging push dSource

You can perform the following steps to link a PDB dSource using the staging push mechanism.

1. Login to the Delphix Management application.

2. Go to Manage > Datasets.

3. Click the plus (+) icon and select Add dSource.

4. On the Preparation tab, click Next.

5. From the dSource Type tab, select the Oracle Staging Push as dSource type and click Next.

6. On the dSource Configuration step, provide the following dSource configurations:

   1. dSource Name - This name will be shown on the Delphix Engine interface.

   2. Target Group - Select a target group from the drop-down list.

   3. Database Type - Select the database type as PDB.

   4. Staging Environment - Select an environment from the drop-down list. The staging database will be hosted in this environment.

   5. Repository - Select a repository (Oracle installation) from the drop-down list.

   6. Container Database: Select the Staging Push Container database to which the PDB will be plugged.

   7. PDB Name:  Provide the PDB name for the staging PDB dSource.

      Info : Consider the following while providing the PDB name:

      • This should be the same as the source PDB's Name

      • PDB name is case-sensitive

      • You can run this query in the source database to get the PDB name: select name from v$pdbs;

   8. Custom Environment Variables - Configure the custom environment variables, similar to VDBs, if needed. 

   9. Optionally, you can configure Validate Snapshot by Opening Database in Read Only Mode, as per requirement. This indicates whether the staging database snapshot will be validated by opening the database in read-only mode.
      Info : The option is disabled by default.

   10. Click Next.

7. From the Staging Database Parameters tab, select a template and click Next.

8.  From the Policies tab, select any policy for the new dSource. SnapSync Policy is used as a default policy for taking snapshots. For more information on SnapSync policy, see Policies for Scheduled Jobs Click Next.

9. From the Hooks tab, enter any script that should be run before (pre-sync) or after (post-sync) the snapshot operation. 

10. From the Summary tab, review the Staging Push dSource configuration profile and click Submit. Upon submission, a new pluggable database will be created and plugged into the given Container Database on the staging host. The data files for this pluggable database are expected to be placed at the location: MOUNT_BASE/<PDB_Name>-<CDB_Unique_Name>/datafile. Once linking is done, you can see this Staging Push PDB dSource under the Datasets.