{"id":3684,"date":"2021-04-10T08:41:19","date_gmt":"2021-04-10T08:41:19","guid":{"rendered":"https:\/\/swiv.com.br\/reporting-rman-obsolete-backup-files\/"},"modified":"2026-05-27T20:02:33","modified_gmt":"2026-05-27T19:02:33","slug":"reporting-rman-obsolete-backup-files","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/04\/10\/reporting-rman-obsolete-backup-files\/","title":{"rendered":"Reporting RMAN obsolete backup files"},"content":{"rendered":"\n<p>Os arquivos de backup do RMAN que n\u00e3o s\u00e3o mais necess\u00e1rios para satisfazer a pol\u00edtica de reten\u00e7\u00e3o (seja em dias de janela ou tem quantidade de backups) s\u00e3o marcados como obsoletos, e uma vez assim, geralmente s\u00e3o deletados pelas rotinas de administra\u00e7\u00e3o emitidas pelos DBAs (at\u00e9 para n\u00e3o esgotarmos o tamanho da \u00e1rea de backup).<\/p>\n\n\n\n<p>O comando REPORT nos permite visualizar esses arquivos obsoletos. Abaixo temos a atual pol\u00edtica de reten\u00e7\u00e3o do RMAN:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Fri Apr 9 21:15:56 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n \nconnected to target database: RMANDB (DBID=3825250984)\n \nRMAN&gt; SHOW RETENTION POLICY;\n \nusing target database control file instead of recovery catalog\nRMAN configuration parameters for database with db_unique_name RMANDB are:\nCONFIGURE RETENTION POLICY TO REDUNDANCY 2;\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Visualizando os arquivos obsoletos:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; REPORT OBSOLETE;\n \nRMAN retention policy will be applied to the command\nRMAN retention policy is set to redundancy 2\nReport of obsolete backups and copies\nType                 Key    Completion Time    Filename\/Handle\n-------------------- ------ ------------------ --------------------\nArchive Log          74     2021-03-28:10:40:00 \/oracle\/archives\/1_67_1036964654.dbf\nBackup Set           155    2021-04-09:04:32:22\n  Backup Piece       155    2021-04-09:04:32:22 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389141_j700r62m_.bkp\nBackup Set           156    2021-04-09:04:34:09\n  Backup Piece       156    2021-04-09:04:34:09 \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vk1w_.bkp\nBackup Set           157    2021-04-09:04:34:10\n  Backup Piece       157    2021-04-09:04:34:10 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389250_j700vlmc_.bkp\nBackup Set           158    2021-04-09:04:34:16\n  Backup Piece       158    2021-04-09:04:34:16 \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vrh3_.bkp\nBackup Set           159    2021-04-09:04:34:18\n  Backup Piece       159    2021-04-09:04:34:18 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389257_j700vt63_.bkp\nBackup Set           160    2021-04-09:04:40:00\n  Backup Piece       160    2021-04-09:04:40:00 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389599_j7016hx3_.bkp\nBackup Set           162    2021-04-09:04:43:05\n  Backup Piece       162    2021-04-09:04:43:05 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389785_j701d9kj_.bkp\nBackup Set           163    2021-04-09:04:49:52\n  Backup Piece       163    2021-04-09:04:49:52 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069390192_j701s0pz_.bkp\nBackup Set           165    2021-04-09:05:17:23\n  Backup Piece       165    2021-04-09:05:17:23 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069391842_j703dm1l_.bkp\nBackup Set           167    2021-04-09:05:20:34\n  Backup Piece       167    2021-04-09:05:20:34 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069392033_j703llbt_.bkp\nBackup Set           169    2021-04-09:05:20:55\n  Backup Piece       169    2021-04-09:05:20:55 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069392054_j703m70y_.bkp\nBackup Set           170    2021-04-09:05:23:47\n  Backup Piece       170    2021-04-09:05:23:47 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069392227_j703rmm7_.bkp\nBackup Set           171    2021-04-09:20:21:01\n  Backup Piece       171    2021-04-09:20:21:01 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069446060_j71rbxfh_.bkp\nBackup Set           172    2021-04-09:20:41:05\n  Backup Piece       172    2021-04-09:20:41:05 \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_TAG20210409T204104_j71sjk5l_.bkp\nBackup Set           173    2021-04-09:20:41:07\n  Backup Piece       173    2021-04-09:20:41:07 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069447266_j71sjlrt_.bkp\nBackup Set           174    2021-04-09:20:45:44\n  Backup Piece       174    2021-04-09:20:45:44 \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_TAG20210409T204544_j71ss8jf_.bkp\nBackup Set           175    2021-04-09:20:45:46\n  Backup Piece       175    2021-04-09:20:45:46 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069447545_j71ssb5n_.bkp\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Deletando os arquivos obsoletos:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; DELETE OBSOLETE;\n \nRMAN retention policy will be applied to the command\nRMAN retention policy is set to redundancy 2\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=68 device type=DISK\nDeleting the following obsolete backups and copies:\nType                 Key    Completion Time    Filename\/Handle\n-------------------- ------ ------------------ --------------------\nArchive Log          74     2021-03-28:10:40:00 \/oracle\/archives\/1_67_1036964654.dbf\nBackup Set           155    2021-04-09:04:32:22\n  Backup Piece       155    2021-04-09:04:32:22 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389141_j700r62m_.bkp\nBackup Set           156    2021-04-09:04:34:09\n  Backup Piece       156    2021-04-09:04:34:09 \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vk1w_.bkp\nBackup Set           157    2021-04-09:04:34:10\n  Backup Piece       157    2021-04-09:04:34:10 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389250_j700vlmc_.bkp\nBackup Set           158    2021-04-09:04:34:16\n  Backup Piece       158    2021-04-09:04:34:16 \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vrh3_.bkp\nBackup Set           159    2021-04-09:04:34:18\n  Backup Piece       159    2021-04-09:04:34:18 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389257_j700vt63_.bkp\nBackup Set           160    2021-04-09:04:40:00\n  Backup Piece       160    2021-04-09:04:40:00 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389599_j7016hx3_.bkp\nBackup Set           162    2021-04-09:04:43:05\n  Backup Piece       162    2021-04-09:04:43:05 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389785_j701d9kj_.bkp\nBackup Set           163    2021-04-09:04:49:52\n  Backup Piece       163    2021-04-09:04:49:52 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069390192_j701s0pz_.bkp\nBackup Set           165    2021-04-09:05:17:23\n  Backup Piece       165    2021-04-09:05:17:23 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069391842_j703dm1l_.bkp\nBackup Set           167    2021-04-09:05:20:34\n  Backup Piece       167    2021-04-09:05:20:34 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069392033_j703llbt_.bkp\nBackup Set           169    2021-04-09:05:20:55\n  Backup Piece       169    2021-04-09:05:20:55 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069392054_j703m70y_.bkp\nBackup Set           170    2021-04-09:05:23:47\n  Backup Piece       170    2021-04-09:05:23:47 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069392227_j703rmm7_.bkp\nBackup Set           171    2021-04-09:20:21:01\n  Backup Piece       171    2021-04-09:20:21:01 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069446060_j71rbxfh_.bkp\nBackup Set           172    2021-04-09:20:41:05\n  Backup Piece       172    2021-04-09:20:41:05 \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_TAG20210409T204104_j71sjk5l_.bkp\nBackup Set           173    2021-04-09:20:41:07\n  Backup Piece       173    2021-04-09:20:41:07 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069447266_j71sjlrt_.bkp\nBackup Set           174    2021-04-09:20:45:44\n  Backup Piece       174    2021-04-09:20:45:44 \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_TAG20210409T204544_j71ss8jf_.bkp\nBackup Set           175    2021-04-09:20:45:46\n  Backup Piece       175    2021-04-09:20:45:46 \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069447545_j71ssb5n_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? YES\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_67_1036964654.dbf RECID=74 STAMP=1068374400\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389141_j700r62m_.bkp RECID=155 STAMP=1069389142\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vk1w_.bkp RECID=156 STAMP=1069389249\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389250_j700vlmc_.bkp RECID=157 STAMP=1069389250\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vrh3_.bkp RECID=158 STAMP=1069389256\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389257_j700vt63_.bkp RECID=159 STAMP=1069389258\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389599_j7016hx3_.bkp RECID=160 STAMP=1069389599\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389785_j701d9kj_.bkp RECID=162 STAMP=1069389785\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069390192_j701s0pz_.bkp RECID=163 STAMP=1069390192\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069391842_j703dm1l_.bkp RECID=165 STAMP=1069391843\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069392033_j703llbt_.bkp RECID=167 STAMP=1069392034\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069392054_j703m70y_.bkp RECID=169 STAMP=1069392055\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069392227_j703rmm7_.bkp RECID=170 STAMP=1069392227\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069446060_j71rbxfh_.bkp RECID=171 STAMP=1069446061\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_TAG20210409T204104_j71sjk5l_.bkp RECID=172 STAMP=1069447265\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069447266_j71sjlrt_.bkp RECID=173 STAMP=1069447266\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_TAG20210409T204544_j71ss8jf_.bkp RECID=174 STAMP=1069447544\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069447545_j71ssb5n_.bkp RECID=175 STAMP=1069447546\nDeleted 18 objects\n<\/pre><\/div>\n\n\n<p>Ambiente n\u00e3o possui mais arquivos de backups obsoletos:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; REPORT OBSOLETE;\n \nRMAN retention policy will be applied to the command\nRMAN retention policy is set to redundancy 2\nno obsolete backups found\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Os arquivos de backup do RMAN que n\u00e3o s\u00e3o mais necess\u00e1rios para satisfazer a pol\u00edtica de reten\u00e7\u00e3o (seja em dias de janela ou tem quantidade de backups) s\u00e3o marcados como obsoletos, e uma vez assim, geralmente s\u00e3o deletados pelas rotinas de administra\u00e7\u00e3o emitidas pelos DBAs (at\u00e9 para n\u00e3o esgotarmos o tamanho da \u00e1rea de backup). [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3684","post","type-post","status-publish","format-standard","hentry","category-backup-recovery"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=3684"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3684\/revisions"}],"predecessor-version":[{"id":9179,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3684\/revisions\/9179"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=3684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=3684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=3684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}