昨天搭建DG，在使用rman在备库进行duplicate：

RMAN>duplicate target database standby nofilenamecheck;

的时候，一直hang住，于是参看警报日志文件，发现如下错误信息：

Errors in file /u01/app/oracle/diag/rdbms/sdb/orcl/trace/orcl_ora_8975.trc:

ORA-00060: deadlock detected while waiting for resource

Trace dumping is performing id=[cdmp_20150617065802]

Wed Jun 17 06:58:04 2015

Errors in file /u01/app/oracle/diag/rdbms/sdb/orcl/trace/orcl_ora_8975.trc:

ORA-00060: deadlock detected while waiting for resource

Errors in file /u01/app/oracle/diag/rdbms/sdb/orcl/trace/orcl_ora_8975.trc:

ORA-00060: deadlock detected while waiting for resource

Trace dumping is performing id=[cdmp_20150617065806]

很明显是产生了死锁，于是查看造成当前死锁的会话：

SQL>select sid,serial#,username from v$session where sid in(select blocking_session from v$session);

SID SERIAL# USERNAME

------- --------- ------------------

17 15 HH

找到会话信息之后就可以直接kill掉这个session：

SQL>alter system kill session '17,15' immediate;

接着，重新执行duplicate就可以了。

ITPub博客

【ORA-00060】 deadlock detected while waiting for resource