Unable To Copy Datafiles From Filesystem To ASM Directories On Windows Platforms. (Doc ID 786364.1)

Last updated on OCTOBER 01, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 11.1.0.7

Symptoms


Unable to copy datafiles from filesystem to ASM directories using relative or absolute paths:

TEST 1


C:\app\Administrator\product\11.2.0\dbhome_1\oradata\HWSDB\BACKUPSET\2010_06_02> dir
Volume in drive C has no label.
Volume Serial Number is C27F-D6EA

Directory of
C:\app\Administrator\product\11.2.0\dbhome_1\oradata\HWSDB\BACKUPSET\2010_06_02

02/06/2010 03:42 PM <DIR> .
02/06/2010 03:42 PM <DIR> ..
02/06/2010 03:40 PM 2,175,684,096
O1_MF_ANNNN_TAG20100602T194042_60FDXTXB_.
BKP
1 File(s) 2,175,684,096 bytes
2 Dir(s) 356,267,802,624 bytes free



C:\app\Administrator\product\11.2.0\dbhome_1\oradata\HWSDB\BACKUPSET\2010_06_02>asmcmd

ASMCMD> cp O1_MF_ANNNN_TAG20100602T194042_60FDXTXB_.BKP +FRA_01/HWSDB/BACKUPSET/2010_06_02/O1_MF_ANNNN_TAG20100602T194042_60FDXTXB_.BKP
ASMCMD-08002: entry 'O1_MF_ANNNN_TAG20100602T194042_60FDXTXB_.BKP' does not exist in directory '+fra_01/hwsdb/'
ASMCMD-08014: can not open
file->'O1_MF_ANNNN_TAG20100602T194042_60FDXTXB_.BKP'



C:\Users\Administrator>asmcmd
ASMCMD> cp \app\Administrator\product\11.2.0\dbhome_1\oradata\USERS.380.719384463 +FRA_01/HWSDB/DATAFILES/USERS.380.719384463
ASMCMD-08001: diskgroup
'\app\Administrator\product\11.2.0\dbhome_1\oradata\USERS.380.719384463' does not exist or is not mounted
ASMCMD-08014: can not open
file->'\app\Administrator\product\11.2.0\dbhome_1\oradata\USERS.380.719384463'
ASMCMD>


TEST 2

1) Connect to the database instance and obtain the list of datafiles:


C:\>sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jun 3 10:41:06 2010

Copyright (c) 1982, 2008, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$datafile;

NAME
------------------------------------------------------------------------------
--

D:\DATABASE\DB11G\DATAFILE\O1_MF_SYSTEM_4VRSGGPG_.DBF
D:\DATABASE\DB11G\DATAFILE\O1_MF_SYSAUX_4VRSGGRF_.DBF
D:\DATABASE\DB11G\DATAFILE\O1_MF_UNDOTBS1_4VRSGGSD_.DBF
D:\DATABASE\DB11G\DATAFILE\O1_MF_USERS_4VRSGH0H_.DBF
D:\DATABASE\DB11G\DATAFILE\O1_MF_EXAMPLE_4VRSLMOZ_.DBF
+DATA/db11g/datafile/test.256.715955911

6 rows selected.





2) Then try to copy the “D:\DATABASE\DB11G\DATAFILE\O1_MF_SYSTEM_4VRSGGPG_.DBF” datafile to +data/db11g/datafile ASM directory using relative paths (but it will fails):




D:\>cd D:\DATABASE\DB11G\DATAFILE\

D:\database\DB11G\DATAFILE>dir
Volume in drive D is ORA
Volume Serial Number is B48E-A424

Directory of D:\database\DB11G\DATAFILE

03/14/2009 09:22 PM <DIR> .
03/14/2009 09:22 PM <DIR> ..
06/03/2010 10:40 AM 104,865,792 O1_MF_EXAMPLE_4VRSLMOZ_.DBF
06/03/2010 10:40 AM 631,971,840 O1_MF_SYSAUX_4VRSGGRF_.DBF
06/03/2010 10:40 AM 744,497,152 O1_MF_SYSTEM_4VRSGGPG_.DBF
04/11/2010 07:20 AM 28,319,744 O1_MF_TEMP_4VRSLCTC_.TMP
06/03/2010 10:40 AM 89,137,152 O1_MF_UNDOTBS1_4VRSGGSD_.DBF
06/03/2010 10:40 AM 5,251,072 O1_MF_USERS_4VRSGH0H_.DBF
6 File(s) 1,604,042,752 bytes
2 Dir(s) 9,469,845,504 bytes free



