OraFAQ Forum: Backup & Recovery » DUPLICATE DATABASE keep failing with ORA-00235

Home » RDBMS Server » Backup & Recovery » DUPLICATE DATABASE keep failing with ORA-00235

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DUPLICATE DATABASE keep failing with ORA-00235 [message #360117]

Wed, 19 November 2008 12:09

Orna
Messages: 62
Registered: November 2008

Member

Hi

I am trying to run the duplicate database command, USING an rman catalog, but keep getting

ORA-00235: controlfile fixed table inconsistent due to concurrent update

How come ?

this is the command I run :

rman target sys/****@timsr5 catalog rman/rman@rman auxiliary / cmdfile duplicate.rcv

and this is my duplicate.rcv :

run{
ALLOCATE AUXILIARY CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=bkpnyc02.ibasis.net,NSR_DATA_VOLUME_POOL=DBBACKUP, NSR_CLIENT=racnyc05, NSR_GROUP=RMAN_2_WEEKS)';
set until time "to_date('Nov 16 2008 17:00:00','Mon DD YYYY HH24:MI:SS')";
duplicate target database to AUX1 skip tablespace .... < about 100 tablespaces I skip, because I want only 2 tablespaces to restore >
}

and this is what I get :

Starting Duplicate Db at 19-NOV-08
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/19/2008 18:01:13
ORA-00235: controlfile fixed table inconsistent due to concurrent update

Recovery Manager complete.

Appreciate any reply
thanks
Orna

Report message to a moderator

Re: DUPLICATE DATABASE keep failing with ORA-00235 [message #360120 is a reply to message #360117]

Wed, 19 November 2008 12:17

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-00235: control file fixed table inconsistent due to concurrent update
 *Cause:  Concurrent update activity on a control file caused a query on a
           control file fixed table to read inconsistent information.
 *Action: Retry the operation.

It happens from time to time, there is nothing you can do but retry.
If it happens each time then you likely encountered a bug and have to open a SR.

Regards
Michel

Report message to a moderator