I have a problem to delete the archive log files before 5 days. it shows me that error message.

RMAN> delete noprompt archivelog all completed before 'sysdate - 5';
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=203 device type=DISK
specification does not match any archived log in the repository 

migrated from stackoverflow.com Dec 29 '16 at 16:20

This question came from our site for professional and enthusiast programmers.


maybe there aren't any!

run this and see if there are any archivelogs older than 5 days

list backup of archivelog all;
  • yes there is no backup of archive log, but sir my database directory is increasing gradually? do you have any idea why this happen? – mmubeen Dec 29 '16 at 15:11
  • i would guess data was being added to your database and therefore it is getting larger – davegreen100 Dec 29 '16 at 15:13
  • do you have any idea about discrepancy of block ID's? – mmubeen Dec 29 '16 at 15:35
  • i'd suggest you post another question with as much detail as you can on the block problem – davegreen100 Dec 29 '16 at 15:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy