ASMCMD CP Copying ASM Spfile Returns ASMCMD-08016 (文档 ID 1296544.1)

转载

jason_125 2017-02-25 14:30:34 博主文章分类：MOS

文章标签 source document command errors applies 文章分类 Oracle 数据库

APPLIES TO:

Oracle Server - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

SYMPTOMS

Copying an ASM spfile using ASMCMD “cp” command fails with the next errors:

ASMCMD> cp +DATA/asm/asmparameterfile/registry.253.718980293 +RECO/ copying +DATA/asm/asmparameterfile/registry.253.718980293 -> +RECO/registry.253.718980293 ASMCMD-08016: copy source->'+DATA/asm/asmparameterfile/registry.253.718980293' and target->'+RECO/registry.253.718980293' failed ORA-15091: operation incompatible with open handle in this session ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 397 ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

CAUSE

This problem is document in the next Bug (closed as non bug):

Bug 7394103 : TB: ASMCMD-08012 TRYING TO COPY ASM SPFILE

SOLUTION

1) On ASM 11.2 and onwards use the new spcopy command to copy ASM spfiles:

2) You can back up, copy, or move an Oracle ASM SPFILE with the ASMCMD spbackup, spcopy or spmove commands.

Syntax:

spcopy [-u] source destination

Example 1:

ASMCMD> spcopy +DATA/asm/asmparameterfile/registry.253.721810181 +FRA/spfileCopyASM.ora ASMCMD> spcopy +DATA/asm/asmparameterfile/registry.253.721810181 $ORACLE_HOME/dbs/spfileCopyASM.ora

Example 2:

SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string +DATA/asm/asmparameterfile/registry.253.718980293 ASMCMD> pwd +data/asm/asmparameterfile ASMCMD> ls -l REGISTRY.253.718980293 Type Redund Striped Time Sys Name ASMPARAMETERFILE MIRROR COARSE MAY 14 2010 Y REGISTRY.253.718980293 ASMCMD> spcopy REGISTRY.253.718980293 +reco/ASM/asmparameterfile/spfilenew.txt ASMCMD> ls -l +reco/ASM/asmparameterfile/spfilenew.txt Type Redund Striped Time Sys Name N spfilenew.txt => +RECO/ASM/asmparameterfile/REGISTRY.253.743275019