Thursday, October 20, 2016

ORA-15046: ASM file name '+FRA/CDBRAC/CONTROLFILE/Current.261.909834683' is not in single-file creation form

tried copying the control file from +data to +fra and encountered the error.

ASMCMD> cd +DATA/CDBRAC/CONTROLFILE
ASMCMD> ls -l
Type         Redund  Striped  Time             Sys  Name
CONTROLFILE  UNPROT  FINE     OCT 20 15:00:00  Y    Current.261.909834683
CONTROLFILE  UNPROT  FINE     OCT 20 15:00:00  N    Current.261.909834683.copy => +DATA/ASM/CONTROLFILE/Current.261.909834683.copy.277.925746471
ASMCMD>
ASMCMD>
ASMCMD> cp Current.261.909834683 +FRA/CDBRAC/CONTROLFILE/Current.256.909834683
copying +DATA/CDBRAC/CONTROLFILE/Current.261.909834683 -> +FRA/CDBRAC/CONTROLFILE/Current.256.909834683
ASMCMD-8016: copy source '+DATA/CDBRAC/CONTROLFILE/Current.261.909834683' and target '+FRA/CDBRAC/CONTROLFILE/Current.256.909834683' failed
ORA-15056: additional error message
ORA-15046: ASM file name '+FRA/CDBRAC/CONTROLFILE/Current.256.909834683' is not in single-file creation form
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 486
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)
ASMCMD>


Please note that it will only work if we specify the file name on target and do not specify the number or incarnation. That is something that asm will choose

ASMCMD> cp Current.261.909834683 +FRA/CDBRAC/CONTROLFILE
copying +DATA/CDBRAC/CONTROLFILE/Current.261.909834683 -> +FRA/CDBRAC/CONTROLFILE/Current.261.909834683
ASMCMD-8016: copy source '+DATA/CDBRAC/CONTROLFILE/Current.261.909834683' and target '+FRA/CDBRAC/CONTROLFILE/Current.261.909834683' failed
ORA-15056: additional error message
ORA-15046: ASM file name '+FRA/CDBRAC/CONTROLFILE/Current.261.909834683' is not in single-file creation form
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 486
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)
ASMCMD>


-- Below is how it should be done.

ASMCMD>
ASMCMD> cp Current.261.909834683 +FRA/CDBRAC/CONTROLFILE/Current
copying +DATA/CDBRAC/CONTROLFILE/Current.261.909834683 -> +FRA/CDBRAC/CONTROLFILE/Current
ASMCMD>


ASMCMD> cd +FRA/CDBRAC/CONTROLFILE/      
ASMCMD> ls -l
Type         Redund  Striped  Time             Sys  Name
CONTROLFILE  UNPROT  FINE     OCT 20 15:00:00  N    Current => +FRA/ASM/CONTROLFILE/Current.488.925746873
CONTROLFILE  UNPROT  FINE     OCT 20 15:00:00  Y    Current.256.909834683
CONTROLFILE  UNPROT  FINE     OCT 20 15:00:00  N    Current.256.909834683.copyFra => +FRA/ASM/CONTROLFILE/Current.256.909834683.copyFra.487.925746605
ASMCMD>



No comments: