{"id":821,"date":"2020-10-26T19:04:51","date_gmt":"2020-10-26T22:04:51","guid":{"rendered":"https:\/\/www.fernandosimon.com\/blog\/?p=821"},"modified":"2020-10-26T19:04:51","modified_gmt":"2020-10-26T22:04:51","slug":"copy_backup-at-zdlra","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/","title":{"rendered":"COPY_BACKUP at ZDLRA"},"content":{"rendered":"

As you know, ZDLRA is one appliance dedicated to provides you zero data loss in several (planned and unplanned) outages. All the backups are stored inside of the delta store<\/a> to be processed, and they are deconstructed, meaning that the rman backup set does not exist (as is the formal backup set file).<\/p>\n

But sometimes we need to copy\/extract some backups outside of ZDLRA and copy it to the filesystem. Maybe because some regulations\/compliances need to store for long-term\/archival purposes. But some caveats are important to be explained.<\/p>\n

\"\"<\/a><\/p>\n

<\/p>\n

The DBMS_RA.COPY_BACKUP<\/a> (and COPY_BACKUP_PIECE) procedure allows us to copy backups sets from one library to another one. But also allow us to copy to disk, extracting it from ZDLRA.<\/p>\n

As you can see in the reference, if we define the \u201ctemplate_name\u201d as null, the backupset is exported to a filesystem mounted at ZDLRA. So, it an easy way that allows us to export backupsets from ZDLRA. The way to do that is to specify the \u201cformat\u201d parameter using the same rules\/definition as rman and pointing to fs.<\/p>\n

Look below some backups for datafile 1 that are stored at ZDLRA:<\/p>\n

RMAN> list backup of datafile 1 summary device type sbt_tape;\r\n\r\n\r\nList of Backups\r\n===============\r\nKey     TY LV S Device Type Completion Time     #Pieces #Copies Compressed Tag\r\n------- -- -- - ----------- ------------------- ------- ------- ---------- ---\r\n9372    B  0  A SBT_TAPE    04\/10\/2020 19:37:39 1       1       YES        TAG20201004T193527\r\n9562    B  1  A SBT_TAPE    04\/10\/2020 20:07:03 1       1       YES        TAG20201004T200657\r\n9637    B  0  A SBT_TAPE    04\/10\/2020 20:07:03 1       1       YES        TAG20201004T200657\r\n9832    B  1  A SBT_TAPE    04\/10\/2020 20:19:10 1       1       YES        COPYBKP\r\n9845    B  0  A SBT_TAPE    04\/10\/2020 20:19:10 1       1       YES        COPYBKP\r\n9928    B  1  A SBT_TAPE    04\/10\/2020 20:23:36 1       1       YES        TAG20201004T202331\r\n10083   B  0  A SBT_TAPE    04\/10\/2020 20:23:36 1       1       YES        TAG20201004T202331\r\n\r\nRMAN>  list backup of datafile 1 tag 'COPYBKP';\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\n9832    Incr 1  80.00K     SBT_TAPE    00:00:02     04\/10\/2020 20:19:10\r\n        BP Key: 9833   Status: AVAILABLE  Compressed: YES  Tag: COPYBKP\r\n        Handle: VB$_1918343643_9831I   Media:\r\n  List of Datafiles in backup set 9832\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    1  Incr 2591788    04\/10\/2020 20:19:08              NO    \/u01\/app\/oracle\/oradata\/ORCL19C\/system01.dbf\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n9845    Incr 0  323.84M    SBT_TAPE    00:00:02     04\/10\/2020 20:19:10\r\n        BP Key: 9846   Status: AVAILABLE  Compressed: YES  Tag: COPYBKP\r\n        Handle: VB$_1918343643_9831_1   Media:\r\n  List of Datafiles in backup set 9845\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 2591788    04\/10\/2020 20:19:08              NO    \/u01\/app\/oracle\/oradata\/ORCL19C\/system01.dbf\r\n\r\nRMAN><\/pre>\n
As you can see above I have two backups with the tag COPYBKP for datafile 1. Two virtual backups generated by ZDLRA.<\/p>\n
So, I will copy these (and all with the same TAG) to a folder inside of ZDLRA. This is a local folder existing in both nodes of ZDLRA and can be an NFS mount point as well. So, to do that, I connected to the ZDLRA database and called the COPY_BACKUP:<\/p>\n
SQL> BEGIN\r\n  2      DBMS_RA.COPY_BACKUP(\r\n  3          tag => 'COPYBKP'\r\n  4          , format => '\/radump\/copybkp_%d_%U'\r\n  5          , template_name => NULL\r\n  6      );\r\n  7  END;\r\n  8  \/\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL><\/pre>\n
And at \u201c\/radump\u201d folder for ZDLRA now we have the backup sets from rman:<\/p>\n
[root@zdlras1n1 ~]# ls -lh \/radump\/copybkp_*\r\n-rw-r----- 1 oracle dba 218M Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_24vc5961_1_2\r\n-rw-r----- 1 oracle dba 168K Oct  4 20:30 \/radump\/copybkp_ZDLRAS1_5gvc595s_1_2\r\n-rw-r----- 1 oracle dba 160K Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_5hvc595t_1_2\r\n-rw-r----- 1 oracle dba 216K Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_5ivc595u_1_2\r\n-rw-r----- 1 oracle dba 112K Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_5kvc5961_1_2\r\n-rw-r----- 1 oracle dba  48K Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_5lvc5962_1_2\r\n-rw-r----- 1 oracle dba 208K Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_5ovc5964_1_2\r\n-rw-r----- 1 oracle dba  48K Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_5pvc5965_1_2\r\n-rw-r----- 1 oracle dba  48K Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_5qvc5966_1_2\r\n-rw-r----- 1 oracle dba 3.7M Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_7ivc595u_1_2\r\n-rw-r----- 1 oracle dba 453K Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_8svc596e_1_2\r\n-rw-r----- 1 oracle dba 1.2M Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_bqvc5966_1_2\r\n-rw-r----- 1 oracle dba 356M Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_f1vc595t_1_2\r\n-rw-r----- 1 oracle dba 2.3M Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_h9vc5965_1_2\r\n-rw-r----- 1 oracle dba 1.6M Oct  4 20:30 \/radump\/copybkp_ZDLRAS1_j8vc5964_1_2\r\n-rw-r----- 1 oracle dba 194M Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_qlvc5962_1_2\r\n-rw-r----- 1 oracle dba 767M Oct  4 20:29 \/radump\/copybkp_ZDLRAS1_u0vc595s_1_2\r\n[root@zdlras1n1 ~]#<\/pre>\n
These files are all the backup set with tag COPYBKP and you can see that the catalog was updated too. Now we have two copies of these backup sets:<\/p>\n
RMAN> list backup of datafile 1 summary device type sbt_tape tag 'COPYBKP';\r\n\r\n\r\nList of Backups\r\n===============\r\nKey     TY LV S Device Type Completion Time     #Pieces #Copies Compressed Tag\r\n------- -- -- - ----------- ------------------- ------- ------- ---------- ---\r\n9832    B  1  A SBT_TAPE    04\/10\/2020 20:30:08 1       2       NO         COPYBKP\r\n9845    B  0  A SBT_TAPE    04\/10\/2020 20:29:26 1       2       NO         COPYBKP\r\n\r\nRMAN> list backup of datafile 1 summary device type sbt_tape;\r\n\r\n\r\nList of Backups\r\n===============\r\nKey     TY LV S Device Type Completion Time     #Pieces #Copies Compressed Tag\r\n------- -- -- - ----------- ------------------- ------- ------- ---------- ---\r\n9372    B  0  A SBT_TAPE    04\/10\/2020 19:37:39 1       1       YES        TAG20201004T193527\r\n9562    B  1  A SBT_TAPE    04\/10\/2020 20:07:03 1       1       YES        TAG20201004T200657\r\n9637    B  0  A SBT_TAPE    04\/10\/2020 20:07:03 1       1       YES        TAG20201004T200657\r\n9832    B  1  A SBT_TAPE    04\/10\/2020 20:30:08 1       2       NO         COPYBKP\r\n9845    B  0  A SBT_TAPE    04\/10\/2020 20:29:26 1       2       YES        COPYBKP\r\n9928    B  1  A SBT_TAPE    04\/10\/2020 20:23:36 1       1       YES        TAG20201004T202331\r\n10083   B  0  A SBT_TAPE    04\/10\/2020 20:23:36 1       1       YES        TAG20201004T202331\r\n\r\nRMAN> list backupset 9832;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size\r\n------- ---- -- ----------\r\n9832    Incr 1  80.00K\r\n  List of Datafiles in backup set 9832\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    1  Incr 2591788    04\/10\/2020 20:19:08              NO    \/u01\/app\/oracle\/oradata\/ORCL19C\/system01.dbf\r\n\r\n  Backup Set Copy #1 of backup set 9832\r\n  Device Type Elapsed Time Completion Time     Compressed Tag\r\n  ----------- ------------ ------------------- ---------- ---\r\n  SBT_TAPE    00:11:00     04\/10\/2020 20:19:10 YES        COPYBKP\r\n\r\n    List of Backup Pieces for backup set 9832 Copy #1\r\n    BP Key  Pc# Status      Media                   Piece Name\r\n    ------- --- ----------- ----------------------- ----------\r\n    9833    1   AVAILABLE                           VB$_1918343643_9831I\r\n\r\n  Backup Set Copy #2 of backup set 9832\r\n  Device Type Elapsed Time Completion Time     Compressed Tag\r\n  ----------- ------------ ------------------- ---------- ---\r\n  SBT_TAPE    00:11:00     04\/10\/2020 20:30:08 NO         COPYBKP\r\n\r\n    List of Backup Pieces for backup set 9832 Copy #2\r\n    BP Key  Pc# Status      Media                   Piece Name\r\n    ------- --- ----------- ----------------------- ----------\r\n    10203   1   AVAILABLE                           \/radump\/copybkp_ZDLRAS1_5gvc595s_1_2\r\n\r\nRMAN> list backupset 9845;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size\r\n------- ---- -- ----------\r\n9845    Incr 0  766.46M\r\n  List of Datafiles in backup set 9845\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 2591788    04\/10\/2020 20:19:08              NO    \/u01\/app\/oracle\/oradata\/ORCL19C\/system01.dbf\r\n\r\n  Backup Set Copy #2 of backup set 9845\r\n  Device Type Elapsed Time Completion Time     Compressed Tag\r\n  ----------- ------------ ------------------- ---------- ---\r\n  SBT_TAPE    00:10:18     04\/10\/2020 20:29:26 NO         COPYBKP\r\n\r\n    List of Backup Pieces for backup set 9845 Copy #2\r\n    BP Key  Pc# Status      Media                   Piece Name\r\n    ------- --- ----------- ----------------------- ----------\r\n    10154   1   AVAILABLE                           \/radump\/copybkp_ZDLRAS1_u0vc595s_1_2\r\n\r\n  Backup Set Copy #1 of backup set 9845\r\n  Device Type Elapsed Time Completion Time     Compressed Tag\r\n  ----------- ------------ ------------------- ---------- ---\r\n  SBT_TAPE    00:10:18     04\/10\/2020 20:19:10 YES        COPYBKP\r\n\r\n    List of Backup Pieces for backup set 9845 Copy #1\r\n    BP Key  Pc# Status      Media                   Piece Name\r\n    ------- --- ----------- ----------------------- ----------\r\n    9846    1   AVAILABLE                           VB$_1918343643_9831_1\r\n\r\nRMAN><\/pre>\n
Look above that for bs 9832 and 9845 now we have two copies. But the caveat here is that these copies have the same retention that the original backup set. If you are thinking to use the COPY_BACKUP as one way to have archival backups stored outside they are not the best option. They will be deleted from the rman catalog after the RECOVERY_WINDOW of it expired. And if you try to extend this time window frame, you will affect all the backupsets and probably impose pressure of used spaced for ZDLRA. The best option is to use the KEED backups for rman.<\/p>\n
If you want to copy just one backup set you can use the DBMS_RA.COPY_BACKUP_PIECE, it will work ate the same way as COPY_BACKUP. Another option is to copy between libraries\/tapes to improve the consolidation of the tapes. I already show how to do this in one previous post<\/a>.<\/p>\n
 <\/p>\n
Disclaimer<\/strong>: \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":"
As you know, ZDLRA is one appliance dedicated to provides you zero data loss in several (planned and unplanned) outages. All the backups are stored inside of the delta store to be processed, and they are deconstructed, meaning that the rman backup set does not exist (as is the formal backup set file). But sometimes […]<\/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,65,74],"class_list":["post-821","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-oracle","tag-zdlra"],"yoast_head":"\nCOPY_BACKUP at ZDLRA - Fernando Simon<\/title>\n<meta name=\"description\" content=\"How to use DBMS_RA.COPY_BACKUP to copy\/extract your backupset at one filesystem inside ZDLRA. But also what are the caveats of that.\" \/>\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\/copy_backup-at-zdlra\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"COPY_BACKUP at ZDLRA - Fernando Simon\" \/>\n<meta property=\"og:description\" content=\"How to use DBMS_RA.COPY_BACKUP to copy\/extract your backupset at one filesystem inside ZDLRA. But also what are the caveats of that.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/\" \/>\n<meta property=\"og:site_name\" content=\"Fernando Simon\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-26T22:04:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/5e6b994af3ed766cfa24b058_Backup.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\/copy_backup-at-zdlra\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/\"},\"author\":{\"name\":\"Simon\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"headline\":\"COPY_BACKUP at ZDLRA\",\"datePublished\":\"2020-10-26T22:04:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/\"},\"wordCount\":529,\"commentCount\":4,\"image\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/5e6b994af3ed766cfa24b058_Backup.jpg\",\"keywords\":[\"backup\",\"Engineered Systems\",\"Oracle\",\"ZDLRA\"],\"articleSection\":[\"Backup\",\"Database\",\"Engineered Systems\",\"Oracle\",\"RMAN\",\"ZDLRA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/\",\"name\":\"COPY_BACKUP at ZDLRA - Fernando Simon\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/5e6b994af3ed766cfa24b058_Backup.jpg\",\"datePublished\":\"2020-10-26T22:04:51+00:00\",\"author\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"description\":\"How to use DBMS_RA.COPY_BACKUP to copy\/extract your backupset at one filesystem inside ZDLRA. But also what are the caveats of that.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#primaryimage\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/5e6b994af3ed766cfa24b058_Backup.jpg\",\"contentUrl\":\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/5e6b994af3ed766cfa24b058_Backup.jpg\",\"width\":900,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.fernandosimon.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"COPY_BACKUP at 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":"COPY_BACKUP at ZDLRA - Fernando Simon","description":"How to use DBMS_RA.COPY_BACKUP to copy\/extract your backupset at one filesystem inside ZDLRA. But also what are the caveats of that.","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\/copy_backup-at-zdlra\/","og_locale":"en_US","og_type":"article","og_title":"COPY_BACKUP at ZDLRA - Fernando Simon","og_description":"How to use DBMS_RA.COPY_BACKUP to copy\/extract your backupset at one filesystem inside ZDLRA. But also what are the caveats of that.","og_url":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/","og_site_name":"Fernando Simon","article_published_time":"2020-10-26T22:04:51+00:00","og_image":[{"url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/5e6b994af3ed766cfa24b058_Backup.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\/copy_backup-at-zdlra\/#article","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/"},"author":{"name":"Simon","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"headline":"COPY_BACKUP at ZDLRA","datePublished":"2020-10-26T22:04:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/"},"wordCount":529,"commentCount":4,"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/5e6b994af3ed766cfa24b058_Backup.jpg","keywords":["backup","Engineered Systems","Oracle","ZDLRA"],"articleSection":["Backup","Database","Engineered Systems","Oracle","RMAN","ZDLRA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/","url":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/","name":"COPY_BACKUP at ZDLRA - Fernando Simon","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#primaryimage"},"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/5e6b994af3ed766cfa24b058_Backup.jpg","datePublished":"2020-10-26T22:04:51+00:00","author":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"description":"How to use DBMS_RA.COPY_BACKUP to copy\/extract your backupset at one filesystem inside ZDLRA. But also what are the caveats of that.","breadcrumb":{"@id":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#primaryimage","url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/5e6b994af3ed766cfa24b058_Backup.jpg","contentUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/10\/5e6b994af3ed766cfa24b058_Backup.jpg","width":900,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.fernandosimon.com\/blog\/copy_backup-at-zdlra\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fernandosimon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"COPY_BACKUP at 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-df","_links":{"self":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/821","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=821"}],"version-history":[{"count":0,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/821\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/media?parent=821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/categories?post=821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/tags?post=821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}