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就可以了。