{"id":10562,"date":"2017-10-22T19:02:31","date_gmt":"2017-10-22T17:02:31","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/"},"modified":"2017-10-22T19:02:31","modified_gmt":"2017-10-22T17:02:31","slug":"archivelog-deletion-policy-on-data-guard-configuration","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/","title":{"rendered":"Archivelog deletion policy on Data Guard configuration"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nThe deletion policy on a dataguard configuration should be:<\/p>\n<pre><code>\nCONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\n<\/code><\/pre>\n<p>for the site where you don&#8217;t backup. It can be the standby or the primary.<\/p>\n<p>and:<\/p>\n<pre><code>\nCONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;\n<\/code><\/pre>\n<p>for the site where you do the backups. It can be the primary or the standby.<\/p>\n<p>I&#8217;ve always configured it in this way, but I recently discovered that the order of the subclause matters. Do not CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK APPLIED ON ALL STANDBY; because no archivelogs will be reclaimable, and your recovery area will be full. This is probably a bug. I&#8217;ll update this post when I have more information about this.<\/p>\n<h3>Test case<\/h3>\n<p>I&#8217;m on the standby database where I do the backups:<\/p>\n<pre><code>\n&nbsp;\nRecovery Manager: Release 12.2.0.1.0 - Production on Sun Oct 22 17:37:18 2017\n&nbsp;\nCopyright (c) 1982, 2017, Oracle and\/or its affiliates.  All rights reserved.\n&nbsp;\nRMAN-06568: connected to target database: CDB2 (DBID=693620717, not open)\n&nbsp;\nRMAN&gt; \nRMAN-03029: echo set on\n&nbsp;\n<\/code><\/pre>\n<p>I start with all default configuration:<\/p>\n<pre><code>\nRMAN&gt; show all;\nRMAN-06607: RMAN configuration parameters for database with db_unique_name CDB2B are:\nRMAN-01005: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default\nRMAN-01005: CONFIGURE BACKUP OPTIMIZATION OFF; # default\nRMAN-01005: CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default\nRMAN-01005: CONFIGURE CONTROLFILE AUTOBACKUP ON; # default\nRMAN-01005: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default\nRMAN-01005: CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default\nRMAN-01005: CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default\nRMAN-01005: CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default\nRMAN-01005: CONFIGURE MAXSETSIZE TO UNLIMITED; # default\nRMAN-01005: CONFIGURE ENCRYPTION FOR DATABASE OFF; # default\nRMAN-01005: CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default\nRMAN-01005: CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default\nRMAN-01005: CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default\nRMAN-01005: CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default\nRMAN-01005: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/dbs\/snapcf_CDB2B.f'; # default\n<\/code><\/pre>\n<p>I have one full backup and then some archivelog backups:<\/p>\n<pre><code>\nRMAN&gt; list backup summary;\nRMAN-06345: List of Backups\nRMAN-06346: ===============\nRMAN-06347: Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag\nRMAN-06348: ------- -- -- - ----------- --------------- ------- ------- ---------- ---\nRMAN-06349: 9       B  F  A DISK        22-OCT 17:05:16 1       1       NO         TAG20171022T170250\nRMAN-06349: 10      B  F  A DISK        22-OCT 17:06:23 1       1       NO         TAG20171022T170250\nRMAN-06349: 11      B  F  A DISK        22-OCT 17:07:18 1       1       NO         TAG20171022T170250\nRMAN-06349: 12      B  F  A DISK        22-OCT 17:07:35 1       1       NO         TAG20171022T170732\nRMAN-06349: 13      B  A  A DISK        22-OCT 17:15:09 1       1       NO         TAG20171022T171502\nRMAN-06349: 14      B  F  A DISK        22-OCT 17:15:19 1       1       NO         TAG20171022T171518\nRMAN-06349: 15      B  A  A DISK        22-OCT 17:27:28 1       1       NO         TAG20171022T172721\nRMAN-06349: 16      B  F  A DISK        22-OCT 17:27:39 1       1       NO         TAG20171022T172737\n<\/code><\/pre>\n<p>I have no obsolete backups:<\/p>\n<pre><code>\nRMAN&gt; report obsolete;\nRMAN-06524: RMAN retention policy will be applied to the command\nRMAN-06511: RMAN retention policy is set to redundancy 1\nRMAN-06147: no obsolete backups found\n<\/code><\/pre>\n<h3>APPLIED ON ALL STANDBY<\/h3>\n<p>I have 1.8% of the recovery area that has been applied:<\/p>\n<pre><code>\nRMAN&gt; configure archivelog deletion policy to applied on all standby;\nRMAN-06601: new RMAN configuration parameters:\nRMAN-01005: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\nRMAN-06604: new RMAN configuration parameters are successfully stored\n&nbsp;\n&nbsp;\nRMAN&gt; select percent_space_used,percent_space_reclaimable,number_of_files from v$recovery_area_usage where file_type='ARCHIVED LOG';\nRMAN-01005: PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES\nRMAN-01005: ------------------ ------------------------- ---------------\nRMAN-01005:                1.3                      1.08               3\n<\/code><\/pre>\n<h3>BACKED UP 1 TIMES TO DISK<\/h3>\n<p>I have 1.3% of the recovery area that has been backed up:<\/p>\n<pre><code>\nRMAN&gt; configure archivelog deletion policy to backed up 1 times to disk;\nRMAN-06600: old RMAN configuration parameters:\nRMAN-01005: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\nRMAN-06601: new RMAN configuration parameters:\nRMAN-01005: CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;\nRMAN-06604: new RMAN configuration parameters are successfully stored\n&nbsp;\n&nbsp;\nRMAN&gt; select percent_space_used,percent_space_reclaimable,number_of_files from v$recovery_area_usage where file_type='ARCHIVED LOG';\nRMAN-01005: PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES\nRMAN-01005: ------------------ ------------------------- ---------------\nRMAN-01005:                1.3                       1.3               3\n<\/code><\/pre>\n<p>This looks good. I have some archived logs that have been applied but not backed up yet.<\/p>\n<h3>Both in the &#8216;bad&#8217; order<\/h3>\n<p>But now I want to combine both:<\/p>\n<pre><code>\nRMAN&gt; configure archivelog deletion policy to backed up 1 times to disk applied on all standby;\nRMAN-06600: old RMAN configuration parameters:\nRMAN-01005: CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;\nRMAN-06601: new RMAN configuration parameters:\nRMAN-01005: CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK APPLIED ON ALL STANDBY;\nRMAN-06604: new RMAN configuration parameters are successfully stored\n&nbsp;\n&nbsp;\nRMAN&gt; select percent_space_used,percent_space_reclaimable,number_of_files from v$recovery_area_usage where file_type='ARCHIVED LOG';\nRMAN-01005: PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES\nRMAN-01005: ------------------ ------------------------- ---------------\nRMAN-01005:                1.3                         0               3\n<\/code><\/pre>\n<p>Nothing is recoverable here, wich is in my opinion a bug.<\/p>\n<h3>Both in the &#8216;right&#8217; order<\/h3>\n<p>Trying the same but with different order:<\/p>\n<pre><code>\nRMAN&gt; configure archivelog deletion policy to applied on all standby backed up 1 times to disk;\nRMAN-06600: old RMAN configuration parameters:\nRMAN-01005: CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK APPLIED ON ALL STANDBY;\nRMAN-06601: new RMAN configuration parameters:\nRMAN-01005: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;\nRMAN-06604: new RMAN configuration parameters are successfully stored\n&nbsp;\n&nbsp;\nRMAN&gt; select percent_space_used,percent_space_reclaimable,number_of_files from v$recovery_area_usage where file_type='ARCHIVED LOG';\nRMAN-01005: PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES\nRMAN-01005: ------------------ ------------------------- ---------------\nRMAN-01005:                1.3                      1.08               3\n<\/code><\/pre>\n<p>This look good. 1.08% have been applied and backed up.<\/p>\n<p>I&#8217;ve verified the same behavior when backups are done on primary, or on standby, and same in 11.2.0.4, 12.1 and 12.2 with latest RU.<br \/>\nWhen the deletion policy is starting with the backup clause before the standby clause, the files are not marked as reclaimable. However, they are deleted with a &#8216;delete archivelog&#8217; statement without the &#8216;force&#8217; option.<br \/>\nThe behavior is the same with &#8216;shipped to&#8217; instead of &#8216;applied on&#8217;.<\/p>\n<h3>So what?<\/h3>\n<p>Be careful with the syntax: the &#8216;applied&#8217; or &#8216;shipped&#8217; clause must be written before the &#8216;backup&#8217; one.<br \/>\nCheck that archived logs are reclaimable. The query I use for that is in: <a href=\"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-for-standby-database-in-oracle-data-guard\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-for-standby-database-in-oracle-data-guard\/<\/a>. When more archived log detail is required, I&#8217;ve also this query: <a href=\"https:\/\/www.dbi-services.com\/blog\/drilling-down-vrecoveryareausage\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.dbi-services.com\/blog\/drilling-down-vrecoveryareausage\/<\/a><br \/>\nAlways have a look at the recovery area usage after you change the deletion policy, the site where you backup, or after a switchover.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . The deletion policy on a dataguard configuration should be: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; for the site where you don&#8217;t backup. It can be the standby or the primary. and: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK; for the&hellip;&nbsp;<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[59],"tags":[221,593],"class_list":["post-10562","post","type-post","status-publish","format-standard","category-oracle","tag-data-guard","tag-fra"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Archivelog deletion policy on Data Guard configuration - dbi services 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\/archivelog-deletion-policy-on-data-guard-configuration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Archivelog deletion policy on Data Guard configuration\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . The deletion policy on a dataguard configuration should be: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; for the site where you don&#8217;t backup. It can be the standby or the primary. and: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK; for the&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-22T17:02:31+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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=\"5 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\\\/archivelog-deletion-policy-on-data-guard-configuration\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/archivelog-deletion-policy-on-data-guard-configuration\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\"},\"headline\":\"Archivelog deletion policy on Data Guard configuration\",\"datePublished\":\"2017-10-22T17:02:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/archivelog-deletion-policy-on-data-guard-configuration\\\/\"},\"wordCount\":391,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"keywords\":[\"Data Guard\",\"fra\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/archivelog-deletion-policy-on-data-guard-configuration\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/archivelog-deletion-policy-on-data-guard-configuration\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/archivelog-deletion-policy-on-data-guard-configuration\\\/\",\"name\":\"Archivelog deletion policy on Data Guard configuration - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2017-10-22T17:02:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/archivelog-deletion-policy-on-data-guard-configuration\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/archivelog-deletion-policy-on-data-guard-configuration\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/archivelog-deletion-policy-on-data-guard-configuration\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Archivelog deletion policy on Data Guard configuration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"caption\":\"Oracle Team\"},\"description\":\"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Archivelog deletion policy on Data Guard configuration - dbi services 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\/archivelog-deletion-policy-on-data-guard-configuration\/","og_locale":"en_US","og_type":"article","og_title":"Archivelog deletion policy on Data Guard configuration","og_description":"By Franck Pachot . The deletion policy on a dataguard configuration should be: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; for the site where you don&#8217;t backup. It can be the standby or the primary. and: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK; for the&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2017-10-22T17:02:31+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5"},"headline":"Archivelog deletion policy on Data Guard configuration","datePublished":"2017-10-22T17:02:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/"},"wordCount":391,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"keywords":["Data Guard","fra"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/","url":"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/","name":"Archivelog deletion policy on Data Guard configuration - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-10-22T17:02:31+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/archivelog-deletion-policy-on-data-guard-configuration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Archivelog deletion policy on Data Guard configuration"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","caption":"Oracle Team"},"description":"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.","url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10562","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=10562"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10562\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}