Tuesday 27 June 2017

Oracle Active Database Duplication (using RMAN): ORA-00201: control file version incompatible Oracle 11.2.0.4


During active database duplication for standby database creation I faced below error, which is related to compatible on 11.2.0.4 on RHEL-6.5 x64.


Error :


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



RMAN> duplicate target database for standby from active database ;

Starting Duplicate Db at 24-JUN-15
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=21 device type=DISK

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwEMREP12C' auxiliary format
 '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwSEMREP'   ;
}
executing Memory Script

Starting backup at 24-JUN-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=46 device type=DISK
Finished backup at 24-JUN-15

contents of Memory Script:
{
   backup as copy current controlfile for standby auxiliary format  '/u01/app/oracle/oradata/SEMREP/controlfile/o1_mf_bsq5tlql_.ctl';
   sql clone "create spfile from memory";
   shutdown clone immediate;
   startup clone nomount;
   sql clone "alter system set  control_files =
  ''/u01/app/oracle/oradata/SEMREP/controlfile/o1_mf_bsq5tlql_.ctl'' comment=
 ''Set by RMAN'' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Starting backup at 24-JUN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_EMREP12C.f tag=TAG20150624T211439 RECID=2 STAMP=883257280
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 24-JUN-15

sql statement: create spfile from memory

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     835104768 bytes

Fixed Size                     2257840 bytes
Variable Size                494931024 bytes
Database Buffers             335544320 bytes
Redo Buffers                   2371584 bytes

sql statement: alter system set  control_files =   ''/u01/app/oracle/oradata/SEMREP/controlfile/o1_mf_bsq5tlql_.ctl'' comment= ''Set by RMAN'' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     835104768 bytes

Fixed Size                     2257840 bytes
Variable Size                494931024 bytes
Database Buffers             335544320 bytes
Redo Buffers                   2371584 bytes

contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/24/2015 21:14:51
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 06/24/2015 21:14:51
RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database
ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.0.0
ORA-00202: control file: '/u01/app/oracle/oradata/SEMREP/controlfile/o1_mf_bsq5tlql_.ctl'

RMAN>

RMAN>



CAUSE :


·         Parameter Compatible on Standby Site is not compatible with Primary.

Solution

Set the compatible parameter to 11.2.0.4.0 on standby parameter file.

Restart the duplication.


on Primary

[oracle@rac126 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 24 21:18:22 2015

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, OLAP, Data Mining and Real Application Testing options

SQL> show parameter compati

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      11.2.0.4.0
plsql_v2_compatibility               boolean     FALSE


ON STANDBY SITE

Edit init parameter file

[oracle@rac125 dbs]$ vi initSEMREP.ora
db_name=EMREP12C
db_unique_name=SEMREP
db_domain=ora.com
db_create_file_dest=/u01/app/oracle/oradata
dg_broker_start=true
memory_target=800m
standby_file_management=auto
compatible=11.2.0.4.0


[oracle@rac125 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 7 14:45:49 2015

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

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size                  2257840 bytes
Variable Size             490736720 bytes
Database Buffers          339738624 bytes
Redo Buffers                2371584 bytes
SQL>
SQL>
SQL> sho parameter compatible

NAME               TYPE        VALUE
------------------- ----------- -------------
compatible         string      11.2.0.4.0


on Primary

[oracle@rac126 ~]$ rman target sys/xxxxxx@emrep12c auxiliary sys/xxxxxx@semrep

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jun 24 21:22:58 2015

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

connected to target database: EMREP12C (DBID=3728288860)
connected to auxiliary database: EMREP12C (not mounted)

RMAN> duplicate target database for standby from active database  ;

Starting Duplicate Db at 24-JUN-15
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=21 device type=DISK

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwEMREP12C' auxiliary format
 '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwSEMREP'   ;
}
executing Memory Script

Starting backup at 24-JUN-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=17 device type=DISK
Finished backup at 24-JUN-15

contents of Memory Script:
{
   backup as copy current controlfile for standby auxiliary format  '/u01/app/oracle/oradata/SEMREP/controlfile/o1_mf_bsq6c1rb_.ctl';
   sql clone "create spfile from memory";
   shutdown clone immediate;
   startup clone nomount;
   sql clone "alter system set  control_files =
  ''/u01/app/oracle/oradata/SEMREP/controlfile/o1_mf_bsq6c1rb_.ctl'' comment=
 ''Set by RMAN'' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Starting backup at 24-JUN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_EMREP12C.f tag=TAG20150624T212326 RECID=3 STAMP=883257807
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 24-JUN-15

sql statement: create spfile from memory

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     835104768 bytes

Fixed Size                     2257840 bytes
Variable Size                494931024 bytes
Database Buffers             335544320 bytes
Redo Buffers                   2371584 bytes

sql statement: alter system set  control_files =   ''/u01/app/oracle/oradata/SEMREP/controlfile/o1_mf_bsq6c1rb_.ctl'' comment= ''Set by RMAN'' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     835104768 bytes

Fixed Size                     2257840 bytes
Variable Size                494931024 bytes
Database Buffers             335544320 bytes
Redo Buffers                   2371584 bytes

contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:
{
   set newname for clone tempfile  1 to new;
   switch clone tempfile all;
   set newname for clone datafile  1 to new;
   set newname for clone datafile  2 to new;
   set newname for clone datafile  3 to new;
   set newname for clone datafile  4 to new;
   set newname for clone datafile  5 to new;
   set newname for clone datafile  6 to new;
   set newname for clone datafile  7 to new;
   set newname for clone datafile  8 to new;
   backup as copy reuse
   datafile  1 auxiliary format new
   datafile  2 auxiliary format new
   datafile  3 auxiliary format new
   datafile  4 auxiliary format new
   datafile  5 auxiliary format new
   datafile  6 auxiliary format new
   datafile  7 auxiliary format new
   datafile  8 auxiliary format new
   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/SEMREP/datafile/o1_mf_temp_%u_.tmp in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 24-JUN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/EMREP12C/mgmt.dbf
output file name=/u01/app/oracle/oradata/SEMREP/datafile/o1_mf_mgmt_tab_03qaasf0_.dbf tag=TAG20150624T212344
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/EMREP12C/system01.dbf

No comments:

Post a Comment