CLI cookbook: attaching or detaching a PDB

This topic describes how to attach or detach a PDB using the command-line interface.

PDB CLI attach

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

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

3. Select the PDB dSource database to be attached.

   Copy

   delphix> database
   delphix database> select "R268PDB1"delphix 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 PDB dSource.

   Copy

   delphix database 'R268PDB1'> attachSource
   delphix database 'R268PDB1' attachSource *> set attachData.type=OraclePDBAttachData
   delphix database 'R268PDB1' attachSource *> set attachData.config=R268PDB1
   delphix database 'R268PDB1' attachSource *> set attachData.environmentUser=ora12201
   delphix database 'R268PDB1' attachSource *> commit
       R268PDB1
       Dispatched job JOB-46
       DB_ATTACH_SOURCE job started for "Untitled/R268PDB1".
       Starting validation of attach parameters for database "Untitled/R268PDB1".
       Validation finished for database "Untitled/R268PDB1"    Obtaining information from source database "Untitled/R268PDB1".
       The dSource "R268PDB1" was successfully linked from source database "Untitled/R268PDB1".
       DB_ATTACH_SOURCE job for "Untitled/R268PDB1" completed successfully.

PDB CLI detach

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

2. Select the PDB dSource database to be detached.

   Copy

   delphix> database
   delphix database> select "R268PDB1"delphix database 'R268PDB1'>

3. Detach the PDB dSource using the detachSource command:

   Copy

   delphix database 'R268PDB1'> detachSource
   delphix database 'R268PDB1' detachSource *> set source=R268PDB1
   delphix 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.