{"id":36919,"date":"2025-01-29T15:10:52","date_gmt":"2025-01-29T14:10:52","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=36919"},"modified":"2025-01-29T15:27:47","modified_gmt":"2025-01-29T14:27:47","slug":"how-to-clone-remote-pdb-with-dbaascli-on-exacc","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/","title":{"rendered":"How to clone remote PDB with dbaascli on ExaCC?"},"content":{"rendered":"\n

When your DB infrastructure move to ExaCC, it’s a good option to appropriate the tools offer by it to facilitate your life. And for ExaCC, this tool is dbaascli. It manages many aspects of the ExaCC layers. And in this blog, we focus on the clone remote PDB with dbaascli!<\/p>\n\n\n\n

The environment used for this blog is : <\/p>\n\n\n\n

\n
\n
\n
<\/td>Server Name<\/td>CDB Name<\/td>PDB Name<\/td>Scan name<\/td><\/tr>
Source<\/td>ExaCC-1<\/td>CDBORA1<\/td>PDBORA1<\/td>ExaCC-1-scan.mydomain.ch<\/td><\/tr>
Target<\/td>ExaCC-2<\/td>CDBORA2<\/td>PDBORA2<\/td>ExaCC-2-scan.mydomain.ch<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n

The target PDB (PDBORA2) must not exist on the target CDB (CDBORA2). Unless it, an error will be raised.<\/p>\n\n\n\n

And in addition, the SYS password will be asked for the remote CDB.<\/p>\n\n\n\n

You must connect on the target server with the root or oracle OS account. In my case, I will use the oracle account.<\/p>\n\n\n\n

The dbaascli syntax is simple and friendly : <\/p>\n\n\n\n

dbaascli pdb remoteClone --pdbName <value> --dbName <value> --sourceDBConnectionString <value> [--targetPDBName <value>] [--powerLimit <value>] [--maxCPU <value>] [--maxSize <value>] [--resume [--sessionID <value>]] [--executePrereqs] [--waitForCompletion <value>] [--sourcePDBExportedTDEKeyFile <value>]\n        {\n            [--blobLocation <value>]\n            | [--standbyBlobFromPrimary <value>]\n        }\n[--excludeUserTablespaces <value>] \n[--excludePDBData <value>] \n[--pdbAdminUserName <value>] \n[--lockPDBAdminAccount <value>] \n[--sourcePDBServiceConvertList <value>] \n[--refreshablePDB --refreshMode <value> [--refreshIntervalInMinutes <value>] --dblinkUsername <value> \n[--honorCaseSensitiveUserName]] \n[--updateDBBlockCacheSize]<\/code><\/pre>\n\n\n\n
Where mandatory parameters are : <\/p>\n\n\n\n
--pdbName<\/code> specifies the name of the source PDB that you want to clone<\/p>\n\n\n\n
--dbname<\/code> specifies the name (DB_NAME<\/code>) of the CDB that hosts the newly cloned PDB<\/p>\n\n\n\n
--sourceDBConnectionString<\/code> specifies the source database connection string in the format scan_name<\/em>:scan_port<\/em>\/database_service_name<\/em><\/code><\/p>\n\n\n\n
--targetPDBName<\/code> specifies the name for the target PDB (new cloned PDB)<\/p>\n\n\n\n
For this blog, we must use this command : <\/p>\n\n\n
\noracle@ExaCC-2:~\/ [CDBORA2] dbaascli pdb remoteclone --pdbname PDBORA1 --dbname CDBORA2 --targetPDBName PDBORA2 --sourceDBConnectionString ExaCC-1-scan.mydomain.ch:1521\/CDBORA1.mydomain.ch\nDBAAS CLI version 24.3.2.0.0\nExecuting command pdb remoteclone --pdbname PDBORA1 --dbname CDBORA2 --targetPDBName PDBORA2 --sourceDBConnectionString ExaCC-1-scan.mydomain.ch:1521\/CDBORA1.mydomain.ch\nJob id: 688a8b27-40b1-4115-9fbb-deabc741a235\nSession log: \/var\/opt\/oracle\/log\/CDBORA2\/pdb\/remoteClone\/dbaastools_2025-01-28_11-27-30-AM_153668.log\nEnter REMOTE_DB_SYS_PASSWORD:\n\nEnter REMOTE_DB_SYS_PASSWORD (reconfirmation):\n\nLoading PILOT...\nSession ID of the current execution is: 689\nLog file location: \/var\/opt\/oracle\/log\/CDBORA2\/pdb\/remoteClone\/pilot_2025-01-28_11-33-38-AM_178552\n-----------------\nRunning Plugin_initialization job\nEnter TDE_PASSWORD:\n****************\nEnter REMOTE_DB_SYS_PASSWORD\n****************\nCompleted Plugin_initialization job\n-----------------\nRunning Validate_input_params job\nCompleted Validate_input_params job\n-----------------\nRunning Validate_target_pdb_service_name job\nCompleted Validate_target_pdb_service_name job\n-----------------\nRunning Perform_dbca_prechecks job\nCompleted Perform_dbca_prechecks job\n-----------------\nRunning Perform_pdb_cross_release_prechecks job\nCompleted Perform_pdb_cross_release_prechecks job\nAcquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_1\nAcquiring read lock: CDBORA2\nAcquiring write lock: PDBORA2\n-----------------\nRunning PDB_creation job\nCompleted PDB_creation job\n-----------------\nRunning Load_pdb_details job\nCompleted Load_pdb_details job\n-----------------\nRunning Configure_pdb_service job\nCompleted Configure_pdb_service job\n-----------------\nRunning Configure_tnsnames_ora job\nCompleted Configure_tnsnames_ora job\n-----------------\nRunning Set_pdb_admin_user_profile job\nCompleted Set_pdb_admin_user_profile job\n-----------------\nRunning Lock_pdb_admin_user job\nCompleted Lock_pdb_admin_user job\n-----------------\nRunning Register_ocids job\nSkipping. Job is detected as not applicable.\n-----------------\nRunning Prepare_blob_for_standby_in_primary job\nSkipping. Job is detected as not applicable.\nReleasing lock: PDBORA2\nReleasing lock: CDBORA2\nReleasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_1\n-----------------\nRunning Generate_dbsystem_details job\nAcquiring native write lock: global_dbsystem_details_generation\nReleasing native lock: global_dbsystem_details_generation\nCompleted Generate_dbsystem_details job\n\ndbaascli execution completed\n<\/pre><\/div>\n\n\n
And from now a new PDB has been created on the target CDB : <\/p>\n\n\n\n
oracle@ExaCC-2:~\/ [] CDBORA2\n*******************************************************\n INSTANCE_NAME   : CDBORA21\n DB_NAME         : CDBORA2\n DB_UNIQUE_NAME  : CDBORA2\n STATUS          : OPEN READ WRITE \n LOG_MODE        : ARCHIVELOG\n USERS\/SESSIONS  : Normal: 0\/0, Oracle-maintained: 2\/16\n DATABASE_ROLE   : PRIMARY\n FLASHBACK_ON    : YES\n FORCE_LOGGING   : YES\n VERSION         : 19.25.0.0.0\n NLS_LANG        : AMERICAN_AMERICA.WE8ISO8859P15\n CDB_ENABLED     : YES\n PDBs            : PDBORA2  PDB$SEED  \n *******************************************************<\/code><\/pre>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
When your DB infrastructure move to ExaCC, it’s a good option to appropriate the tools offer by it to facilitate your life. And for ExaCC, this tool is dbaascli. It manages many aspects of the ExaCC layers. And in this blog, we focus on the clone remote PDB with dbaascli! The environment used for this […]<\/p>\n","protected":false},"author":146,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[],"type_dbi":[],"class_list":["post-36919","post","type-post","status-publish","format-standard","hentry","category-oracle"],"acf":[],"yoast_head":"\nHow to clone remote PDB with dbaascli on ExaCC? - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to clone remote PDB with dbaascli on ExaCC?\" \/>\n<meta property=\"og:description\" content=\"When your DB infrastructure move to ExaCC, it’s a good option to appropriate the tools offer by it to facilitate your life. And for ExaCC, this tool is dbaascli. It manages many aspects of the ExaCC layers. And in this blog, we focus on the clone remote PDB with dbaascli! The environment used for this […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-29T14:10:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-29T14:27:47+00:00\" \/>\n<meta name=\"author\" content=\"Xavier Franck Godard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Xavier Franck Godard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/\"},\"author\":{\"name\":\"Xavier Franck Godard\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4809e0f09c20eb127777125e037328f2\"},\"headline\":\"How to clone remote PDB with dbaascli on ExaCC?\",\"datePublished\":\"2025-01-29T14:10:52+00:00\",\"dateModified\":\"2025-01-29T14:27:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/\"},\"wordCount\":226,\"commentCount\":2,\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/\",\"name\":\"How to clone remote PDB with dbaascli on ExaCC? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2025-01-29T14:10:52+00:00\",\"dateModified\":\"2025-01-29T14:27:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4809e0f09c20eb127777125e037328f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to clone remote PDB with dbaascli on ExaCC?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4809e0f09c20eb127777125e037328f2\",\"name\":\"Xavier Franck Godard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g\",\"caption\":\"Xavier Franck Godard\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/xavierfranck\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to clone remote PDB with dbaascli on ExaCC? - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/","og_locale":"en_US","og_type":"article","og_title":"How to clone remote PDB with dbaascli on ExaCC?","og_description":"When your DB infrastructure move to ExaCC, it’s a good option to appropriate the tools offer by it to facilitate your life. And for ExaCC, this tool is dbaascli. It manages many aspects of the ExaCC layers. And in this blog, we focus on the clone remote PDB with dbaascli! The environment used for this […]","og_url":"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/","og_site_name":"dbi Blog","article_published_time":"2025-01-29T14:10:52+00:00","article_modified_time":"2025-01-29T14:27:47+00:00","author":"Xavier Franck Godard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Xavier Franck Godard","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/"},"author":{"name":"Xavier Franck Godard","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4809e0f09c20eb127777125e037328f2"},"headline":"How to clone remote PDB with dbaascli on ExaCC?","datePublished":"2025-01-29T14:10:52+00:00","dateModified":"2025-01-29T14:27:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/"},"wordCount":226,"commentCount":2,"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/","url":"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/","name":"How to clone remote PDB with dbaascli on ExaCC? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2025-01-29T14:10:52+00:00","dateModified":"2025-01-29T14:27:47+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4809e0f09c20eb127777125e037328f2"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-clone-remote-pdb-with-dbaascli-on-exacc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to clone remote PDB with dbaascli on ExaCC?"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4809e0f09c20eb127777125e037328f2","name":"Xavier Franck Godard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g","caption":"Xavier Franck Godard"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/xavierfranck\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/36919","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/146"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=36919"}],"version-history":[{"count":21,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/36919\/revisions"}],"predecessor-version":[{"id":36943,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/36919\/revisions\/36943"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=36919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=36919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=36919"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=36919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}