7 Replies Latest reply: Feb 14, 2013 7:02 AM by Niket Kumar RSS

    Reg: Archive log backup using RMAN

    968940
      Hi,

      I have one doubt,

      We have 100 archive log files out of that 20 archive log file are deleted,

      We want take full Database backup plus archivelog files using RMAN

      Is it possible to take backup without 20 archivelog file using RMAN?

      Is it possible to take full database backup with 80 archivelog file using RMAN?

      If means how?

      Thanks
      Bala
        • 1. Re: Reg: Archive log backup using RMAN
          RNi
          hi,

          why do you thing you need archives that are older than your current backup of database?
          • 2. Re: Reg: Archive log backup using RMAN
            EdStevens
            965937 wrote:
            Hi,

            I have one doubt,

            We have 100 archive log files out of that 20 archive log file are deleted,
            Why are they deleted?
            How were they deleted?
            >
            We want take full Database backup plus archivelog files using RMAN

            Is it possible to take backup without 20 archivelog file using RMAN?

            Is it possible to take full database backup with 80 archivelog file using RMAN?
            Backing up the database is different than backing up the archivelogs, even though they can be combined into the same command. So of course you can backup the database without the archivelogs.

            If means how?
            rman> backup database;

            >
            Thanks
            Bala
            You can certainly backup the database without the archivelogs. But of course you can't backup archivelogs that have gone missing. Your question hints at some other problems that should be addressed.
            • 3. Re: Reg: Archive log backup using RMAN
              TSharma-Oracle
              This link would help

              https://blogs.oracle.com/sysdba/entry/rman_backup_error_what_to_do_i
              • 4. Re: Reg: Archive log backup using RMAN
                Hemant K Chitale
                You would
                CROSSCHECK ARCHIVELOG ALL;
                DELETE [NOPROMPT] EXPIRED ARCHIVELOG ;
                BACKUP DATABASE PLUS ARCHIVELOG;
                optionally, you could separate the Archivelogs from the Database Backup as
                BACKUP DATABASE ;
                sql 'ALTER SYSTEM ARCHIVE LOG CURRENT' ;
                BACKUP ARCHIVELOG ALL;
                Hemant K Chitale
                • 5. Re: Reg: Archive log backup using RMAN
                  968940
                  Hi,

                  This question was one of my Interview question,

                  For that question I said no we can’t take backup,

                  Then interviewer said we can take the backup

                  -bala
                  • 6. Re: Reg: Archive log backup using RMAN
                    saratpvv
                    Yes we can take the backup using skip inaccessible clause
                    • 7. Re: Reg: Archive log backup using RMAN
                      Niket Kumar
                      you can use inaccesible clause to skip inaccessible archivelogs as suggested by saratpvv....

                      RMAN> backup database plus archivelog;


                      Starting backup at 14-FEB-13
                      current log archived
                      using target database control file instead of recovery catalog
                      allocated channel: ORA_DISK_1
                      channel ORA_DISK_1: SID=184 device type=DISK
                      RMAN-00571: ===========================================================
                      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                      RMAN-00571: ===========================================================
                      RMAN-03002: failure of backup plus archivelog command at 02/14/2013 18:28:30
                      RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
                      ORA-19625: error identifying file C:\ORACLEXE\APP\ORACLE\ARC0000000203_0803042474.0001
                      ORA-27041: unable to open file
                      OSD-04002: unable to open file
                      O/S-Error: (OS 2) The system cannot find the file specified.


                      RMAN> backup database plus archivelog;


                      Starting backup at 14-FEB-13
                      current log archived
                      using target database control file instead of recovery catalog
                      allocated channel: ORA_DISK_1
                      channel ORA_DISK_1: SID=184 device type=DISK
                      RMAN-00571: ===========================================================
                      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                      RMAN-00571: ===========================================================
                      RMAN-03002: failure of backup plus archivelog command at 02/14/2013 18:28:30
                      RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
                      ORA-19625: error identifying file C:\ORACLEXE\APP\ORACLE\ARC0000000203_0803042474.0001
                      ORA-27041: unable to open file
                      OSD-04002: unable to open file
                      O/S-Error: (OS 2) The system cannot find the file specified.

                      RMAN> backup database plus archivelog skip inaccessible;


                      Starting backup at 14-FEB-13
                      current log archived
                      using channel ORA_DISK_1
                      archived log C:\ORACLEXE\APP\ORACLE\ARC0000000203_0803042474.0001 not found or out of sync with catalog
                      skipping inaccessible file C:\ORACLEXE\APP\ORACLE\ARC0000000203_0803042474.0001
                      archived log C:\ORACLEXE\APP\ORACLE\ARC0000000204_0803042474.0001 not found or out of sync with catalog
                      skipping inaccessible file C:\ORACLEXE\APP\ORACLE\ARC0000000204_0803042474.0001
                      RMAN-06061: WARNING: skipping archived log compromises recoverability
                      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=185 RECID=20 STAMP=805701609
                      input archived log thread=1 sequence=186 RECID=21 STAMP=805765351
                      input archived log thread=1 sequence=187 RECID=22 STAMP=805851766
                      input archived log thread=1 sequence=188 RECID=23 STAMP=805925412
                      input archived log thread=1 sequence=189 RECID=24 STAMP=805962620
                      input archived log thread=1 sequence=190 RECID=25 STAMP=805982116
                      input archived log thread=1 sequence=191 RECID=26 STAMP=805985149
                      input archived log thread=1 sequence=192 RECID=27 STAMP=806046801
                      input archived log thread=1 sequence=193 RECID=28 STAMP=806133212
                      input archived log thread=1 sequence=194 RECID=29 STAMP=806219633
                      input archived log thread=1 sequence=195 RECID=30 STAMP=806238999
                      input archived log thread=1 sequence=196 RECID=31 STAMP=806305574
                      input archived log thread=1 sequence=197 RECID=32 STAMP=806392032
                      input archived log thread=1 sequence=198 RECID=33 STAMP=806478490

                      Edited by: Niket Kumar on Feb 14, 2013 6:31 PM