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
|
|
|
Goto Forum:
Current Time: Thu Apr 03 04:20:43 CDT 2025
|