failure of backup plus archivelog command
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: failure of backup plus archivelog command

  1. #1
    Join Date
    Mar 2005
    Posts
    143

    failure of backup plus archivelog command

    I am using rman to do a full database backup plus the archive logs. The backup fails with this error:
    failure of backup plus archivelog command at 02/04/2010 14:30:41
    ORA-19505: failed to identify file "/data3/oradata/axium/arch/1_553_707676115.db
    f"
    ORA-27037: unable to obtain file status
    IBM AIX RISC System/6000 Error: 2: No such file or directory
    Additional information: 3

    the arcive log in question is there.

    here is the script I am running:
    run {
    crosscheck archivelog all;
    backup as compressed backupset database plus archivelog;
    }
    exit

    if I look at the log file from the rman command when it does the crosscheck archive log all, it validates the file is there.

    after the the rman script fails, the file is no longer there.

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    Cool enemies ??

    some one might have physically deleted that file after cross check and before RMAN actually backup that file.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Mar 2005
    Posts
    143
    thank you for the quick responce. The crosscheck runs right before the db gets backed up. I don't think somone is deleteing the file. I think the crosscheck command may be doing it, but if it thinks it should be deleted because it isn't needed then why is rman trying to back it up.

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    cross check never deletes any file no matter whether it is required for backup or not. It just updates the RMAN repository.

    run crosscheck archivelog all command once again and take the backup.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you are doing a crosscheck but not deleting the obsolete ones

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