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

How to recovery PDB when PDB database is dropped in Oracle

  How to recovery PDB when PDB database is dropped :) [oracle@rac01 ~]$ sqlplus '/as sysdba' SQL*Plus: Release 21.0.0.0.0 - Product...