8 Replies Latest reply: Aug 21, 2013 5:58 AM by Ragnar.H. RSS

    copy files from ntfs to asm

    934646
      Hi all,

      I am unable to copy files from asm to ntfs or from ntfs to asm through cp command in windows server 2008 R 2.

      Do i need to give any permissions?? and also is it possible to copy file from one server ntfs to another server asm??

      Thanks,
        • 1. Re: copy files from ntfs to asm
          934646
          it is working through the dbms_file_transfer package...I would like to know whetherwe can copy from one server ntfs to another server asm file system?

          Thanks.
          • 2. Re: copy files from ntfs to asm
            vlethakula
            asmcmd cp supports
            1)one diskgroup to other diskgroup
            2)from OS to diskgroup and viceversa
            3)from locak diskgroup to remote diskgroup
            • 3. Re: copy files from ntfs to asm
              934646
              thanks for the reply...

              I am trying to do from os to diskgroup. But copy command is not working.

              is this right syntax?

              cp +DATA/test/test.txt C:\oracle\test.txt

              Thanks,
              • 4. Re: copy files from ntfs to asm
                vlethakula
                what error you are getting?
                • 5. Re: copy files from ntfs to asm
                  934646
                  following is the error

                  ASMCMD> cp +fra/gisdev/archivelog/2012_12_12/thread_1_seq_8687.3100.801877195 C:\Oracle\test
                  copying fra/gisdev/archivelog/2012_12_12/thread_1_seq_8687.3100.801877195 -> fra/gisdev/archivelog/2012_12_12/C:\Oracle\test
                  ASMCMD-8016: copy source->'+fra/gisdev/archivelog/2012_12_12/thread_1_seq_8687.3100.801877195' and target->'+fra/gisdev/archivelog/2012_12_12/C:\Oracle\test' failed
                  ORA-19505: failed to identify file "+fra/gisdev/archivelog/2012_12_12/C:\Oracle\test"
                  ORA-15124: ASM file name '+fra/gisdev/archivelog/2012_12_12/C:\Oracle\test' contains an invalid alias name
                  ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 413
                  ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)
                  ASMCMD>


                  do i have to mention it in quotes??
                  • 6. Re: copy files from ntfs to asm
                    vlethakula
                    Try without Drivename

                    cp +fra/gisdev/archivelog/2012_12_12/thread_1_seq_8687.3100.801877195 \Oracle\test\arch1.log                                                                                                                                                                                                                                           
                    • 7. Re: copy files from ntfs to asm
                      934646
                      that is working only for the 'c' drive but what if we want to copy to other drives?? and also can we copy folders instead of individual files to acfs drives??


                      Thanks
                      • 8. Re: copy files from ntfs to asm
                        Ragnar.H.

                        I know this is a bit late. But I found a way to make this work.

                         

                        In windows cmd, create a Directory Junction.

                        : mklink /J c:\testfolder d:\testfolder

                        : asmcmd cp +DATA/DBA/DATAFILE/file /./testfolder/

                         

                        This seems to work for me.

                         

                        --

                        Ragnar H.