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

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...