| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Dreadful RMAN bug
Hi,
On my platform, when I run "report obsolete" (and "delete obsolete") with a retention policy set to a recovery window, RMAN treats as obsolete *all* controlfile autobackups created at the end of each online database backup (including the last one, even if there is no other controlfile backup afterward)!
RMAN & Oracle server versions are 9.2.0.1.0. Did anyone encounter the same behavior? I run Oracle on an unsupported OS (FreeBSD in Linux compatibility mode), but it'd be strange if this was the cause of this problem.
Example with a newly created database:
RMAN> show RETENTION POLICY;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;
RMAN> list backup;
List of Backup Sets
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1 955K DISK 00:00:01 16/03/2004 12:14:22
BP Key: 1 Status: AVAILABLE Tag: TAG20040316T121421
Piece Name: /usr/orabackup/01fgq3st_1_1
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 220 50146 16/03/2004 11:54:39 50696 16/03/2004 12:08:55
1 221 50696 16/03/2004 12:08:55 50869 16/03/2004 12:14:20
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2 Incr 0 119M DISK 00:00:24 16/03/2004 12:14:47
BP Key: 2 Status: AVAILABLE Tag: TAG20040316T121423
Piece Name: /usr/orabackup/02fgq3sv_1_1
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0 Incr 50871 16/03/2004 12:14:23 /usr/oradata1/NAIN/system01.dbf
2 0 Incr 50871 16/03/2004 12:14:23 /usr/oradata2/NAIN/undotbs01.dbf
3 0 Incr 50871 16/03/2004 12:14:23 /usr/oradata3/NAIN/nain01.dbf
4 0 Incr 50871 16/03/2004 12:14:23 /usr/oradata2/NAIN/indnain01.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
3 3K DISK 00:00:01 16/03/2004 12:14:50
BP Key: 3 Status: AVAILABLE Tag: TAG20040316T121449
Piece Name: /usr/orabackup/03fgq3tp_1_1
List of Archived Logs in backup set 3
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 222 50869 16/03/2004 12:14:20 50882 16/03/2004 12:14:49
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 0 Incr 50871 16/03/2004 12:14:23 /usr/oradata2/NAIN/indnain01.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
3 3K DISK 00:00:01 16/03/2004 12:14:50
BP Key: 3 Status: AVAILABLE Tag: TAG20040316T121449
Piece Name: /usr/orabackup/03fgq3tp_1_1
List of Archived Logs in backup set 3
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 222 50869 16/03/2004 12:14:20 50882 16/03/2004 12:14:49
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Full 912K DISK 00:00:00 16/03/2004 12:14:52
BP Key: 4 Status: AVAILABLE Tag:
Piece Name: /usr/orabackup2/c-525403183-20040316-00
SPFILE Included: Modification time: 16/03/2004 12:07:50
RMAN> report obsolete;
RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 5 days Report of obsolete backups and copies
Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 4 16/03/2004 12:14:52 Backup Piece 4 16/03/2004 12:14:52 /usr/orabackup2/c-525403183-20040316-00
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 5 days
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 4 16/03/2004 12:14:52 Backup Piece 4 16/03/2004 12:14:52 /usr/orabackup2/c-525403183-20040316-00
Do you really want to delete the above objects (enter YES or NO)? n
RMAN> Received on Tue Mar 16 2004 - 05:50:40 CST
 |
 |