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: AZCBS (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/azcbsdr/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/azcbsdr/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: AZCBS (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: