| 10g ORA-00201 - Controlfile version [message #335556] |
Tue, 22 July 2008 11:22  |
marcossantos
Messages: 123
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 #335558 is a reply to message #335556] |
Tue, 22 July 2008 11:32  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
