Email: service@parnassusdata.com 7 x 24 online support!

    You are here

    • You are here:
    • Home > Blogs > PDSERVICE's blog > Opening Database with Resetlogs 时报ORA-00604 ORA-04024错误 ORA-00604: 递归 SQL 级别 出现错误 ORA-04024: 尝试对游标 进行互斥定位时检测到自死锁

Opening Database with Resetlogs 时报ORA-00604 ORA-04024错误 ORA-00604: 递归 SQL 级别 出现错误 ORA-04024: 尝试对游标 进行互斥定位时检测到自死锁

Opening Database with Resetlogs 时报ORA-00604 ORA-04024错误 ORA-00604: 递归 SQL 级别 出现错误 ORA-04024: 尝试对游标 进行互斥定位时检测到自死锁

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com

 

ORA-04024: 尝试对游标  进行互斥定位时检测到自死锁

ORA-00604: 递归 SQL 级别  出现错误

 

适用于

Oracle数据库 –企业版 – 12.1.0.2 版本及更高版本
本文档的内容适用于各个平台。

症状

用RMAN Duplicate 命令创建一个新的数据库,在执行”alter database open resetlogs”报下面的错误
ORA-00604: error occurred at recursive SQL level 2
ORA-04024: self-deadlock detected while trying to mutex pin cursor  0x4B4583CC8

原因

  产生这种情况是因为 Bug 19469538: LOADING OF DATA IN ECOL$ TABLE IS NON-OPTIMAL FOR QUERIES

NOTE:  This is not an issue specific to RMAN duplicate but is associated with opening the database with resetlogs.

解决

打补丁 Bug 19469538 和按下面两张方法打开数据库:

Option 1.  Mount the new database, complete the recovery, and open the database with resetlogs via SQL*Plus.

Option 2.  Repeat the duplicate again.