{"id":136,"date":"2013-11-22T15:05:00","date_gmt":"2013-11-22T14:05:00","guid":{"rendered":"https:\/\/www.carajandb.com\/2013\/11\/22\/database-virtualization-and-instant-cloning-and-12c\/"},"modified":"2013-11-22T15:05:00","modified_gmt":"2013-11-22T14:05:00","slug":"database-virtualization-and-instant-cloning-and-12c","status":"publish","type":"post","link":"https:\/\/carajandb.com\/en\/2013\/11\/22\/database-virtualization-and-instant-cloning-and-12c\/","title":{"rendered":"Database virtualization and instant cloning \u2026 and 12c"},"content":{"rendered":"<h2><span style=\"line-height: 1.3em;\">Clone Wars<\/span><span style=\"line-height: 18.1875px;\"><\/span><\/h2>\n<p>When we\u2019re hearing \u201eClone\u201c, most people will associate it with Star Wars the Clone Wars \u2026 something like that, The main idea behind the clones was that they are identically as possible with identical functions, that means that they have the same power, strength and what else.<\/p>\n<p>When we think about cloning databases, it\u2019s not really different. Target is to create a copy of the production environment which is preferably as much identical as we can get it, for testing and development purposes. In most cases it will not stop with only one copy. Over the time different requirements need different copies and more and more copies have to be provided. At the end it comes to our \u201eClone War\u201c between the tasks that a DBA has to accomplish and the modest requirements of the developers.<\/p>\n<p>  <!--more-->  <\/p>\n<p>In this blog series I will shortly describe different methods for cloning to give then an example for cloning with CloneDB feature for Oracle 11gR2 databases, snapshot copy for our new 12c Multitenant database and at the an extremely fancy high-end solution by a third-party developer called Delphix.<\/p>\n<ul>\n<li><span style=\"line-height: 1.3em;\">I &nbsp; &#8211; Database virtualization and instant cloning \u2026 and 12c<\/span><\/li>\n<li><a href=\"index.php?option=com_content&amp;view=article&amp;id=139:clonedb-quick-n-easy-2&amp;catid=22:blog-s-winkler&amp;Itemid=161\"><span style=\"line-height: 1.3em;\">II &nbsp;&#8211; CloneDB &#8211; Quick &#8216;n Easy<\/span><\/a><\/li>\n<li><span style=\"line-height: 1.3em;\">III &#8211; 12c Snapshot Copy &#8211; Plug &#8216;n Clone<\/span><\/li>\n<li><span style=\"line-height: 1.3em;\">IV &#8211; Delphix &#8211; Database virtualization for Pros<\/span><\/li>\n<\/ul>\n<h2>Capabilities of cloning<\/h2>\n<p>The need to copy databases for testing or development almost exists as long as databases exists. Usually there will be made a backup of the database and after that recovered on another server. The required time and the required space are normally the limiting factors. That means you have to make some compromise regarding the actuality and the number of copies.<\/p>\n<p>Since Oracle 11g a very simple method exists for cloning a database with RMAN. You have to login to the source database (TARGET) and an existing instance on the target system (AUXILARY) and use the DUPLICATE command to create a copy. Don\u2019t get confused by TARGET (source database) and AUXILARY (clone database).<\/p>\n<pre>% rman target sys\/manager@PROD auxiliary sys\/manager@MYCLONE RMAN&gt; DUPLICATE TARGET DATABASE; <\/pre>\n<p>For building the database RMAN uses an existing backup of the primary database and with the help of archived Redolog files the clone database can rolled out to any given moment.<\/p>\n<p>Since Oracle 11g Release 2 even direct cloning is possible without a previous backup of the primary database. The command doesn\u2019t change significantly:<\/p>\n<pre>RMAN&gt; DUPLICATE TARGET DATABASE FROM ACTIVE DATABASE; <\/pre>\n<p>Of course there are various options, for example the declaration of the directories for the database files but in general this short statement really is sufficient to create a clone.<\/p>\n<h2>So, what\u2019s the problem?<\/h2>\n<p>Certainly for one clone this procedure is enough, but what is when we have to create several clones. The backup charged the production. It means negative effects for our performance besides the running time for backup and cloning. You will not copy a database in one or two hours which has several terabytes of data. But much more important is the fact that every new clone needs the same space as the production. With that fact you\u2019re really fast on natural limits and the limit of possible clones in your environment.<\/p>\n<p>A lot of companies get by with this problem by using Data Pump. Instead of the whole database only a little part or the part that is really needed for the project will be copied. That saves space but is usually slower because you need to create a database body and as we all know Data Pump is not the fastest method for copying big amounts of data. In spite of using the parameter NETWORK_LINK without temporary storing the dump files like the DUPLICATE this method is space-consuming and time-consuming.<\/p>\n<h2>Maybe we can learn from virtualization<\/h2>\n<p>In the meantime some methods are established in virtual environments, which uses a reading and a altered version of one date. That means many guest systems access the same resource for reading and only altered parts will be stored in a unique copy. This so called copy-on-write (c.o.w.) is used by ZFS storage for example. The advantage is obvious: Less storage is needed or by the way consumed and the clone can be provided much faster because only links on existing files must be provided.<\/p>\n<p>Expire how we get with patchset 11.2.0.2 on the quiet a possibility to save a lot of time and storage and which role copy-on-write plays at that on the following article \u201c<a href=\"index.php?option=com_content&amp;view=article&amp;id=138:clonedb-quick-n-easy&amp;catid=9:blogs&amp;Itemid=115\">CloneDB \u2013 Quick &#8216;n Easy<\/a>\u201d<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Clone Wars When we\u2019re hearing \u201eClone\u201c, most people will associate it with Star Wars the Clone Wars \u2026 something like that, The main idea behind the clones was that they are identically as possible with identical functions, that means that they have the same power, strength and what else. When we think about cloning databases, it\u2019s not really different. Target is to create a copy of the production environment which is preferably as much identical as we can get it, for testing and development purposes. In most cases it will not stop with only one copy. Over the time different [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_crdt_document":"","_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[],"tags":[120,41,44,119],"class_list":["post-136","post","type-post","status-publish","format-standard","hentry","tag-cloning","tag-oracle-12c","tag-oracle-database","tag-virtualization"],"acf":{"occupation":"Write the Occupation of the Person","person_can-be-speaker":true,"person_is-team":true,"person_related-user-account":null,"person_ordering-number":50,"publication_speakers":null,"publication_content-language":["de"],"publication_files":null,"publication_event":"","publication_date":null},"spectra_custom_meta":{"_fgj2wp_old_id":["136"],"_yoast_wpseo_metadesc":["Oracle database virtualization and Cloning"],"_yoast_wpseo_metakeywords":["Oracle Database, Virtualization, Cloning, Oracle 12c"],"layout_show-author-box":["1"],"_layout_show-author-box":["field_5a64ee9cc6490"],"_edit_lock":["1517511611:1"],"rank_math_description":["Oracle database virtualization and Cloning"],"rank_math_news_sitemap_robots":["index"],"rank_math_robots":["a:1:{i:0;s:5:\"index\";}"],"rank_math_internal_links_processed":["1"],"wpil_sync_report3":["1"],"wpil_links_inbound_internal_count":["0"],"wpil_links_inbound_internal_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_links_outbound_internal_count":["2"],"wpil_links_outbound_internal_count_data":["eJzdUk1rGzEQ\/StGBd\/WtuSPOrOYQJocDG1DTzkKrSRs1bKkSto6IQT6H\/oP80s62nWCA8klkEtvmtGbmfdmngAG9wYm9TXQOZCbYCz\/5pW2\/KtxOwJ0CvcJPgOxGHKjSF3ACaZA2mgJvuh8AWSbc4DxOGorWie3bMJmIymi+CmcakbS78fGKX07Cttw7kM23q0wyaV3Wbs8FPtQ\/zb6sBIxG2l1lzBqRadnIK13WjXVr9bIXeUqLdJdxTqEFBlBjEFj\/aZK1QE5Wh27v3XW+9JhQQvJGVL0KZcnQ7pv8yyIJRCDvKITKLAB2teHrv47BthAYLGPBTxnQNbrwdA1KdTDT0tGaT34UjhfXgye4h+Fex8taje4Qgn96rCTUlrx5o4H226MKwMnPQfriz7vChIPcNxVJ2FyvMdha1LQkcuoRdbPx6EUFSQu2uwL7DSdo5A74zYnpyzpvVet1fwFmh2HdINvc59\/MLiP93tlNvtAryxf9cqJU846o6QX\/qDzj\/XHFLf7ZIfHP3\/\/Jys8\/APCvWLR"],"wpil_links_outbound_external_count":["0"],"wpil_links_outbound_external_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_sync_report2_time":["2024-08-27T11:47:30+00:00"],"astra_style_timestamp_css":["1773747558"],"copied_media_ids":["a:0:{}"],"referenced_media_ids":["a:0:{}"],"_uag_css_file_name":["uag-css-136.css"]},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Johannes Ahrends","author_link":"https:\/\/carajandb.com\/en\/author\/9aa6cdb2095bd409\/"},"uagb_comment_info":0,"uagb_excerpt":"Clone Wars When we\u2019re hearing \u201eClone\u201c, most people will associate it with Star Wars the Clone Wars \u2026 something like that, The main idea behind the clones was that they are identically as possible with identical functions, that means that they have the same power, strength and what else. When we think about cloning databases,&hellip;","_links":{"self":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/comments?post=136"}],"version-history":[{"count":0,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/136\/revisions"}],"wp:attachment":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/media?parent=136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/categories?post=136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/tags?post=136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}