{"id":16701,"date":"2021-09-29T13:30:28","date_gmt":"2021-09-29T11:30:28","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/"},"modified":"2021-09-29T13:30:28","modified_gmt":"2021-09-29T11:30:28","slug":"nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/","title":{"rendered":"Nutanix Era with oracle databases : Part 5 \u2013 Clone an oracle database"},"content":{"rendered":"<p>Now that we have our ORATEST database provisioned (see <a href=\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-3-provision-an-oracle-database\/\">Nutanix Era blog part 3<\/a>), that we could run snapshot and take Log Catch Up (see <a href=\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-4-taking-a-snapshot-and-running-log-catch-up\/?lang=en\">Nutanix Era Blog part 4<\/a>), we will now see how we can clone an oracle database. <\/p>\n<p>For more information on Nutanix products, I would encourage you to visit <a href=\"http:\/\/www.nutanix.com\/switzerland\">Nutanix website<\/a>.<\/p>\n<table style=\"border: none\">\n<tr>\n<td bgcolor=\"#FFFFFF\" style=\"border: none;vertical-align: middle\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix-Era-logo-2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix-Era-logo-2.png\" alt=\"\" width=\"300\" height=\"57\" class=\"alignleft size-medium wp-image-51055\" \/><\/a><\/td>\n<td bgcolor=\"#FFFFFF\" style=\"border: none\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aws-logo.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aws-logo.jpg\" alt=\"\" width=\"227\" height=\"170\" class=\"alignleft size-medium wp-image-51435\" \/><\/a><\/td>\n<\/tr>\n<\/table>\n<p><!--more--><\/p>\n<h3>Database Menu<\/h3>\n<p>Source database and clone database list are reachable from Nutanix Era Databases menu :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_1.png\" alt=\"\" width=\"187\" height=\"300\" class=\"alignleft size-medium wp-image-51728\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<p>You can list the source databases :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_2.png\" alt=\"\" width=\"300\" height=\"48\" class=\"alignleft size-medium wp-image-51729\" \/><\/a><br \/>\n<\/br><\/p>\n<p>You can list the clone databases :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_3.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_3.png\" alt=\"\" width=\"300\" height=\"53\" class=\"alignleft size-medium wp-image-51731\" \/><\/a><br \/>\n<\/br><\/p>\n<h3>Clone a source database<\/h3>\n<p>Clone databases are created from the Nutanix Era Time Machines menu :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_4.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_4.png\" alt=\"\" width=\"233\" height=\"300\" class=\"alignleft size-medium wp-image-51735\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<h4>Authorize Database Servers VMs<\/h4>\n<p>During a clone of a source database we can decide either to create a new VM that will host the clone, or to use an existing one that is already part of the authorize database servers VMs. Those authorized VM can be managed from the &#8220;Authorize Database Servers VMs&#8221; Menu that can be reachable clicking on Actions after having selected the appropriate Time Machine of the source database we would like to clone :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_5.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_5.png\" alt=\"\" width=\"205\" height=\"300\" class=\"alignleft size-medium wp-image-51737\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<p>We just need to move the appropriate existing VM we would like to host our future clone.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_6.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_6.png\" alt=\"\" width=\"300\" height=\"213\" class=\"alignleft size-medium wp-image-51739\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<p>Here in our example, we will authorized the VM named ORADEMO1-VM_clone :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_7.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_7.png\" alt=\"\" width=\"300\" height=\"215\" class=\"alignleft size-medium wp-image-51742\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<p>This can also be done directly from the clone menu clicking the + button :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_8.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_8.png\" alt=\"\" width=\"300\" height=\"92\" class=\"alignleft size-medium wp-image-51743\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<p><strong>It is important to know that for Oracle database case, only VM created for clones can be added to the authorized database servers VMs and host other clones. Source database VMs can not be added to the authorised VM list been able to host clones.<\/strong><\/p>\n<h4>Let&#8217;s clone an oracle database!<\/h4>\n<p>Let&#8217;s clone our oracle source database ORATEST that we provisioned earlier.<\/p>\n<p>Clicking on the ORATEST_TM source database time machine, we will be able to enter the Time Machine part for that specific source database. From the Actions menu, we will click on &#8220;Create Single Instance Database Clone&#8221; :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_9-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_9-1.png\" alt=\"\" width=\"300\" height=\"151\" class=\"alignleft size-medium wp-image-51750\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<p>We can create the clone based on existing snapshot or using &#8220;Point in Time&#8221;. For oracle database this would restore the previous snapshot and recover all archive logs that was secured during Log Catch Up. Let&#8217;s clone our database using the last &#8220;Point in Time&#8221;.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_10.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_10.png\" alt=\"\" width=\"300\" height=\"246\" class=\"alignleft size-medium wp-image-51751\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<p>We will use existing ORADEMo1-VM_clone clone VM :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_11.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_11.png\" alt=\"\" width=\"300\" height=\"136\" class=\"alignleft size-medium wp-image-51753\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<p>We will give a name for the database clone and push the button clone :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_12.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_12.png\" alt=\"\" width=\"300\" height=\"153\" class=\"alignleft size-medium wp-image-51756\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<p>Note that we could schedule automatic refresh of the clone by using below option :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_13.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_13.png\" alt=\"\" width=\"181\" height=\"27\" class=\"alignleft size-full wp-image-51759\" \/><\/a><br \/>\n<\/br><\/p>\n<p>And we could give the refresh frequency and the time when the refresh needs to be executed :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_14.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_14.png\" alt=\"\" width=\"300\" height=\"161\" class=\"alignleft size-medium wp-image-51761\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<p>And remove the schedule after a number of days :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_15.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_15.png\" alt=\"\" width=\"300\" height=\"97\" class=\"alignleft size-medium wp-image-51764\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<p>The cloning output can be seen from the operations menu :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_16.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_16.png\" alt=\"\" width=\"300\" height=\"104\" class=\"alignleft size-medium wp-image-51775\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<h4>What is happening exactly during the cloning?<\/h4>\n<h5>Source database<\/h5>\n<p>On the source database, nothing :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1]\">\noracle@test1-VM:\/home\/oracle\/ [ORATEST] taa\n2021-09-29T08:04:17.112961+00:00\nNET  (PID:350610): Archived Log entry 645 added for T-1.S-654 ID 0xd7835926 LAD:1\n2021-09-29T08:33:12.862502+00:00\nALTER SYSTEM ARCHIVE LOG\n2021-09-29T08:33:12.884826+00:00\nThread 1 advanced to log sequence 656 (LGWR switch),  current SCN: 3913958\n  Current log# 2 seq# 656 mem# 0: \/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/onlinelog\/o1_mf_2_jk7r196j_.log\n  Current log# 2 seq# 656 mem# 1: \/u02\/app\/oracle\/oradata\/fra_ORATEST\/ORATEST\/onlinelog\/o1_mf_2_jk7r19gf_.log\n2021-09-29T08:33:12.982560+00:00\nNET  (PID:360220): Archived Log entry 646 added for T-1.S-655 ID 0xd7835926 LAD:1\n2021-09-29T09:02:12.738644+00:00\nALTER SYSTEM ARCHIVE LOG\n2021-09-29T09:02:12.759186+00:00\nThread 1 advanced to log sequence 657 (LGWR switch),  current SCN: 3915489\n  Current log# 3 seq# 657 mem# 0: \/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/onlinelog\/o1_mf_3_jk7r1986_.log\n  Current log# 3 seq# 657 mem# 1: \/u02\/app\/oracle\/oradata\/fra_ORATEST\/ORATEST\/onlinelog\/o1_mf_3_jk7r19lz_.log\n2021-09-29T09:02:12.822721+00:00\nNET  (PID:369894): Archived Log entry 647 added for T-1.S-656 ID 0xd7835926 LAD:1\n<\/pre>\n<p><\/br><\/p>\n<h5>Clone VM<\/h5>\n<p>On the clone VM, before cloning, there is no database file system. Only \/u02 which will contain the oracle binaries (ORACLE_HOME) and other file system used for Era engine. :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,19]\">\n[oracle@ORADEMO1-VM-clo trace]$ df -h\nFilesystem                                                                                                                      Size  Used Avail Use% Mounted on\ndevtmpfs                                                                                                                        7.7G     0  7.7G   0% \/dev\ntmpfs                                                                                                                            12G     0   12G   0% \/dev\/shm\ntmpfs                                                                                                                           7.7G   17M  7.7G   1% \/run\ntmpfs                                                                                                                           7.7G     0  7.7G   0% \/sys\/fs\/cgroup\n\/dev\/mapper\/vgroot--lv-root                                                                                                     6.0G  118M  5.9G   2% \/\n\/dev\/mapper\/vgroot--lv-usr                                                                                                      3.0G  1.6G  1.5G  53% \/usr\n\/dev\/mapper\/vgroot--lv-var                                                                                                      3.0G  448M  2.6G  15% \/var\n\/dev\/mapper\/vgroot--lv-home                                                                                                     4.0G   73M  4.0G   2% \/home\n\/dev\/mapper\/vgroot--lv-opt                                                                                                      4.0G   69M  4.0G   2% \/opt\n\/dev\/mapper\/vgroot--lv-tmp                                                                                                      3.0G  954M  2.1G  32% \/tmp\n\/dev\/mapper\/ntnx_era_agent_vg_ff05dbb5a2084503b80ccc72156b5383-ntnx_era_agent_lv_era_software_ff05dbb5a2084503b80ccc72156b5383  2.9G  668M  2.1G  25% \/opt\/era_base\/era_engine\n\/dev\/sda1                                                                                                                       496M  224M  273M  46% \/boot\n\/dev\/mapper\/ntnx_era_agent_vg_ff05dbb5a2084503b80ccc72156b5383-ntnx_era_agent_lv_era_logs_ff05dbb5a2084503b80ccc72156b5383      7.7G   55M  7.2G   1% \/opt\/era_base\/logs\n\/dev\/mapper\/ntnx_era_agent_vg_ff05dbb5a2084503b80ccc72156b5383-ntnx_era_agent_lv_era_config_ff05dbb5a2084503b80ccc72156b5383     93M  1.6M   85M   2% \/opt\/era_base\/cfg\n\/dev\/sda2                                                                                                                      1022M   12K 1022M   1% \/boot\/efi\ntmpfs                                                                                                                           1.6G     0  1.6G   0% \/run\/user\/54321\n\/dev\/sdb                                                                                                                         50G  9.8G   38G  21% \/u02\n<\/pre>\n<p><\/br><\/p>\n<p>Also no ORACLE_SID defined in the oratab file :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[oracle@ORADEMO1-VM-clo trace]$ cat \/etc\/oratab\n#\n\n\n\n# This file is used by ORACLE utilities.  It is created by root.sh\n# and updated by either Database Configuration Assistant while creating\n# a database or ASM Configuration Assistant while creating ASM instance.\n\n# A colon, ':', is used as the field terminator.  A new line terminates\n# the entry.  Lines beginning with a pound sign, '#', are comments.\n#\n# Entries are of the form:\n#   $ORACLE_SID:$ORACLE_HOME::\n#\n# The first and second fields are the system identifier and home\n# directory of the database respectively.  The third field indicates\n# to the dbstart utility that the database should , \"Y\", or should not,\n# \"N\", be brought up at system boot time.\n#\n# Multiple entries with the same $ORACLE_SID are not allowed.\n#\n#\nrdbms_19000_1:\/u02\/app\/oracle\/product\/19.0.0\/dbhome_1:D\n[oracle@ORADEMO1-VM-clo trace]$\n<\/pre>\n<p><\/br><\/p>\n<p>After some pre-processing actions and checking the database layout information that are provided, Nutanix Era system will restore the appropriate snapshot.<\/p>\n<p>Once this is done, the recovering part will begin. We will see that now we have some new file system been mounted :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,20,21,22]\">\n[oracle@ORADEMO1-VM-clo trace]$ df -h\nFilesystem                                                                                                                      Size  Used Avail Use% Mounted on\ndevtmpfs                                                                                                                        7.7G     0  7.7G   0% \/dev\ntmpfs                                                                                                                            12G  184K   12G   1% \/dev\/shm\ntmpfs                                                                                                                           7.7G   17M  7.7G   1% \/run\ntmpfs                                                                                                                           7.7G     0  7.7G   0% \/sys\/fs\/cgroup\n\/dev\/mapper\/vgroot--lv-root                                                                                                     6.0G  118M  5.9G   2% \/\n\/dev\/mapper\/vgroot--lv-usr                                                                                                      3.0G  1.6G  1.5G  53% \/usr\n\/dev\/mapper\/vgroot--lv-var                                                                                                      3.0G  450M  2.6G  15% \/var\n\/dev\/mapper\/vgroot--lv-home                                                                                                     4.0G   74M  4.0G   2% \/home\n\/dev\/mapper\/vgroot--lv-opt                                                                                                      4.0G   69M  4.0G   2% \/opt\n\/dev\/mapper\/vgroot--lv-tmp                                                                                                      3.0G  954M  2.1G  32% \/tmp\n\/dev\/mapper\/ntnx_era_agent_vg_ff05dbb5a2084503b80ccc72156b5383-ntnx_era_agent_lv_era_software_ff05dbb5a2084503b80ccc72156b5383  2.9G  668M  2.1G  25% \/opt\/era_base\/era_engine\n\/dev\/sda1                                                                                                                       496M  224M  273M  46% \/boot\n\/dev\/mapper\/ntnx_era_agent_vg_ff05dbb5a2084503b80ccc72156b5383-ntnx_era_agent_lv_era_logs_ff05dbb5a2084503b80ccc72156b5383      7.7G   57M  7.2G   1% \/opt\/era_base\/logs\n\/dev\/mapper\/ntnx_era_agent_vg_ff05dbb5a2084503b80ccc72156b5383-ntnx_era_agent_lv_era_config_ff05dbb5a2084503b80ccc72156b5383     93M  1.6M   85M   2% \/opt\/era_base\/cfg\n\/dev\/sda2                                                                                                                      1022M   12K 1022M   1% \/boot\/efi\ntmpfs                                                                                                                           1.6G     0  1.6G   0% \/run\/user\/54321\n\/dev\/sdb                                                                                                                         50G  9.8G   38G  21% \/u02\n\/dev\/mapper\/ntnx_era_dg_log_vg_47aab96bac4343b2a4a73453130a22fd-ntnx_era_agent_lv_47aab96bac4343b2a4a73453130a22fd              197G  8.8G  178G   5% \/tmp\/era_recovery_staging_area_ORATCL1\n\/dev\/mapper\/oradata_ORATEST_vg_ORATCL1-oradata_ORATEST_lv                                                                        20G  3.3G   16G  18% \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\n\/dev\/mapper\/oradata_fra_ORATEST_vg_ORATCL1-oradata_fra_ORATEST_lv                                                               9.8G  3.1G  6.2G  34% \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\n<\/pre>\n<p><\/br><\/p>\n<p>The file system \/tmp\/era_recovery_staging_area_ORATCL1 will contain the restored Log Catch Up file (archive log files) :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[oracle@ORADEMO1-VM-clo trace]$ ls -l \/tmp\/era_recovery_staging_area_ORATCL1\/logs_0\/20210929*\n\/tmp\/era_recovery_staging_area_ORATCL1\/logs_0\/20210929080417_20210929083312:\ntotal 54284\n-rwxr-xr-x. 1 oracle root 12173312 Sep 29 08:34 control01_1084523635.ctl\n-rwxr-xr-x. 1 oracle root 43411456 Sep 29 08:34 o1_mf_1_655_jo8968wd_.arc\n\n\/tmp\/era_recovery_staging_area_ORATCL1\/logs_0\/20210929083312_20210929090212:\ntotal 15388\n-rwxr-xr-x. 1 oracle root 12173312 Sep 29 09:03 control01_1084525374.ctl\n-rwxr-xr-x. 1 oracle root  3584000 Sep 29 09:03 o1_mf_1_656_jo8bwns0_.arc\n<\/pre>\n<p><\/br><\/p>\n<p>This will be used to restore the archive log in the appropriate FRA stored in the \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1 file system. There will be 2 directories : one with the source database name and another one with the clone database name :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[oracle@ORADEMO1-VM-clo trace]$ ls -l \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\ntotal 24\ndrwx------. 2 oracle oinstall 16384 Aug 11 14:31 lost+found\ndrwxr-x---. 3 oracle oinstall  4096 Sep 29 09:14 ORATCL1\ndrwxr-x---. 6 oracle oinstall  4096 Aug 11 14:54 ORATEST\n<\/pre>\n<p><\/br><\/p>\n<p>The clone database FRA will be first empty, as the restore and recover will be done with the source database name (db_name=ORATEST) :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[oracle@ORADEMO1-VM-clo trace]$ ls -l \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATCL1\/archivelog\/2021_09_29\/\ntotal 0\n[oracle@ORADEMO1-VM-clo trace]$\n<\/pre>\n<p><\/br><\/p>\n<p>The FRA with the source database will contain the restored archive logs if they would be needed :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[oracle@ORADEMO1-VM-clo trace]$ ls -l \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATEST\/archivelog\/2021_09_26\ntotal 29400\n-rw-rw----. 1 oracle oinstall  3886592 Sep 26 00:13 o1_mf_1_602_jnzgrr6g_.arc\n-rw-rw----. 1 oracle oinstall 22735872 Sep 26 00:42 o1_mf_1_603_jnzjhdog_.arc\n-rw-rw----. 1 oracle oinstall  3478528 Sep 26 01:00 o1_mf_1_604_jnzkjv9h_.arc\n<\/pre>\n<p><\/br><\/p>\n<p>The datafile file system \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1 will contain datafiles for the new clone in 2 sub-directories : One with the source database name and one with the clone database name. :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,7]\">\n[oracle@ORADEMO1-VM-clo trace]$ ls -ltrh \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/\ntotal 2.7G\n-rw-r-----. 1 oracle oinstall  5.1M Sep 29 09:21 o1_mf_users_jk7r05t2_.dbf\n-rw-r-----. 1 oracle oinstall  513M Sep 29 09:21 o1_mf_undotbsp_jk7rk221_.dbf\n-rw-r-----. 1 oracle oinstall  1.2G Sep 29 09:26 o1_mf_sysaux_jk7qzopd_.dbf\n-rw-r-----. 1 oracle oinstall 1001M Sep 29 09:26 o1_mf_system_jk7qywmo_.dbf\n[oracle@ORADEMO1-VM-clo trace]$ ls -ltrh \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/datafile\/\ntotal 1.1G\n-rw-r-----. 1 oracle oinstall 257M Sep 29 09:19 o1_mf_temptbs__jo8cs8w2_.tmp\n-rw-r-----. 1 oracle oinstall 1.1G Sep 29 09:26 o1_mf_undotbs__jo8ct5gs_.dbf\n[oracle@ORADEMO1-VM-clo trace]$\n<\/pre>\n<p><\/br><\/p>\n<p>Once restore will be completed, the clone database will have its own archive logs :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,5]\">\n[oracle@ORADEMO1-VM-clo trace]$ ls -l \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATCL1\/archivelog\/\ntotal 4\ndrwxr-x---. 2 oracle oinstall 4096 Sep 29 09:16 2021_09_29\n\n[oracle@ORADEMO1-VM-clo trace]$ ls -l \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATCL1\/archivelog\/2021_09_29\/\ntotal 25672\n-rw-r-----. 1 oracle oinstall 22735872 Sep 29 09:16 o1_mf_1_603_jo8cr0vn_.arc\n-rw-r-----. 1 oracle oinstall  3478528 Sep 29 09:16 o1_mf_1_604_jo8cr0sr_.arc\n-rw-r-----. 1 oracle oinstall    67584 Sep 29 09:16 o1_mf_1_605_jo8cr0ts_.arc\n<\/pre>\n<p><\/br><\/p>\n<p>Once the clone database operation is completed, the \/tmp\/era_recovery_staging_area_ORATCL1 file system will disappear :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[oracle@ORADEMO1-VM-clo trace]$ df -h\nFilesystem                                                                                                                      Size  Used Avail Use% Mounted on\ndevtmpfs                                                                                                                        7.7G     0  7.7G   0% \/dev\ntmpfs                                                                                                                            12G     0   12G   0% \/dev\/shm\ntmpfs                                                                                                                           7.7G   17M  7.7G   1% \/run\ntmpfs                                                                                                                           7.7G     0  7.7G   0% \/sys\/fs\/cgroup\n\/dev\/mapper\/vgroot--lv-root                                                                                                     6.0G  118M  5.9G   2% \/\n\/dev\/mapper\/vgroot--lv-usr                                                                                                      3.0G  1.6G  1.5G  53% \/usr\n\/dev\/mapper\/vgroot--lv-var                                                                                                      3.0G  456M  2.6G  15% \/var\n\/dev\/mapper\/vgroot--lv-home                                                                                                     4.0G   73M  4.0G   2% \/home\n\/dev\/mapper\/vgroot--lv-opt                                                                                                      4.0G   69M  4.0G   2% \/opt\n\/dev\/mapper\/vgroot--lv-tmp                                                                                                      3.0G  981M  2.1G  33% \/tmp\n\/dev\/mapper\/ntnx_era_agent_vg_ff05dbb5a2084503b80ccc72156b5383-ntnx_era_agent_lv_era_software_ff05dbb5a2084503b80ccc72156b5383  2.9G  668M  2.1G  25% \/opt\/era_base\/era_engine\n\/dev\/sda1                                                                                                                       496M  224M  273M  46% \/boot\n\/dev\/mapper\/ntnx_era_agent_vg_ff05dbb5a2084503b80ccc72156b5383-ntnx_era_agent_lv_era_logs_ff05dbb5a2084503b80ccc72156b5383      7.7G   60M  7.2G   1% \/opt\/era_base\/logs\n\/dev\/mapper\/ntnx_era_agent_vg_ff05dbb5a2084503b80ccc72156b5383-ntnx_era_agent_lv_era_config_ff05dbb5a2084503b80ccc72156b5383     93M  1.6M   85M   2% \/opt\/era_base\/cfg\n\/dev\/sda2                                                                                                                      1022M   12K 1022M   1% \/boot\/efi\ntmpfs                                                                                                                           1.6G     0  1.6G   0% \/run\/user\/54321\n\/dev\/sdb                                                                                                                         50G  9.8G   38G  21% \/u02\n\/dev\/mapper\/oradata_ORATEST_vg_ORATCL1-oradata_ORATEST_lv                                                                        20G  4.3G   15G  24% \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\n\/dev\/mapper\/oradata_fra_ORATEST_vg_ORATCL1-oradata_fra_ORATEST_lv                                                               9.8G  3.1G  6.2G  34% \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\n[oracle@ORADEMO1-VM-clo trace]$\n<\/pre>\n<p><\/br><\/p>\n<p>If we study the alert log file, we can easily understand most important steps of what happened during the clone :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,4,7]\">\n[oracle@ORADEMO1-VM-clo trace]$ pwd\n\/u02\/app\/oracle\/diag\/rdbms\/oratcl1\/ORATCL1\/trace\n\n[oracle@ORADEMO1-VM-clo trace]$ ls -l alert_ORATCL1.log\n-rw-r-----. 1 oracle oinstall 263969 Sep 29 09:21 alert_ORATCL1.log\n\n[oracle@ORADEMO1-VM-clo trace]$ more alert_ORATCL1.log\n<\/pre>\n<p><\/br><\/p>\n<p>We can first note the following :<\/p>\n<ul>\n<li>The parameter file has been restored<\/li>\n<li>The OMF create parameters have been set<\/li>\n<li>The recovery file destination has been set<\/li>\n<li>The instance name and db_unique_name has been set to the clone one<\/li>\n<li>The db_name is still the source one<\/li>\n<\/ul>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,15,16,17,18,23,27,28]\">\nUsing parameter settings in server-side spfile \/u02\/app\/oracle\/product\/19.0.0\/dbhome_1\/dbs\/spfileORATCL1.ora\nSystem parameters with non-default values:\n  processes                = 300\n  nls_language             = \"AMERICAN\"\n  nls_territory            = \"AMERICA\"\n  filesystemio_options     = \"SETALL\"\n  sga_target               = 2G\n  memory_target            = 0\n  control_files            = \"\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/controlfile\/o1_mf_jk7r16xw_.ctl\"\n  control_files            = \"\/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATEST\/controlfile\/o1_mf_jk7r16ys_.ctl\"\n  db_block_size            = 8192\n  compatible               = \"19.0.0\"\n  log_archive_dest_1       = \"LOCATION=USE_DB_RECOVERY_FILE_DEST\"\n  log_archive_format       = \"%t_%s_%r.dbf\"\n  db_create_file_dest      = \"\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\"\n  db_create_online_log_dest_1= \"\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\"\n  db_create_online_log_dest_2= \"\/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\"\n  db_recovery_file_dest    = \"\/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\"\n  db_recovery_file_dest_size= 10G\n  fast_start_mttr_target   = 300\n  undo_tablespace          = \"UNDOTBSP1\"\n  remote_login_passwordfile= \"EXCLUSIVE\"\n  instance_name            = \"ORATCL1\"\n  shared_servers           = 0\n  audit_file_dest          = \"\/u02\/app\/oracle\/admin\/ORATCL1\/adump\"\n  audit_trail              = \"DB\"\n  db_name                  = \"ORATEST\"\n  db_unique_name           = \"ORATCL1\"\n  open_cursors             = 300\n  parallel_threads_per_cpu = 1\n  pga_aggregate_target     = 1G\n  dg_broker_start          = FALSE\n  diagnostic_dest          = \"\/u02\/app\/oracle\"\n<\/pre>\n<p><\/br><\/p>\n<p>Database has been started in mount mode using exclusive mode :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nDatabase mounted in Exclusive Mode\nLost write protection disabled\n.... (PID:32835): Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST [krsd.c:18222]\nCompleted: alter database mount\n<\/pre>\n<p><\/br><\/p>\n<p>Datafiles have been renamed to the new file system snapshot mounted on the clone VMs.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n2021-09-29T09:15:50.060562+00:00\n\t\t\t\t\t\talter database rename file '\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_sysaux_jk7qzopd_.dbf' to '\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\n\/ORATEST\/datafile\/o1_mf_sysaux_jk7qzopd_.dbf'\n2021-09-29T09:15:50.074132+00:00\nDeleted Oracle managed file \/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_sysaux_jk7qzopd_.dbf\nCompleted: \t\t\t\t\t\talter database rename file '\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_sysaux_jk7qzopd_.dbf' to '\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\n_ORATCL1\/ORATEST\/datafile\/o1_mf_sysaux_jk7qzopd_.dbf'\n\t\t\t\t\t\talter database rename file '\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_system_jk7qywmo_.dbf' to '\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\n\/ORATEST\/datafile\/o1_mf_system_jk7qywmo_.dbf'\nDeleted Oracle managed file \/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_system_jk7qywmo_.dbf\nCompleted:\n<\/pre>\n<p><\/br><\/p>\n<p>The needed archive logs will now be restored using the temporary Log Catch Up file system (\/tmp\/era_recovery_staging_area_ORATCL1) :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nalter database recover\n if needed start until time '2021\/09\/29 08:04:17' using backup controlfile\n2021-09-29T09:16:33.631940+00:00\nMedia Recovery Start\n Started logmerger process\n2021-09-29T09:16:33.691420+00:00\nParallel Media Recovery started with 2 slaves\nORA-279 signalled during: alter database recover\n if needed start until time '2021\/09\/29 08:04:17' using backup controlfile\n...\nalter database recover logfile '\/tmp\/era_recovery_staging_area_ORATCL1\/logs_0\/20210926004220_20210926010104\/o1_mf_1_605_jnzkljv2_.arc'\n2021-09-29T09:16:34.276907+00:00\nMedia Recovery Log \/tmp\/era_recovery_staging_area_ORATCL1\/logs_0\/20210926004220_20210926010104\/o1_mf_1_605_jnzkljv2_.arc\nORA-279 signalled during: alter database recover logfile '\/tmp\/era_recovery_staging_area_ORATCL1\/logs_0\/20210926004220_20210926010104\/o1_mf_1_605_jnzkljv2_.arc'...\nalter database recover logfile '\/tmp\/era_recovery_staging_area_ORATCL1\/logs_0\/20210926010104_20210926013011\/o1_mf_1_606_jnzm93vc_.arc'\n2021-09-29T09:16:34.483362+00:00\nMedia Recovery Log \/tmp\/era_recovery_staging_area_ORATCL1\/logs_0\/20210926010104_20210926013011\/o1_mf_1_606_jnzm93vc_.arc\nORA-279 signalled during: alter database recover logfile '\/tmp\/era_recovery_staging_area_ORATCL1\/logs_0\/20210926010104_20210926013011\/o1_mf_1_606_jnzm93vc_.arc'...\nalter database recover logfile '\/tmp\/era_recovery_staging_area_ORATCL1\/logs_0\/20210926013011_20210926015916\/o1_mf_1_607_jnznznq5_.arc'\n<\/pre>\n<p><\/br><\/p>\n<p>The online log file will be cleared :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nNET  (PID:33711): Clearing online redo logfile 1 \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/onlinelog\/o1_mf_1_jk7r195y_.log\nNET  (PID:33711): Clearing online redo logfile 2 \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/onlinelog\/o1_mf_2_jk7r196j_.log\nNET  (PID:33711): Clearing online redo logfile 3 \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/onlinelog\/o1_mf_3_jk7r1986_.log\nClearing online log 1 of thread 1 sequence number 604\nClearing online log 2 of thread 1 sequence number 605\nClearing online log 3 of thread 1 sequence number 603\n2021-09-29T09:16:51.991586+00:00\nNET  (PID:33711): Clearing online redo logfile 1 complete\nNET  (PID:33711): Clearing online redo logfile 2 complete\nNET  (PID:33711): Clearing online redo logfile 3 complete\nResetting resetlogs activation ID 3615709478 (0xd7835926)\nOnline log \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/onlinelog\/o1_mf_1_jk7r195y_.log: Thread 1 Group 1 was previously cleared\nOnline log \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATEST\/onlinelog\/o1_mf_1_jk7r19br_.log: Thread 1 Group 1 was previously cleared\nOnline log \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/onlinelog\/o1_mf_2_jk7r196j_.log: Thread 1 Group 2 was previously cleared\nOnline log \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATEST\/onlinelog\/o1_mf_2_jk7r19gf_.log: Thread 1 Group 2 was previously cleared\nOnline log \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/onlinelog\/o1_mf_3_jk7r1986_.log: Thread 1 Group 3 was previously cleared\nOnline log \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATEST\/onlinelog\/o1_mf_3_jk7r19lz_.log: Thread 1 Group 3 was previously cleared\n<\/pre>\n<p><\/br><\/p>\n<p>Database name has been changed to new clone name :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSuccesfully changed database name and ID.\n*** DBNEWID utility finished succesfully ***\n<\/pre>\n<p><\/br><\/p>\n<p>And we can see that db_name is now appropriately set to the new clone name :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [31]\">\nUsing parameter settings in client-side pfile \/u02\/app\/oracle\/product\/19.0.0\/dbhome_1\/dbs\/initORATCL1.ora on machine ORADEMO1-VM-clo\nSystem parameters with non-default values:\n  processes                = 300\n  nls_language             = \"AMERICAN\"\n  nls_territory            = \"AMERICA\"\n  filesystemio_options     = \"SETALL\"\n  service_names            = \"ORATCL1\"\n  sga_target               = 2G\n  memory_target            = 0\n  control_files            = \"\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/controlfile\/o1_mf_jk7r16xw_.ctl\"\n  control_files            = \"\/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATEST\/controlfile\/o1_mf_jk7r16ys_.ctl\"\n  db_block_size            = 8192\n  compatible               = \"19.0.0\"\n  log_archive_dest_1       = \"LOCATION=USE_DB_RECOVERY_FILE_DEST\"\n  log_archive_format       = \"%t_%s_%r.dbf\"\n  db_create_file_dest      = \"\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\"\n  db_create_online_log_dest_1= \"\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\"\n  db_create_online_log_dest_2= \"\/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\"\n  db_recovery_file_dest    = \"\/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\"\n  db_recovery_file_dest_size= 10G\n  fast_start_mttr_target   = 300\n  undo_tablespace          = \"UNDOTBS_ORATCL1\"\n  remote_login_passwordfile= \"EXCLUSIVE\"\n  instance_name            = \"ORATCL1\"\n  dispatchers              = \"(PROTOCOL=tcp)(LISTENER=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.129.51)(PORT=1521)))\"\n  shared_servers           = 0\n  local_listener           = \"(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.129.51)(PORT=1521))\"\n  job_queue_processes      = 40\n  audit_file_dest          = \"\/u02\/app\/oracle\/admin\/ORATCL1\/adump\"\n  audit_trail              = \"DB\"\n  db_name                  = \"ORATCL1\"\n  db_unique_name           = \"ORATCL1\"\n  open_cursors             = 300\n  parallel_threads_per_cpu = 1\n  pga_aggregate_target     = 1G\n  dg_broker_start          = FALSE\n  diagnostic_dest          = \"\/u02\/app\/oracle\"\n2021-09-29T09:20:00.695139+00:00\n<\/pre>\n<p><\/br><\/p>\n<p>Finally, the oratab will now contain the new ORACLE SID:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [25]\">\n[oracle@ORADEMO1-VM-clo ~]$ cat \/etc\/oratab\n#\n\n\n\n# This file is used by ORACLE utilities.  It is created by root.sh\n# and updated by either Database Configuration Assistant while creating\n# a database or ASM Configuration Assistant while creating ASM instance.\n\n# A colon, ':', is used as the field terminator.  A new line terminates\n# the entry.  Lines beginning with a pound sign, '#', are comments.\n#\n# Entries are of the form:\n#   $ORACLE_SID:$ORACLE_HOME::\n#\n# The first and second fields are the system identifier and home\n# directory of the database respectively.  The third field indicates\n# to the dbstart utility that the database should , \"Y\", or should not,\n# \"N\", be brought up at system boot time.\n#\n# Multiple entries with the same $ORACLE_SID are not allowed.\n#\n#\nrdbms_19000_1:\/u02\/app\/oracle\/product\/19.0.0\/dbhome_1:D\nORATCL1:\/u02\/app\/oracle\/product\/19.0.0\/dbhome_1:N\n[oracle@ORADEMO1-VM-clo ~]$\n<\/pre>\n<p><\/br><\/p>\n<p>Finally we can see our new clone database in the clone database list :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_17.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_17.png\" alt=\"\" width=\"300\" height=\"59\" class=\"alignleft size-medium wp-image-51792\" \/><\/a><br \/>\n<\/br><br \/>\n<\/br><\/p>\n<h3>What about the online logs after been cleared?<\/h3>\n<p>Online logs have been recreated in appropriate clone database folders :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1]\">\nSQL&gt; select group#, member from v$logfile order by group#;\n\n    GROUP# MEMBER\n---------- ----------------------------------------------------------------------------------------------------\n         1 \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/onlinelog\/o1_mf_1_jo8xsl74_.log\n         1 \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATCL1\/onlinelog\/o1_mf_1_jo8xslhc_.log\n         2 \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/onlinelog\/o1_mf_2_jo8xsloy_.log\n         2 \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATCL1\/onlinelog\/o1_mf_2_jo8xslx7_.log\n         3 \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/onlinelog\/o1_mf_3_jo8xsm4o_.log\n         3 \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATCL1\/onlinelog\/o1_mf_3_jo8xsmcj_.log\n\n6 rows selected.\n<\/pre>\n<p><\/br><\/p>\n<h3> New archive log on the clone database<\/h3>\n<p>As we can see the new clone has now the online log file archived in his own FRA, starting new incarnation (sequence 1) :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,14,16,22,26]\">\noracle@ORADEMO1-VM-clo:\/home\/oracle\/ [rdbms_19000_1] ORATCL1\n********* dbi services Ltd. *********\nSTATUS                 : OPEN\nDB_UNIQUE_NAME         : ORATCL1\nOPEN_MODE              : READ WRITE\nLOG_MODE               : ARCHIVELOG\nDATABASE_ROLE          : PRIMARY\nFLASHBACK_ON           : NO\nFORCE_LOGGING          : NO\nVERSION                : 19.12.0.0.0\nCDB Enabled            : NO\n*************************************\n\noracle@ORADEMO1-VM-clo:\/home\/oracle\/ [ORATCL1] sqh\n\nSQL&gt; !ls -l \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATCL1\/archivelog\/2021_09_29\/\ntotal 25672\n-rw-r-----. 1 oracle oinstall 22735872 Sep 29 09:16 o1_mf_1_603_jo8cr0vn_.arc\n-rw-r-----. 1 oracle oinstall  3478528 Sep 29 09:16 o1_mf_1_604_jo8cr0sr_.arc\n-rw-r-----. 1 oracle oinstall    67584 Sep 29 09:16 o1_mf_1_605_jo8cr0ts_.arc\n\nSQL&gt; ALTER SYSTEM ARCHIVE LOG CURRENT;\n\nSystem altered.\n\nSQL&gt; !ls -l \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATCL1\/archivelog\/2021_09_29\/\ntotal 96572\n-rw-r-----. 1 oracle oinstall 72601600 Sep 29 10:31 o1_mf_1_1_jo8j4cb8_.arc\n-rw-r-----. 1 oracle oinstall 22735872 Sep 29 09:16 o1_mf_1_603_jo8cr0vn_.arc\n-rw-r-----. 1 oracle oinstall  3478528 Sep 29 09:16 o1_mf_1_604_jo8cr0sr_.arc\n-rw-r-----. 1 oracle oinstall    67584 Sep 29 09:16 o1_mf_1_605_jo8cr0ts_.arc\n\nSQL&gt;\n<\/pre>\n<p><\/br><\/p>\n<h3>Clone database datafiles<\/h3>\n<p>As we could see previously, datafiles for clone database are stored in 2 subdirectories : ORATEST (source database name) and ORATCL1 (clone database name).<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,8]\">\noracle@ORADEMO1-VM-clo:\/home\/oracle\/ [ORATCL1] ls -ltrh \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/\ntotal 2.7G\n-rw-r-----. 1 oracle oinstall  513M Sep 29 10:36 o1_mf_undotbsp_jk7rk221_.dbf\n-rw-r-----. 1 oracle oinstall  5.1M Sep 29 10:36 o1_mf_users_jk7r05t2_.dbf\n-rw-r-----. 1 oracle oinstall 1001M Sep 29 11:45 o1_mf_system_jk7qywmo_.dbf\n-rw-r-----. 1 oracle oinstall  1.2G Sep 29 11:45 o1_mf_sysaux_jk7qzopd_.dbf\n\noracle@ORADEMO1-VM-clo:\/home\/oracle\/ [ORATCL1] ls -ltrh \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/datafile\/\ntotal 1.1G\n-rw-r-----. 1 oracle oinstall 257M Sep 29 09:19 o1_mf_temptbs__jo8cs8w2_.tmp\n-rw-r-----. 1 oracle oinstall 1.1G Sep 29 11:41 o1_mf_undotbs__jo8ct5gs_.dbf\noracle@ORADEMO1-VM-clo:\/home\/oracle\/ [ORATCL1]\n<\/pre>\n<p><\/br><\/p>\n<p>This is certainly due to the fact that when cloning a database the base vDisk is made Read Only and 2 new clones are created. One for the original source and another for the clone. The clones have a block mapping with the existing source block extent. It&#8217;s like a copy of the datafiles where only updated block or new block will required new extent space. The source database and the clone database are 2 independant READ\/WRITE databases.<\/p>\n<p>This is confirmed when querying the ORATCL1 clone database :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,11,17,22]\">\nSQL&gt; select name from v$datafile order by name;\n\nNAME\n----------------------------------------------------------------------------------------------------\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/datafile\/o1_mf_undotbs__jo8ct5gs_.dbf\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/o1_mf_sysaux_jk7qzopd_.dbf\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/o1_mf_system_jk7qywmo_.dbf\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/o1_mf_undotbsp_jk7rk221_.dbf\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/o1_mf_users_jk7r05t2_.dbf\n\nSQL&gt; select name from v$tempfile order by name;\n\nNAME\n----------------------------------------------------------------------------------------------------\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/datafile\/o1_mf_temptbs__jo8cs8w2_.tmp\n\nSQL&gt; !du -ha \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/datafile\n1.0M\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/datafile\/o1_mf_temptbs__jo8cs8w2_.tmp\n1.1G\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/datafile\/o1_mf_undotbs__jo8ct5gs_.dbf\n1.1G\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/datafile\n\nSQL&gt; !du -ha \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\n1001M\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/o1_mf_system_jk7qywmo_.dbf\n5.1M\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/o1_mf_users_jk7r05t2_.dbf\n513M\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/o1_mf_undotbsp_jk7rk221_.dbf\n1.2G\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/o1_mf_sysaux_jk7qzopd_.dbf\n2.7G\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\n\nSQL&gt;\n<\/pre>\n<p><\/br><\/p>\n<p>On the ORATEST source database :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,10,16]\">\nSQL&gt; select name from v$datafile order by name;\n\nNAME\n----------------------------------------------------------------------------------------------------\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_sysaux_jk7qzopd_.dbf\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_system_jk7qywmo_.dbf\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_undotbsp_jk7rk221_.dbf\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_users_jk7r05t2_.dbf\n\nSQL&gt; select name from v$tempfile order by name;\n\nNAME\n----------------------------------------------------------------------------------------------------\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_temp_jk7rk1xc_.tmp\n\nSQL&gt; !du -ha \/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/\n1001M\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_system_jk7qywmo_.dbf\n3.5M\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_temp_jk7rk1xc_.tmp\n5.1M\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_users_jk7r05t2_.dbf\n513M\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_undotbsp_jk7rk221_.dbf\n1.2G\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/o1_mf_sysaux_jk7qzopd_.dbf\n2.7G\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/\n\nSQL&gt;\n<\/pre>\n<p><\/br><\/p>\n<p>Let&#8217;s create a new tablespace TSTSOURCE on the ORATEST source database. Datafile is only created on the source of course :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,4,8,15]\">\nSQL&gt; !hostname\ntest1-VM\n\nSQL&gt; create tablespace TSTSOURCE datafile size 10M autoextend on next 100M maxsize 1G;\n\nTablespace created.\n\nSQL&gt; !ls -ltrh \/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/\ntotal 2.7G\n-rw-r-----. 1 oracle oinstall  129M Sep 29 11:55 o1_mf_temp_jk7rk1xc_.tmp\n-rw-r-----. 1 oracle oinstall 1001M Sep 29 12:01 o1_mf_system_jk7qywmo_.dbf\n-rw-r-----. 1 oracle oinstall  1.2G Sep 29 12:01 o1_mf_sysaux_jk7qzopd_.dbf\n-rw-r-----. 1 oracle oinstall  5.1M Sep 29 12:01 o1_mf_users_jk7r05t2_.dbf\n-rw-r-----. 1 oracle oinstall  513M Sep 29 12:01 o1_mf_undotbsp_jk7rk221_.dbf\n-rw-r-----. 1 oracle oinstall   11M Sep 29 12:03 o1_mf_tstsourc_jo8ok0yn_.dbf\n<\/pre>\n<p><\/br><\/p>\n<p>Let&#8217;s create another new tablespace, TSTCLONE, on the ORATCL1 clone database :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,4,8,19]\">\nSQL&gt; !hostname\nORADEMO1-VM-clo\n\nSQL&gt; create tablespace TSTCLONE datafile size 10M autoextend on next 100M maxsize 1G;\n\nTablespace created.\n\nSQL&gt; !ls -ltrh \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\ntotal 2.7G\n-rw-r-----. 1 oracle oinstall  513M Sep 29 10:36 o1_mf_undotbsp_jk7rk221_.dbf\n-rw-r-----. 1 oracle oinstall  5.1M Sep 29 10:36 o1_mf_users_jk7r05t2_.dbf\n-rw-r-----. 1 oracle oinstall 1001M Sep 29 12:05 o1_mf_system_jk7qywmo_.dbf\n-rw-r-----. 1 oracle oinstall  1.2G Sep 29 12:05 o1_mf_sysaux_jk7qzopd_.dbf\n\nSQL&gt; !ls -ltrh \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/datafile\ntotal 1.1G\n-rw-r-----. 1 oracle oinstall 257M Sep 29 09:19 o1_mf_temptbs__jo8cs8w2_.tmp\n-rw-r-----. 1 oracle oinstall 1.1G Sep 29 12:05 o1_mf_undotbs__jo8ct5gs_.dbf\n-rw-r-----. 1 oracle oinstall  11M Sep 29 12:07 o1_mf_tstclone_jo8oq73s_.dbf\n\nSQL&gt;\n<\/pre>\n<p><\/br><\/p>\n<p>The new file created in the clone database will be recorded locally in the ORATCL1 directory datafile, and only created on the clone database.<\/p>\n<p>We can even create a table into the users tablespace from the clone database that would be seen only by the clone database :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,4,8,14]\">\nSQL&gt; !hostname\nORADEMO1-VM-clo\n\nSQL&gt; create table userclone tablespace users as select * from dba_users;\n\nTable created.\n\nSQL&gt; select table_name, tablespace_name from dba_tables where table_name='USERCLONE';\n\nTABLE_NAME TABLESPACE_NAME\n---------- ------------------------------\nUSERCLONE  USERS\n\nSQL&gt; select file_name from dba_data_files where tablespace_name='USERS';\n\nFILE_NAME\n----------------------------------------------------------------------------------------------------\n\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/o1_mf_users_jk7r05t2_.dbf\n<\/pre>\n<p><\/br><\/p>\n<p>This table is not created on the ORATEST source database :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,4]\">\nSQL&gt; !hostname\ntest1-VM\n\nSQL&gt; select table_name, tablespace_name from dba_tables where table_name='USERCLONE';\n\nno rows selected\n\nSQL&gt;\n<\/pre>\n<p><\/br><\/p>\n<h3>Conclusion<\/h3>\n<p>As we could see it is easy to clone a database using Nutanix Era. What can be surprising is that the clone database is composed of datafiles belonging to a directory named as the source database (ORATEST) and datafiles belonging to another directory named as the clone database (ORATCL1). All new files created on the clone will go to the clone directory. Source and clone databases are 2 separate read\/write databases. When cloning a database the base vDisk is made Read Only and 2 new clones are created. One for the original VM\/database and one for the new clone. On the clone VM, the files from the directory named as the source database are copies from the source database as its status at the point in time cloning. These files are using pointer to the original existing block extent. Updates on block or new inserted data will be added for the file in new extent group belonging to the clone.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Now that we have our ORATEST database provisioned (see Nutanix Era blog part 3), that we could run snapshot and take Log Catch Up (see Nutanix Era Blog part 4), we will now see how we can clone an oracle database. For more information on Nutanix products, I would encourage you to visit Nutanix website.<\/p>\n","protected":false},"author":48,"featured_media":16702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[2384,2203],"type_dbi":[],"class_list":["post-16701","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-nutanix-era","tag-oracle-database"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Nutanix Era with oracle databases : Part 5 \u2013 Clone an oracle database - 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\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nutanix Era with oracle databases : Part 5 \u2013 Clone an oracle database\" \/>\n<meta property=\"og:description\" content=\"Now that we have our ORATEST database provisioned (see Nutanix Era blog part 3), that we could run snapshot and take Log Catch Up (see Nutanix Era Blog part 4), we will now see how we can clone an oracle database. For more information on Nutanix products, I would encourage you to visit Nutanix website.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-29T11:30:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"234\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"25 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"Nutanix Era with oracle databases : Part 5 \u2013 Clone an oracle database\",\"datePublished\":\"2021-09-29T11:30:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/\"},\"wordCount\":1296,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Blog_part5_img_1.png\",\"keywords\":[\"Nutanix ERA\",\"Oracle Database\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/\",\"name\":\"Nutanix Era with oracle databases : Part 5 \u2013 Clone an oracle database - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Blog_part5_img_1.png\",\"datePublished\":\"2021-09-29T11:30:28+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/225d9884b8467ead9a872823acb14628\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Blog_part5_img_1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Blog_part5_img_1.png\",\"width\":234,\"height\":376},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Nutanix Era with oracle databases : Part 5 \u2013 Clone an oracle database\"}]},{\"@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":"Nutanix Era with oracle databases : Part 5 \u2013 Clone an oracle database - 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\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/","og_locale":"en_US","og_type":"article","og_title":"Nutanix Era with oracle databases : Part 5 \u2013 Clone an oracle database","og_description":"Now that we have our ORATEST database provisioned (see Nutanix Era blog part 3), that we could run snapshot and take Log Catch Up (see Nutanix Era Blog part 4), we will now see how we can clone an oracle database. For more information on Nutanix products, I would encourage you to visit Nutanix website.","og_url":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/","og_site_name":"dbi Blog","article_published_time":"2021-09-29T11:30:28+00:00","og_image":[{"width":234,"height":376,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_1.png","type":"image\/png"}],"author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"25 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"Nutanix Era with oracle databases : Part 5 \u2013 Clone an oracle database","datePublished":"2021-09-29T11:30:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/"},"wordCount":1296,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_1.png","keywords":["Nutanix ERA","Oracle Database"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/","url":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/","name":"Nutanix Era with oracle databases : Part 5 \u2013 Clone an oracle database - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_1.png","datePublished":"2021-09-29T11:30:28+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part5_img_1.png","width":234,"height":376},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-5-clone-an-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Nutanix Era with oracle databases : Part 5 \u2013 Clone an oracle database"}]},{"@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\/16701","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=16701"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16701\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16702"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16701"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}