Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

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