Oracle Database Discussions

Oracle10g RHEL 4

Hello all,

I have a slight situation here. I just finished duplicating my PROD database to DEV. Yesterday, the database started up fine. BUT now it's giving me some problems. Basically I have 2 pfiles: 1 that was created when I created the DEV database and 1 that was used to create the duplicate db from PROD. Now for some reason when I try to startup the database it is looking for the original pfile that was created with the database, NOT the one that was used with the duplication process from PROD. The problem is that the original pfile has 3 controlfiles in it and the duplicate one has 2 so I get the following error when I try to start it up with the duplicate pfile, which only has 2 controlfiles (and I need to use this pfile, not the original because of certain parameters and especially the db_block_size which needs to be 16K not 8K):


SQL> startup pfile='/opt/app/oracle/product/10.2.0/db_1/dbs/initVMRACDEV.ora'
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size 2078264 bytes
Variable Size 3472886216 bytes
Database Buffers 805306368 bytes
Redo Buffers 14696448 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-01104: number of control files (2) does not equal 3

I'm not sure how to resolve this issue. I can start it with the old pfile, but I don't want that. I NEED to use the new pfile that was created as part of the duplication process.

Any help would be appreciated.

Thank you.