ORA-00201 and ORA-00202 errors

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Thu, 10 Jan 2019 18:58:01 +0000
Message-ID: <DM6PR11MB278026976FE88D136A78F19AF4840_at_DM6PR11MB2780.namprd11.prod.outlook.com>



Hi,
I have recently upgraded a database from 11.2.0.4 to 12.1.0.2. The upgrade was successful and the database had been running for many weeks until today. This database has a standby associated with it.

Today, I recreated SPFILE and by mistake I used the PFILE which belonged to the 11.2.0.4 database instead of 12.1.0 and brought up the database. The value of COMPATIBLE in the 12.1.0.2 parameter file is set to 12.1.0 where as it is set to 11.2.0 in the 11.1.2.0.4 parameter file. After I realized the mistake, I shut down the database, recreated the SPFILE from 12.1.0 parameter file and tried to bring up the database. I am not able to bring up the database anymore and getting the following errors while mounting the database:



SQL> startup mount
ORACLE instance started.

Total System Global Area 1.4026E+10 bytes Fixed Size 5299672 bytes
Variable Size 5402264104 bytes
Database Buffers 8589934592 bytes
Redo Buffers 28254208 bytes
ORA-00201: control file version 12.1.0.0.0 incompatible with ORACLE version 11.2.0.0.0
ORA-00202: control file: '/u2004/oradata/m44lb1/cntrl01.dbf'


When I try to recreate the control file, I get the following error:



CREATE CONTROLFILE REUSE DATABASE M44LB1 NORESETLOGS FORCE LOGGING ARCHIVELOG *
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01210: data file header is media corrupt
ORA-01110: data file : '/u2095/oradata/m44lb1/system01.dbf'
ORA-01130: database file version 12.1.0.0.0 incompatible with ORACLE version
11.2.0.0.0
ORA-01110: data file 1: '/u2095/oradata/m44lb1/system01.dbf'

It seems that after I initially recreated SPFILE from the 11.2.0.4 Pfile and brought up the database, the version database information in the data file header was updated to 11.2.0.4. Any suggestion to resolve this issue will be appreciated.

Thank you,
Amir

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 10 2019 - 19:58:01 CET

Original text of this message