Reporting RMAN obsolete backup files

Backup & Recovery / 14/07/2022

Os arquivos de backup do RMAN que não são mais necessários para satisfazer a política de retenção (seja em dias de janela ou tem quantidade de backups) são marcados como obsoletos, e uma vez assim, geralmente são deletados pelas rotinas de administração emitidas pelos DBAs (até para não esgotarmos o tamanho da área de backup).

O comando REPORT nos permite visualizar esses arquivos obsoletos. Abaixo temos a atual política de retenção do RMAN:

[oracle@oel8 ~]$ rman target /
 
Recovery Manager: Release 18.0.0.0.0 - Production on Fri Apr 9 21:15:56 2021
Version 18.13.0.0.0
 
Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database: RMANDB (DBID=3825250984)
 
RMAN> SHOW RETENTION POLICY;
 
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name RMANDB are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
 
RMAN>

Visualizando os arquivos obsoletos:

RMAN> REPORT OBSOLETE;
 
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          74     2021-03-28:10:40:00 /oracle/archives/1_67_1036964654.dbf
Backup Set           155    2021-04-09:04:32:22
  Backup Piece       155    2021-04-09:04:32:22 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389141_j700r62m_.bkp
Backup Set           156    2021-04-09:04:34:09
  Backup Piece       156    2021-04-09:04:34:09 /oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_USERS_BS_j700vk1w_.bkp
Backup Set           157    2021-04-09:04:34:10
  Backup Piece       157    2021-04-09:04:34:10 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389250_j700vlmc_.bkp
Backup Set           158    2021-04-09:04:34:16
  Backup Piece       158    2021-04-09:04:34:16 /oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_USERS_BS_j700vrh3_.bkp
Backup Set           159    2021-04-09:04:34:18
  Backup Piece       159    2021-04-09:04:34:18 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389257_j700vt63_.bkp
Backup Set           160    2021-04-09:04:40:00
  Backup Piece       160    2021-04-09:04:40:00 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389599_j7016hx3_.bkp
Backup Set           162    2021-04-09:04:43:05
  Backup Piece       162    2021-04-09:04:43:05 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389785_j701d9kj_.bkp
Backup Set           163    2021-04-09:04:49:52
  Backup Piece       163    2021-04-09:04:49:52 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069390192_j701s0pz_.bkp
Backup Set           165    2021-04-09:05:17:23
  Backup Piece       165    2021-04-09:05:17:23 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069391842_j703dm1l_.bkp
Backup Set           167    2021-04-09:05:20:34
  Backup Piece       167    2021-04-09:05:20:34 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069392033_j703llbt_.bkp
Backup Set           169    2021-04-09:05:20:55
  Backup Piece       169    2021-04-09:05:20:55 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069392054_j703m70y_.bkp
Backup Set           170    2021-04-09:05:23:47
  Backup Piece       170    2021-04-09:05:23:47 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069392227_j703rmm7_.bkp
Backup Set           171    2021-04-09:20:21:01
  Backup Piece       171    2021-04-09:20:21:01 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069446060_j71rbxfh_.bkp
Backup Set           172    2021-04-09:20:41:05
  Backup Piece       172    2021-04-09:20:41:05 /oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_TAG20210409T204104_j71sjk5l_.bkp
Backup Set           173    2021-04-09:20:41:07
  Backup Piece       173    2021-04-09:20:41:07 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069447266_j71sjlrt_.bkp
Backup Set           174    2021-04-09:20:45:44
  Backup Piece       174    2021-04-09:20:45:44 /oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_TAG20210409T204544_j71ss8jf_.bkp
Backup Set           175    2021-04-09:20:45:46
  Backup Piece       175    2021-04-09:20:45:46 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069447545_j71ssb5n_.bkp
 
RMAN>

Deletando os arquivos obsoletos:

RMAN> DELETE OBSOLETE;
 
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=68 device type=DISK
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          74     2021-03-28:10:40:00 /oracle/archives/1_67_1036964654.dbf
Backup Set           155    2021-04-09:04:32:22
  Backup Piece       155    2021-04-09:04:32:22 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389141_j700r62m_.bkp
Backup Set           156    2021-04-09:04:34:09
  Backup Piece       156    2021-04-09:04:34:09 /oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_USERS_BS_j700vk1w_.bkp
