Search This Blog

Sunday, 3 May 2015

ASMCMD Copy failing with ORA-15046 Error

ORA-15046


Copying of the file among the ASM disks will fail with the ORA-15046 error.

ASMCMD> cp +DATA/gbjfou/data/carlos.297.878629835 +REDO/gbjfou/data/carlos.297.878626689
copying +DATA/gbjfou/data/carlos.297.878629835 -> +REDO/gbjfou/data/carlos.297.878626689
ASMCMD-8016: copy source '+DATA/gbjfou/data/carlos.297.878629835' and target '+REDO/gbjfou/data/carlos.297.878626689' failed
ORA-15056: additional error message
ORA-15046: ASM file name '+REDO/gbjfou/data/carlos.297.878626689' is not in single-file creation form
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 415
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

Here, i am trying to copy the carlos.297.878626689 file from +DATA diskgroup to the +REDO diskgroup. As per the MOS note Doc ID 452158.1 they said it is a known behavior because the file carlos.297.878626689 creating in the target disk is not in the form where that can be used to create a single file. As here we can see the file name extension with numerals where it represents the filenumber / Incarnation.

Then, i removed the numerals and tried to copy which worked fine for me :)

ASMCMD> cp +DATA/gbjfou/data/carlos.297.878629835 +REDO/gbjfou/data/carlos
source +DATA/gbjfou/data/carlos.297.878629835
target +REDO/gbjfou/data/carlos
copying file(s)...file, +REDO/gbjfou/data/carlos, copy committed.


No comments:

Post a Comment