Home » RDBMS Server » Server Administration » 10g ORA-00201 - Controlfile version (RHEL5 10g 10.2.0.3)
10g ORA-00201 - Controlfile version [message #335556] Tue, 22 July 2008 11:22 Go to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

I am trying restore my database of Oracle 10.2.0.1 to 10.2.0.3.
The restore and recovery finish normaly, but not open database.

SQL> startup
ORACLE instance started.

Total System Global Area 293601280 bytes
Fixed Size 2072224 bytes
Variable Size 150995296 bytes
Database Buffers 134217728 bytes
Redo Buffers 6316032 bytes
ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version
10.2.0.1.0
ORA-00202: control file: '/dados/u01/oradata/oradds/control01.ctl'


When I alter the parameter COMPATIBILITY of file initSID.ora for 10.2.0.3, I get error:

SQL> startup
ORACLE instance started.

Total System Global Area 293601280 bytes
Fixed Size 2072224 bytes
Variable Size 150995296 bytes
Database Buffers 134217728 bytes
Redo Buffers 6316032 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced


Can anyboby help me, please.


Marcos
Re: 10g ORA-00201 - Controlfile version [message #335557 is a reply to message #335556] Tue, 22 July 2008 11:24 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
answers can be found in alert_SID.log file & possible trace file as specified therein.
Re: 10g ORA-00201 - Controlfile version [message #335558 is a reply to message #335556] Tue, 22 July 2008 11:32 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course if you had posted all what you did and not just the last part when you got the error, it would be easier to diagnose.
It seems you try to recover a 10.2.0.3 version with a 10.2.0.1 binary and it seems that this is not possible due to control file format evolution.
Please confirm what you did with which versions.

Regards
Michel
Previous Topic: Database Creation using DBCA stalls at 92%
Next Topic: undo tablespace usage
Goto Forum:
  


Current Time: Sun Dec 11 00:31:43 CST 2016

Total time taken to generate the page: 0.07443 seconds