Configuring a standby PDB in mount mode

This procedure is optional and only applies if SCM is disabled. 

To configure a standby PDB in the mount mode, you must also provide a non-SYS user for both the CDB and the PDB. The PDB non-SYS user can only be added via the CLI. You must perform a fresh SnapSync after adding the non-SYS user. 

Prerequisite 

In order for Delphix Engine to connect, you must configure a static listener configuration for the PDB. You can configure a static listener by adding a configuration into listener.ora and restarting the listener. 

SID_LIST_LISTENER= 
(SID_DESC= 
(GLOBAL_DBNAME=CDOMLOSR4F71PDB1) 
(SID_NAME=stby18c) 
(ORACLE_HOME=/u01/app/oracle/product/18.0.0.0/dbhome_1) 
) 
) 

In the above example configuration, GLOBAL_DBNAME is the PDB name and SID_NAME is the SID of the CDB. 

Procedure 

Run the following commands to configure a PDB and CDB in the mount mode. 

1. Update PDB non-SYS user. 

   CODE

   # Update PDB nonsys user 
   delphix> /sourceconfig 
   delphix sourceconfig> select RH74PDB04 
   delphix sourceconfig 'RH74PDB04'> update 
   delphix sourceconfig 'RH74PDB04' update *> set nonSysUser=delphix 
   delphix sourceconfig 'RH74PDB04' update *> set nonSysCredentials.type=PasswordCredential 
   delphix sourceconfig 'RH74PDB04' update *> set nonSysCredentials.password=delphix 
   delphix sourceconfig 'RH74PDB04' update *> commit;

2. Update CDB non-SYS user. 

   CODE

   # Update CDB nonsys user 
   delphix> /sourceconfig 
   delphix sourceconfig> select rh74cdb2 
   delphix sourceconfig 'rh74cdb2'> update 
   delphix sourceconfig 'rh74cdb2' update *> set nonSysUser=delphix 
   delphix sourceconfig 'rh74cdb2' update *> set nonSysCredentials.type=PasswordCredential 
   delphix sourceconfig 'rh74cdb2' update *> set nonSysCredentials.password=delphix 
   delphix sourceconfig 'rh74cdb2' update *> commit; 
   delphix sourceconfig 'rh74cdb2'>

3. Perform sync of the PDB. 

   CODE

   # Perform sync of PDB 
   delphix> /database 
   delphix database> select RH74PDB04 
   delphix database 'RH74PDB04'> sync 

Setting the Non-Sys User on the Oracle dSource 

1. Create the delphix_db user in the primary database. 

2. Log into the Delphix Management application. 

3. From the Manage menu, select Datasets. 

4. From the Configuration tab select the Oracle dSource for which you want to add a non-SYS user. 

5. Click the dSource's icon to open the dSource information pane. 

6. Click the Edit button next to Non-SYS User. 

7. Enter a non-SYS user and credentials that exist on the standby. 

8. Click the Accept button to save this user and associated credentials. 

The non-SYS user will be used to connect to all VDBs provisioned from snapshots of this dSource that are created after the non-Sys user has been set.

PreLogSync Hook 

If the datafiles in the snapshot are inconsistent, latest archive logs are needed to recover them during provisioning. The logs are fetched by the LogSync operation which immediately follows the SnapSync operation. Since Standby Redo Logs (SRL) are not processed by LogSync operation, until the existing SRL at the time of the SnapSync operation is archived, the snapshot is not marked as provisionable. 
A PreLogSync hook can be used to archive the redo log file in the primary database which will archive the SRL on the standby database. The PreLogSync hook runs after the SnapSync operation but before the LogSync operation.

Updating repository for applied patches with the command line interface 

1. Select the repository of the database 

   CODE

   delphix> repository select '/opt/app/oracle/product/11.2.0.2/db_1'

2. Execute the updatecommand. 

   CODE

   delphix repository ''/opt/app/oracle/product/11.2.0.2/db_1''> update

3. Set appliedPatches to list current patches applied to the repository. 

   CODE

   delphix repository ''/opt/app/oracle/product/11.2.0.2/db_1''update *> set appliedPatches=13075226

4. Commit the operation. 

   CODE

   delphix repository ''/opt/app/oracle/product/11.2.0.2/db_1''update *> commit 

Setting the Non-Sys User with the Command Line Interface 

1. Select the source configof the mounted standby. 

   CODE

   delphix> sourceconfig select pomme 

2. Execute the updatecommand. 

   CODE

   delphix sourceconfig "pomme"> update

3. Set the nonSysUser and nonSysCredentialsto a non-SYS user that exists on standby. 

   CODE

   delphix sourceconfig "pomme" update *> set nonSysUser=<non-sys-username> 
   delphix sourceconfig "pomme" update *> set nonSysCredentials.type=PasswordCredential 
   delphix sourceconfig "pomme" update *> set nonSysCredentials.password=<non-sys-password> 

4. Commit the operation. 

   CODE

   delphix sourceconfig "pomme" update *> commit