Oracle Active Database Duplication
(using RMAN):
ORA-00201: control file version incompatible
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
Enjoy.........
No comments:
Post a Comment