RMAN (missing .arc file)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RMAN (missing .arc file)

Hybrid View

  1. #1
    Join Date
    Jul 2006
    Posts
    195

    RMAN (missing .arc file)

    I running the RMAN command below and getting the following error. I did
    check and the .arc file it's refrerring to is not there. Would running a crosscheck command get rid of this problem, if not how can I rectify this issue.

    SOLUTION
    ========
    run {
    crosscheck archivelog all;
    }


    PROBLEM
    =======
    rman < connect target login/password
    connect catalog login/password
    show all;
    sql "alter system archive log current";
    backup filesperset 5 archivelog until time 'sysdate-2/24'
    format $FILE_DEST_ARCH
    delete input ;
    resync catalog;
    EOT


    RMAN-00571: =========================================================
    RMAN-00569: ==== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ==============================================
    RMAN-03002: failure of backup command at 11/29/2010 21:39:46
    RMAN-06059: expected archived log not found, lost of archived log compromises re
    coverability
    ORA-19625: error identifying file /archive/ifdtest1/ifdtest1_1_1_736321408.arc
    ORA-27037: unable to obtain file status
    SVR4 Error: 2: No such file or directory
    Additional information: 3

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Talking

    Alternative one:
    Code:
    ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
    CHANGE ARCHIVELOG ALL CROSSCHECK;
    Alternative two:
    Code:
      BACKUP
        FORMAT ...etc...
        ARCHIVELOG ALL DELETE INPUT SKIP INACCESSIBLE;
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Jul 2006
    Posts
    195
    Quote Originally Posted by LKBrwn_DBA View Post
    Alternative one:
    Code:
    ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
    CHANGE ARCHIVELOG ALL CROSSCHECK;
    Alternative two:
    Code:
      BACKUP
        FORMAT ...etc...
        ARCHIVELOG ALL DELETE INPUT SKIP INACCESSIBLE;

    This will be a one time run correct?
    run
    {
    ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
    CHANGE ARCHIVELOG ALL CROSSCHECK;
    }

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477
    Quote Originally Posted by BeefStu View Post
    This will be a one time run correct?
    run
    {
    ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
    CHANGE ARCHIVELOG ALL CROSSCHECK;
    }
    Yes, it's a one time fix and works in 11g, not sure if it will work on lower versions.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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