Backup Set           157    2021-04-09:04:34:10
  Backup Piece       157    2021-04-09:04:34:10 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389250_j700vlmc_.bkp
Backup Set           158    2021-04-09:04:34:16
  Backup Piece       158    2021-04-09:04:34:16 /oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_USERS_BS_j700vrh3_.bkp
Backup Set           159    2021-04-09:04:34:18
  Backup Piece       159    2021-04-09:04:34:18 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389257_j700vt63_.bkp
Backup Set           160    2021-04-09:04:40:00
  Backup Piece       160    2021-04-09:04:40:00 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389599_j7016hx3_.bkp
Backup Set           162    2021-04-09:04:43:05
  Backup Piece       162    2021-04-09:04:43:05 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389785_j701d9kj_.bkp
Backup Set           163    2021-04-09:04:49:52
  Backup Piece       163    2021-04-09:04:49:52 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069390192_j701s0pz_.bkp
Backup Set           165    2021-04-09:05:17:23
  Backup Piece       165    2021-04-09:05:17:23 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069391842_j703dm1l_.bkp
Backup Set           167    2021-04-09:05:20:34
  Backup Piece       167    2021-04-09:05:20:34 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069392033_j703llbt_.bkp
Backup Set           169    2021-04-09:05:20:55
  Backup Piece       169    2021-04-09:05:20:55 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069392054_j703m70y_.bkp
Backup Set           170    2021-04-09:05:23:47
  Backup Piece       170    2021-04-09:05:23:47 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069392227_j703rmm7_.bkp
Backup Set           171    2021-04-09:20:21:01
  Backup Piece       171    2021-04-09:20:21:01 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069446060_j71rbxfh_.bkp
Backup Set           172    2021-04-09:20:41:05
  Backup Piece       172    2021-04-09:20:41:05 /oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_TAG20210409T204104_j71sjk5l_.bkp
Backup Set           173    2021-04-09:20:41:07
  Backup Piece       173    2021-04-09:20:41:07 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069447266_j71sjlrt_.bkp
Backup Set           174    2021-04-09:20:45:44
  Backup Piece       174    2021-04-09:20:45:44 /oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_TAG20210409T204544_j71ss8jf_.bkp
Backup Set           175    2021-04-09:20:45:46
  Backup Piece       175    2021-04-09:20:45:46 /oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069447545_j71ssb5n_.bkp
 
Do you really want to delete the above objects (enter YES or NO)? YES
deleted archived log
archived log file name=/oracle/archives/1_67_1036964654.dbf RECID=74 STAMP=1068374400
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389141_j700r62m_.bkp RECID=155 STAMP=1069389142
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_USERS_BS_j700vk1w_.bkp RECID=156 STAMP=1069389249
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389250_j700vlmc_.bkp RECID=157 STAMP=1069389250
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_USERS_BS_j700vrh3_.bkp RECID=158 STAMP=1069389256
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389257_j700vt63_.bkp RECID=159 STAMP=1069389258
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389599_j7016hx3_.bkp RECID=160 STAMP=1069389599
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069389785_j701d9kj_.bkp RECID=162 STAMP=1069389785
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069390192_j701s0pz_.bkp RECID=163 STAMP=1069390192
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069391842_j703dm1l_.bkp RECID=165 STAMP=1069391843
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069392033_j703llbt_.bkp RECID=167 STAMP=1069392034
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069392054_j703m70y_.bkp RECID=169 STAMP=1069392055
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069392227_j703rmm7_.bkp RECID=170 STAMP=1069392227
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069446060_j71rbxfh_.bkp RECID=171 STAMP=1069446061
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_TAG20210409T204104_j71sjk5l_.bkp RECID=172 STAMP=1069447265
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069447266_j71sjlrt_.bkp RECID=173 STAMP=1069447266
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/backupset/2021_04_09/o1_mf_nnndf_TAG20210409T204544_j71ss8jf_.bkp RECID=174 STAMP=1069447544
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_04_09/o1_mf_s_1069447545_j71ssb5n_.bkp RECID=175 STAMP=1069447546
Deleted 18 objects

Ambiente não possui mais arquivos de backups obsoletos:

RMAN> REPORT OBSOLETE;
 
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
no obsolete backups found
 
RMAN>

Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laboratório pessoal para fins de aprendizado.

Leave a Comment

Your email address will not be published.

pt Portuguese
en Englishpt Portuguesees Spanish