{"id":825,"date":"2020-11-09T18:39:07","date_gmt":"2020-11-09T21:39:07","guid":{"rendered":"https:\/\/www.fernandosimon.com\/blog\/?p=825"},"modified":"2020-11-09T18:39:07","modified_gmt":"2020-11-09T21:39:07","slug":"move_backup-and-zdlra","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/","title":{"rendered":"MOVE_BACKUP and ZDLRA"},"content":{"rendered":"<p style=\"text-align: justify;\"><a href=\"https:\/\/www.fernandosimon.com\/blog\/keep-backups-and-zdlra\/\" target=\"_blank\" rel=\"noopener noreferrer\">As I wrote previously<\/a>, sometimes we need to have long-term\/archival backups due to some compliance. And usually, these backups are stores outside (like a vault\/bunker) but for sure not at the same datacenter as the database. But how we can do this at ZDLRA?<\/p>\n<p style=\"text-align: justify;\">In my post about <a href=\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/\" target=\"_blank\" rel=\"noopener noreferrer\">COPY_BACKUP<\/a>, I wrote how to have an external copy of one backup set at ZDLRA. But this is not the best option when we need to archive some backup because it continues to follow the same recovery window as the original backup set. This means that if you need to have some kind of archive for 5 years, you need to define your recovery window (at the policy level) to this window. And for sure this will put high pressure on space usage because all backups will be stored until became obsolete.<\/p>\n<p><a href=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-826 size-full\" src=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg\" alt=\"\" width=\"1000\" height=\"668\" srcset=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg 1000w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1-300x200.jpg 300w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1-768x513.jpg 768w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1-624x417.jpg 624w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">So, the best way is to use the <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/rcmrf\/keepOption.html#GUID-36E9008E-48A5-4AB9-8C9D-2D477342594B\" target=\"_blank\" rel=\"noopener noreferrer\">KEEP backups<\/a> from rman. And as I wrote in my previous post, they not interact\/broke with the incremental forever strategy. Is possible to generate the keep backup, and using the <a href=\"https:\/\/docs.oracle.com\/en\/engineered-systems\/zero-data-loss-recovery-appliance\/19.2\/amagd\/amagd_dbms.html#GUID-5A2CA465-046A-436F-AB35-FBE958E17C08\" target=\"_blank\" rel=\"noopener noreferrer\">DBMS_RA.MOVE_BACKUP<\/a> moves these backups to a filesystem destination (and further you can copy\/store) and archive it outside of ZDLRA.<\/p>\n<p style=\"text-align: justify;\"><!--more Click here to read more...--><\/p>\n<p style=\"text-align: justify;\">So, first, let&#8217;s create some KEEP backups (I cropped the output t to reduce the size of the post):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">RMAN&gt; run{\r\n2&gt; BACKUP INCREMENTAL LEVEL 1 DEVICE TYPE SBT FILESPERSET 1 DATABASE TAG 'LONGTERM' KEEP FOREVER;\r\n3&gt; SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';\r\n4&gt; BACKUP DEVICE TYPE SBT FILESPERSET 100 FORMAT '%U' ARCHIVELOG ALL NOT BACKED UP TAG 'LONGTERM' KEEP FOREVER;\r\n5&gt; }\r\n\r\nStarting backup at 04\/10\/2020 23:27:27\r\n\r\nallocated channel: ORA_SBT_TAPE_1\r\nchannel ORA_SBT_TAPE_1: SID=69 device type=SBT_TAPE\r\nchannel ORA_SBT_TAPE_1: RA Library (ZDLRAS1) SID=B0E0085540FB6D61E053010310AC6E1C\r\nbackup will never be obsolete\r\narchived logs required to recover from this backup will be backed up\r\n...\r\n...\r\npiece handle=ORCL19C_a7vc5kgd_1_1 tag=LONGTERM comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01\r\ncurrent log archived\r\n\r\nusing channel ORA_SBT_TAPE_1\r\n...\r\n...\r\nFinished backup at 04\/10\/2020 23:32:50\r\n\r\nsql statement: ALTER SYSTEM ARCHIVE LOG CURRENT\r\n\r\nStarting backup at 04\/10\/2020 23:32:52\r\ncurrent log archived\r\nusing channel ORA_SBT_TAPE_1\r\nbackup will never be obsolete\r\narchived logs required to recover from this backup will be backed up\r\nskipping archived logs of thread 1 from sequence 43 to 70; already backed up\r\nskipping archived log of thread 1 with sequence 84; already backed up\r\nchannel ORA_SBT_TAPE_1: starting archived log backup set\r\nchannel ORA_SBT_TAPE_1: specifying archived log(s) in backup set\r\ninput archived log thread=1 sequence=71 RECID=130 STAMP=1052941336\r\ninput archived log thread=1 sequence=72 RECID=131 STAMP=1052941338\r\ninput archived log thread=1 sequence=73 RECID=132 STAMP=1052942766\r\ninput archived log thread=1 sequence=74 RECID=133 STAMP=1052942786\r\ninput archived log thread=1 sequence=75 RECID=134 STAMP=1052942787\r\ninput archived log thread=1 sequence=76 RECID=135 STAMP=1052942845\r\ninput archived log thread=1 sequence=77 RECID=136 STAMP=1052942847\r\ninput archived log thread=1 sequence=78 RECID=137 STAMP=1052943564\r\ninput archived log thread=1 sequence=79 RECID=138 STAMP=1052943565\r\ninput archived log thread=1 sequence=80 RECID=139 STAMP=1052943830\r\ninput archived log thread=1 sequence=81 RECID=140 STAMP=1052943831\r\ninput archived log thread=1 sequence=82 RECID=141 STAMP=1052946686\r\ninput archived log thread=1 sequence=83 RECID=142 STAMP=1052946686\r\ninput archived log thread=1 sequence=85 RECID=144 STAMP=1052955171\r\ninput archived log thread=1 sequence=86 RECID=145 STAMP=1052955175\r\nchannel ORA_SBT_TAPE_1: starting piece 1 at 04\/10\/2020 23:32:57\r\nchannel ORA_SBT_TAPE_1: finished piece 1 at 04\/10\/2020 23:33:04\r\npiece handle=abvc5kh9_1_1 tag=LONGTERM comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:07\r\nFinished backup at 04\/10\/2020 23:33:04\r\n\r\nRMAN&gt; list backupset 10464;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n10464   Incr 0  783.25M    SBT_TAPE    00:01:41     04\/10\/2020 23:29:09\r\n        BP Key: 10465   Status: AVAILABLE  Compressed: NO  Tag: LONGTERM\r\n        Handle: ORCL19C_9tvc5k70_1_1   Media: Recovery Appliance (ZDLRAS1)\r\n        Keep: BACKUP_LOGS        Until: FOREVER\r\n  List of Datafiles in backup set 10464\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 2637014    04\/10\/2020 23:27:28              NO    \/u01\/app\/oracle\/oradata\/ORCL19C\/system01.dbf\r\n\r\nRMAN&gt;<\/pre>\n<p style=\"text-align: justify;\">As you can see above, the backup set 10464 is stored inside of ZDLRA (handle name is ORCL19C_9tvc5k70_1_1) and just one copy exists.<\/p>\n<p style=\"text-align: justify;\">Now we can use <a href=\"https:\/\/docs.oracle.com\/en\/engineered-systems\/zero-data-loss-recovery-appliance\/19.2\/amagd\/amagd_dbms.html#GUID-5A2CA465-046A-436F-AB35-FBE958E17C08\" target=\"_blank\" rel=\"noopener noreferrer\">DBMS_RA.MOVE_BACKUP<\/a> to move where we want. The definition follows the same as COPY_BACKUP, and if we define the \u201ctemplate_name\u201d as null, we can send it to the filesystem. Below I moving all the backups with tag equal \u201cLONGTERM\u201d:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">SQL&gt; BEGIN\r\n  2      DBMS_RA.MOVE_BACKUP(\r\n  3           tag =&gt; 'LONGTERM'\r\n  4          , format =&gt; '\/radump\/longterm_%d_%U'\r\n  5          , template_name =&gt; NULL\r\n  6      );\r\n  7  END;\r\n  8  \/\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt;<\/pre>\n<p style=\"text-align: justify;\">And after some time, we have at filesystem:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">[root@zdlras1n1 ~]# ls -lh \/radump\/longterm*\r\n-rw-r----- 1 oracle dba 784M Oct  4 23:42 \/radump\/longterm_ZDLRAS1_9tvc5k70_1_2\r\n-rw-r----- 1 oracle dba 384M Oct  4 23:43 \/radump\/longterm_ZDLRAS1_9uvc5ka9_1_2\r\n-rw-r----- 1 oracle dba 1.6M Oct  4 23:43 \/radump\/longterm_ZDLRAS1_9vvc5kc0_1_2\r\n-rw-r----- 1 oracle dba 217M Oct  4 23:42 \/radump\/longterm_ZDLRAS1_a0vc5kc1_1_2\r\n-rw-r----- 1 oracle dba 224M Oct  4 23:42 \/radump\/longterm_ZDLRAS1_a1vc5kd4_1_2\r\n-rw-r----- 1 oracle dba 202M Oct  4 23:43 \/radump\/longterm_ZDLRAS1_a2vc5ke7_1_2\r\n-rw-r----- 1 oracle dba 190M Oct  4 23:42 \/radump\/longterm_ZDLRAS1_a3vc5kf0_1_2\r\n-rw-r----- 1 oracle dba  69M Oct  4 23:43 \/radump\/longterm_ZDLRAS1_a4vc5kfq_1_2\r\n-rw-r----- 1 oracle dba 1.7M Oct  4 23:42 \/radump\/longterm_ZDLRAS1_a5vc5kg9_1_2\r\n-rw-r----- 1 oracle dba 2.4M Oct  4 23:43 \/radump\/longterm_ZDLRAS1_a6vc5kga_1_2\r\n-rw-r----- 1 oracle dba 1.2M Oct  4 23:43 \/radump\/longterm_ZDLRAS1_a7vc5kgd_1_2\r\n-rw-r----- 1 oracle dba  13M Oct  4 23:42 \/radump\/longterm_ZDLRAS1_a8vc5kgg_1_2\r\n-rw-r----- 1 oracle dba 112K Oct  4 23:43 \/radump\/longterm_ZDLRAS1_a9vc5kgo_1_2\r\n-rw-r----- 1 oracle dba  19M Oct  4 23:43 \/radump\/longterm_ZDLRAS1_aavc5kgq_1_2\r\n-rw-r----- 1 oracle dba  52M Oct  4 23:42 \/radump\/longterm_ZDLRAS1_abvc5kh9_1_2\r\n-rw-r----- 1 oracle dba 765M Sep 30 23:51 \/radump\/longterm_ZDLRAS1_s0vbof97_1_2\r\n[root@zdlras1n1 ~]#<\/pre>\n<p style=\"text-align: justify;\">And if we check the backupset 10464 we can see that now we continue to have just one copy of that and it is stored at a different place (look the handle definition):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">RMAN&gt; list backupset 10464;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n10464   Incr 0  783.24M    SBT_TAPE    00:15:28     04\/10\/2020 23:42:56\r\n        BP Key: 10954   Status: AVAILABLE  Compressed: NO  Tag: LONGTERM\r\n        Handle: \/radump\/longterm_ZDLRAS1_9tvc5k70_1_2   Media:\r\n        Keep: BACKUP_LOGS        Until: FOREVER\r\n  List of Datafiles in backup set 10464\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 2637014    04\/10\/2020 23:27:28              NO    \/u01\/app\/oracle\/oradata\/ORCL19C\/system01.dbf\r\n\r\nRMAN&gt;<\/pre>\n<p style=\"text-align: justify;\">Another interesting about the move is that, if the backups are stored outside of ZDLRA, the \u201ckeep_space\u201d from the ra_database table deducts the size. In this case, I have no more keep backups inside of ZDLRA database:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">SQL&gt; select keep_space from ra_database;\r\n\r\nKEEP_SPACE\r\n----------\r\n         0\r\n\r\nSQL&gt;<\/pre>\n<p style=\"text-align: justify;\">So, rman KEEP backups and DBMS_RA.MOVE_BACKUP can be used to move backups to an external place and further archival outside of ZDLRA. Some regulations\/compliances require that backups need to be stored physically outside of the same datacenter than the database (and needs to be archived for a long-term period). Maybe move the backups is needed because your sbt_library is not compatible with rman (not allowing the use with ZDLRA), or even that the ZDLRA can&#8217;t connect at your library.<\/p>\n<p style=\"text-align: justify;\">Just remember that is impossible to move normal virtual full backups and even transform a virtual backup into one KEEP backup:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">SQL&gt; BEGIN\r\n  2      DBMS_RA.MOVE_BACKUP(\r\n  3          tag =&gt; 'LONGTERM'\r\n  4          , format =&gt; '\/radump\/longterm_%d_%U'\r\n  5          , template_name =&gt; NULL\r\n  6      );\r\n  7  END;\r\n  8  \/\r\nBEGIN\r\n*\r\nERROR at line 1:\r\nORA-45138: Backup not found.\r\nORA-06512: at \"RASYS.DBMS_RA\", line 9852\r\nORA-06512: at \"RASYS.DBMS_RA\", line 9671\r\nORA-06512: at \"RASYS.DBMS_RA\", line 9602\r\nORA-06512: at \"RASYS.DBMS_RA\", line 9831\r\nORA-06512: at line 2\r\n\r\n\r\nSQL&gt; \r\nSQL&gt; BEGIN\r\n  2      DBMS_RA.MOVE_BACKUP_PIECE(\r\n  3          bp_key =&gt; 10367\r\n  4          , format =&gt; '\/radump\/longterm_%d_%U'\r\n  5          , template_name =&gt; NULL\r\n  6      );\r\n  7  END;\r\n  8  \/\r\nBEGIN\r\n*\r\nERROR at line 1:\r\nORA-64733: unable to move individual backup piece with BP_KEY 10367; not a KEEP backup\r\nORA-06512: at \"RASYS.DBMS_RA\", line 9761\r\nORA-06512: at \"RASYS.DBMS_RA\", line 9637\r\nORA-06512: at \"SYS.DBMS_SYS_ERROR\", line 86\r\nORA-06512: at \"RASYS.DBMS_RA\", line 9616\r\nORA-06512: at \"RASYS.DBMS_RA\", line 9741\r\nORA-06512: at line 2\r\n\r\n\r\nSQL&gt;\r\n\r\nRMAN&gt; change backupset 10861 keep until time \"sysdate + 365\";\r\n\r\nusing channel ORA_SBT_TAPE_1\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=62 device type=DISK\r\nNot Supported on Recovery Appliance\r\nCannot do KEEP on virtual backups\r\n\r\nRMAN&gt;<\/pre>\n<p style=\"text-align: justify;\">&nbsp;<\/p>\n<p style=\"text-align: justify;\"><strong>Disclaimer<\/strong>: <em>\u201cThe postings on this site are my own and don\u2019t necessarily represent my actual employer positions, strategies or opinions. The information here was edited to be useful for general purpose, specific data and identifications were removed to allow reach the generic audience and to be useful for the community. Post protected by copyright.\u201d<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As I wrote previously, sometimes we need to have long-term\/archival backups due to some compliance. And usually, these backups are stores outside (like a vault\/bunker) but for sure not at the same datacenter as the database. But how we can do this at ZDLRA? In my post about COPY_BACKUP, I wrote how to have an [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[44,29,77,5,91,51],"tags":[93,100,155,65,74],"class_list":["post-825","post","type-post","status-publish","format-standard","hentry","category-backup","category-database","category-engineeredsystems","category-oracle","category-rman","category-zdlra","tag-backup","tag-engineered-systems","tag-keep","tag-oracle","tag-zdlra"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MOVE_BACKUP and ZDLRA - Fernando Simon<\/title>\n<meta name=\"description\" content=\"How to use DBMS_RA.MOVE_BACKUP and move long-term backups from ZDLRA to a filesystem allowing them to be archive externally.\" \/>\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.fernandosimon.com\/blog\/move_backup-and-zdlra\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MOVE_BACKUP and ZDLRA - Fernando Simon\" \/>\n<meta property=\"og:description\" content=\"How to use DBMS_RA.MOVE_BACKUP and move long-term backups from ZDLRA to a filesystem allowing them to be archive externally.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/\" \/>\n<meta property=\"og:site_name\" content=\"Fernando Simon\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-09T21:39:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg\" \/>\n<meta name=\"author\" content=\"Simon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simon\" \/>\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.fernandosimon.com\/blog\/move_backup-and-zdlra\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/\"},\"author\":{\"name\":\"Simon\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"headline\":\"MOVE_BACKUP and ZDLRA\",\"datePublished\":\"2020-11-09T21:39:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/\"},\"wordCount\":541,\"commentCount\":3,\"image\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg\",\"keywords\":[\"backup\",\"Engineered Systems\",\"Keep\",\"Oracle\",\"ZDLRA\"],\"articleSection\":[\"Backup\",\"Database\",\"Engineered Systems\",\"Oracle\",\"RMAN\",\"ZDLRA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/\",\"name\":\"MOVE_BACKUP and ZDLRA - Fernando Simon\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg\",\"datePublished\":\"2020-11-09T21:39:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"description\":\"How to use DBMS_RA.MOVE_BACKUP and move long-term backups from ZDLRA to a filesystem allowing them to be archive externally.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#primaryimage\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg\",\"contentUrl\":\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg\",\"width\":1000,\"height\":668},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.fernandosimon.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MOVE_BACKUP and ZDLRA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#website\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/\",\"name\":\"Fernando Simon\",\"description\":\"Have you hugged your backup today?\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fernandosimon.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\",\"name\":\"Simon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"caption\":\"Simon\"},\"sameAs\":[\"http:\/\/www.fernandosimon.com\"],\"url\":\"https:\/\/www.fernandosimon.com\/blog\/author\/simon\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MOVE_BACKUP and ZDLRA - Fernando Simon","description":"How to use DBMS_RA.MOVE_BACKUP and move long-term backups from ZDLRA to a filesystem allowing them to be archive externally.","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.fernandosimon.com\/blog\/move_backup-and-zdlra\/","og_locale":"en_US","og_type":"article","og_title":"MOVE_BACKUP and ZDLRA - Fernando Simon","og_description":"How to use DBMS_RA.MOVE_BACKUP and move long-term backups from ZDLRA to a filesystem allowing them to be archive externally.","og_url":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/","og_site_name":"Fernando Simon","article_published_time":"2020-11-09T21:39:07+00:00","og_image":[{"url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg","type":"","width":"","height":""}],"author":"Simon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Simon","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#article","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/"},"author":{"name":"Simon","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"headline":"MOVE_BACKUP and ZDLRA","datePublished":"2020-11-09T21:39:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/"},"wordCount":541,"commentCount":3,"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg","keywords":["backup","Engineered Systems","Keep","Oracle","ZDLRA"],"articleSection":["Backup","Database","Engineered Systems","Oracle","RMAN","ZDLRA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/","url":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/","name":"MOVE_BACKUP and ZDLRA - Fernando Simon","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#primaryimage"},"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg","datePublished":"2020-11-09T21:39:07+00:00","author":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"description":"How to use DBMS_RA.MOVE_BACKUP and move long-term backups from ZDLRA to a filesystem allowing them to be archive externally.","breadcrumb":{"@id":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#primaryimage","url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg","contentUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/1000x-1.jpg","width":1000,"height":668},{"@type":"BreadcrumbList","@id":"https:\/\/www.fernandosimon.com\/blog\/move_backup-and-zdlra\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fernandosimon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MOVE_BACKUP and ZDLRA"}]},{"@type":"WebSite","@id":"https:\/\/www.fernandosimon.com\/blog\/#website","url":"https:\/\/www.fernandosimon.com\/blog\/","name":"Fernando Simon","description":"Have you hugged your backup today?","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fernandosimon.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9","name":"Simon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","caption":"Simon"},"sameAs":["http:\/\/www.fernandosimon.com"],"url":"https:\/\/www.fernandosimon.com\/blog\/author\/simon\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5ofTp-dj","_links":{"self":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/comments?post=825"}],"version-history":[{"count":0,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/825\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/media?parent=825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/categories?post=825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/tags?post=825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}