In previous post I showed how to perform remote clone with Resource Manager/Terraform/Ansible. What if you just want a quick remote clone to be done manually?

Remember OCI Console doesn’t support Remote Cloning at the moment (February 2022) but you can do the remote clone through API’s as well. So let’s do it with OCI CLI!

Command to clone is very simple as you can see below:

simo@cloudshell:~ (us-ashburn-1)$ oci db pluggable-database remote-cloneUsage: oci db pluggable-database remote-clone [OPTIONS]

Error: Missing option(s) --target-container-database-id, --source-container-db-admin-password, --cloned-pdb-name, --pluggable-database-id.

Only options I need to define are target-container-database-id, source-container-db-admin-password, cloned-pdb-name and pluggable-database-id (source), right? WRONG!

I ran above command but it kept saying that I’m missing few parameters. Looking CLI documentation I need to define following parameters:

  • --cloned-pdb-name 
  • --pdb-admin-password 
  • --pluggable-database-id 
  • --source-container-db-admin-password 
  • --target-container-database-id 
  • --target-tde-wallet-password 

After defining them and running CLI I see the job has been created:

simo@cloudshell:~ (us-ashburn-1)$ oci db pluggable-database remote-clone --target-container-database-id ocid1.database.oc1.iad.12345 --source-container-db-admin-password Password123 --cloned-pdb-name MY_pdb1 --pluggable-database-id ocid1.pluggabledatabase.oc1.iad.12345 --pdb-admin-password Password123 --target-tde-wallet-password Password123

  "data": {
    "compartment-id": "ocid1.compartment.oc1..12345",
    "connection-strings": null,
    "container-database-id": "ocid1.database.oc1.iad.12345",
    "defined-tags": {},
    "freeform-tags": {},
    "id": "ocid1.pluggabledatabase.oc1.iad.12345",
    "is-restricted": null,
    "lifecycle-details": null,
    "lifecycle-state": "PROVISIONING",
    "open-mode": "READ_WRITE",
    "pdb-name": "MY_pdb1",
    "time-created": "2022-02-23T17:42:59.089000+00:00"
  "etag": "806984a2",
  "opc-work-request-id": "ocid1.coreservicesworkrequest.oc1.iad.12345"

After a short wait – I can see my new PDB being available in the destination CDB. You can use CLI to monitor the status, OCI Console didn’t really show the work request status properly.

s_vilmunen@cloudshell:~ (us-ashburn-1)$ oci work-requests work-request  get --work-request-id ocid1.coreservicesworkrequest.oc1.iad.12345
  "data": {
    "compartment-id": "ocid1.compartment.oc1..12345",
    "id": "ocid1.coreservicesworkrequest.oc1.iad.12345",
    "operation-type": "Remote Clone Pluggable Database",
    "percent-complete": 100.0,
    "resources": [
        "action-type": "CREATED",
        "entity-type": "pluggableDatabase",
        "entity-uri": "/20160918/pluggableDatabases/ocid1.pluggabledatabase.oc1.iad.12345",
        "identifier": "ocid1.pluggabledatabase.oc1.iad.12345"
    "status": "SUCCEEDED",
    "time-accepted": "2022-02-23T17:42:59.166000+00:00",
    "time-finished": "2022-02-23T17:57:15.400000+00:00",
    "time-started": null

Easy way to use CLI to clone your PDB – just the CLI required parameters should be fixed!

Leave a Reply

Your email address will not be published.