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