I face wiht this error while i try to move one of my file system to my ASM
I have 11.2.0 database which is working on ASM
I needed to copy one file from file system to asm. Here is the my steps:
[oracle@prod]</tmp> asmcmd -p
ASMCMD [+] > ls
ORADATA/
ORAFRA/
ASMCMD [+] > cd oradata
ASMCMD [+oradata] > ls
ASM/
ORCL/
ASMCMD [+oradata] > cp /tmp/thread_1_seq_148.268.755819361 +ORADATA/thread_1_seq_148.268.755819361
copying /tmp/thread_1_seq_148.268.755819361 -> +ORADATA/thread_1_seq_148.268.755819361
ASMCMD-08016: copy source->’/tmp/thread_1_seq_148.268.755819361′ and target->’+ORADATA/thread_1_seq_148.268.755819361′ failed
ORA-19505: failed to identify file “+ORADATA/thread_1_seq_148.268.755819361”
ORA-17502: ksfdcre:4 Failed to create file +ORADATA/thread_1_seq_148.268.755819361
ORA-15046: ASM file name ‘+ORADATA/thread_1_seq_148.268.755819361’ is not in single-file creation form
ORA-06512: at “SYS.X$DBMS_DISKGROUP”, line 397
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)
The cp command failed because the ASM file name was not in a form that can be used to create an single file.File name should not contain the file number/incarnation
Here is the solution:
ASMCMD cp command fails with ORA-15046 [ID 452158.1]
ASMCMD [+oradata] > cp /tmp/thread_1_seq_148.268.755819361 +ORADATA/thread_1_seq_148
Referance:
ASMCMD cp command fails with ORA-15046 [ID 452158.1]
Yorum bırakın
Comments feed for this article