This discussion is archived
9 Replies Latest reply: Sep 20, 2013 9:12 AM by jgarry RSS

RMAN backup from Database on Linux to Windows Share

Munira Newbie
Currently Being Moderated

Hi All,

 

I am getting the below error when I try to take a RMAN backup from a database on Linux to a Windows volume mounted to the Linux machine

 

channel ORA_DISK_7 disabled, job failed on it will be run on another channel

channel ORA_DISK_8: starting compressed full datafile backup set

channel ORA_DISK_8: specifying datafile(s) in backup set

including current control file in backup set

channel ORA_DISK_8: starting piece 1 at 17-SEP-13

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_8 channel at 09/17/2013 15:33:20

ORA-19504: failed to create file "/u03/totest/control_auok395u_1_1"

ORA-27041: unable to open file

Linux-x86_64 Error: 13: Permission denied

Additional information: 3

 

fstab entry for the windows share

//db-testsrv/totest  /u03/totest  cifs   defaults,users,rw,username=oracle,password=password,domain=db-recovery,disk_mask=777,file_mask=777,uid=502,gid=501 0 0

 

Can anyone shed some light on this

 

Thanks in advance

  • 1. Re: RMAN backup from Database on Linux to Windows Share
    sb92075 Guru
    Currently Being Moderated

    OS/filesystem error

    Problem & solution are external to Oracle.

    You might be successful but you'll likely have to be persistent in order to work through all in inherent incompatibilities involving what you are attempting.

     

    What do you hope to do with the RMAN backup files once they reside on Windows filesystem?

     

     

     

    How do I ask a question on the forums?

    https://forums.oracle.com/message/9362002#9362002

  • 2. Re: RMAN backup from Database on Linux to Windows Share
    Munira Newbie
    Currently Being Moderated

    I need to know where I can start to look if it is a OS/filesystem error.

     

    Daily backups need to go to the shared drive. 

  • 3. Re: RMAN backup from Database on Linux to Windows Share
    sb92075 Guru
    Currently Being Moderated

    Munira wrote:

     

    I need to know where I can start to look if it is a OS/filesystem error.

     

    Daily backups need to go to the shared drive.

     

    >Linux-x86_64 Error: 13: Permission denied

    what part of the above do you NOT understand?

    It clearly states it is OS error!

  • 4. Re: RMAN backup from Database on Linux to Windows Share
    EdStevens Guru
    Currently Being Moderated

    Munira wrote:

     

    I need to know where I can start to look if it is a OS/filesystem error.

     

    Daily backups need to go to the shared drive.

    I'd start by looking at the permissions on /u03

    then look at the permissions on /u03/totes

    then look at same from the Windows side.

     

    Instead of having rman write directly to the shared drive, can you write to a local linux file system, then copy the files with os-level utilities?

  • 5. Re: RMAN backup from Database on Linux to Windows Share
    jgarry Guru
    Currently Being Moderated

    That's what I do from FRA on hpux to mysterious pizza box visible to unix and Windows, which storage propagates it elsewhere.  No tapes and plenty of redundancy, yay!

  • 6. Re: RMAN backup from Database on Linux to Windows Share
    Munira Newbie
    Currently Being Moderated

    The backup plan it to write the backup to the local filesystem and then copy the files over to the mounted windows volume.

     

    All the folders have full access.  But thanks for your answer, I will try and dig deeper and see what I can find.

  • 7. Re: RMAN backup from Database on Linux to Windows Share
    jgarry Guru
    Currently Being Moderated

    You might trying starting rman (not as oracle) and go into another session.  grep a long ps output for rman.  See who the user is?  Since Oracle tends to run things setuid, whoever the unix user that is running the backup has to have privileges to write to the device.  If you are running rman as oracle, perhaps there is a different mapping of user to userid on the share.

     

    Edit:  Here's another odd thought.  If you've done this repeatedly and Oracle came up with the same filename, owned by a different user, it might not have the permission to remove/overwrite it (or directories if you are running into the controlfile autobackup).

  • 8. Re: RMAN backup from Database on Linux to Windows Share
    Munira Newbie
    Currently Being Moderated

    To put a closure on this thread, I spoke with the IT team to look at the privileges on the OS level on both the windows and linux machines and they confirmed that there was full access provided to the shared mount.  So, as a last resort I opened a ticket with Oracle and this is the final reply I got from them.

     

    As stated by the Oracle Rep:

    What was discussed is that one can create backups to NFS-shared mounts or windows shared drives but in both case the source where Oracle database is running and the destination directory where you intend to take backups, must be the same platform. Any other configuration might work but it will not be supported since it is not documented as such.

     

    Thanks for all the help.  If anyone has any other inputs kindly post them.

  • 9. Re: RMAN backup from Database on Linux to Windows Share
    jgarry Guru
    Currently Being Moderated

    The acronym is YOYO - You're On Your Own.

     

    Thanks for the update.  I'm still wondering about files already existing though, that's a matter of a user with higher privilege blocking one with lower, even though both have privilege.  You can guess I've run across this mistake

     

    jeg$ su

    Password:

    # echo "blabla" > blabla

    # ll blabla

    -rw-rw-rw-   1 root       sys              7 Sep 20 09:16 blabla

    # chmod 700 blabla

    # exit

    jeg$ echo "blabla" > blabla

    /usr/bin/ksh: blabla: cannot create

Legend

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