This discussion is archived
1 2 Previous Next 28 Replies Latest reply: Apr 30, 2013 1:20 AM by yxes2013 RSS

RMAN error

yxes2013 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    yxes2013 wrote:
    Is this a warning only or can i disregard it?
    yes, please do.
  • 2. Re: RMAN error
    Kh$n Journeyer
    Currently Being Moderated
    look into below link

    http://www.dba-oracle.com/t_rman_06059.htm
  • 3. Re: RMAN error
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    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.... Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    dup

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points