{"id":7397,"date":"2016-03-17T16:43:36","date_gmt":"2016-03-17T15:43:36","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/"},"modified":"2016-03-17T16:43:36","modified_gmt":"2016-03-17T15:43:36","slug":"rman-12c-push-and-pull-duplicate-explained","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/","title":{"rendered":"RMAN 12c Push and Pull duplicate explained"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nOracle Database 12c<\/em> introduced the ‘restore from service’ where you can restore and recover by requesting backupsets from the source. With that feature, the duplicate from active can work in the opposite way: instead of asking the source (target) to send the files to the destination (auxiliary) now the destination can do all the job. Let’s see how it works by comparing the RMAN log of the two methods.
\n<\/p>\n

Pull Based Duplicate<\/h3>\n

In 12c the pull method is the default. Here there are two additional reasons for it: I allocate more channels in auxiliary than in target, and I specify ‘from backupset’<\/p>\n

\nRMAN>\necho set on\n run {\n  allocate channel c1 device type disk;\n  allocate auxiliary channel a1 device type disk;\n  allocate auxiliary channel a2 device type disk;\n  duplicate database for standby from active database using backupset nofilenamecheck;\n}\n<\/code><\/pre>\n
In pull based duplicate, the auxiliary channels will connect to the target. This means that the credentials and connection string you used to connect target must be available (tnsnames, etc.) from the auxiliary.<\/p>\n
I allocated 2 channels a1 and a2 in auxiliary and only one c1 in target.<\/p>\n
\"CapturePull\"<\/a><\/p>\n
Push Based Duplicate<\/h3>\n
In order to force a push based duplicate, I can mention ‘using copy’ instead of ‘using backupset’. Here I do not mention anything but  I allocate more channels in target than in auxiliary and push-based is then used:<\/p>\n
\nRMAN>\necho set on\n run {\n  allocate channel c1 device type disk;\n  allocate channel c2 device type disk;\n  allocate auxiliary channel a1 device type disk;\n  duplicate database for standby from active database nofilenamecheck;\n}\n<\/code><\/pre>\n
I allocated 2 channels c1 and c2 in target and only one a1 in auxiliary.<\/p>\n
\"CapturePush\"<\/a><\/p>\n
In push based duplicate the target will connect to the auxiliary. So SQL*Net connection must be ok for that. You probably need to define a static entry for the auxiliary in its listener so that the target can connect to the nomount instance.<\/p>\n
In order to compare, I’ve diff’ed the rman logs so the pull based are prefixed by ‘<‘ and the push based by ‘>’ in the following.<\/p>\n
Control File<\/h3>\n
The first step is to restore the control file. Here is the difference:<\/p>\n
Pull based duplicate do a restore from service (VM117 is the target)<\/p>\n
<    restore clone from service  '\/\/VM117\/CDB' standby controlfile;\n<\/code><\/pre>\n
Whereas push based do a backup as copy to the auxiliary. Why as copy? Because all the intelligence here is on the target. The auxiliary will not read a backupset.<\/p>\n
>    backup as copy current controlfile for standby auxiliary format  '\/u02\/fast_recovery_area\/CDB_SBY\/controlfile\/crontrol.ctl';\n<\/code><\/pre>\n
In pull based, the auxiliary channels are doing all the job:<\/p>\n
\n< channel a1: starting datafile backup set restore\n< channel a1: using network backup set from service \/\/VM117\/CDB\n< channel a1: restoring control file\n< channel a1: restore complete, elapsed time: 00:00:02\n< output file name=\/u02\/fast_recovery_area\/CDB_SBY\/controlfile\/crontrol.ctl<\/code><\/pre>\n
Whereas in push based, it’s the target that do the work:<\/p>\n
> channel c1: starting datafile copy\n> copying standby control file\n> output file name=\/u01\/app\/oracle\/product\/12R2EE\/dbs\/snapcf_CDB.f tag=TAG20160317T152842\n> channel c1: datafile copy complete, elapsed time: 00:00:03\n<\/code><\/pre>\n
Datafiles<\/h3>\n
Now the datafiles. The pull based is the auxiliary restoring from service:<\/p>\n
\n<    restore\n<    from  nonsparse   from service\n<  '\/\/VM117\/CDB'   clone database\n<    ;\n<\/code><\/pre>\n
On the opposite, the push based is the target sending copies to the auxiliary:<\/p>\n
\n>    backup as copy reuse\n>    datafile  1 auxiliary format\n>  \"\/u02\/oradata\/CDB\/system01.dbf\"   datafile\n>  3 auxiliary format\n>  \"\/u02\/oradata\/CDB\/sysaux01.dbf\"   datafile\n>  4 auxiliary format\n>  \"\/u02\/oradata\/CDB\/undotbs01.dbf\"   datafile\n...\n<\/code><\/pre>\n
Channels are working. For the pull based, I’ve two auxiliary channels:<\/p>\n
\n< channel a1: starting datafile backup set restore\n< channel a1: using network backup set from service \/\/VM117\/CDB\n< channel a1: specifying datafile(s) to restore from backup set\n< channel a1: restoring datafile 00001 to \/u02\/oradata\/CDB\/system01.dbf\n< channel a2: starting datafile backup set restore\n< channel a2: using network backup set from service \/\/VM117\/CDB\n< channel a2: specifying datafile(s) to restore from backup set\n< channel a2: restoring datafile 00003 to \/u02\/oradata\/CDB\/sysaux01.dbf\n<\/code><\/pre>\n
for the push based it’s the two channels in target:<\/p>\n
\n> channel c1: starting datafile copy\n> input datafile file number=00001 name=\/u02\/oradata\/CDB\/system01.dbf\n> channel c2: starting datafile copy\n> input datafile file number=00003 name=\/u02\/oradata\/CDB\/sysaux01.dbf\n> output file name=\/u02\/oradata\/CDB\/system01.dbf tag=TAG20160317T152850\n> channel c1: datafile copy complete, elapsed time: 00:00:46\n> channel c1: starting datafile copy\n> input datafile file number=00009 name=\/u02\/oradata\/CDB\/pdb\/sysaux01.dbf\n> output file name=\/u02\/oradata\/CDB\/sysaux01.dbf tag=TAG20160317T152850\n<\/code><\/pre>\n
Conclusion<\/h3>\n
Hope it helps to remember how it works:<\/p>\n
    \n
  • Pull: The auxiliary restores from target. All ‘backup as backupset’ optimizations are available: compression, section size,… Non formatted blocks and unnecessary undo is not transfered.<\/li>\n
  • Push: Use it if you want the target to do all the job. More data will be transferred because it’s full datafiles. Target must be able to connect to auxiliary.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
    By Franck Pachot . Oracle Database 12c introduced the ‘restore from service’ where you can restore and recover by requesting backupsets from the source. With that feature, the duplicate from active can work in the opposite way: instead of asking the source (target) to send the files to the destination (auxiliary) now the destination can […]<\/p>\n","protected":false},"author":27,"featured_media":7400,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[311,209,270],"type_dbi":[],"class_list":["post-7397","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-duplicate","tag-oracle-12c","tag-rman"],"acf":[],"yoast_head":"\nRMAN 12c Push and Pull duplicate explained - 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\/rman-12c-push-and-pull-duplicate-explained\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RMAN 12c Push and Pull duplicate explained\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . Oracle Database 12c introduced the ‘restore from service’ where you can restore and recover by requesting backupsets from the source. With that feature, the duplicate from active can work in the opposite way: instead of asking the source (target) to send the files to the destination (auxiliary) now the destination can […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-17T15:43:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePull-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"954\" \/>\n\t<meta property=\"og:image:height\" content=\"652\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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\/rman-12c-push-and-pull-duplicate-explained\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"RMAN 12c Push and Pull duplicate explained\",\"datePublished\":\"2016-03-17T15:43:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/\"},\"wordCount\":482,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePull-1.png\",\"keywords\":[\"duplicate\",\"Oracle 12c\",\"RMAN\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/\",\"name\":\"RMAN 12c Push and Pull duplicate explained - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePull-1.png\",\"datePublished\":\"2016-03-17T15:43:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePull-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePull-1.png\",\"width\":954,\"height\":652},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RMAN 12c Push and Pull duplicate explained\"}]},{\"@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\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"RMAN 12c Push and Pull duplicate explained - 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\/rman-12c-push-and-pull-duplicate-explained\/","og_locale":"en_US","og_type":"article","og_title":"RMAN 12c Push and Pull duplicate explained","og_description":"By Franck Pachot . Oracle Database 12c introduced the ‘restore from service’ where you can restore and recover by requesting backupsets from the source. With that feature, the duplicate from active can work in the opposite way: instead of asking the source (target) to send the files to the destination (auxiliary) now the destination can […]","og_url":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/","og_site_name":"dbi Blog","article_published_time":"2016-03-17T15:43:36+00:00","og_image":[{"width":954,"height":652,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePull-1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"RMAN 12c Push and Pull duplicate explained","datePublished":"2016-03-17T15:43:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/"},"wordCount":482,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePull-1.png","keywords":["duplicate","Oracle 12c","RMAN"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/","url":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/","name":"RMAN 12c Push and Pull duplicate explained - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePull-1.png","datePublished":"2016-03-17T15:43:36+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePull-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePull-1.png","width":954,"height":652},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/rman-12c-push-and-pull-duplicate-explained\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"RMAN 12c Push and Pull duplicate explained"}]},{"@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\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7397","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\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=7397"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7397\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/7400"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7397"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}