ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.0.0


bash-3.2$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 5 11:28:25 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: ANARDB (not mounted)

RMAN> restore standby controlfile from '/dataguard_backup/stby.yed';

Starting restore at 05-FEB-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=866 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=+DATA/ANARDBdr/controlfile/current.1629.903007733

Finished restore at 05-FEB-16

RMAN> alter database mount;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of alter db command at 02/05/2016 11:29:07

ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.0.0

ORA-00202: control file: '+DATA/ANARDBdr/controlfile/current.1629.903007733'

RMAN> ^D

Recovery Manager complete.

bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 5 11:29:26 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> show parameters comp

NAME

------------------------------------

TYPE VALUE

-------------------------------------------- ------------------------------

cell_offload_compaction

string ADAPTIVE

compatible

string 11.2.0.0.0

nls_comp

string BINARY

plsql_v2_compatibility

boolean FALSE

SQL> alter system set compatible='11.2.0.4.0' scope=spfile;

System altered.

SQL> startup force mount;

ORACLE instance started.

Total System Global Area 2.0583E+10 bytes

Fixed Size 2190488 bytes

Variable Size 3019903848 bytes

Database Buffers 1.7515E+10 bytes

Redo Buffers 45883392 bytes

Database mounted.

bash-3.2$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 5 11:31:34 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: ANARDB (DBID=4272911893, not open)

RMAN> CATALOG START WITH '/dataguard_backup/';

Starting implicit crosscheck backup at 05-FEB-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=1442 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=2 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=98 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=196 device type=DISK

Crosschecked 19 objects

Crosschecked 14 objects

Finished implicit crosscheck backup at 05-FEB-16

Starting implicit crosscheck copy at 05-FEB-16

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

Finished implicit crosscheck copy at 05-FEB-16

searching for all files in the recovery area

cataloging files...

no files cataloged

searching for all files that match the pattern /dataguard_backup/

List of Files Unknown to the Database

=====================================

File Name: /dataguard_backup/stby.yed

Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done
List of Cataloged Files
=======================
File Name: /dataguard_backup/stby.yed
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: