1 2 Previous Next 20 Replies Latest reply on Dec 14, 2011 11:07 AM by VaibhavDixit

    how to delete archive log file

    VaibhavDixit
      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
        • 1. Re: how to delete archive log file
          KanchDev
          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.
          1 person found this helpful
          • 2. Re: how to delete archive log file
            asifkabirdba
            Log into RMAN and run the command

            RMAN > crosscheck backup;

            RMAN > delete noprompt obsolete;

            RMAN > backup archivelog all delete input;



            Regards
            Asif Kabir
            1 person found this helpful
            • 3. Re: how to delete archive log file
              CKPT
              Use only RMAN, commands again depend on your retention.
              • 4. Re: how to delete archive log file
                890758
                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.
                • 5. Re: how to delete archive log file
                  Varma
                  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
                  • 6. Re: how to delete archive log file
                    VaibhavDixit
                    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
                    • 7. Re: how to delete archive log file
                      KanchDev
                      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
                      • 8. Re: how to delete archive log file
                        Varma
                        Hi,

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

                        backup archivelog all delete input;
                        • 9. Re: how to delete archive log file
                          VaibhavDixit
                          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
                          • 10. Re: how to delete archive log file
                            KanchDev
                            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
                            1 person found this helpful
                            • 11. Re: how to delete archive log file
                              KanchDev
                              Hi Vaibhav

                              If you closely check the output of the list archivelog all; all archive logs have status as A. if you follow the my last post when you delete some archive logs from file system the output of list archivelog all; will show you the deleted archive logs status as X means expried . then your delete noprompt expired archivelog all; will complete successfully.

                              Cheers
                              Kanchana.
                              1 person found this helpful
                              • 12. Re: how to delete archive log file
                                Helios-GunesEROL
                                Hi;

                                1. What show all returns;
                                2. Be sure you connect catalog db via rman

                                Regard
                                Helios
                                • 13. Re: how to delete archive log file
                                  VaibhavDixit
                                  And some archive files which are not showing in

                                  "LIST archivelog all';

                                  What to do with them ??
                                  • 14. Re: how to delete archive log file
                                    KanchDev
                                    Hi Vaibhav
                                    Please let let us know the time stamp of those archive log files and mentioned the file name of one of those files.

                                    Cheers
                                    Kanchana.
                                    1 2 Previous Next