Linking a CDB staging push dSource

You can perform the following steps to link a CDB 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 CDB.

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

   5. User - Select an environment user from the drop-down list.

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

   7. CDB name: Provide the Database Name for the staging CDB dSource.

   8. CDB unique name: Provide CDB unique name for the staging database. It can be different from the database unique name of the source CDB database.
      Info: Consider the following while providing the CDB name:

      • This is the name of the staging container database that is created on the staging host after linking. 

      • It should be the same as the source CDB's Database Name

      • It is case-sensitive

      • You can run either of the two queries on the source database to get the CDB database name:

        • show parameter db_name;

        • select name from v$database;

   9. SID - Provide the SID for the staging database.

   10. Mount base - Provide a mount path. This is the location on the staging host at which the Delphix Engine will mount its storage for the staging database. To know about the permissions that the mount path directory must have, see Additional Target/Staging Host Requirements section of this article.

   11. Custom environment variables - Configure the custom environment variables, similar to VDBs, if needed. 

   12. Optionally, you can configure Auto staging push restart, Configure staging database parameters, Physical standby, and Validate snapshot by opening Database in read only mode, as per requirement.

       1. Auto Staging Push Restart indicates whether this staging database should be automatically restarted when the staging host reboot is detected.

          1. For a non-standby database, only storage is mounted on the staging host.

          2. For a standby database, after mounting the storage the database is also started in MOUNT mode.

       2. Configure Staging Database Parameters to override Oracle database configuration parameters.

       3. Physical Standby indicates that the staging database will be configured as a physical standby.
          Info: The staging database is not configured as a Physical Standby by Delphix Engine. The setup should be done outside Delphix Engine before initiating the snapshot operation.

       4. Validate Snapshot by Opening Database in Read Only Mode indicates whether the staging database snapshot will be validated by opening the database in read-only mode.
          Info: All these options are disabled by default

   13. Click Next.

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

8. From the Data Management tab, select the LogSync checkbox to enable the logsync for Staging Push dSource. For more information on LogSync, see Staging Push LogSync, click Next.

9. 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.

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

11. From the Summary tab, review the Staging Push dSource configuration profile and click Submit.

When all the above steps are executed on the staging host, a new database is instantiated with the above provided Database Name, Database Unique Name, and SID, and the database files are expected to be placed at the location: MOUNT_BASE/<CDB_Unique_Name>/datafile. Once linking is done, you can see this Staging Push CDB dSource under the Datasets.