CLI cookbook: attaching or detaching a PDB

PDB CLI attach

1. Ensure the new source environment has been fully discovered by the Delphix Engine, including CDB discovery.

2. Login to the engine via SSH with a Delphix admin account.

3. Select the PDB dSource database to be attached.

   CODE

   dvde.dcenter> database
   dvde.dcenter database> select "R268PDB1"
   dvde.dcenter database 'R268PDB1'>

4. Attach the PDB dSource to the correct source PDB in the new environment using the attachSource command; you will need to specify the environment user and login credentials for the PDBdSource.

   CODE

   dvde.dcenter database 'R268PDB1'> attachSource
   dvde.dcenter database 'R268PDB1' attachSource *> set attachData.type=OraclePDBAttachData
   dvde.dcenter database 'R268PDB1' attachSource *> set attachData.config=R268PDB1
   dvde.dcenter database 'R268PDB1' attachSource *> set attachData.environmentUser=ora12201
   dvde.dcenter database 'R268PDB1' attachSource *> set attachData.dbUser=delphix
   dvde.dcenter database 'R268PDB1' attachSource *> set attachData.dbCredentials.password
   Enter attachData.dbCredentials.password: *******
   dvde.dcenter database 'R268PDB1' attachSource *> commit
       R268PDB1
       Dispatched job JOB-46
       DB_ATTACH_SOURCE job started for "Untitled/R268PDB1".
       Obtaining information from source database "Untitled/R268PDB1".
       The dSource "R268PDB1" was successfully linked from source database "Untitled/R268PDB1".

PDB CLI detach

1. Login to the engine via SSH with a Delphix admin account.

2. Select the PDB dSource database to be detached.

   CODE

   dvde.dcenter> database
   dvde.dcenter database> select "R268PDB1"
   dvde.dcenter database 'R268PDB1'>

3. Detach the PDB dSource using the detachSource command:

   CODE

   dvde.dcenter database 'R268PDB1'> detachSource
   dvde.dcenter database 'R268PDB1' detachSource *> set source=R268PDB1
   dvde.dcenter database 'R268PDB1' detachSource *> commit
       Dispatched job JOB-45
       DB_DETACH_SOURCE job started for "Untitled/R268PDB1".
       DB_DETACH_SOURCE job for "Untitled/R268PDB1" completed successfully.