Rman Resync Fails With Ora-00001: Unique Constraint (Rman.Ts_u1) Violated (Doc ID 605224.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition
Information in this document applies to any platform.
***Checked for relevance on 23-Jul-2012***

Symptoms

Target database 10.2.0.4
catalog database 10.2.0.3
catalog schema 10.2.0.4
rman executable 10.2.0.4

RMAN error during resync catalog

RMAN>resync catalog;

RMAN-06005: connected to target database: ORA04P (DBID=3575581226)

RMAN-06008: connected to recovery catalog database

RMAN-08002: starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 06/20/2008 09:47:09
ORA-00001: unique constraint (RMAN.TS_U1) violated

Changes

Catalog schema has recently Upgraded to 10.2.0.4

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms