{"id":16720,"date":"2021-09-29T14:56:47","date_gmt":"2021-09-29T12:56:47","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\/"},"modified":"2021-09-29T14:56:47","modified_gmt":"2021-09-29T12:56:47","slug":"nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\/","title":{"rendered":"Nutanix Era with oracle databases : Part 6 \u2013 Refresh an oracle clone database"},"content":{"rendered":"

Now that we have cloned our ORATEST source database into a clone database named ORATCL1 (see Nutanix Era Blog part 5<\/a>), we will see how we can refresh it and see the impacts on the oracle database itself. <\/p>\n

For more information on Nutanix products, I would encourage you to visit Nutanix website<\/a>.<\/p>\n\n\n
\"\"<\/a><\/td>\n\"\"<\/a><\/td>\n<\/tr>\n<\/table>\n

<\/p>\n

Create a test table on the ORATEST source database<\/h3>\n

In blog part 5, we have been creating the clone with point in time 10:04:07 from September the 29th. <\/p>\n

I just created a new table in ORATEST database. This is the source database of our clone database, ORATCL1.<\/p>\n

\nSQL> select host_name, instance_name from v$instance;\n\nHOST_NAME                                                        INSTANCE_NAME\n---------------------------------------------------------------- ----------------\ntest1-VM                                                         ORATEST\n\nSQL> create table REFRESHCLONE as select * from dba_users;\n\nTable created.\n<\/pre>\n
<\/br><\/p>\n
Let’s take a new log catch up<\/h3>\n
I took a new Log Catch Up :
\n\"\"<\/a>
\n<\/br>
\n<\/br><\/p>\n
Refresh the ORATCL1 clone<\/h3>\n
From the “Databases” Menu, in the “Clones” list, we will select the name of the clone we would like to refresh. Here ORATCL1. Then we will click the “Refresh” button :
\n\"\"<\/a>
\n<\/br>
\n<\/br><\/p>\n
We will use the last point in Time which correspond to our last Log Catch Up :
\n\"\"<\/a>
\n<\/br>
\n<\/br>
\n<\/br>
\n<\/br>
\n<\/br>
\n<\/br><\/p>\n
Note the warning Nutanix Era is providing : “All active user sessions to the database will be disconnected before the operation.”<\/em><\/strong><\/p>\n
These are the steps that have been be performed :
\n\"\"<\/a>
\n<\/br>
\n<\/br><\/p>\n
We can see this on the system.<\/p>\n
The clone database has been shutdown, as we can see in the alert log :<\/p>\n
\noracle@ORADEMO1-VM-clo:\/home\/oracle\/ [ORATCL1] taa\n  Current log# 2 seq# 2 mem# 1: \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\/ORATCL1\/onlinelog\/o1_mf_2_jo8czv9n_.log\n2021-09-29T10:31:39.459563+00:00\nNET  (PID:55416): Archived Log entry 1 added for T-1.S-1 ID 0xcbd23736 LAD:1\n2021-09-29T12:07:03.119723+00:00\ncreate tablespace TSTCLONE datafile size 10M autoextend on next 100M maxsize 1G\nCompleted: create tablespace TSTCLONE datafile size 10M autoextend on next 100M maxsize 1G\n2021-09-29T14:15:55.260063+00:00\nTABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P526 (4290) VALUES LESS THAN (TO_DATE(' 2021-09-30 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))\nTABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P527 (4290) VALUES LESS THAN (TO_DATE(' 2021-09-30 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))\nTABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P530 (4289) VALUES LESS THAN (TO_DATE(' 2021-09-29 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))\n2021-09-29T14:16:31.607250+00:00\nShutting down ORACLE instance (abort) (OS id: 108686)\n2021-09-29T14:16:31.607362+00:00\nShutdown is initiated by sqlplus@ORADEMO1-VM-clo (TNS V1-V3).\nLicense high water mark = 3\nUSER (ospid: 108686): terminating the instance\n2021-09-29T14:16:32.629626+00:00\nInstance terminated by USER, pid = 108686\n2021-09-29T14:16:32.631772+00:00\nInstance shutdown complete (OS id: 108686)\n<\/pre>\n
<\/br><\/p>\n
We can see that the database file systems (\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1 and \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1) have been unmounted :<\/p>\n
\noracle@ORADEMO1-VM-clo:\/home\/oracle\/ [ORATCL1] df -h\nFilesystem                                                                                                                      Size  Used Avail Use% Mounted on\ndevtmpfs                                                                                                                        7.7G     0  7.7G   0% \/dev\ntmpfs                                                                                                                            12G  168K   12G   1% \/dev\/shm\ntmpfs                                                                                                                           7.7G   25M  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   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  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   62M  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
<\/br><\/p>\n
And the exact next steps done during a database clone are performed (see Nutanix Era blog part 5<\/a>) :<\/p>\n
\noracle@ORADEMO1-VM-clo:\/home\/oracle\/ [ORATCL1] df -h\nFilesystem                                                                                                                      Size  Used Avail Use% Mounted on\ndevtmpfs                                                                                                                        7.7G     0  7.7G   0% \/dev\ntmpfs                                                                                                                            12G  176K   12G   1% \/dev\/shm\ntmpfs                                                                                                                           7.7G   25M  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  457M  2.6G  15% \/var\n\/dev\/mapper\/vgroot--lv-home                                                                                                     4.0G   75M  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   64M  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  9.0G  178G   5% \/tmp\/era_recovery_staging_area_ORATCL1\n\/dev\/mapper\/oradata_ORATEST_vg_ORATCL1-oradata_ORATEST_lv                                                                        20G  3.4G   16G  18% \/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\n\/dev\/mapper\/oradata_fra_ORATEST_vg_ORATCL1-oradata_fra_ORATEST_lv                                                               9.8G  3.5G  5.8G  38% \/u02\/app\/oracle\/oradata\/fra_ORATEST_ORATCL1\n<\/pre>\n
<\/br><\/p>\n
We can see the temporary File System, \/tmp\/era_recovery_staging_area_ORATCL1, containing the Log Catch Up has been temporary mounted again.
\nBoth clone database’s File System have been mounted back after the snapshot has been restored.<\/p>\n
We can already see that the clone has been refreshed with source database version dated from 16:04:39. We can even use the word rebuild. \ud83d\ude42 Why? Because we can see that the file from the tablespace TSTSOURCE we created in Nutanix Era blog part 5<\/a>, on the source database ORATEST after the clone creation is now present in the ORACTL1 clone database :<\/p>\n
\noracle@ORADEMO1-VM-clo:\/home\/oracle\/ [ORATCL1] 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\n11M\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATEST\/datafile\/o1_mf_tstsourc_jo8ok0yn_.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\noracle@ORADEMO1-VM-clo:\/home\/oracle\/ [ORATCL1] 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__jo8xm38x_.tmp\n1.1G\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/datafile\/o1_mf_undotbs__jo8xnb70_.dbf\n1.1G\t\/u02\/app\/oracle\/oradata\/datafiles_ORATEST_ORATCL1\/ORATCL1\/datafile\/\noracle@ORADEMO1-VM-clo:\/home\/oracle\/ [ORATCL1]\n<\/pre>\n
<\/br><\/p>\n
This is confirmed querying the dictionary on the ORATCL1 clone database we have just refreshed. We can now see this TSTSOURCE tablespace. And we will highlight that we lost the TSTCLONE tablespace we created on the previous clone version (See Nutanix Era blog part 5<\/a>).<\/p>\n
\nSQL> select host_name, instance_name from v$instance;\n\nHOST_NAME\t\t\t\t\t\t\t INSTANCE_NAME\n---------------------------------------------------------------- ----------------\nORADEMO1-VM-clo \t\t\t\t\t\t ORATCL1\n\nSQL> select tablespace_name from dba_tablespaces where tablespace_name like '%TST%';\n\nTABLESPACE_NAME\n------------------------------\nTSTSOURCE\n\nSQL>\n<\/pre>\n
<\/br><\/p>\n
Do we have our REFRESHCLONE table we created previously at the beginning of the blog?<\/p>\n
\nSQL> select host_name, instance_name from v$instance;\n\nHOST_NAME\t\t\t\t\t\t\t INSTANCE_NAME\n---------------------------------------------------------------- ----------------\nORADEMO1-VM-clo \t\t\t\t\t\t ORATCL1\n\nSQL> select table_name from dba_tables where upper(table_name) like 'REFRESH%';\n\nTABLE_NAME\n---------------\nREFRESHCLONE\n\nSQL>\n<\/pre>\n
<\/br><\/p>\n
Yes we have!<\/p>\n
Conclusion<\/h3>\n
Refreshing a clone with Nutanix Era is also something very easy to achieve. The clone is in fact created from fresh in a couple of minutes.<\/p>\n","protected":false},"excerpt":{"rendered":"
Now that we have cloned our ORATEST source database into a clone database named ORATCL1 (see Nutanix Era Blog part 5), we will see how we can refresh it and see the impacts on the oracle database itself. For more information on Nutanix products, I would encourage you to visit Nutanix website.<\/p>\n","protected":false},"author":48,"featured_media":16721,"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-16720","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-nutanix-era","tag-oracle-database"],"acf":[],"yoast_head":"\nNutanix Era with oracle databases : Part 6 \u2013 Refresh an oracle clone 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-6-refresh-an-oracle-clone-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 6 \u2013 Refresh an oracle clone database\" \/>\n<meta property=\"og:description\" content=\"Now that we have cloned our ORATEST source database into a clone database named ORATCL1 (see Nutanix Era Blog part 5), we will see how we can refresh it and see the impacts on the oracle database itself. 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-6-refresh-an-oracle-clone-database\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-29T12:56:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part6_img_1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1403\" \/>\n\t<meta property=\"og:image:height\" content=\"325\" \/>\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=\"7 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-6-refresh-an-oracle-clone-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\\\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"Nutanix Era with oracle databases : Part 6 \u2013 Refresh an oracle clone database\",\"datePublished\":\"2021-09-29T12:56:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\\\/\"},\"wordCount\":453,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Blog_part6_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-6-refresh-an-oracle-clone-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\\\/\",\"name\":\"Nutanix Era with oracle databases : Part 6 \u2013 Refresh an oracle clone 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-6-refresh-an-oracle-clone-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Blog_part6_img_1.png\",\"datePublished\":\"2021-09-29T12:56:47+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-6-refresh-an-oracle-clone-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Blog_part6_img_1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Blog_part6_img_1.png\",\"width\":1403,\"height\":325},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-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 6 \u2013 Refresh an oracle clone 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 6 \u2013 Refresh an oracle clone 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-6-refresh-an-oracle-clone-database\/","og_locale":"en_US","og_type":"article","og_title":"Nutanix Era with oracle databases : Part 6 \u2013 Refresh an oracle clone database","og_description":"Now that we have cloned our ORATEST source database into a clone database named ORATCL1 (see Nutanix Era Blog part 5), we will see how we can refresh it and see the impacts on the oracle database itself. 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-6-refresh-an-oracle-clone-database\/","og_site_name":"dbi Blog","article_published_time":"2021-09-29T12:56:47+00:00","og_image":[{"width":1403,"height":325,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part6_img_1.png","type":"image\/png"}],"author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"Nutanix Era with oracle databases : Part 6 \u2013 Refresh an oracle clone database","datePublished":"2021-09-29T12:56:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\/"},"wordCount":453,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part6_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-6-refresh-an-oracle-clone-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\/","url":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\/","name":"Nutanix Era with oracle databases : Part 6 \u2013 Refresh an oracle clone 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-6-refresh-an-oracle-clone-database\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part6_img_1.png","datePublished":"2021-09-29T12:56:47+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-6-refresh-an-oracle-clone-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-database\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part6_img_1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_part6_img_1.png","width":1403,"height":325},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-6-refresh-an-oracle-clone-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 6 \u2013 Refresh an oracle clone 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\/16720","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=16720"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16720\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16721"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16720"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}