D:\database\DB11G\DATAFILE>asmcmd
ASMCMD> ls
DATA/
ASMCMD> cd data
ASMCMD> ls
DB1/
DB11G/
ASMCMD> cd db11g
ASMCMD> ls
DATAFILE/
ASMCMD> cd datafile
ASMCMD> pwd
+data/db11g/datafile


ASMCMD> cp O1_MF_EXAMPLE_4VRSLMOZ_.DBF .
ASMCMD-08002: entry 'O1_MF_EXAMPLE_4VRSLMOZ_.DBF' does not exist in directory
'+data/db11g/datafile/'
ASMCMD-08014: can not open file->'O1_MF_EXAMPLE_4VRSLMOZ_.DBF'

ASMCMD> cp ./O1_MF_EXAMPLE_4VRSLMOZ_.DBF .
ASMCMD-08002: entry 'O1_MF_EXAMPLE_4VRSLMOZ_.DBF' does not exist in directory
'+data/db11g/datafile/'
ASMCMD-08014: can not open file->'./O1_MF_EXAMPLE_4VRSLMOZ_.DBF'

ASMCMD> cp .\O1_MF_EXAMPLE_4VRSLMOZ_.DBF .
ASMCMD-08004: ASM file path '.\O1_MF_EXAMPLE_4VRSLMOZ_.DBF' contains an
invalid alias name
ASMCMD-08014: can not open file->'.\O1_MF_EXAMPLE_4VRSLMOZ_.DBF'

ASMCMD> cp D:\database\DB11G\DATAFILE\O1_MF_EXAMPLE_4VRSLMOZ_.DBF .
ASMCMD-08010: no usr name is specified in remote instance connect_string->'D'


3) Then try to copy the “D:\DATABASE\DB11G\DATAFILE\O1_MF_SYSTEM_4VRSGGPG_.DBF” datafile to +data/db11g/datafile ASM directory using absolute paths (but it will fails as well):


D:\database\DB11G\DATAFILE>asmcmd
ASMCMD> cd data
ASMCMD> ls
DB1/
DB11G/
ASMCMD> cd db11g
ASMCMD> ls
DATAFILE/
ASMCMD> cd datafile
ASMCMD> pwd
+data/db11g/datafile
ASMCMD> cp D:\database\DB11G\DATAFILE\O1_MF_EXAMPLE_4VRSLMOZ_.DBF +data/db11g/datafile
ASMCMD-08010: no usr name is specified in remote instance connect_string->'D'


ASMCMD> cp D:\database\DB11G\DATAFILE\O1_MF_EXAMPLE_4VRSLMOZ_.DBF +data/db11g/datafile/
ASMCMD-08010: no usr name is specified in remote instance connect_string->'D'


ASMCMD> cp D:\database\DB11G\DATAFILE\O1_MF_EXAMPLE_4VRSLMOZ_.DBF +data/db11g/datafile/.
ASMCMD-08010: no usr name is specified in remote instance connect_string->'D'


ASMCMD> cp D:\database\DB11G\DATAFILE\O1_MF_EXAMPLE_4VRSLMOZ_.DBF +data/db11g/datafile/O1_MF_EXAMPLE_4VRSLMOZ_.DBF
ASMCMD-08010: no usr name is specified in remote instance connect_string->'D'


ASMCMD> cp \database\DB11G\DATAFILE\O1_MF_EXAMPLE_4VRSLMOZ_.DBF +data/db11g/datafile/O1_MF_EXAMPLE_4VRSLMOZ_.DBF
ASMCMD-08004: ASM file path
'\database\DB11G\DATAFILE\O1_MF_EXAMPLE_4VRSLMOZ_.DBF' contains an invalid alias name
ASMCMD-08014: can not open file->'\database\DB11G\DATAFILE\O1_MF_EXAMPLE_4VRSLMOZ_.DBF'




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms