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: 239
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: Mon Oct 21 12:29:38 CDT 2019