{"id":695,"date":"2020-03-09T21:09:05","date_gmt":"2020-03-10T00:09:05","guid":{"rendered":"http:\/\/www.fernandosimon.com\/blog\/?p=695"},"modified":"2020-07-19T19:11:22","modified_gmt":"2020-07-19T22:11:22","slug":"zdlra-dataguard-archivelogs-and-rman-08137","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/","title":{"rendered":"ZDLRA, Dataguard, Archivelogs, and RMAN-08137"},"content":{"rendered":"

When configuring a database with Real-Time Redo at ZDLRA it is important to check the deletion policy for archivelog. This is even more important when the database is protected with dataguard. I already wrote about Real-time Redo in this previous post<\/a>, and when using with dataguard in another post<\/a>.  <\/p>\n

But sometimes (during maintenance as an example) you can face the error RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process <\/strong>if the deletion policy of archivelog is not aligned with your needs.<\/p>\n

<\/p>\n

Protection Policy<\/h2>\n

As I already wrote before, the deletion policy when suing ZDLRA is defined by the protection policy inside ZDLRA. Since the rman catalog is auto managed by recovery appliance (and what you defined at your protection policy) usually nothing is needed to do at rman side (like delete backup and others commands) because ZDLRA itself delete and crosscheck backups.<\/p>\n

But with archivelog it is a different scenario because ZDLRA can\u2019t manage it at the database side. It is your script (or yourself) that need to manage them. But since that with Real-Time Redo the backup of archivelog is automatically done by ZDLRA, you need to adapt how to delete your archivelogs.<\/p>\n

Dataguard Environment<\/h2>\n

Look the configuration below with dataguard and ZDLRA configured:<\/p>\n

DGMGRL> show configuration\r\n\r\nConfiguration - or19dg\r\n\r\n  Protection Mode: MaxAvailability\r\n  Members:\r\n  or19dg  - Primary database\r\n    or19dgs - Physical standby database\r\n      zdlras2 - Recovery appliance (receiving current redo)\r\n    zdlras1 - Recovery appliance\r\n\r\nFast-Start Failover:  Disabled\r\n\r\nConfiguration Status:\r\nSUCCESS   (status updated 14 seconds ago)\r\n\r\nDGMGRL><\/pre>\n
Two databases or19dg (primary), and or19dgs (standby); ad zdlras1 (to protect primary), and zdlras2 (to protect standby) both receiving redo.<\/p>\n
And as you can see, the backup is automatically done by Real-time redo:<\/p>\n
RMAN> list copy of archivelog all;\r\n\r\nList of Archived Log Copies for database with db_unique_name OR19DG\r\n=====================================================================\r\n\r\nKey     Thrd Seq     S Low Time\r\n------- ---- ------- - -------------------\r\n19906   1    182     A 09\/03\/2020 23:33:57\r\n        Name: +RECO\/OR19DG\/ARCHIVELOG\/2020_03_09\/thread_1_seq_182.435.1034638571\r\n\r\n19993   1    183     A 09\/03\/2020 23:36:10\r\n        Name: +RECO\/OR19DG\/ARCHIVELOG\/2020_03_09\/thread_1_seq_183.433.1034638845\r\n\r\n\r\nRMAN> alter system archive log current;\r\n\r\nStatement processed\r\n\r\nRMAN> list backup of archivelog sequence 184;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Size       Device Type Elapsed Time Completion Time\r\n------- ---------- ----------- ------------ -------------------\r\n20068   104.00K    SBT_TAPE    00:00:00     09\/03\/2020 23:44:00\r\n        BP Key: 20069   Status: AVAILABLE  Compressed: YES  Tag: TAG20200309T234400\r\n        Handle: $RSCN_1920977_RTIM_1028557385_THRD_1_SEQ_184_CTKEY_19989_BACKUP   Media:\r\n\r\n  List of Archived Logs in backup set 20068\r\n  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time\r\n  ---- ------- ---------- ------------------- ---------- ---------\r\n  1    184     2884794    09\/03\/2020 23:40:45 2885266    09\/03\/2020 23:43:39\r\n\r\nRMAN><\/pre>\n
And if I try to delete I can do it:<\/p>\n
RMAN> delete copy of archivelog sequence 184;\r\n\r\nreleased channel: ORA_SBT_TAPE_1\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=132 instance=or19dg1 device type=DISK\r\nList of Archived Log Copies for database with db_unique_name OR19DG\r\n=====================================================================\r\n\r\nKey     Thrd Seq     S Low Time\r\n------- ---- ------- - -------------------\r\n20066   1    184     A 09\/03\/2020 23:40:45\r\n        Name: +RECO\/OR19DG\/ARCHIVELOG\/2020_03_09\/thread_1_seq_184.418.1034639019\r\n\r\n\r\nDo you really want to delete the above objects (enter YES or NO)? yes\r\ndeleted archived log\r\narchived log file name=+RECO\/OR19DG\/ARCHIVELOG\/2020_03_09\/thread_1_seq_184.418.1034639019 RECID=491 STAMP=1034639019\r\nDeleted 1 objects\r\n\r\n\r\nRMAN><\/pre>\n
This was possible because the standby is up, running and applying the redo, and the configuration of archivelog deletion is the default:<\/p>\n
RMAN> show all;\r\n\r\nRMAN configuration parameters for database with db_unique_name OR19DG are:\r\n...\r\n\r\nCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default\r\n...\r\n\r\nRMAN>\r\n<\/pre>\n
But in this config, if the standby database is down for some reason (or the apply is off) and if we try to delete the archivelog we receive the error RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process.<\/strong><\/p>\n
Look that my standby is down:<\/p>\n
DGMGRL> show configuration\r\n\r\nConfiguration - or19dg\r\n\r\n  Protection Mode: MaxAvailability\r\n  Members:\r\n  or19dg  - Primary database\r\n    Warning: ORA-16629: database reports a different protection level from the protection mode\r\n\r\n    or19dgs - Physical standby database (disabled)\r\n      ORA-16906: The member was shutdown.\r\n\r\n      zdlras2 - Recovery appliance (receiving current redo)\r\n        Error: ORA-16685: database does not receive redo data\r\n\r\n    zdlras1 - Recovery appliance\r\n\r\nFast-Start Failover:  Disabled\r\n\r\nConfiguration Status:\r\nERROR   (status updated 47 seconds ago)\r\n\r\nDGMGRL><\/pre>\n
And at rman look that below I have the last sequence as 187 and if I generate a new one and try to delete it I got an error:<\/p>\n
RMAN> list copy of archivelog all;\r\n\r\nList of Archived Log Copies for database with db_unique_name OR19DG\r\n=====================================================================\r\n\r\nKey     Thrd Seq     S Low Time\r\n------- ---- ------- - -------------------\r\n20156   1    186     A 09\/03\/2020 23:45:44\r\n        Name: +RECO\/OR19DG\/ARCHIVELOG\/2020_03_09\/thread_1_seq_186.418.1034639695\r\n\r\n20157   1    187     A 09\/03\/2020 23:54:54\r\n        Name: +RECO\/OR19DG\/ARCHIVELOG\/2020_03_09\/thread_1_seq_187.421.1034639697\r\n\r\n\r\nRMAN> alter system archive log current;\r\n\r\nStatement processed\r\n\r\nRMAN> \r\ndelete copy of archivelog sequence 188;\r\n\r\nreleased channel: ORA_SBT_TAPE_1\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=132 instance=or19dg1 device type=DISK\r\nRMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process\r\narchived log file name=+RECO\/OR19DG\/ARCHIVELOG\/2020_03_09\/thread_1_seq_188.420.1034639927 thread=1 sequence=188\r\n\r\nRMAN><\/pre>\n
Changing the deletion policy<\/h3>\n
But it is possible to manage this configuring the delete policy of archivelog at rman to allow delete after backed up at tape:<\/p>\n
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DEVICE TYPE SBT;\r\n\r\nnew RMAN configuration parameters:\r\nCONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';\r\nnew RMAN configuration parameters are successfully stored\r\nstarting full resync of recovery catalog\r\nfull resync complete\r\n\r\nRMAN><\/pre>\n
Doing this, you allow the deletion of archivelog even after the standby if down:<\/p>\n
RMAN> delete copy of archivelog sequence 188;\r\n\r\nreleased channel: ORA_DISK_1\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=132 instance=or19dg1 device type=DISK\r\nList of Archived Log Copies for database with db_unique_name OR19DG\r\n=====================================================================\r\n\r\nKey     Thrd Seq     S Low Time\r\n------- ---- ------- - -------------------\r\n20221   1    188     A 09\/03\/2020 23:54:57\r\n        Name: +RECO\/OR19DG\/ARCHIVELOG\/2020_03_09\/thread_1_seq_188.420.1034639927\r\n\r\n\r\nDo you really want to delete the above objects (enter YES or NO)? yes\r\ndeleted archived log\r\narchived log file name=+RECO\/OR19DG\/ARCHIVELOG\/2020_03_09\/thread_1_seq_188.420.1034639927 RECID=500 STAMP=1034639927\r\nDeleted 1 objects\r\n\r\n\r\nRMAN><\/pre>\n
And after you return your standby you can just restore the archivelog and the synchronization will continue. You did not lose the archivelog, it is protected inside of ZDLRA:<\/p>\n
RMAN> restore archivelog sequence 188;\r\n\r\nStarting restore at 10\/03\/2020 00:25:04\r\nusing channel ORA_DISK_1\r\nallocated channel: ORA_SBT_TAPE_1\r\nchannel ORA_SBT_TAPE_1: SID=115 instance=or19dg1 device type=SBT_TAPE\r\nchannel ORA_SBT_TAPE_1: RA Library (ZDLRAS1) SID=A0755032DEC66C81E0533205A00A9FCE\r\n\r\nchannel ORA_SBT_TAPE_1: starting archived log restore to default destination\r\nchannel ORA_SBT_TAPE_1: restoring archived log\r\narchived log thread=1 sequence=188\r\nchannel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1920977_RTIM_1028557385_THRD_1_SEQ_188_CTKEY_20143_BACKUP\r\nchannel ORA_SBT_TAPE_1: piece handle=$RSCN_1920977_RTIM_1028557385_THRD_1_SEQ_188_CTKEY_20143_BACKUP tag=TAG20200309T235859\r\nchannel ORA_SBT_TAPE_1: restored backup piece 1\r\nchannel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01\r\nFinished restore at 10\/03\/2020 00:25:12\r\n\r\nRMAN><\/pre>\n
Can\u2019t fix everything<\/h3>\n
But as you imagined, if the ZDLRA is down (for some reason) and you need to delete the archivelogs you will get an error pointing that you need more backups (RMAN-08138: warning: archived log not deleted – must create more backups).<\/strong><\/p>\n
RMAN> list copy of archivelog all;\r\n\r\nusing target database control file instead of recovery catalog\r\nList of Archived Log Copies for database with db_unique_name OR19DG\r\n=====================================================================\r\n\r\nKey     Thrd Seq     S Low Time\r\n------- ---- ------- - -------------------\r\n505     1    190     A 09\/03\/2020 23:58:51\r\n        Name: +RECO\/OR19DG\/ARCHIVELOG\/2020_03_10\/thread_1_seq_190.435.1034641661\r\n\r\n513     1    191     A 10\/03\/2020 00:27:39\r\n        Name: +RECO\/OR19DG\/ARCHIVELOG\/2020_03_10\/thread_1_seq_191.429.1034641663\r\n\r\n516     1    192     A 10\/03\/2020 00:27:41\r\n        Name: +RECO\/OR19DG\/ARCHIVELOG\/2020_03_10\/thread_1_seq_192.433.1034641857\r\n\r\n519     1    193     A 10\/03\/2020 00:30:57\r\n        Name: +RECO\/OR19DG\/ARCHIVELOG\/2020_03_10\/thread_1_seq_193.420.1034641915\r\n\r\n\r\nRMAN> alter system archive log current;\r\n\r\nStatement processed\r\n\r\nRMAN> \r\nlist backup of archivelog sequence 194;\r\n\r\nspecification does not match any backup in the repository\r\n\r\nRMAN> delete copy of archivelog sequence 194;\r\n\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=117 instance=or19dg1 device type=DISK\r\nRMAN-08138: warning: archived log not deleted - must create more backups\r\narchived log file name=+RECO\/OR19DG\/ARCHIVELOG\/2020_03_10\/thread_1_seq_194.421.1034642149 thread=1 sequence=194\r\n\r\nRMAN><\/pre>\n
You can use force if needed:<\/p>\n
RMAN> delete force copy of archivelog sequence 194;\r\n\r\nreleased channel: ORA_DISK_1\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=117 instance=or19dg1 device type=DISK\r\nList of Archived Log Copies for database with db_unique_name OR19DG\r\n=====================================================================\r\n\r\nKey     Thrd Seq     S Low Time\r\n------- ---- ------- - -------------------\r\n522     1    194     A 10\/03\/2020 00:31:53\r\n        Name: +RECO\/OR19DG\/ARCHIVELOG\/2020_03_10\/thread_1_seq_194.421.1034642149\r\n\r\n\r\nDo you really want to delete the above objects (enter YES or NO)? yes\r\ndeleted archived log\r\narchived log file name=+RECO\/OR19DG\/ARCHIVELOG\/2020_03_10\/thread_1_seq_194.421.1034642149 RECID=522 STAMP=1034642148\r\nDeleted 1 objects\r\n\r\n\r\nRMAN><\/pre>\n
Architecture<\/h2>\n
The point here is the architecture design, the idea is always to remove the single point of failure. Even if you have the standby down, with the ZDLRA and database configured with Real-Time Redo you have RPO ZERO.<\/p>\n
\"\"<\/a><\/p>\n
Of course, that as showed before, you need to take care of archivelog deletion policy to allow delete archivelogs when standby is down. But as you saw too, this can have another collateral effect. Unfortunately, there is no rule of thumb here, you need to sit and check what it is the best in this case: If you want to delete archivelogs just when they were copied to standby or when they were backed up at ZDLRA.<\/p>\n
The point was shown to you the options that you have to solve this common issue when using ZDLRA and Dataguard. If you want to dig more, you can see the archivelog definition at the Oracle docs for rman<\/a>. Or check this post<\/a> from Frank Pachot.<\/p>\n
 <\/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":"
When configuring a database with Real-Time Redo at ZDLRA it is important to check the deletion policy for archivelog. This is even more important when the database is protected with dataguard. I already wrote about Real-time Redo in this previous post, and when using with dataguard in another post.   But sometimes (during maintenance as […]<\/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,41,29,77,51],"tags":[133,93,122,100,65,132],"class_list":["post-695","post","type-post","status-publish","format-standard","hentry","category-backup","category-data-guard","category-database","category-engineeredsystems","category-zdlra","tag-archivelog","tag-backup","tag-dataguard","tag-engineered-systems","tag-oracle","tag-zdrla"],"yoast_head":"\nZDLRA, Dataguard, Archivelogs, and RMAN-08137 - Fernando Simon<\/title>\n<meta name=\"description\" content=\"Check some options how to solve (or mitigate) the error RMAN-08137 when usinng DataGuard with ZDLRA and Real-Time Redo.\" \/>\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\/zdlra-dataguard-archivelogs-and-rman-08137\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ZDLRA, Dataguard, Archivelogs, and RMAN-08137 - Fernando Simon\" \/>\n<meta property=\"og:description\" content=\"Check some options how to solve (or mitigate) the error RMAN-08137 when usinng DataGuard with ZDLRA and Real-Time Redo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/\" \/>\n<meta property=\"og:site_name\" content=\"Fernando Simon\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-10T00:09:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-19T22:11:22+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/03\/ZDLRA-and-DG.png\" \/>\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=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/\"},\"author\":{\"name\":\"Simon\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"headline\":\"ZDLRA, Dataguard, Archivelogs, and RMAN-08137\",\"datePublished\":\"2020-03-10T00:09:05+00:00\",\"dateModified\":\"2020-07-19T22:11:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/\"},\"wordCount\":701,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/03\/ZDLRA-and-DG.png\",\"keywords\":[\"Archivelog\",\"backup\",\"dataguard\",\"Engineered Systems\",\"Oracle\",\"ZDRLA\"],\"articleSection\":[\"Backup\",\"Data Guard\",\"Database\",\"Engineered Systems\",\"ZDLRA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/\",\"name\":\"ZDLRA, Dataguard, Archivelogs, and RMAN-08137 - Fernando Simon\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/03\/ZDLRA-and-DG.png\",\"datePublished\":\"2020-03-10T00:09:05+00:00\",\"dateModified\":\"2020-07-19T22:11:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"description\":\"Check some options how to solve (or mitigate) the error RMAN-08137 when usinng DataGuard with ZDLRA and Real-Time Redo.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#primaryimage\",\"url\":\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/03\/ZDLRA-and-DG.png\",\"contentUrl\":\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/03\/ZDLRA-and-DG.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.fernandosimon.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ZDLRA, Dataguard, Archivelogs, and RMAN-08137\"}]},{\"@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":"ZDLRA, Dataguard, Archivelogs, and RMAN-08137 - Fernando Simon","description":"Check some options how to solve (or mitigate) the error RMAN-08137 when usinng DataGuard with ZDLRA and Real-Time Redo.","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\/zdlra-dataguard-archivelogs-and-rman-08137\/","og_locale":"en_US","og_type":"article","og_title":"ZDLRA, Dataguard, Archivelogs, and RMAN-08137 - Fernando Simon","og_description":"Check some options how to solve (or mitigate) the error RMAN-08137 when usinng DataGuard with ZDLRA and Real-Time Redo.","og_url":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/","og_site_name":"Fernando Simon","article_published_time":"2020-03-10T00:09:05+00:00","article_modified_time":"2020-07-19T22:11:22+00:00","og_image":[{"url":"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/03\/ZDLRA-and-DG.png","type":"","width":"","height":""}],"author":"Simon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Simon","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#article","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/"},"author":{"name":"Simon","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"headline":"ZDLRA, Dataguard, Archivelogs, and RMAN-08137","datePublished":"2020-03-10T00:09:05+00:00","dateModified":"2020-07-19T22:11:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/"},"wordCount":701,"commentCount":1,"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#primaryimage"},"thumbnailUrl":"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/03\/ZDLRA-and-DG.png","keywords":["Archivelog","backup","dataguard","Engineered Systems","Oracle","ZDRLA"],"articleSection":["Backup","Data Guard","Database","Engineered Systems","ZDLRA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/","url":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/","name":"ZDLRA, Dataguard, Archivelogs, and RMAN-08137 - Fernando Simon","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#primaryimage"},"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#primaryimage"},"thumbnailUrl":"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/03\/ZDLRA-and-DG.png","datePublished":"2020-03-10T00:09:05+00:00","dateModified":"2020-07-19T22:11:22+00:00","author":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"description":"Check some options how to solve (or mitigate) the error RMAN-08137 when usinng DataGuard with ZDLRA and Real-Time Redo.","breadcrumb":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#primaryimage","url":"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/03\/ZDLRA-and-DG.png","contentUrl":"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/03\/ZDLRA-and-DG.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fernandosimon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ZDLRA, Dataguard, Archivelogs, and RMAN-08137"}]},{"@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-bd","_links":{"self":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/695","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=695"}],"version-history":[{"count":0,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/695\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/media?parent=695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/categories?post=695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/tags?post=695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}