Disclaimer

Sunday 11 July 2021

ASM SPFILE Copy From ASM Diskgroup to File System Failed

 

ASMCMD> cp +DG_TEST_DATA/ASM/ASMPARAMETERFILE/registry.253.978021167 /u01/oragrid/spfile/spfile+ASM.ora;


copying +DG_TEST_DATA/ASM/ASMPARAMETERFILE/registry.253.978021167 -> /u01/oragrid/spfile/;
ASMCMD-8016: copy source '+DG_TEST_DATA/ASM/ASMPARAMETERFILE/registry.253.978021167' and target '/u01/oragrid/spfile/;' failed
ORA-19505: failed to identify file "+DG_TEST_DATA/ASM/ASMPARAMETERFILE/registry.253.978021167"

ORA-17503: ksfdopn:2 Failed to open file +DG_TEST_DATA/ASM/ASMPARAMETERFILE/registry.253.978021167


ORA-15308: could not access ASM SPFILE in RDBMS instance

ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 603

ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)


Cause :
asmcmd cp does not support some file types eg ASMSPFILE, OCR and OCR backup file types.

Resolution
use asmcmd spcopy


ASMCMD> spcopy +DG_TEST_DATA/ASM/ASMPARAMETERFILE/registry.253.978021167 /u01/oragrid/spfile/spfile+ASM.ora


$ ls -lrt /u01/oragrid/spfile/spfile+ASM.ora
-rw-r----- 1 oragrid oinstall 1536 Jun  8 10:58 /u01/oragrid/spfile/spfile+ASM.ora



No comments:

Post a Comment

100 Oracle DBA Interview Questions and Answers

  Here are 100 tricky interview questions tailored for a Senior Oracle DBA role. These questions span a wide range of topics, including perf...