This discussion is archived
8 Replies Latest reply: Aug 21, 2013 3:58 AM by Ragnar.H. RSS

copy files from ntfs to asm

934646 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    what error you are getting?
  • 5. Re: copy files from ntfs to asm
    934646 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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. Newbie
    Currently Being Moderated

    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.

Legend

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