RMAN-03008: error while performing automatic resync of recovery catalog ORA-00060: deadlock detecte
Hi All:
We have been experiencing many, many of the RMAN-03008 deadlock errors nightly for some time now. An SR has been opened for at least a couple of months, but hasn't helped to resolve the issue.
Our Recovery Catalog is at the following version, and this is the highest version of any of our databases as well.
SQL> SELECT * FROM rcver;
VERSION
------------
11.02.00.03
We have found an article that suggests the following, but the Tables do not exist:
SOLUTION
Workaround :-
In Rman catalog database create the following indexes :-
CREATE INDEX tfatt_i_sck on tfatt(start_ckp_key)
CREATE INDEX tfatt_i_eck on tfatt(end_ckp_key)