Database Backup and Recovery (MOSC)

MOSC Banner

RMAN-03008: error while performing automatic resync of recovery catalog ORA-00060: deadlock detecte

edited Jan 22, 2013 5:46AM in Database Backup and Recovery (MOSC) 6 commentsAnswered

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center