1 2 Previous Next 28 Replies Latest reply: Apr 30, 2013 3:20 AM by yxes2013 RSS

    RMAN error

    yxes2013
      Hi all,

      10.2.0.4
      SLES 11

      I am running an RMAN backup but I got error:
      sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
      
      Starting backup at 29-APR-13
      current log archived
      using channel ORA_DISK_1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of backup command at 04/29/2013 12:35:50
      RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
      ORA-19625: error identifying file /u01/app/oracle/flash_recovery_area/PROD/archivelog/2013_03_20/o1_mf_1_721_8nmo95l7_.arc
      ORA-27037: unable to obtain file status
      Linux-x86_64 Error: 2: No such file or directory
      Additional information: 3
      
      Recovery Manager complete.
      Is this a warning only or can i disregard it?

      Thanks a lot,

      zxy
        • 1. Re: RMAN error
          sb92075
          yxes2013 wrote:
          Is this a warning only or can i disregard it?
          yes, please do.
          • 2. Re: RMAN error
            Kh$n
            look into below link

            http://www.dba-oracle.com/t_rman_06059.htm
            • 3. Re: RMAN error
              Hemant K Chitale
              Is this a warning only or can i disregard it?
              It depends on what your backup script is. Do you do multiple backups of the archivelogs ? Do you run the archivelog backup with the database backup (i.e. as a "PLUS ARCHIVELOG") ? (In the latter case, you cannot disregard it !)

              And the first question to ask is : Why is that archivelog missing ?


              Hemant K Chitale
              • 4. Re: RMAN error
                Aman....
                yxes2013 wrote:
                Hi all,

                10.2.0.4
                SLES 11

                I am running an RMAN backup but I got error:
                sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
                
                Starting backup at 29-APR-13
                current log archived
                using channel ORA_DISK_1
                RMAN-00571: ===========================================================
                RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                RMAN-00571: ===========================================================
                RMAN-03002: failure of backup command at 04/29/2013 12:35:50
                RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
                ORA-19625: error identifying file /u01/app/oracle/flash_recovery_area/PROD/archivelog/2013_03_20/o1_mf_1_721_8nmo95l7_.arc
                ORA-27037: unable to obtain file status
                Linux-x86_64 Error: 2: No such file or directory
                Additional information: 3
                
                Recovery Manager complete.
                Is this a warning only or can i disregard it?

                Thanks a lot,

                zxy
                Always remember that when you are reading the RMAN error stack, you should read it from bottom up and in this case , you have an archive log that's not found. So now tell us why is it missing?

                Aman....
                • 5. Re: RMAN error
                  yxes2013
                  I thank you all :)
                  And the first question to ask is : Why is that archivelog missing ?
                  Maybe mr sb had stolen it :(

                  We have a 3rd party standby solution that periodically transfer logs to be applied at the standby database? Do you think it deleted the logs which were applied at the standby database?
                  But I dont think it will intrude to the Oracle folders since it has its own folders. :(

                  I got this parameter in RMAN script.
                  run {
                       CONFIGURE CONTROLFILE AUTOBACKUP ON;
                       backup database;
                       SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
                       BACKUP ARCHIVELOG ALL;
                       crosscheck archivelog all;
                       delete noprompt expired archivelog all;
                       delete obsolete;
                       }
                  Does the command ordering sequence matters? or may have caused the deletion of the logs?

                  Thanks,
                  • 6. Re: RMAN error
                    Hemant K Chitale
                    I have no idea how the archivelog file got deleted at your site.


                    The BACKUP ARCHIVELOG ALL failed with the error message. In general, you can CROSSCHECK and DELETE EXPIRED and re-run the BACKUP ARCHIVELOG ALL.
                    If the ArchiveLog was generated in the midst of a BACKUP DATABASE, then the database backup created by that session is not usable for a RECOVERy. You need to run a fresh BACKUP DATABASE.



                    Hemant K Chitale
                    • 7. Re: RMAN error
                      yxes2013
                      The link said;
                      Cause: The archived log was not found. The repository thinks it does exist. If the archived log has in fact been lost and there is no backup, 
                      then the database is no longer recoverable across the point in time covered by the archived log. 
                      
                      This may occur because the archived log was removed by an outside utility without updating the repository.
                      
                      Action: If the archived log has been removed with an outside utility and the archivelog has already been backed up, then you can synchronize 
                      the repository by running CROSSCHECK ARCHIVELOG ALL. 
                      But i did that in the command parameter above right?
                      • 8. Re: RMAN error
                        yxes2013
                        Thanks hem,

                        So the solution is just to rerun the backup? :)

                        Can you check my RMAN command parameter if there is missing or redundant command? or in wrong sequence?

                        run {
                        CONFIGURE CONTROLFILE AUTOBACKUP ON;
                        backup database;
                        SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
                        BACKUP ARCHIVELOG ALL;
                        crosscheck archivelog all;
                        delete noprompt expired archivelog all;
                        delete obsolete;
                        }


                        Thanks a lot....
                        • 9. Re: RMAN error
                          Hemant K Chitale
                          Yes, you should re-run the backup.

                          If missing archivelogs is a frequent occurrence, I would advice you to put or run the CROSSCHECK ARCHIVELOG ALL and DELETE [NOPROMPT] EXPIRED ARCHIVELOG ALL before the BACKUP DATABASE. If the subsequent BACKUP ARCHIVELOG ALL still errors out your Database Backup is likely unusable because of a missing archivelog.

                          As a responsible DBA you must investigate, identify and fix the reason for the missing archivelog.

                          Hemant K Chitale
                          • 10. Re: RMAN error
                            yxes2013
                            Thanks :)
                            As a responsible DBA you must investigate, identify and fix the reason for the missing archivelog.
                            Of course I am doing that, hence this post ;)
                            • 11. Re: RMAN error
                              Hemant K Chitale
                              No.

                              Responses to this thread can only help you identify what you should do after you've found out that one or more archivelogs is missing.
                              But we can't help you identify what caused the archivelog to go missing and how to fix it -- i.e. prevent recurrence of the issue.



                              Hemant K Chitale
                              • 12. Re: RMAN error
                                yxes2013
                                Did you encounter such issue? Maybe you can share what process you did :)

                                Or TO ALL PEOPLE READING THIS....please share how did you resolve this issue. or how did you investigate missing archivelogs....


                                Thanks a lot....

                                Edited by: yxes2013 on 29.4.2013 21:37
                                • 13. Re: RMAN error
                                  yxes2013
                                  Hi again hem,
                                  If missing archivelogs is a frequent occurrence, I would advice you to put or run the CROSSCHECK ARCHIVELOG ALL and DELETE [NOPROMPT] EXPIRED ARCHIVELOG ALL before the BACKUP >DATABASE. If the subsequent BACKUP ARCHIVELOG ALL still errors out your Database Backup is likely unusable because of a missing archivelog.
                                  Is this correct now?
                                  run {
                                       CONFIGURE CONTROLFILE AUTOBACKUP ON;    
                                       SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
                                       BACKUP ARCHIVELOG ALL;
                                       crosscheck archivelog all;
                                       delete noprompt expired archivelog all;
                                       delete obsolete;
                                       backup database;
                                       }
                                  
                                  Thanks.......
                                  
                                  Edited by: yxes2013 on 29.4.2013 21:40                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                                  • 14. fast recovery area 10g
                                    yxes2013
                                    dup

                                    Edited by: yxes2013 on 29.4.2013 21:57
                                    1 2 Previous Next