Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2012
    Posts
    3

    RMAN backup error

    When I run my RMAN backup script I get the following error:

    RMAN-00571: ================================================== =========
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ================================================== =========
    RMAN-03007: retryable error occurred during execution of command: backup
    RMAN-07004: unhandled exception during command execution on channel dev1
    RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "/db01/app/oracle/admin/train/adhoc/TRAIN_DB_05nsjjn2"
    ORA-27044: unable to write the header block of file
    Linux Error: 22: Invalid argument
    Additional information: 2
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

    RMAN>
    RMAN-08031: released channel: dev1

    Recovery Manager complete.

    I definitely have enough disk space:
    /dev/sdb1 247G 143G 91G 62% /db01

    I am mostly curious about the "Linux Error: 22: Invalid argument" line. Has anyone come across this before?

    I am a sysadmin trying to troubleshoot this for our DBAs so please forgive me if I left out any pertinent information. Thanks.
    -K

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,659
    >Linux Error: 22: Invalid argument
    indicates OS error. what clues exist in OS messages file?

    post results from OS commands below

    ls -l /db01/app/oracle/admin/train/adhoc/TRAIN_DB_05nsjjn2
    ls -ld /db01/app/oracle/admin/train/adhoc/
    ls -ld /db01/app/oracle/admin/train/
    ls -ld /db01/app/oracle/admin/
    ls -ld /db01/app/oracle/
    ls -ld /db01/app/
    ls -ld /db01/
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,558
    I take it all the "stupid" stuff has been taken care of. The login they are using has rights to create a file in the directory, and the directory exists?

    Also, if this is an unusually old version of Oracle, you can check this article:
    Electronic Chickens: RMAN-10035: exception raised in RPC

  4. #4
    Join Date
    Dec 2012
    Posts
    3
    I am running the backup script as root to aviod any access issues. The mask for the directory I am using is 755, owned by user oracle and group oinstall. Both the owner user id and group id are local accounts.

    here is the output of the OS commands:

    [root@rh4ora8 adhoc]# ls -ld /db01/app/oracle/admin/train/adhoc
    drwxr-xr-x 2 oracle oinstall 4096 Dec 11 14:12 /db01/app/oracle/admin/train/adhoc
    [root@rh4ora8 adhoc]# ls -ld /db01/app/oracle/admin/train/adhoc
    drwxr-xr-x 2 oracle oinstall 4096 Dec 11 14:12 /db01/app/oracle/admin/train/adhoc
    [root@rh4ora8 adhoc]# ls -ld /db01/app/oracle/admin/train
    drwxr-xr-x 10 oracle oinstall 4096 Nov 2 16:53 /db01/app/oracle/admin/train
    [root@rh4ora8 adhoc]# ls -ld /db01/app/oracle/admin
    drwxrwxr-x 5 oracle oinstall 4096 Nov 21 12:14 /db01/app/oracle/admin
    [root@rh4ora8 adhoc]# ls -ld /db01/app/oracle
    drwxrwxr-x 9 oracle oinstall 4096 Mar 20 2011 /db01/app/oracle
    [root@rh4ora8 adhoc]# ls -ld /db01/app
    drwxrwxr-x 3 oracle oinstall 4096 Mar 17 2011 /db01/app
    [root@rh4ora8 adhoc]# ls -ld /db01
    drwxr-xr-x 6 oracle oinstall 4096 Nov 15 03:22 /db01

    Thanks for the quick reply!
    -K

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,659
    >I am running the backup script as root to aviod any access issues
    NEVER use root to do anything involving Oracle!
    Always use OS "oracle" account.

    Code:
    27044, 00000, "unable to write the header block of file"
    // *Cause:  write system call failed, additional information indicates which
    //          function encountered the error
    // *Action: check errno
    OS error. Oracle is the victim; not the culprit.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  6. #6
    Join Date
    Dec 2012
    Posts
    3
    I normally don't do anything as root unless absolutely neccessary. I'm troubleshooting this issue in a test environment so if I blow something up it's easily re-imaged. I think the RPC error MCrowley pointed out may have been the problem. My latest test backup is still running with no error. It was failing almost immediately before. Thanks.
    -K

Posting Permissions

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