9 Replies Latest reply: Sep 20, 2013 11:12 AM by jgarry RSS

    RMAN backup from Database on Linux to Windows Share

    Munira

      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

          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

            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

              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

                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

                  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

                    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

                      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

                        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

                          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