9 Replies Latest reply: Nov 6, 2012 8:59 AM by 934646 RSS

    Re: can not copy dump file from ASm to NTFS

    934646
      Hi all,

      I have done data pump export of a schema and is in asm disk group. I can copy the file from disk group to 'C' drive but can not copy to other drives. When I tried to copy to other drives it gives me the following error:
      ASMCMD> cp +fra/dump/testasm.dmp /Test
      copying +fra/dump/testasm.dmp -> /Test/testasm.dmp
      ASMCMD-8016: copy source->'+fra/dump/testasm.dmp' and target->'/Test/testasm.dmp
      ' failed
      ORA-19505: failed to identify file "/Test/testasm.dmp"
      ORA-27040: file create error, unable to create file
      OSD-04002: unable to open file
      O/S-Error: (OS 3) The system cannot find the path specified.
      ORA-15120: ASM file name '/Test/testasm.dmp' does not begin with the ASM prefix
      character
      ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 413
      ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)


      It is possible to copy to C drive only that's because of the grid home is residing in c drive? Can`t we copy to other directories?

      Thanks

      Edited by: 931643 on Nov 5, 2012 12:02 PM
        • 1. Re: can not copy dump file from ASm to NTFS
          934646
          my environment is a windows server 2008..

          Thanks
          • 2. Re: can not copy dump file from ASm to NTFS
            dba-india
            cp +fra/dump/testasm.dmp /Test
            Check your target folder name is wrong as you are on windows you should specify the complete path d:\Test\testasm.dmp

            Also you can use DBMS_FILE_TRANSFER package to copy files from ASM to disk, check the below link,

            http://samiora.blogspot.com/2009/03/copy-asm-files-with-dbmsfiletransfer.html
            • 3. Re: can not copy dump file from ASm to NTFS
              934646
              ASMCMD> cp +fra/dump/testasm.dmp F:\lpn_test\testasm.dmp
              copying fra/dump/testasm.dmp -> /F:\lpn_test\testasm.dmp
              ASMCMD-8016: copy source->'+fra/dump/testasm.dmp' and target->'+/F:\lpn_test\tes
              tasm.dmp' failed
              ORA-19505: failed to identify file "+/F:\lpn_test\testasm.dmp"
              ORA-17502: ksfdcre:3 Failed to create file +/F:\lpn_test\testasm.dmp
              ORA-15045: ASM file name '+/F:\lpn_test\testasm.dmp' is not in reference form
              ORA-15121: ASM file name '+/F:\lpn_test\testasm.dmp' contains an invalid diskgro
              up name
              ORA-15121: ASM file name '+/F:\lpn_test\testasm.dmp' contains an invalid diskgro
              up name
              ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 413
              ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

              Thanks,
              • 4. Re: can not copy dump file from ASm to NTFS
                vlethakula
                Are you trying this with GRID OS user or ORACLE OS user?
                • 5. Re: can not copy dump file from ASm to NTFS
                  934646
                  running as a grid user
                  • 6. Re: can not copy dump file from ASm to NTFS
                    vlethakula
                    Refer

                    ORA-17502, OSD-4002 and ORA-15081 when creating a datafile on a ASM diskgroup [ID 369898.1]
                    • 7. Re: can not copy dump file from ASm to NTFS
                      934646
                      I don`t know why you gave me that link. I have no problem with the disk group.
                      Here when i mention the drive letter, it is not considering as windows drive...it is considering as disk group.

                      But when i tried without mentioning the drive letter i got succeed with the c drive but not with other drives.

                      eg:
                      when i log in to the asmcmd from the c drive and use copy command it works. But when i login from other drives and use the same command it doesn't work.

                      I hope you got the point.

                      Thanks
                      • 8. Re: can not copy dump file from ASm to NTFS
                        Veeresh.S
                        I have done data pump export of a schema and is in asm disk group. I can copy the file from disk group to *'C' drive* but can not copy to other drives. When I tried to copy to other drives it gives me the following error:
                        you say that you can copy to C drive, so it seems it is windows system...................if it is windows OS why you are trying to copy to */Test* as if it is linux file system.

                        try and see if below command works

                        cp +fra/dump/testasm.dmp D:\



                        you have other option to copy from ASM to local system using SQL

                        try

                        create directory SRC_DIR as ‘+fra/dump/’;

                        create directory DEST_DIR as 'D:\';

                        BEGIN
                        dbms_file_transfer.copy_file(
                        source_directory_object => ‘SRC_DIR’,
                        source_file_name => ‘testasm.dmp′,
                        destination_directory_object => ‘DEST_DIR’,
                        destination_file_name => ‘testasm.dmp’
                        );
                        END;
                        /
                        • 9. Re: can not copy dump file from ASm to NTFS
                          934646
                          No even that is not working.

                          and by the way I have done the dbms_file_transfer procedure and it is working. But i was looking for the reason why we can not do in that way..do we need any further setup..etc..


                          Thanks,