Forum Stats

  • 3,768,281 Users
  • 2,252,770 Discussions
  • 7,874,513 Comments

Discussions

how to delete archive log file

VaibhavDixit
VaibhavDixit Member Posts: 89
edited Dec 14, 2011 6:07AM in General Database Discussions
hii,

presently i am working on oracle 10gR2 on windows server 2003.
hard disk drive is almost full.



when i execute this command
"DELETE EXPIRED ARCHIVE LOG ALL";

it give message

"specifies does not match any archive log in the recovery catalog"



how can i delete archive log files ??

Regards
Vaibhav Dixit

Best Answer

«1

Answers

  • KanchDev
    KanchDev Member Posts: 406
    First You can delete old archive logs from the filesystem. then on rman use the following
    crosscheck archivelog all;
    delete noprompt expired archivelog all;
    Cheers
    Kanchana.
    KanchDev
  • asifkabirdba
    asifkabirdba Member Posts: 3,358 Gold Trophy
    Log into RMAN and run the command

    RMAN > crosscheck backup;

    RMAN > delete noprompt obsolete;

    RMAN > backup archivelog all delete input;



    Regards
    Asif Kabir
    asifkabirdba
  • CKPT
    CKPT Member Posts: 9,955 Silver Crown
    Use only RMAN, commands again depend on your retention.
  • 890758
    890758 Member Posts: 46
    If you are using rman then it can be done by taking archive logs backup with 'DELETE ALL INPUT' parameter.
    It will purge all backep up archive log files after the backup completion.
  • Varma
    Varma Member Posts: 139
    edited Dec 14, 2011 2:50AM
    Hi,


    Use the following commands to delete expired archive logs;
    RMAN>crosscheck archivelog all';
    RMAN>delete noprompt expired archivelog all;

    or

    you can take archive logs backup with "backup archivelog all delete input" parameter.
    It will delete all archive logs after the backup.

    Edited by: kcv on Dec 14, 2011 1:20 PM
  • VaibhavDixit
    VaibhavDixit Member Posts: 89
    edited Dec 14, 2011 4:06AM
    When i use these following commands

    crosscheck archivelog all;
    delete noprompt expired archivelog all;

    it give same message

    "specifies does not match any archive log in the recovery catalog"


    when i executed command

    crosscheck archivelog all;

    it is give status

    "\FLASH_RECOVERY_AREA\XXX\1_341_758982530.ARC"
    to
    "\FLASH_RECOVERY_AREA\XXX\1_461_758982530.ARC"





    is it good to delete archive log files from "\FLASH_RECOVERY_AREA\XXX\1_1_758982530.ARC" to "\FLASH_RECOVERY_AREA\XXX\1_340_758982530.ARC" manually for getting more space ???

    please reply

    Regards
    Vaibhav

    Edited by: Vaibhav Dixit on Dec 14, 2011 2:33 PM
  • KanchDev
    KanchDev Member Posts: 406
    Please post the output of the first command.

    Also
    RMAN> list archivelog all;
    Then
    RMAN> delete noprompt expired archivelog all;
    Please post the last 15 lines of all above outputs.

    Cheers
    Kanchana
  • Varma
    Varma Member Posts: 139
    Hi,

    don't delete manually.try to take backup of archivelogs and delete the input using command

    backup archivelog all delete input;
  • these are the list



    RMAN> list archivelog all;


    List of Archived Log Copies
    Key Thrd Seq S Low Time Name
    ------- ---- ------- - --------- ----
    696 1 341 A 25-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_341_758982530.ARC
    698 1 342 A 26-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_342_758982530.ARC
    700 1 343 A 26-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_343_758982530.ARC
    702 1 344 A 26-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_344_758982530.ARC
    704 1 345 A 26-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_345_758982530.ARC
    705 1 346 A 26-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_346_758982530.ARC
    708 1 347 A 26-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_347_758982530.ARC
    710 1 348 A 27-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_348_758982530.ARC
    712 1 349 A 27-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_349_758982530.ARC
    714 1 350 A 27-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_350_758982530.ARC
    716 1 351 A 28-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_351_758982530.ARC
    719 1 352 A 28-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_352_758982530.ARC
    720 1 353 A 28-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_353_758982530.ARC
    721 1 354 A 28-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_354_758982530.ARC
    722 1 355 A 28-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_355_758982530.ARC
    727 1 356 A 29-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_356_758982530.ARC
    728 1 357 A 29-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_357_758982530.ARC
    730 1 358 A 29-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_358_758982530.ARC
    732 1 359 A 29-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_359_758982530.ARC
    734 1 360 A 29-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_360_758982530.ARC
    736 1 361 A 30-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_361_758982530.ARC
    738 1 362 A 30-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_362_758982530.ARC
    740 1 363 A 30-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_363_758982530.ARC
    741 1 364 A 30-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_364_758982530.ARC
    742 1 365 A 30-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_365_758982530.ARC
    743 1 366 A 30-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_366_758982530.ARC
    744 1 367 A 30-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_367_758982530.ARC
    745 1 368 A 30-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_368_758982530.ARC
    746 1 369 A 30-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_369_758982530.ARC
    753 1 370 A 30-NOV-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_370_758982530.ARC
    756 1 371 A 01-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_371_758982530.ARC
    758 1 372 A 01-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_372_758982530.ARC
    759 1 373 A 01-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_373_758982530.ARC
    763 1 374 A 01-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_374_758982530.ARC
    764 1 375 A 02-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_375_758982530.ARC
    767 1 376 A 02-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_376_758982530.ARC
    768 1 377 A 02-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_377_758982530.ARC
    770 1 378 A 02-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_378_758982530.ARC
    772 1 379 A 02-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_379_758982530.ARC
    774 1 380 A 02-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_380_758982530.ARC
    776 1 381 A 03-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_381_758982530.ARC
    778 1 382 A 03-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_382_758982530.ARC
    780 1 383 A 03-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_383_758982530.ARC
    782 1 384 A 03-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_384_758982530.ARC
    784 1 385 A 04-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_385_758982530.ARC
    785 1 386 A 04-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_386_758982530.ARC
    788 1 387 A 05-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_387_758982530.ARC
    790 1 388 A 05-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_388_758982530.ARC
    791 1 389 A 05-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_389_758982530.ARC
    792 1 390 A 05-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_390_758982530.ARC
    793 1 391 A 06-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_391_758982530.ARC
    794 1 392 A 06-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_392_758982530.ARC
    795 1 393 A 06-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_393_758982530.ARC
    796 1 394 A 06-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_394_758982530.ARC
    797 1 395 A 06-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_395_758982530.ARC
    798 1 396 A 06-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_396_758982530.ARC
    799 1 397 A 06-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_397_758982530.ARC
    800 1 398 A 06-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_398_758982530.ARC
    801 1 399 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_399_758982530.ARC
    802 1 400 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_400_758982530.ARC
    803 1 401 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_401_758982530.ARC
    804 1 402 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_402_758982530.ARC
    805 1 403 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_403_758982530.ARC
    806 1 404 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_404_758982530.ARC
    808 1 405 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_405_758982530.ARC
    814 1 406 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_406_758982530.ARC
    816 1 407 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_407_758982530.ARC
    817 1 408 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_408_758982530.ARC
    822 1 409 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_409_758982530.ARC
    823 1 410 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_410_758982530.ARC
    824 1 411 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_411_758982530.ARC
    826 1 412 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_412_758982530.ARC
    829 1 413 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_413_758982530.ARC
    831 1 414 A 07-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_414_758982530.ARC
    839 1 415 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_415_758982530.ARC
    841 1 416 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_416_758982530.ARC
    843 1 417 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_417_758982530.ARC
    844 1 418 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_418_758982530.ARC
    848 1 419 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_419_758982530.ARC
    849 1 420 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_420_758982530.ARC
    850 1 421 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_421_758982530.ARC
    851 1 422 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_422_758982530.ARC
    852 1 423 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_423_758982530.ARC
    853 1 424 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_424_758982530.ARC
    854 1 425 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_425_758982530.ARC
    856 1 426 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_426_758982530.ARC
    862 1 427 A 08-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_427_758982530.ARC
    870 1 428 A 09-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_428_758982530.ARC
    872 1 429 A 09-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_429_758982530.ARC
    874 1 430 A 09-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_430_758982530.ARC
    875 1 431 A 09-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_431_758982530.ARC
    878 1 432 A 09-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_432_758982530.ARC
    880 1 433 A 09-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_433_758982530.ARC
    882 1 434 A 10-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_434_758982530.ARC
    884 1 435 A 10-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_435_758982530.ARC
    886 1 436 A 10-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_436_758982530.ARC
    888 1 437 A 10-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_437_758982530.ARC
    890 1 438 A 11-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_438_758982530.ARC
    891 1 439 A 11-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_439_758982530.ARC
    893 1 440 A 12-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_440_758982530.ARC
    896 1 441 A 12-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_441_758982530.ARC
    898 1 442 A 12-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_442_758982530.ARC
    900 1 443 A 12-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_443_758982530.ARC
    901 1 444 A 12-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_444_758982530.ARC
    902 1 445 A 13-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_445_758982530.ARC
    903 1 446 A 13-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_446_758982530.ARC
    904 1 447 A 13-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_447_758982530.ARC
    910 1 448 A 13-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_448_758982530.ARC
    912 1 449 A 13-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_449_758982530.ARC
    914 1 450 A 13-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_450_758982530.ARC
    916 1 451 A 13-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_451_758982530.ARC
    918 1 452 A 13-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_452_758982530.ARC
    920 1 453 A 13-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_453_758982530.ARC
    922 1 454 A 13-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_454_758982530.ARC
    924 1 455 A 14-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_455_758982530.ARC
    926 1 456 A 14-DEC-11 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ES
    PL\1_456_758982530.ARC

    RMAN> delete noprompt expired archivelog all;

    released channel: ORA_DISK_1
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=77 devtype=DISK
    specification does not match any archive log in the recovery catalog
  • KanchDev
    KanchDev Member Posts: 406
    Hi Vaibhav,

    If you don't have a rman archive deletion policy or if you don't delete any archive logs from the file system (\FLASH_RECOVERY_AREA\XXX\) then when you issue crosscheck archivelog all; it check and flag on the recovery catalog for archive logs physically present in the archive destination (\FLASH_RECOVERY_AREA\XXX\) . Now if you have not deleted any archive logs from \FLASH_RECOVERY_AREA\XXX\ then running the next command delete noprompt expired archivelog all; will not have anything to remove from the recovery catalog . so you will get this error message.

    Safest method will be to backup the archive logs to a different file system ,deleted it from the file system (\FLASH_RECOVERY_AREA\XXX\) then run the rman command which I have explained in my first post.

    Cheers
    Kanchana
    KanchDev
This discussion has been closed.