ORA-02429 When doing a PITR duplication with RMAN
Hi all.
I am trying to do a PITR duplication with RMAN but I only want to recover some datafiles, and I get:
ORA 2429 cannot drop index used for enforcement of unique/primary key
How can I solve the problem? Do I have to recover all the datafiles?
Thanks in advance.
Script for the duplication:
CONNECT TARGET sys/***@CULT;
CONNECT CATALOG rman/***@REPO;
CONNECT AUXILIARY sys/****;
CONFIGURE CHANNEL DEVICE TYPE disk CLEAR;
CONFIGURE DEFAULT DEVICE TYPE TO disk;
CONFIGURE DEVICE TYPE disk PARALLELISM 3;
RUN
{
# the DUPLICATE command uses an automatic disk channel
set until time "to_date('2007-10-27:01:30:00','YYYY-MM-DD:HH24:MI:SS')";
set newname for datafile 1 to '/datos/clonprod/tabs/systclonprod_1.dbf';
SET NEWNAME FOR DATAFILE 109 TO '/indices/clonprod/tabs/TSMASTIN_I_1';
SET NEWNAME FOR DATAFILE 93 TO '/indices/clonprod/tabs/TS_MCONTRATAI_1';
SET NEWNAME FOR DATAFILE 50 TO '/datos/clonprod/tabs/TSMASTIN_1';
SET NEWNAME FOR DATAFILE 5 TO '/datos/clonprod/tabs/USUARIOS';
set newname for datafile 2 to '/datos/clonprod/tabs/undo01_1.dbf';
DUPLICATE TARGET DATABASE TO clonprod
skip tablespace
ROLLBACK,TOOLS,CENTROS,GESTER,
.
.
/*Tablespaces to skip*/
.
.
.
TS_BOLSAND,LLIBRESC,INVENTARIO
LOGFILE
GROUP 1
('/indices/clonprod/log/log1aCLONPROD.ora','/oracle9i/clonprod/log/log1CLONPROD.
ora') SIZE 10M REUSE,
GROUP 2 ('/oracle9i/clonpro
.
.
.
The complete error messge is:
sentencia sql: drop tablespace USERS including contents
sentencia sql: drop tablespace TS_XACENI including contents
RMAN-00571: =========================================
RMAN-00569: ==== ERROR MESSAGE STACK FOLLOWS =======
RMAN-00571: =========================================
RMAN-03002: failure of Duplicate Db command at 10/31/2007 18:16:28
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 10/31/2007 18:16:28
RMAN-11003: failure during parse/execution of SQL statement: drop tablespace TS_XACENI including contents
ORA-00604: error producido a nivel 1 de SQL recursivo
ORA-02429: no se puede borrar el índice utilizado para el forzado de clave única/primaria