Re: ORA-00201 during startup

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 26 May 2021 15:06:29 -0400
Message-ID: <89cd4ac8-86e2-075c-f21b-3a4bd110a36e_at_gmail.com>

Sayan, my understanding is that the situation is actually vice versa: database software is 11.2.0.3 and somebody has set compatible parameter to 11.2.0.4. Re-creating the control file or restoring from backup seem like the best options in that case.

Regards

Hi Abdella,

Why do you think that  11.2.0.4 is a bad compatible parameter? 

Why do you want 11.2.0.3, if your Oracle software is 11.2.0.4 really? 

(AFAIR, otherwise it wouldn't start with 11.2.0.4)

On Wed, May 26, 2021 at 6:16 PM Radoulov, Dimitre <cichomitiko_at_gmail.com> wrote:

Hello,

I suppose that you'll need to use a backup of the controlfile (or
recreate it from a backup to trace) and than run a fake incomplete
recovery (using backup controlfile).


Regards
Dimitre

On 26/05/2021 11.05, Abdellah DANY wrote:
> Hi experts,
>
> We inadvertently startup database bad compatible parameter. 11.2.0.4
> instead of 11.2.0.3.
>
> When trying to restart it using the good init file, we got this error.
>
> ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE
> version
> 11.2.0.3.0
> ORA-00202: control file: '../.../oracle/control/control01.ctl'
>
> Is there a way to start the database without upgrading/downgrading
> procedure?
>
> PS: the datafiles header contain already the new 11.2.0.4 compatible
> parameter.
>
> Thanks in advance.
>
--
http://www.freelists.org/webpage/oracle-l

--

Best regards,
Sayan Malakshinov

Oracle performance tuning engineer

Oracle ACE Associate
http://orasql.org

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

-- http://www.freelists.org/webpage/oracle-l Received on Wed May 26 2021 - 21:06:29 CEST