CLI cookbook: attaching, detaching, or linking a CDB

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

A CDB is not automatically detached when you detach the last PDB of the CDB. The CDB still remains in an inactive state which in turn prevents you from removing the environment. Therefore, you must detach the CDB in order to remove the environment.

You can perform detach or attach operations only via Command-Line Interface (CLI).

CDB CLI detach

Perform the following steps to detach a CDB.

You can detach a CDB only when there are no PDBs linked and the CDB does not have any vPDBs.

Login to the engine via SSH with a Delphix admin account.
CODE
```
$ ssh admin@YOUR_ENGINE
```

Select the CDB dSource database to be detached.

CODE

delphix> cd database
delphix database> select CDOMLOSR421F
delphix database 'CDOMLOSR421F'>

Detach the CDB dSource using the detachSource command.

CODE

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

You must attach the CDB back before performing the following operations: linking a new PDB, attaching a PDB, provisioning a vPDB, or attaching a converted PDB. Failure to do this will either result in an error due to duplicated object or will create a second CDB that will duplicate the space used for the CDB.

CDB CLI link

You can not perform an attach operation for PDBs that have already been detached from the primary CDB and are required to be attached to a standby CDB if the standby CDB is not already linked or attached. You must link the CDB manually before performing the PDB attach operation.

Perform the following steps to link a CDB.

Login to the engine via SSH with a Delphix admin account.
CODE
```
$ ssh admin@YOUR_ENGINE
```

Select the CDB dSource database to be linked.

CODE

delphix> cd database
delphix database> link
delphix database link *>

Link the CDB dSource using the link command.

CODE

delphix database link *> set name=mycdb
delphix database link *> set group=Untitled
delphix database link *> edit linkData
delphix database link linkData *> set type=OracleLinkFromExternal
delphix database link linkData *> set syncStrategy.config=CDOMSHSR6706
delphix database link linkData *> set environmentUser=oracle
delphix database link linkData *> set linkNow=true
delphix database link linkData *> commit
    `ORACLE_DB_CONTAINER-23
    Dispatched job JOB-171
    DB_LINK job started for "Untitled/mycdb".
    Obtaining information from source database "Untitled/mycdb".
    Creating new TimeFlow for dSource "Untitled/mycdb".    
    Request to SnapSync container database "Untitled/mycdb" after attaching it will be ignored.  
    Action: Direct SnapSync of container database is not allowed. Container database SnapSync will be taken when SnapSync of corresponding
               pluggable database is taken.    
    The dSource "mycdb" was successfully linked from source database "Untitled/mycdb".    
    DB_LINK job for "Untitled/mycdb" completed successfully.

CDB CLI Attach

Perform the following steps to attach a CDB.

Ensure the new source environment has been fully discovered by the Delphix Engine.
Login to the engine via SSH with a Delphix admin account.
CODE
```
$ ssh admin@YOUR_ENGINE
```

Select the CDB dSource database to be attached.

CODE

delphix> cd database
delphix database> select CDOMLOSR421F
delphix database 'CDOMLOSR421F'>

Attach the CDB dSource to the correct source CDB in the new environment using the attachSource command.

When attaching a CDB, the linkNow=true command is ignored. Snapshots for CDBs cannot be taken directly. CDB snapshots will be taken when a PDB requires a snapshot of the CDB.

CODE

delphix database 'CDOMLOSR421F'> attachSource
delphix database 'CDOMLOSR421F' attachSource *> edit attachData
delphix database 'CDOMLOSR421F' attachSource attachData *> set type=OracleAttachData
delphix database 'CDOMLOSR421F' attachSource attachData *> set config=CDOMLOSR421F
delphix database 'CDOMLOSR421F' attachSource attachData *> set environmentUser=oracle
delphix database 'CDOMLOSR421F' attachSource *> commit
    CDOMLOSR421F    
    Dispatched job JOB-46    
    DB_ATTACH_SOURCE job started for "Untitled/CDOMLOSR421F".
        Starting validation of attach parameters for database "CDOMLOSR421F".    
    Obtaining information from source database "Untitled/CDOMLOSR421F".    
    The dSource "CDOMLOSR421F" was successfully linked from source database "Untitled/CDOMLOSR421F".