Home » RDBMS Server » Backup & Recovery » obsolete disk backup found in report obsolete but not in report obsolete device type disk (12.1.0.2 windows 2016 Data Center)
- obsolete disk backup found in report obsolete but not in report obsolete device type disk [message #675027] Tue, 05 March 2019 20:12
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear all,

I found obsolete disk backup in report obsolete but not in report obsolete device type disk.

obsolete disk backup found in report obsolete recovery window of 1 days
RMAN> SET ECHO ON
2> 
3> REPORT OBSOLETE RECOVERY WINDOW OF 1 DAYS;
4> 
5> EXIT
RMAN-03029: echo set on

RMAN-06009: using target database control file instead of recovery catalog
RMAN-06280: Report of obsolete backups and copies
RMAN-06281: Type                 Key    Completion Time    Filename/Handle
RMAN-06282: -------------------- ------ ------------------ --------------------
RMAN-06284: Backup Set           3      2018-12-20 14:16:08
RMAN-06285:   Backup Piece       3      2018-12-20 14:16:08 R:\BACKUP\BILLCDB\DF_LEVEL0_BILLCDB_S3_U03TL8I54_1_1_T995379364
RMAN-06284: Backup Set           5      2018-12-20 14:16:23
RMAN-06285:   Backup Piece       5      2018-12-20 14:16:23 R:\BACKUP\BILLCDB\DF_LEVEL0_BILLCDB_S5_U05TL8I5I_1_1_T995379378
RMAN-06284: Backup Set           6      2018-12-20 14:16:28
RMAN-06285:   Backup Piece       6      2018-12-20 14:16:28 R:\BACKUP\BILLCDB\DF_LEVEL0_BILLCDB_S6_U06TL8I5Q_1_1_T995379386
RMAN-06284: Backup Set           31     2018-12-20 14:17:06
RMAN-06285:   Backup Piece       31     2018-12-20 14:17:06 R:\BACKUP\BILLCDB\DF_LEVEL0_BILLCDB_S31_U0VTL8I72_1_1_T995379426
RMAN-06286: Proxy Copy           27     2019-03-01 11:39:51 bk_dBILLCDB_u1atrbchk_s42_p27_t1001763380
RMAN-06284: Backup Set           40     2018-12-20 14:17:18
RMAN-06285:   Backup Piece       40     2018-12-20 14:17:18 R:\BACKUP\BILLCDB\CONTROLCOPY.CTL_BILLCDB_S40_T995379437
RMAN-06286: Proxy Copy           28     2019-03-01 11:39:51 bk_dBILLCDB_u1atrbchk_s42_p28_t1001763380
........................................................

obsolete disk backup not found in report obsolete recovery window of 1 days device type disk;

RMAN> SET ECHO ON
2> 
3> REPORT OBSOLETE RECOVERY WINDOW OF 1 DAYS DEVICE TYPE disk;
4> 
5> EXIT
RMAN-03029: echo set on

RMAN-06009: using target database control file instead of recovery catalog
RMAN-06147: no obsolete backups found

Recovery Manager complete.




may I know why? I've done crosscheck of backup and archivelog

I supposed report obsolete recovery window of 1 days device type disk is a subset of report obsolete recovery window of 1 days

many thanks in advance
Previous Topic: RMAN Restore
Next Topic: Database directory got removed.
Goto Forum:
  


Current Time: Thu Apr 03 04:20:43 CDT 2025