{"id":14679,"date":"2021-09-09T15:26:55","date_gmt":"2021-09-09T18:26:55","guid":{"rendered":"https:\/\/www.dbarj.com.br\/?p=14679"},"modified":"2021-09-09T15:37:13","modified_gmt":"2021-09-09T18:37:13","slug":"creating-a-snapshot-sparse-clone-from-a-different-release-update","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/","title":{"rendered":"Creating a snapshot sparse clone from a different Release Update"},"content":{"rendered":"<p>Those days, I was testing if it is possible to create a snapshot sparse clone in one database referencing a PDB on a lower release (like 19.11), and later applying datapatch on this cloned PDB to take it to the higher release (like 19.12).<\/p>\n<p id=\"nohYLqE\"><img loading=\"lazy\" decoding=\"async\" width=\"778\" height=\"255\" class=\"alignnone size-full wp-image-14680 \" src=\"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_613a4ab905de8.png\" alt=\"\" srcset=\"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_613a4ab905de8.png 778w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_613a4ab905de8-300x98.png 300w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_613a4ab905de8-768x252.png 768w\" sizes=\"auto, (max-width: 778px) 100vw, 778px\" \/><\/p>\n<p>Technically I couldn&#8217;t see any constraint, given the <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/multi\/cloning-a-pdb.html#GUID-3E29F21E-FB48-408A-BE2F-3DE1F3AF6F62\" target=\"_blank\" rel=\"noopener\">Snapshot Copy requirements<\/a> are already met. But nothing better than testing to check if something works.<\/p>\n<p>So let&#8217;s try it!<\/p>\n<ul>\n<li><strong>Source DB:<\/strong><\/li>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>CDB: RJ1911<\/li>\n<li>PDB: PDB1911<\/li>\n<\/ul>\n<\/li>\n<li><strong>Target DB:<\/strong>\n<ul>\n<li>CDB: RJ1912<\/li>\n<li>PDB: PDB1912<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Preparing the source (19.11):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">[oracle@exacs-c0gab1 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 9 18:01:44 2021\r\nVersion 19.11.0.0.0\r\n\r\nCopyright (c) 1982, 2020, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\r\nVersion 19.11.0.0.0\r\n\r\nSQL&gt; CREATE PLUGGABLE DATABASE PDB1911 file_name_convert=('+DATAC1','+SPRC1')\r\n  2  ADMIN USER myadm IDENTIFIED BY password ROLES=(DBA);\r\n\r\nPluggable database created.\r\n\r\nSQL&gt; ALTER PLUGGABLE DATABASE PDB1911 OPEN;\r\n\r\nPluggable database altered.\r\n\r\nSQL&gt; CREATE USER c##pdb_clone_user IDENTIFIED BY \"Rodrigo.12345\" CONTAINER=ALL;\r\n\r\nUser created.\r\n\r\nSQL&gt; GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO c##pdb_clone_user CONTAINER=ALL;\r\n\r\nGrant succeeded.\r\n\r\nSQL&gt; alter pluggable database PDB1911 close;\r\n\r\nPluggable database altered.\r\n\r\nSQL&gt; alter pluggable database PDB1911 open read only;\r\n\r\nPluggable database altered.\r\n\r\nSQL&gt;\r\n<\/pre>\n<p>Now connecting on the target (19.12):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">[oracle@exacs-c0gab1 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 9 18:05:03 2021\r\nVersion 19.12.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\r\nVersion 19.12.0.0.0\r\n\r\nSQL&gt; CREATE DATABASE LINK RJ1911\r\n  2  CONNECT TO c##pdb_clone_user IDENTIFIED BY \"Rodrigo.12345\"\r\n  3  USING 'exacs-c0gab-scan.x.x.oraclevcn.com:1521\/RJ1911.x.x.oraclevcn.com';\r\n\r\nDatabase link created.\r\n\r\nSQL&gt; select * from dual@RJ1911;\r\n\r\nD\r\n-\r\nX\r\n\r\nSQL&gt; CREATE PLUGGABLE DATABASE PDB1912 FROM PDB1911@RJ1911 snapshot copy create_file_dest='+SPRC1';\r\n\r\nPluggable database created.\r\n\r\nSQL&gt; alter pluggable database PDB1912 open;\r\n\r\nWarning: PDB altered with errors.\r\n\r\nSQL&gt; set lines 10000 pages 10000 tab off\r\nSQL&gt; select * from pdb_plug_in_violations where name='PDB1912';\r\n\r\nTIME                            NAME      CAUSE                     TYPE      ERROR_NUMBER       LINE MESSAGE                                                                                                                                                                           STATUS    ACTION                                                 CON_ID\r\n------------------------------- --------- ------------------------- --------- ------------ ---------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------- -------------------------------------------------- ----------\r\n09-SEP-21 06.08.13.722151 PM    PDB1912   Parameter                 WARNING              0          1 CDB parameter wallet_root mismatch: Previous '\/var\/opt\/oracle\/dbaas_acfs\/RJ1911\/wallet_root' Current '\/var\/opt\/oracle\/dbaas_acfs\/RJ1912\/wallet_root'                              PENDING   Please check the parameter in the current CDB               1\r\n09-SEP-21 06.08.13.722715 PM    PDB1912   Oracle Opatch             WARNING              0          1 Oracle opatch mismatch: opatch 32490416 is missing in the CDB.                                                                                                                    PENDING   Install the Oracle opatch in the CDB.                       1\r\n09-SEP-21 06.08.13.722850 PM    PDB1912   Oracle Opatch             WARNING              0          2 Oracle opatch mismatch: opatch 32399816 is missing in the CDB.                                                                                                                    PENDING   Install the Oracle opatch in the CDB.                       1\r\n09-SEP-21 06.08.13.722926 PM    PDB1912   Oracle Opatch             WARNING              0          3 Oracle opatch mismatch: opatch 32579761 is missing in the CDB.                                                                                                                    PENDING   Install the Oracle opatch in the CDB.                       1\r\n09-SEP-21 06.08.13.723071 PM    PDB1912   Oracle Opatch             WARNING              0          4 Oracle opatch mismatch: opatch 32545013 is missing in the CDB.                                                                                                                    PENDING   Install the Oracle opatch in the CDB.                       1\r\n09-SEP-21 06.08.14.164498 PM    PDB1912   SQL Patch                 ERROR                0          1 Interim patch 32876380\/24269510 (OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380)): Installed in the CDB but not in the PDB                                                       PENDING   Call datapatch to install in the PDB or the CDB             5\r\n09-SEP-21 06.08.14.166400 PM    PDB1912   SQL Patch                 ERROR                0          2 Interim patch 30310195\/24121718 (DBSAT REPORTED DISABLED CONSTRAINTS FOR SHARDING  STS_CHUNKS ON GSMADMIN_INTERNAL.SHARD_TS): Not installed in the CDB but installed in the PDB   PENDING   Call datapatch to install in the PDB or the CDB             5\r\n09-SEP-21 06.08.14.167041 PM    PDB1912   SQL Patch                 ERROR                0          3 Interim patch 32399816\/24099425 (OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816)): Not installed in the CDB but installed in the PDB                                             PENDING   Call datapatch to install in the PDB or the CDB             5\r\n09-SEP-21 06.08.14.167585 PM    PDB1912   SQL Patch                 ERROR                0          4 '19.12.0.0.0 Release_Update 2107161418' is installed in the CDB but '19.11.0.0.0 Release_Update 2104130040' is installed in the PDB                                               PENDING   Call datapatch to install in the PDB or the CDB             5\r\n09-SEP-21 06.08.14.168930 PM    PDB1912   is encrypted tablespace?  WARNING          28427          1 Tablespace SYSTEM is not encrypted. Oracle Cloud mandates all tablespaces should be encrypted.                                                                                    PENDING   Encrypt the tablespace.                                     5\r\n09-SEP-21 06.08.14.170047 PM    PDB1912   is encrypted tablespace?  WARNING          28427          2 Tablespace SYSAUX is not encrypted. Oracle Cloud mandates all tablespaces should be encrypted.                                                                                    PENDING   Encrypt the tablespace.                                     5\r\n09-SEP-21 06.08.17.622991 PM    PDB1912   Sync Failure              WARNING           4068          2 Sync PDB failed with ORA-04068 while performing 'DROP USER \"C##PDB_CLONE_USER\"'                                                                                                   PENDING                                                               5\r\n\r\n13 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>Ok. So I could create it and the only issues I have while opening it seems to be related to datapatch. Let me run it:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">[oracle@exacs-c0gab1 OPatch]$ .\/datapatch -verbose\r\nSQL Patching tool version 19.12.0.0.0 Production on Thu Sep  9 18:16:59 2021\r\nCopyright (c) 2012, 2021, Oracle.  All rights reserved.\r\n\r\nLog file for this invocation: \/u02\/app\/oracle\/cfgtoollogs\/sqlpatch\/sqlpatch_203590_2021_09_09_18_16_59\/sqlpatch_invocation.log\r\n\r\nConnecting to database...OK\r\nGathering database info...done\r\n\r\nNote:  Datapatch will only apply or rollback SQL fixes for PDBs\r\n       that are in an open state, no patches will be applied to closed PDBs.\r\n       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation\r\n       (Doc ID 1585822.1)\r\n\r\nBootstrapping registry and package to current versions...done\r\nDetermining current state...done\r\n\r\nCurrent state of interim SQL patches:\r\nInterim patch 30310195 (DBSAT REPORTED DISABLED CONSTRAINTS FOR SHARDING  STS_CHUNKS ON GSMADMIN_INTERNAL.SHARD_TS):\r\n  Binary registry: Not installed\r\n  PDB CDB$ROOT: Not installed\r\n  PDB PDB$SEED: Not installed\r\n  PDB PDB1912: Applied successfully on 21-APR-21 09.13.38.257725 AM\r\nInterim patch 32399816 (OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816)):\r\n  Binary registry: Not installed\r\n  PDB CDB$ROOT: Not installed\r\n  PDB PDB$SEED: Not installed\r\n  PDB PDB1912: Applied successfully on 21-APR-21 09.13.38.231464 AM\r\nInterim patch 32876380 (OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380)):\r\n  Binary registry: Installed\r\n  PDB CDB$ROOT: Applied successfully on 23-JUL-21 03.27.54.717269 PM\r\n  PDB PDB$SEED: Applied successfully on 23-JUL-21 03.28.03.883772 PM\r\n  PDB PDB1912: Not installed\r\n\r\nCurrent state of release update SQL patches:\r\n  Binary registry:\r\n    19.12.0.0.0 Release_Update 210716141810: Installed\r\n  PDB CDB$ROOT:\r\n    Applied 19.12.0.0.0 Release_Update 210716141810 successfully on 23-JUL-21 03.27.54.713346 PM\r\n  PDB PDB$SEED:\r\n    Applied 19.12.0.0.0 Release_Update 210716141810 successfully on 23-JUL-21 03.28.03.879588 PM\r\n  PDB PDB1912:\r\n    Applied 19.11.0.0.0 Release_Update 210413004009 successfully on 21-APR-21 09.13.38.227152 AM\r\n\r\nAdding patches to installation queue and performing prereq checks...done\r\nInstallation queue:\r\n  For the following PDBs: CDB$ROOT PDB$SEED\r\n    No interim patches need to be rolled back\r\n    No release update patches need to be installed\r\n    No interim patches need to be applied\r\n  For the following PDBs: PDB1912\r\n    The following interim patches will be rolled back:\r\n      32399816 (OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816))\r\n      30310195 (DBSAT REPORTED DISABLED CONSTRAINTS FOR SHARDING  STS_CHUNKS ON GSMADMIN_INTERNAL.SHARD_TS)\r\n    Patch 32904851 (Database Release Update : 19.12.0.0.210720 (32904851)):\r\n      Apply from 19.11.0.0.0 Release_Update 210413004009 to 19.12.0.0.0 Release_Update 210716141810\r\n    The following interim patches will be applied:\r\n      32876380 (OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380))\r\n\r\nInstalling patches...\r\nPatch installation complete.  Total patches installed: 4\r\n\r\nValidating logfiles...done\r\nPatch 32399816 rollback (pdb PDB1912): SUCCESS\r\n  logfile: \/u02\/app\/oracle\/cfgtoollogs\/sqlpatch\/32399816\/24099425\/32399816_rollback_RJ1912_PDB1912_2021Sep09_18_17_47.log (no errors)\r\nPatch 30310195 rollback (pdb PDB1912): SUCCESS\r\n  logfile: \/u02\/app\/oracle\/cfgtoollogs\/sqlpatch\/30310195\/24121718\/30310195_rollback_RJ1912_PDB1912_2021Sep09_18_18_00.log (no errors)\r\nPatch 32904851 apply (pdb PDB1912): SUCCESS\r\n  logfile: \/u02\/app\/oracle\/cfgtoollogs\/sqlpatch\/32904851\/24343243\/32904851_apply_RJ1912_PDB1912_2021Sep09_18_18_07.log (no errors)\r\nPatch 32876380 apply (pdb PDB1912): SUCCESS\r\n  logfile: \/u02\/app\/oracle\/cfgtoollogs\/sqlpatch\/32876380\/24269510\/32876380_apply_RJ1912_PDB1912_2021Sep09_18_18_00.log (no errors)\r\nSQL Patching tool complete on Thu Sep  9 18:19:13 2021\r\n[oracle@exacs-c0gab1 OPatch]$<\/pre>\n<p>And now if I try to reopen the PDB:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">[oracle@exacs-c0gab1 OPatch]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 9 18:23:27 2021\r\nVersion 19.12.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\r\nVersion 19.12.0.0.0\r\n\r\nSQL&gt; alter pluggable database PDB1912 close;\r\n\r\nPluggable database altered.\r\n\r\nSQL&gt; alter pluggable database PDB1912 open;\r\n\r\nPluggable database altered.\r\n\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         5 PDB1912                        READ WRITE NO\r\nSQL&gt;\r\n<\/pre>\n<p>And it worked! So creating snapshot clones between different RU releases can be a nice way for patching testing of your master copies.<\/p>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-14679 jlk' href='javascript:void(0)' data-task='like' data-post_id='14679' data-nonce='7596861fb6' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-14679 lc'>+3<\/span><\/a><\/div><\/div> <div class='status-14679 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Those days, I was testing if it is possible to create a snapshot sparse clone in one database referencing a PDB on a lower release (like 19.11), and later applying datapatch on this cloned PDB to take it to the higher release (like 19.12). Technically I couldn&#8217;t see any constraint, given the Snapshot Copy requirements &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-14679","post","type-post","status-publish","format-standard","hentry","category-database-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating a snapshot sparse clone from a different Release Update - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/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.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Creating a snapshot sparse clone from a different Release Update\",\"datePublished\":\"2021-09-09T18:26:55+00:00\",\"dateModified\":\"2021-09-09T18:37:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/\"},\"wordCount\":163,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/img_613a4ab905de8.png\",\"articleSection\":[\"Oracle Database General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/\",\"name\":\"Creating a snapshot sparse clone from a different Release Update - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/img_613a4ab905de8.png\",\"datePublished\":\"2021-09-09T18:26:55+00:00\",\"dateModified\":\"2021-09-09T18:37:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/img_613a4ab905de8.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/img_613a4ab905de8.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/09\\\/creating-a-snapshot-sparse-clone-from-a-different-release-update\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a snapshot sparse clone from a different Release Update\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a snapshot sparse clone from a different Release Update - DBA - Rodrigo Jorge - Oracle Tips and Guides","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.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Creating a snapshot sparse clone from a different Release Update","datePublished":"2021-09-09T18:26:55+00:00","dateModified":"2021-09-09T18:37:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/"},"wordCount":163,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_613a4ab905de8.png","articleSection":["Oracle Database General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/","url":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/","name":"Creating a snapshot sparse clone from a different Release Update - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/#primaryimage"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_613a4ab905de8.png","datePublished":"2021-09-09T18:26:55+00:00","dateModified":"2021-09-09T18:37:13+00:00","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/#primaryimage","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_613a4ab905de8.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/09\/img_613a4ab905de8.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/09\/creating-a-snapshot-sparse-clone-from-a-different-release-update\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Creating a snapshot sparse clone from a different Release Update"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14679","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=14679"}],"version-history":[{"count":5,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14679\/revisions"}],"predecessor-version":[{"id":14687,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14679\/revisions\/14687"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=14679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=14679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=14679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}