DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 1999

    RMAN backup error

    I have a 2 node RAC database which is using ASM. I am using RMAN to backup the database. For the RMAN backups we do not have a recovery catalog, we are using the controlfile. My 'control_file_record_keep_time' parameter is setup at 7 days. One of the DBAs went and cleaned out the ARCHIVELOG directory using 'asmcmd' He basically deleted the files using the 'rm' command to delete all archive logs that were older than 5 days. now my backups are filing with the follwoing errors:

    RMAN-00571: ======================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==========
    RMAN-00571: ===========================================================
    RMAN-03002: failure of backup command at 10/28/2007 21:04:14
    RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
    ORA-19625: error identifying file +ASMDG/prod/1_118839_624905386.dbf
    ORA-17503: ksfdopn:2 Failed to open file +ASMDG/prod/1_118839_624905386.dbf
    ORA-15173: entry '1_118839_624905386.dbf' does not exist in directory 'prod'

    WHat do I do to get my backups to start working again?


  2. #2
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    Take a full backup then put your DBA in 30 days provation.
    At this point you cannot recover from the backup you have.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Apr 2006
    You will have to perform the following before you can do a full backup:

    RMAN> crosscheck archivelog all;
    RMAN> delete expired archivelog all;
    then do as PAVB indicated, do a full backup and put the DBA on probation.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.