ORA-15046: ASM file name is not in single-file creation form
Posted by Mir Sayeed Hassan on December 23rd, 2020
ORA-15046: ASM file name is not in single-file creation form
We got an below error copying the file from the existing ASM location to the New ASM Disk as shown below
ASMCMD> cd +FRA/RACDBN1/BACKUPSET/2020_12_16/
ASMCMD> ls nnndn0_FRIDAY_LEVEL_0_0.333.1059285491
Need to copy the above file to new asm disk
ASMCMD> cp +fra/RACDBN1/backupset/2020_12_16/nnndn0_FRIDAY_LEVEL_0_0.333.1059285491 +backup/fdbbkp/ copying +fra/RACDBN1/backupset/2020_12_16/nnndn0_FRIDAY_LEVEL_0_0.333.1059285491 -> +backup/fdbbkp/nnndn0_FRIDAY_LEVEL_0_0.333.1059285491 ASMCMD-8016: copy source '+fra/RACDBN1/backupset/2020_12_16/nnndn0_FRIDAY_LEVEL_0_0.333.1059285491' and target '+backup/fdbbkp/nnndn0_FRIDAY_LEVEL_0_0.333.1059285491' failed ORA-15056: additional error message ORA-15046: ASM file name '+backup/fdbbkp/nnndn0_FRIDAY_LEVEL_0_0.333.1059285491' is not in single-file creation form ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 617 ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)
Note: The above cp command failed due to the ASM file name was not in a form that can be used to create an single file, here the file name should not contain the file number/incarnation.
To overcome this issue, remove the number/incarnation from the file and copy as shown below
ASMCMD> cp nnndn0_FRIDAY_LEVEL_0_0.333.1059285491 +backup/fdbbkp/nnndn0_FRIDAY_LEVEL333 copying +fra/RACDBN1/backupset/2020_12_16/nnndn0_FRIDAY_LEVEL_0_0.333.1059285491 -> +backup/fdbbkp/nnndn0_FRIDAY_LEVEL
Hence copyied successfully.
Verify
ASMCMD> cd +BACKUP/FDBBKP
ASMCMD> ls nnndn0_FRIDAY_LEVEL333
Note: In case if you have the multiple files to copy, Use the excel to create number of files in correct format.
=====Hence tested & Verified in our test env=====
Also Read: technology quotes