rman not deleting expired

[tchatzi]

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           1004   12-NOV-05         
  Backup Piece       1004   12-NOV-05          /oracle/backups/prod/ora_arch_574128932_s1310_s1
Backup Set           1005   12-NOV-05         
  Backup Piece       1005   12-NOV-05          /oracle/backups/prod/ora_arch_574128962_s1311_s1
Backup Set           1010   13-NOV-05         
  Backup Piece       1010   13-NOV-05          /oracle/backups/prod/ora_arch_574215330_s1316_s1
Backup Set           1011   13-NOV-05         
  Backup Piece       1011   13-NOV-05          /oracle/backups/prod/ora_arch_574215360_s1317_s1
Backup Set           1016   14-NOV-05         
  Backup Piece       1016   14-NOV-05          /oracle/backups/prod/ora_arch_574301743_s1322_s1
Backup Set           1021   15-NOV-05         
  Backup Piece       1021   15-NOV-05          /oracle/backups/prod/ora_arch_574388135_s1327_s1
.................
.................
.................
Backup Set           1989   26-MAY-06         
  Backup Piece       1989   26-MAY-06          /oracle/backups/prod/ora_arch_591447671_s2470_s1
Backup Set           1992   27-MAY-06         
  Backup Piece       1992   27-MAY-06          /oracle/backups/prod/ora_ctrl_591495122_s2474_s1
Backup Set           1995   28-MAY-06         
  Backup Piece       1995   28-MAY-06          /oracle/backups/prod/ora_data_591581784_s2477_s1
Backup Set           1997   28-MAY-06         
  Backup Piece       1997   28-MAY-06          /oracle/backups/prod/ora_arch_591581859_s2479_s1

I have only these

-rw-r-----   1 oracle   oinstall 467832320 May 28 00:17 ora_arch_591581817_s2478_s1
-rw-r-----   1 oracle   oinstall 467505664 May 28 00:18 ora_arch_591581859_s2479_s1
-rw-r-----   1 oracle   oinstall 441711104 May 28 00:19 ora_arch_591581905_s2480_s1
-rw-r-----   1 oracle   oinstall 13303808 May 27 00:12 ora_ctrl_591495122_s2474_s1
-rw-r-----   1 oracle   oinstall 13303808 May 28 00:19 ora_ctrl_591581965_s2481_s1
-rw-r-----   1 oracle   oinstall 13882777600 May 26 10:59 ora_data_591446814_s2467_s1
-rw-r-----   1 oracle   oinstall 13887037440 May 28 00:16 ora_data_591580899_s2476_s1
-rw-r-----   1 oracle   oinstall 13336576 May 28 00:16 ora_data_591581784_s2477_s1
-rw-r-----   1 oracle   oinstall   98304 May 28 00:19 ora_spfile_591581979_s2482_s1

and no crosscheck, no delete expired , no delete obsolete no nothing works as it should( to mark the nonexisted files as expired, or delete the physical files on the disk).
What worries me is that I dont get any errors when I run the commands.
Dont ask me if I have the permissions.Yes I do.
The guy before me was deleting the files manualy and not inside rman. Now I have to deal with this some way.
Any help will be appreciated.
Thanks


``The wise man doesn't give the right answers,
he poses the right questions.''
TIMTOWTDI

 

[Thargy]

perl,

to help us help you, could you type 'archive log list' at the sql prompt and post the result for us.

Also, could you do a 'show all' in RMAN and post the result.

My first thoughts are that maybe the obsolete archive log files are somewhere other than where they're supposed to be.

Regards

Tharg

Grinding away at things Oracular

 

[Michael42]

perluserpengo,

Check your CFRKT and your CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF n DAYS (default 1) values.

Thanks,

Michael42