4 Replies Latest reply: Jul 5, 2012 7:46 AM by Osama_Mustafa RSS

    Deleting all backed up archives using RMAN

    user8610659
      Hi,

      I used 'delete input' to delete all the archives backed up.

      I am storing archives in dest1 and dest2...i.e, in two locatiions in production.

      Although archive in dest1 is getting deleted I am unable to delete those in dest2.Please help to delete archives in dest2 too.
        • 1. Re: Deleting all backed up archives using RMAN
          Balazs Papp
          I am unable to delete those in dest2
          why?

          anyway...
          delete archivelog all backed up 1 times to device type disk;
          • 2. Re: Deleting all backed up archives using RMAN
            EdStevens
            user8610659 wrote:
            Hi,

            I used 'delete input' to delete all the archives backed up.

            I am storing archives in dest1 and dest2...i.e, in two locatiions in production.

            Although archive in dest1 is getting deleted I am unable to delete those in dest2.Please help to delete archives in dest2 too.
            Too bad you didn't show us the complete command you actually use, instead of your description of it.

            Anyway, in addition to the command Balazs showed, which can be used after the fact, you can also
            backup archivelog delete ALL input;
            • 3. Re: Deleting all backed up archives using RMAN
              Girish Sharma
              Ed,
              Probably there is missing one "all" in your command :
              C:\>rman target /
              
              Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 5 17:37:57 2012
              
              Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
              
              connected to target database: ORCL (DBID=1308204436)
              
              RMAN> backup archivelog delete ALL input;
              
              RMAN-00571: ===========================================================
              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
              RMAN-00571: ===========================================================
              RMAN-00558: error encountered while parsing input commands
              RMAN-01009: syntax error: found "delete": expecting one of: "all, from, high, like, low, scn, sequence, time, until"
              RMAN-01007: at line 1 column 19 file: standard input
              
              RMAN> BACKUP ARCHIVELOG ALL DELETE ALL INPUT;
              
              Starting backup at 05-JUL-12
              current log archived
              using target database control file instead of recovery catalog
              allocated channel: ORA_DISK_1
              channel ORA_DISK_1: SID=70 device type=DISK
              channel ORA_DISK_1: starting archived log backup set
              channel ORA_DISK_1: specifying archived log(s) in backup set
              input archived log thread=1 sequence=325 RECID=300 STAMP=786108184
              input archived log thread=1 sequence=326 RECID=301 STAMP=786108634
              ...
              ...
              Finished backup at 05-JUL-12
              
              RMAN>
              Regards
              Girish Sharma
              • 4. Re: Deleting all backed up archives using RMAN
                Osama_Mustafa
                Use
                BACKUP ARCHIVELOG ALL DELETE ALL INPUT;

                It must works

                BR
                OSama