{"id":34456,"date":"2024-07-31T01:02:13","date_gmt":"2024-07-30T23:02:13","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=34456"},"modified":"2024-07-31T01:02:17","modified_gmt":"2024-07-30T23:02:17","slug":"and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/","title":{"rendered":"And what about cloning a PDB in a Data Guard environment on ExaCC?"},"content":{"rendered":"\n<p>I have recently blogged about how to create a new PDB on ExaCC in a Data Guard environment, see <a href=\"https:\/\/www.dbi-services.com\/blog\/create-new-pdb-in-a-data-guard-environment-on-exacc\/\">https:\/\/www.dbi-services.com\/blog\/create-new-pdb-in-a-data-guard-environment-on-exacc\/<\/a>.<\/p>\n\n\n\n<p>And what about if I clone a PDB on the primary CDB? Let&#8217;s see.<\/p>\n\n\n<a class=\"wp-block-read-more\" href=\"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/\" target=\"_self\">Read more<span class=\"screen-reader-text\">: And what about cloning a PDB in a Data Guard environment on ExaCC?<\/span><\/a>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-clone-pdb-on-the-primary-database\">Clone PDB on the primary database<\/h2>\n\n\n\n<p>Let&#8217;s clone our previous NEWPDB into NEWPDB_2 with dbaascli.<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1]\">\noracle@ExaCC-chz1-cl01n1:~\/ [MYCDB1 (CDB$ROOT)] dbaascli pdb localclone --pdbName NEWPDB --dbName MYCDB --targetPDBName NEWPDB_2\nDBAAS CLI version 24.1.2.0.0\nExecuting command pdb localclone --pdbName NEWPDB --dbName MYCDB --targetPDBName NEWPDB_2\nJob id: 584e3b45-7725-4132-a865-88b20a559e4e\nSession log: \/var\/opt\/oracle\/log\/MYCDB\/pdb\/localClone\/dbaastools_2024-05-31_10-56-38-AM_394962.log\nLoading PILOT...\nSession ID of the current execution is: 7855\nLog file location: \/var\/opt\/oracle\/log\/MYCDB\/pdb\/localClone\/pilot_2024-05-31_10-56-49-AM_399103\n-----------------\nRunning Plugin_initialization job\nEnter TDE_PASSWORD:                                                                                                                                                                                            *********************\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\nAcquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_2\nAcquiring write lock: mycdb\nAcquiring write lock: newpdb_2\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\nCompleted Prepare_blob_for_standby_in_primary job\nReleasing lock: newpdb_2\nReleasing lock: mycdb\nReleasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_2\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---------- PLUGIN NOTES ----------\nNote: Pluggable database operation is performed on the primary database. In order to successfully complete the operation, the file \/var\/opt\/oracle\/log\/reg_tmp_files\/MYCDB_2024-05-31_10-56-49-AM_399103.tar needs to be copied to the standby database node and additional steps need to be run on all standby databases. Refer to the Cloud Service documentation for the complete steps.\n---------- END OF PLUGIN NOTES ----------\ndbaascli execution completed\n<\/pre>\n<\/br>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-checks\">Checks<\/h2>\n\n\n\n<p>Let&#8217;s check new clone on the primary side:<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,21,22]\">\noracle@ExaCC-chz1-cl01n1:~\/ [MYCDB1 (CDB$ROOT)] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Fri May 31 11:00:12 2024\nVersion 19.23.0.0.0\n\nCopyright (c) 1982, 2023, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\nVersion 19.23.0.0.0\n\nSQL&gt; show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1                           READ WRITE NO\n         4 PDB2                           READ WRITE NO\n         5 PDB3                           READ WRITE NO\n         6 NEWPDB                         READ WRITE NO\n         7 NEWPDB_2                       READ WRITE NO\nSQL&gt;\n<\/pre>\n<\/br>\n\n\n\n<p>And on the standby side:<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,21,22,24,33]\">\noracle@ExaCC-chz2-cl01n1:~\/ [MYCDB1 (CDB$ROOT)] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Fri May 31 11:00:41 2024\nVersion 19.23.0.0.0\n\nCopyright (c) 1982, 2023, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\nVersion 19.23.0.0.0\n\nSQL&gt; show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1                           READ ONLY  NO\n         4 PDB2                           READ ONLY  NO\n         5 PDB3                           READ ONLY  NO\n         6 NEWPDB                         READ ONLY  NO\n         7 NEWPDB_2                       MOUNTED\n\nSQL&gt; select name, total_size\/1024\/1024\/1024 GB from v$pdbs;\n\nNAME                         GB\n-------------------- ----------\nPDB$SEED             1.85546875\nPDB1                 2308.65039\nPDB2                 1534.89966\nPDB3                 1095.55273\nNEWPDB               4.34375\nNEWPDB_2             0\n\n6 rows selected.\n<\/pre>\n<\/br>\n\n\n\n<p>As expected the PDB clone on the standby side has been created with the Data Guard redo, but is empty.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-resolve-the-problem\">Resolve the problem<\/h2>\n\n\n\n<p>Let&#8217;s transfer the BLOB file the initial commands provided us. The file is here:<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,21,22,24,33]\">\n[opc@ExaCC-chz2-cl01n1 ~]$ sudo mv \/tmp\/MYCDB_2024-05-31_10-56-49-AM_399103.tar \/var\/opt\/oracle\/log\/reg_tmp_files\/\n[opc@ExaCC-chz2-cl01n1 ~]$ sudo chown oracle: \/var\/opt\/oracle\/log\/reg_tmp_files\/MYCDB_2024-05-31_10-56-49-AM_399103.tar\n<\/pre>\n<\/br>\n\n\n\n<p>With the blob file as reference, clone the PDB on the standby side. It is the exact same command used on the primary side, with just an additional command <code>--standbyBlobFromPrimary<\/code>.<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,4]\">\noracle@ExaCC-chz2-cl01n1:~\/ [MYCDB1 (CDB$ROOT)] ls -ltrh \/var\/opt\/oracle\/log\/reg_tmp_files\/MYCDB_2024-05-31_10-56-49-AM_399103.tar\n-rw-r--r-- 1 oracle oinstall 160K May 31 11:03 \/var\/opt\/oracle\/log\/reg_tmp_files\/MYCDB_2024-05-31_10-56-49-AM_399103.tar\n\noracle@ExaCC-chz2-cl01n1:~\/ [MYCDB1 (CDB$ROOT)] dbaascli pdb localclone --pdbName NEWPDB --dbName MYCDB --targetPDBName NEWPDB_2 --standbyBlobFromPrimary \/var\/opt\/oracle\/log\/reg_tmp_files\/MYCDB_2024-05-31_10-56-49-AM_399103.tar\nDBAAS CLI version 24.1.2.0.0\nExecuting command pdb localclone --pdbName NEWPDB --dbName MYCDB --targetPDBName NEWPDB_2 --standbyBlobFromPrimary \/var\/opt\/oracle\/log\/reg_tmp_files\/MYCDB_2024-05-31_10-56-49-AM_399103.tar\nJob id: eabccc30-af71-4d49-ba59-e3fce15c0619\nSession log: \/var\/opt\/oracle\/log\/MYCDB\/pdb\/localClone\/dbaastools_2024-05-31_11-07-21-AM_398735.log\nLoading PILOT...\nSession ID of the current execution is: 5625\nLog file location: \/var\/opt\/oracle\/log\/MYCDB\/pdb\/localClone\/pilot_2024-05-31_11-07-34-AM_1320\n-----------------\nRunning Plugin_initialization job\nEnter SYS_PASSWORD:                                                                                                                                                                                              ************************\nEnter TDE_PASSWORD:                                                                                                                                                                                                     *********************\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\nAcquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_2\nAcquiring write lock: mycdb\nAcquiring write lock: newpdb_2\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\nSkipping. Job is detected as not applicable.\n-----------------\nRunning Lock_pdb_admin_user job\nSkipping. Job is detected as not applicable.\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: newpdb_2\nReleasing lock: mycdb\nReleasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_2\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\ndbaascli execution completed\n<\/pre>\n<\/br>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-final-checks\">Final checks<\/h2>\n\n\n\n<p>And the new cloned PDB is also now opened READ ONLY on the standby side.<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,4]\">\nSQL&gt; show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1                           READ ONLY  NO\n         4 PDB2                           READ ONLY  NO\n         5 PDB3                           READ ONLY  NO\n         6 NEWPDB                         READ ONLY  NO\n         7 NEWPDB_2                       READ ONLY  NO\nSQL&gt;\n<\/pre>\n<\/br>\n\n\n\n<p>And the Data Guard is in sync.<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,9,13]\">\noracle@ExaCC-chz1-cl01n1:~\/ [MYCDB1 (CDB$ROOT)] dgh\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri May 31 11:22:32 2024\nVersion 19.23.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nWelcome to DGMGRL, type \"help\" for information.\n\nDGMGRL&gt; connect \/\nConnected to \"MYCDB_CHZ1\"\nConnected as SYSDG.\n\nDGMGRL&gt; show configuration lag\n\nConfiguration - fsc\n\n  Protection Mode: MaxAvailability\n  Members:\n  MYCDB_CHZ1 - Primary database\n    MYCDB_CHZ2 - Physical standby database\n                    Transport Lag:      0 seconds (computed 0 seconds ago)\n                    Apply Lag:          0 seconds (computed 0 seconds ago)\n\nFast-Start Failover:  Disabled\n\nConfiguration Status:\nSUCCESS   (status updated 44 seconds ago)\n<\/pre>\n<\/br>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-blob-file-contents\">BLOB file contents<\/h2>\n\n\n\n<p>Let&#8217;s see what contains the blob file. The file contains the metadata architecture that will be used to recreate the PDB on the standby side.<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,5,7,10,39,46]\">\n[opc@svl-sirip614 chk_blob_exacc_MYCDB]$ ls -ltrh\ntotal 132K\n-rw-r--r--. 1 opc opc 130K May 31 13:43 MYCDB_2024-05-31_09-52-53-AM_101724.tar\n\n[opc@svl-sirip614 chk_blob_exacc_MYCDB]$ tar xf MYCDB_2024-05-31_09-52-53-AM_101724.tar\n\n[opc@svl-sirip614 chk_blob_exacc_MYCDB]$ ls\nMYCDB_2024-05-31_09-52-53-AM_101724.tar  db_wallet  pwdmycdb_chz1.639.1169979391  wallet_root\n\n[opc@svl-sirip614 chk_blob_exacc_MYCDB]$ tar tvf MYCDB_2024-05-31_09-52-53-AM_101724.tar\ndrwxr-x--- oracle\/oinstall   0 2024-05-30 16:54 wallet_root\/\ndrwxr-x--- oracle\/oinstall   0 2024-05-31 09:54 wallet_root\/tde\/\n-rw------- oracle\/oinstall 15145 2024-05-31 09:54 wallet_root\/tde\/ewallet.p12\n-rw------- oracle\/oinstall 15190 2024-05-31 09:54 wallet_root\/tde\/cwallet.sso\n-rw------- oracle\/oinstall  2553 2024-05-26 10:24 wallet_root\/tde\/ewallet_2024052608245022.p12\n-rw------- oracle\/oinstall  3993 2024-05-26 10:31 wallet_root\/tde\/ewallet_2024052608313060.p12\n-rw------- oracle\/oinstall     0 2024-05-26 17:37 wallet_root\/tde\/ewallet.p12.lck\n-rw------- oracle\/oinstall     0 2024-05-26 17:37 wallet_root\/tde\/cwallet.sso.lck\n-rw------- oracle\/asmadmin  5465 2024-05-26 17:38 wallet_root\/tde\/ewallet_2024052615380164.p12\n-rw------- oracle\/asmadmin  6953 2024-05-26 17:55 wallet_root\/tde\/ewallet_2024052615552711.p12\n-rw------- oracle\/asmadmin  8201 2024-05-29 14:25 wallet_root\/tde\/ewallet_2024052912250856.p12\n-rw------- oracle\/asmadmin  9689 2024-05-29 15:34 wallet_root\/tde\/ewallet_2024052913345698.p12\n-rw------- oracle\/asmadmin 10937 2024-05-29 17:39 wallet_root\/tde\/ewallet_2024052915390341.p12\n-rw------- oracle\/asmadmin 12409 2024-05-29 18:05 wallet_root\/tde\/ewallet_2024052916054502.p12\n-rw------- oracle\/asmadmin 13673 2024-05-31 09:54 wallet_root\/tde\/ewallet_2024053107541551.p12\n-rw-r----- oracle\/oinstall   326 2024-05-26 10:32 wallet_root\/cdb_ocids.json_20240526161751\n-rw-r----- oracle\/oinstall   326 2024-05-26 16:17 wallet_root\/cdb_ocids.json\ndrwx------ oracle\/oinstall     0 2024-05-27 16:22 wallet_root\/195DC5B0E2F4976CE063021FA20AF881\/\n-rw-r----- oracle\/oinstall   335 2024-05-27 16:22 wallet_root\/195DC5B0E2F4976CE063021FA20AF881\/pdb_ocids.json\ndrwx------ oracle\/oinstall     0 2024-05-29 16:51 wallet_root\/19971A75AFAC7611E063021FA20A7BDE\/\n-rw-r----- oracle\/oinstall   335 2024-05-29 16:51 wallet_root\/19971A75AFAC7611E063021FA20A7BDE\/pdb_ocids.json\ndrwx------ oracle\/oinstall     0 2024-05-30 16:54 wallet_root\/1998B7B6E9770BF5E063021FA20A42A7\/\n-rw-r----- oracle\/oinstall   335 2024-05-30 16:54 wallet_root\/1998B7B6E9770BF5E063021FA20A42A7\/pdb_ocids.json\ndrwxr-xr-x oracle\/oinstall     0 2024-05-26 10:35 db_wallet\/\n-rw------- oracle\/oinstall     0 2024-05-26 10:35 db_wallet\/cwallet.sso.lck\n-rw------- oracle\/oinstall   619 2024-05-26 10:42 db_wallet\/cwallet.sso\n-rw-r----- grid\/oinstall    2560 2024-05-31 09:55 pwdmycdb_chz1.639.1169979391\n\n[opc@svl-sirip614 chk_blob_exacc_MYCDB]$ cat wallet_root\/1998B7B6E9770BF5E063021FA20A42A7\/pdb_ocids.json\n{\n  \"tenancyOCID\" : \"ocid1.tenancy.oc1..aaaaaaaa52qxw***************************************************7wka\",\n  \"compartmentOCID\" : \"ocid1.compartment.oc1..aaaaaaaadqt**************************************************7tqa\",\n  \"resourceOCID\" : \"ocid1.pluggabledatabase.oc1.eu-zurich-1.an5he************************************************5na\"\n}\n\n[opc@svl-sirip614 chk_blob_exacc_MYCDB]$ cat wallet_root\/cdb_ocids.json\n{\n  \"tenancyOCID\" : \"ocid1.tenancy.oc1..aaaaaaaa52qxw**************************************************7wka\",\n  \"compartmentOCID\" : \"ocid1.compartment.oc1..aaaaaaaadqt2s**************************************************7tqa\",\n  \"resourceOCID\" : \"ocid1.database.oc1.eu-zurich-1.an5helj**************************************************a3mq\"\n}\n<\/pre>\n<\/br>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-to-wrap-up\">To wrap up<\/h2>\n\n\n\n<p>Clone a PDB in a CDB on ExaCC is the same procedure than creating a new PDB.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have recently blogged about how to create a new PDB on ExaCC in a Data Guard environment, see https:\/\/www.dbi-services.com\/blog\/create-new-pdb-in-a-data-guard-environment-on-exacc\/. And what about if I clone a PDB on the primary CDB? Let&#8217;s see. Clone PDB on the primary database Let&#8217;s clone our previous NEWPDB into NEWPDB_2 with dbaascli. oracle@ExaCC-chz1-cl01n1:~\/ [MYCDB1 (CDB$ROOT)] dbaascli pdb localclone [&hellip;]<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[3413,2598,64],"type_dbi":[],"class_list":["post-34456","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-dbaascli","tag-exacc-3","tag-multitenant"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>And what about cloning a PDB in a Data Guard environment 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\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"And what about cloning a PDB in a Data Guard environment on ExaCC?\" \/>\n<meta property=\"og:description\" content=\"I have recently blogged about how to create a new PDB on ExaCC in a Data Guard environment, see https:\/\/www.dbi-services.com\/blog\/create-new-pdb-in-a-data-guard-environment-on-exacc\/. And what about if I clone a PDB on the primary CDB? Let&#8217;s see. Clone PDB on the primary database Let&#8217;s clone our previous NEWPDB into NEWPDB_2 with dbaascli. oracle@ExaCC-chz1-cl01n1:~\/ [MYCDB1 (CDB$ROOT)] dbaascli pdb localclone [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-30T23:02:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-30T23:02:17+00:00\" \/>\n<meta name=\"author\" content=\"Marc Wagner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc Wagner\" \/>\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\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"And what about cloning a PDB in a Data Guard environment on ExaCC?\",\"datePublished\":\"2024-07-30T23:02:13+00:00\",\"dateModified\":\"2024-07-30T23:02:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/\"},\"wordCount\":224,\"commentCount\":0,\"keywords\":[\"dbaascli\",\"exacc\",\"multitenant\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/\",\"name\":\"And what about cloning a PDB in a Data Guard environment on ExaCC? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2024-07-30T23:02:13+00:00\",\"dateModified\":\"2024-07-30T23:02:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"And what about cloning a PDB in a Data Guard environment 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\/225d9884b8467ead9a872823acb14628\",\"name\":\"Marc Wagner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"caption\":\"Marc Wagner\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"And what about cloning a PDB in a Data Guard environment 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\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/","og_locale":"en_US","og_type":"article","og_title":"And what about cloning a PDB in a Data Guard environment on ExaCC?","og_description":"I have recently blogged about how to create a new PDB on ExaCC in a Data Guard environment, see https:\/\/www.dbi-services.com\/blog\/create-new-pdb-in-a-data-guard-environment-on-exacc\/. And what about if I clone a PDB on the primary CDB? Let&#8217;s see. Clone PDB on the primary database Let&#8217;s clone our previous NEWPDB into NEWPDB_2 with dbaascli. oracle@ExaCC-chz1-cl01n1:~\/ [MYCDB1 (CDB$ROOT)] dbaascli pdb localclone [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/","og_site_name":"dbi Blog","article_published_time":"2024-07-30T23:02:13+00:00","article_modified_time":"2024-07-30T23:02:17+00:00","author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"And what about cloning a PDB in a Data Guard environment on ExaCC?","datePublished":"2024-07-30T23:02:13+00:00","dateModified":"2024-07-30T23:02:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/"},"wordCount":224,"commentCount":0,"keywords":["dbaascli","exacc","multitenant"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/","url":"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/","name":"And what about cloning a PDB in a Data Guard environment on ExaCC? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2024-07-30T23:02:13+00:00","dateModified":"2024-07-30T23:02:17+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/and-what-about-cloning-a-pdb-in-a-data-guard-environment-on-exacc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"And what about cloning a PDB in a Data Guard environment 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\/225d9884b8467ead9a872823acb14628","name":"Marc Wagner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","caption":"Marc Wagner"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34456","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\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=34456"}],"version-history":[{"count":6,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34456\/revisions"}],"predecessor-version":[{"id":34462,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34456\/revisions\/34462"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=34456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=34456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=34456"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=34456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}