{"id":15583,"date":"2020-06-01T13:22:11","date_gmt":"2020-06-01T13:22:11","guid":{"rendered":"https:\/\/dbtut.com\/?p=15583"},"modified":"2020-06-01T13:33:06","modified_gmt":"2020-06-01T13:33:06","slug":"delete-archive-logs-automatically-on-standby","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/","title":{"rendered":"Delete Archive logs Automatically on Standby"},"content":{"rendered":"<p>To delete archive logs automatically on standby you should set LOG_AUTO_DEL_RETENTION_TARGET\u00a0 parameter. The Foreign Archive Logs in Logical Standby Database is automatically deleted by SQL Apply after the time specified in the LOG_AUTO_DEL_RETENTION_TARGET parameter.<\/p>\n<p>Automatic deletion can be delayed with the DBMS_LOGSTDBY.APPLY_SET procedure.<\/p>\n<p>Lets test it;<\/p>\n<h3>Step 1:<\/h3>\n<p>Query deleted logs.<\/p>\n<pre class=\"lang:default decode:true \">[Logical - 04-03-2017 21:06:55] SQL&gt; column file_name format a105\r\n[Logical - 04-03-2017 21:07:05] SQL&gt; SELECT * FROM DBA_LOGMNR_PURGED_LOG;\r\n\r\nFILE_NAME\r\n---------------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_50_dclvkng2_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_51_dclvknft_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_52_dclvrgtp_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_53_dclvrq2c_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_54_dclwb296_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_55_dclwccow_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_56_dclxzx3n_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_57_dcly5j87_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_58_dclzsrz2_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_59_dcmlt7hy_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_60_dcmlv2sp_.arc\r\n\r\nFILE_NAME\r\n---------------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_61_dcmlvv59_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_62_dcmlxh21_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_63_dcmodg64_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_64_dcn7xlq2_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_65_dcnh1gcs_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_66_dcnx9opj_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_67_dco4w7j7_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_68_dcocdnsl_.arc\r\n\r\n19 rows selected.<\/pre>\n<h3>Step 2:<\/h3>\n<p>Query whether logs are deleted by the operating system.<\/p>\n<pre class=\"lang:default decode:true\">[oracle@logical 2017_03_03]$ pwd\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\r\n[oracle@logical 2017_03_03]$ ll\r\ntotal 205724\r\n-rw-r----- 1 oracle oinstall 18794496 Mar  3 15:23 o1_mf_1_50_dclvkng2_.arc\r\n-rw-r----- 1 oracle oinstall     7680 Mar  3 15:23 o1_mf_1_51_dclvknft_.arc\r\n-rw-r----- 1 oracle oinstall   563200 Mar  3 15:26 o1_mf_1_52_dclvrgtp_.arc\r\n-rw-r----- 1 oracle oinstall     5120 Mar  3 15:26 o1_mf_1_53_dclvrq2c_.arc\r\n-rw-r----- 1 oracle oinstall   352256 Mar  3 15:36 o1_mf_1_54_dclwb296_.arc\r\n-rw-r----- 1 oracle oinstall    27648 Mar  3 15:36 o1_mf_1_55_dclwccow_.arc\r\n-rw-r----- 1 oracle oinstall  4408832 Mar  3 16:04 o1_mf_1_56_dclxzx3n_.arc\r\n-rw-r----- 1 oracle oinstall   148480 Mar  3 16:07 o1_mf_1_57_dcly5j87_.arc\r\n-rw-r----- 1 oracle oinstall  1494528 Mar  3 16:35 o1_mf_1_58_dclzsrz2_.arc\r\n-rw-r----- 1 oracle oinstall 39453696 Mar  3 22:00 o1_mf_1_59_dcmlt7hy_.arc\r\n-rw-r----- 1 oracle oinstall 34148864 Mar  3 22:00 o1_mf_1_60_dcmlv2sp_.arc\r\n-rw-r----- 1 oracle oinstall 39014400 Mar  3 22:00 o1_mf_1_61_dcmlvv59_.arc\r\n-rw-r----- 1 oracle oinstall 38416384 Mar  3 22:01 o1_mf_1_62_dcmlxh21_.arc\r\n-rw-r----- 1 oracle oinstall 33534976 Mar  3 22:43 o1_mf_1_63_dcmodg64_.arc\r\n\r\n\r\n[oracle@logical 2017_03_03]$ cd ..\r\n[oracle@logical primary]$ cd 2017_03_04\/\r\n[oracle@logical 2017_03_04]$ ll\r\ntotal 233988\r\n-rw-r----- 1 oracle oinstall 33626624 Mar  4 04:00 o1_mf_1_64_dcn7xlq2_.arc\r\n-rw-r----- 1 oracle oinstall 37053440 Mar  4 06:01 o1_mf_1_65_dcnh1gcs_.arc\r\n-rw-r----- 1 oracle oinstall 35869696 Mar  4 10:05 o1_mf_1_66_dcnx9opj_.arc\r\n-rw-r----- 1 oracle oinstall 33534464 Mar  4 12:14 o1_mf_1_67_dco4w7j7_.arc\r\n-rw-r----- 1 oracle oinstall 35462144 Mar  4 14:05 o1_mf_1_68_dcocdnsl_.arc\r\n-rw-r----- 1 oracle oinstall 34808832 Mar  4 18:05 o1_mf_1_69_dcosh5xd_.arc\r\n-rw-r----- 1 oracle oinstall 28633088 Mar  4 21:10 o1_mf_1_70_dcp48o0w_.arc\r\n-rw-r----- 1 oracle oinstall   316416 Mar  4 21:13 o1_mf_1_71_dcp4gm6m_.arc<\/pre>\n<h3>Step 3:<\/h3>\n<p>Set the Log_Auto_Del_Retention_Target Parameter to an appropriate value, and check if the logs are automatically deleted.<\/p>\n<pre class=\"lang:default decode:true \">[Logical - 04-03-2017 21:08:12] SQL&gt;  execute dbms_logstdby.apply_set('LOG_AUTO_DEL_RETENTION_TARGET',60);\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\n[Logical - 04-03-2017 21:08:31] SQL&gt; execute dbms_logstdby.apply_set ('LOG_AUTO_DELETE','TRUE');\r\n\r\nPL\/SQL procedure successfully completed.<\/pre>\n<h3>Step 4:<\/h3>\n<p>Check if the logs are deleted.<\/p>\n<pre class=\"lang:default decode:true \">[Logical - 04-03-2017 21:08:47] SQL&gt; set linesize 9000\r\n[Logical - 04-03-2017 21:08:59] SQL&gt; column file_name format a105\r\n[Logical - 04-03-2017 21:09:07] SQL&gt; SELECT * FROM DBA_LOGMNR_PURGED_LOG;\r\n\r\nFILE_NAME\r\n---------------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_50_dclvkng2_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_51_dclvknft_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_52_dclvrgtp_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_53_dclvrq2c_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_54_dclwb296_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_55_dclwccow_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_56_dclxzx3n_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_57_dcly5j87_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_58_dclzsrz2_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_59_dcmlt7hy_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_60_dcmlv2sp_.arc\r\n\r\nFILE_NAME\r\n---------------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_61_dcmlvv59_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_62_dcmlxh21_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_63_dcmodg64_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_64_dcn7xlq2_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_65_dcnh1gcs_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_66_dcnx9opj_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_67_dco4w7j7_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_68_dcocdnsl_.arc\r\n\r\n19 rows selected.\r\n<\/pre>\n<h3>Step 5:<\/h3>\n<p>Check to see if the 69. Archive has been applied, which should be deleted but has not been deleted.<\/p>\n<pre class=\"lang:default decode:true \">[Logical - 04-03-2017 21:09:09] SQL&gt; SELECT SEQUENCE#, THREAD#, APPLIED FROM DBA_LOGSTDBY_LOG;\r\n\r\n SEQUENCE#    THREAD# APPLIED\r\n---------- ---------- --------\r\n        50          1 YES\r\n        51          1 YES\r\n        52          1 YES\r\n        53          1 YES\r\n        54          1 YES\r\n        55          1 YES\r\n        56          1 YES\r\n        57          1 YES\r\n        58          1 YES\r\n        59          1 YES\r\n        60          1 YES\r\n\r\n SEQUENCE#    THREAD# APPLIED\r\n---------- ---------- --------\r\n        61          1 YES\r\n        62          1 YES\r\n        63          1 YES\r\n        64          1 YES\r\n        65          1 YES\r\n        66          1 YES\r\n        67          1 YES\r\n        68          1 YES\r\n        69          1 YES\r\n        70          1 YES\r\n\r\n21 rows selected.<\/pre>\n<h3>Step 6:<\/h3>\n<p>Manually trigger Procedure, which will delete logs.<\/p>\n<pre class=\"lang:default decode:true \">[Logical - 04-03-2017 21:21:49] SQL&gt; EXECUTE DBMS_LOGSTDBY.PURGE_SESSION;\r\n\r\nPL\/SQL procedure successfully completed.<\/pre>\n<h3>Step 7:<\/h3>\n<p>Check if the logs are deleted.<\/p>\n<pre class=\"lang:default decode:true \">[Logical - 04-03-2017 21:22:18] SQL&gt; SELECT * FROM DBA_LOGMNR_PURGED_LOG;\r\n\r\nFILE_NAME\r\n---------------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_50_dclvkng2_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_51_dclvknft_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_52_dclvrgtp_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_53_dclvrq2c_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_54_dclwb296_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_55_dclwccow_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_56_dclxzx3n_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_57_dcly5j87_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_58_dclzsrz2_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_59_dcmlt7hy_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_60_dcmlv2sp_.arc\r\n\r\nFILE_NAME\r\n---------------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_61_dcmlvv59_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_62_dcmlxh21_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_03\/o1_mf_1_63_dcmodg64_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_64_dcn7xlq2_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_65_dcnh1gcs_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_66_dcnx9opj_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_67_dco4w7j7_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_68_dcocdnsl_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_69_dcosh5xd_.arc\r\n\/u01\/app\/oracle\/fast_recovery_area\/LOGICAL\/foreign_archivelog\/primary\/2017_03_04\/o1_mf_1_70_dcp48o0w_.arc\r\n\r\n21 rows selected.<\/pre>\n<h3>Step 8:<\/h3>\n<p>Create CRONJOB to delete Logs on the operating system side.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15583\" class=\"pvc_stats all  \" data-element-id=\"15583\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>To delete archive logs automatically on standby you should set LOG_AUTO_DEL_RETENTION_TARGET\u00a0 parameter. The Foreign Archive Logs in Logical Standby Database is automatically deleted by SQL Apply after the time specified in the LOG_AUTO_DEL_RETENTION_TARGET parameter. Automatic deletion can be delayed with the DBMS_LOGSTDBY.APPLY_SET procedure. Lets test it; Step 1: Query deleted logs. [Logical &#8211; 04-03-2017 21:06:55] &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15583\" class=\"pvc_stats all  \" data-element-id=\"15583\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":484,"featured_media":15584,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[9614,9619,9615,9612,9611,9613,9618,9617,9616,9620],"class_list":["post-15583","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-automatically-delete-archive-logs-standby","tag-configure-archivelog-deletion-policy-to-applied-on-all-standby","tag-delete-archive-logs-automatically-on-standby","tag-delete-redo-logs-automatically-on-standby","tag-delete-standby-redo-logs-automatically","tag-how-do-i-get-rid-of-standby-redo-logs","tag-how-to-delete-applied-archive-logs-on-standby-database","tag-not-yet-applied-by-standby","tag-rman-08120-warning-archived-log-not-deleted","tag-standby-delete-applied-archivelog"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":3165,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Delete Archive logs Automatically on Standby - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Delete Archive logs Automatically on Standby\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Delete Archive logs Automatically on Standby - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Delete Archive logs Automatically on Standby\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-01T13:22:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-06-01T13:33:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/06\/Ads\u0131z.png\" \/>\n\t<meta property=\"og:image:width\" content=\"529\" \/>\n\t<meta property=\"og:image:height\" content=\"322\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\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:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Delete Archive logs Automatically on Standby\",\"datePublished\":\"2020-06-01T13:22:11+00:00\",\"dateModified\":\"2020-06-01T13:33:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/\"},\"wordCount\":150,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/06\/Ads\u0131z.png\",\"keywords\":[\"automatically delete archive logs standby\",\"CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY\",\"Delete Archive logs Automatically on Standby\",\"Delete Redo logs Automatically on Standby\",\"delete standby redo logs automatically\",\"How do I get rid of standby redo logs?\",\"How to delete applied archive logs on standby database\",\"not yet applied by standby\",\"RMAN-08120: WARNING: archived log not deleted\",\"Standby delete applied archivelog\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/\",\"name\":\"Delete Archive logs Automatically on Standby - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/06\/Ads\u0131z.png\",\"datePublished\":\"2020-06-01T13:22:11+00:00\",\"dateModified\":\"2020-06-01T13:33:06+00:00\",\"description\":\"Delete Archive logs Automatically on Standby\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/06\/Ads\u0131z.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/06\/Ads\u0131z.png\",\"width\":529,\"height\":322},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Delete Archive logs Automatically on Standby\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Delete Archive logs Automatically on Standby - Database Tutorials","description":"Delete Archive logs Automatically on Standby","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:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/","og_locale":"en_US","og_type":"article","og_title":"Delete Archive logs Automatically on Standby - Database Tutorials","og_description":"Delete Archive logs Automatically on Standby","og_url":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/","og_site_name":"Database Tutorials","article_published_time":"2020-06-01T13:22:11+00:00","article_modified_time":"2020-06-01T13:33:06+00:00","og_image":[{"width":529,"height":322,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/06\/Ads\u0131z.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Delete Archive logs Automatically on Standby","datePublished":"2020-06-01T13:22:11+00:00","dateModified":"2020-06-01T13:33:06+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/"},"wordCount":150,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/06\/Ads\u0131z.png","keywords":["automatically delete archive logs standby","CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY","Delete Archive logs Automatically on Standby","Delete Redo logs Automatically on Standby","delete standby redo logs automatically","How do I get rid of standby redo logs?","How to delete applied archive logs on standby database","not yet applied by standby","RMAN-08120: WARNING: archived log not deleted","Standby delete applied archivelog"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/","url":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/","name":"Delete Archive logs Automatically on Standby - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/06\/Ads\u0131z.png","datePublished":"2020-06-01T13:22:11+00:00","dateModified":"2020-06-01T13:33:06+00:00","description":"Delete Archive logs Automatically on Standby","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/06\/Ads\u0131z.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/06\/Ads\u0131z.png","width":529,"height":322},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/06\/01\/delete-archive-logs-automatically-on-standby\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Delete Archive logs Automatically on Standby"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=15583"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15583\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/15584"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=15583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=15583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=15583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}