El problema se
produce al recrear el tablespace temporal y recrearlo, por un bug de Oracle 7215002, que viola la constraint TS_U1 sobre los campos: DBINC_KEY, TS#, DROP_SCN.
RMAN> resync catalog;
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 01/22/2013
12:04:04
ORA-00001: unique constraint
(RMAN.TS_U1) violated
Se puede
aplicar el patch correspondiente o realizar el siguiente workarround que lo
resuelve de modo inmediato:
1. Conectarse a la base del catálogo de
rman:
SQL> SELECT * from ts where dbinc_key=2 and TS#=2
|
DBINC_
KEY
|
TS#
|
TS_NAME
|
CREATE_SCN
|
CREATE_TIME
|
BIGFILE
|
TEMPORARY
|
DROP_
SCN
|
DROP_
TIME
|
INCLUDED_IN_
DATABASE_BACKUP
|
ENCRYPT_IN_
BACKUP
|
|
2
|
2
|
TEMPORAL
|
29087
|
27/08/2004
16:52:55
|
NO
|
NO
|
|
|
YES
|
|
2.
Eliminar el tablespace temporal de la table TS:
SQL> delete from ts where dbinc_key=2 and TS#=2;
SQL> COMMIT;
3.
Realizar el
resync del catálogo:
RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete
RMAN>
4.
Verificar
que se inserte el registro correspondiente en la tabla TS del catálogo
SQL> SELECT * from ts where dbinc_key=2 and TS#=2
|
DBINC_
KEY
|
TS#
|
TS_NAME
|
CREATE_SCN
|
CREATE_TIME
|
BIGFILE
|
TEMPORARY
|
DROP_
SCN
|
DROP_
TIME
|
INCLUDED_IN_
DATABASE_BACKUP
|
ENCRYPT_IN_
BACKUP
|
|
2
|
2
|
TEMPORAL
|
7121427154
|
19/01/2013
12:26:42
|
NO
|
YES
|
|
|
NO
|
|
