Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, August 11, 2015

ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 486 with ORA-15124: ASM file name contains an invalid alias name

If you use any of the below syntax you will get the below mentioned error, instead try the suggested fix.



Using dot here "."

ASMCMD> cp /home/oracle/sshaik/tt_temp_sales.319.887131035 .
or


Using just path here "+DATA/prod1/daatfile"
cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/'

or
 Using just first two letters of the file name with no quotes here "+DATA2/prod1/datafile/tt"
cp /home/oracle/sshaik/tt_temp_sales.319.887131035 +DATA2/prod1/datafile/tt*

or

Using just first two letters of the file name with quotes here "+DATA2/prod1/datafile/tt"

cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/tt*'

or
Using complete file name with quotes here "+DATA2/prod1/datafile/tt_temp_sales.319.887131035'
 
cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/tt_temp_sales.319.887131035'

copying /home/oracle/sshaik/tt_temp_sales.319.887131035 -> +DATA2/prod1/datafile/tt*
ASMCMD-8016: copy source '/home/oracle/sshaik/tt_temp_sales.319.887131035' and target '+DATA2/prod1/datafile/tt*' failed
ORA-15124: ASM file name '+DATA2/prod1/datafile/tt*' contains an invalid alias name
ORA-15124: ASM file name '+DATA2/prod1/datafile/tt*' contains an invalid alias name
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 486
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)


Workaround:
==========

ASMCMD> cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/tt_temp_sales'
copying /home/oracle/sshaik/tt_temp_sales.319.887131035 -> +DATA2/prod1/datafile/tt_temp_sales

Since ASM will automatically append file/incarnation pair to ensure uniqueness, you will have give the name except the incarnation number….

No comments: