Error:   ORA-1505…

While cloning the following error is reported, this error happened when i perform the step 5.1.4 as the doc 559518.1 RMAN> startup nomount pfile=/u01/dev/db/tech_st/11.2.0/dbs/initDEV1.ora.tmp 2> restore controlfile from '/backup_03/image/data/stage/backup_controlfile.ctl'; 3> alter database mount; 4> exit database is already started Starting restore at 13-MAR-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=331 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/13/2014 09:40:34 ORA-19504: failed to create file "+DATA/dev/controlfile_dev.ctl" ORA-17502: ksfdcre:3 Failed to create file +DATA/dev/controlfile_dev.ctl ORA-15001: diskgroup "DATA" does not exist or is not mounted ORA-15055: unable to connect to ASM instance ORA-01031: insufficient privileges ORA-19600: input file is control file (/backup_03/image/data/stage/backup_controlfile.ctl) ORA-19601: output file is control file (+DATA/dev/controlfile_dev.ctl) Error Codes --------------------------------------------------- ORA-15055: unable to connect to ASM instance Problem Category/Subcategory --------------------------------------------------- E-Business Application Management Pack (AMP/ACMP)

 

While cloning the following error is reported, this error happened when i perform the step 5.1.4 as the doc 559518.1

 

RMAN> startup nomount pfile=/u01/dev/db/tech_st/11.2.0/dbs/initDEV1.ora.tmp
2> restore controlfile from '/backup_03/image/data/stage/backup_controlfile.ctl';
3> alter database mount;
4> exit
database is already started

Starting restore at 13-MAR-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=331 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/13/2014 09:40:34
ORA-19504: failed to create file "+DATA/dev/controlfile_dev.ctl"
ORA-17502: ksfdcre:3 Failed to create file +DATA/dev/controlfile_dev.ctl
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
ORA-19600: input file is control file (/backup_03/image/data/stage/backup_controlfile.ctl)
ORA-19601: output file is control file (+DATA/dev/controlfile_dev.ctl)

Error Codes
---------------------------------------------------
ORA-15055: unable to connect to ASM instance

 

 

 

参考：
{ This note contains error information about an "Oracle Server"
  error number. It may contain additional support notes as
  described in Note:22080.1 }

Error:   ORA-15055  (ORA-15055)
Text:   unable to connect to ASM instance
---------------------------------------------------------------------------
Cause: When accessing a diskgroup for the first time, the database was
 unable to connect to the required ASM instance.
Action: Check the additional error messages. May need to configure
 correct ASM sid or make sure the database instance has OS
 privileges for ASM SYSDBA.

 

Cause:

 

克隆EBS，进行数据库层恢复的问题 

主要原因是数据库用户无法连接ASM实例，将数据库用户的环境变量临时换为GRID用户的环境变量：

 

sqlplus / as sysasm会报没有权限的错误

 

Solution:

 

将数据库用户加入asmdba组中,sqlplus / as sysasm正常连接ASM实例，重新执行克隆操作,正常完成数据层的恢复