Home » RDBMS Server » Backup & Recovery » DUPLICATE DATABASE keep failing with ORA-00235
DUPLICATE DATABASE keep failing with ORA-00235 [message #360117] Wed, 19 November 2008 12:09 Go to next message
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
Re: DUPLICATE DATABASE keep failing with ORA-00235 [message #360120 is a reply to message #360117] Wed, 19 November 2008 12:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: DUPLICATE DATABASE keep failing with ORA-00235 [message #360121 is a reply to message #360117] Wed, 19 November 2008 12:19 Go to previous messageGo to next message
Orna
Messages: 62
Registered: November 2008
Member
.. and just to stress the point : no create/drop tablespace activity is going on in the database now
Re: DUPLICATE DATABASE keep failing with ORA-00235 [message #360141 is a reply to message #360120] Wed, 19 November 2008 14:05 Go to previous message
Orna
Messages: 62
Registered: November 2008
Member
You are right

After 5 failed attempts I ws able to get my lock on the control file

thanks
Orna
Previous Topic: OSB Express: Problem with configuring single SCSI tape drive
Next Topic: RMAN restore PRD to QA, different DBID, different location
Goto Forum:
  


Current Time: Thu Dec 08 20:03:17 CST 2016

Total time taken to generate the page: 0.13264 seconds