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

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

搭建DG时，准备duplicate时报错了

RMAN> duplicate target database for standby nofilenamecheck from active database;

Starting Duplicate Db at 08-JUN-22
using channel ORA_AUX_DISK_1

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

Starting backup at 08-JUN-22
using channel ORA_DISK_1
Finished backup at 08-JUN-22

contents of Memory Script:
{
   backup as copy current controlfile for standby auxiliary format  '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/cntrlorclstd.dbf';
}
executing Memory Script

Starting backup at 08-JUN-22
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_orcl.f tag=TAG20220608T153001 RECID=3 STAMP=1106839803
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 08-JUN-22

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/08/2022 15:30:04
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/08/2022 15:30:04
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/product/11.2.0/dbhome_1/dbs/cntrlorclstd.dbf'

原因在于，备库spfile使用的是我自己手动编写生成的，非系统生成，其中的参数compatible 系统跑回去使用init.ora中配置的。

所以造成了：ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.0.0

备库中init是：compatible ='11.2.0'

而在主库上：

SQL> show parameter compatible

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

直接copy主库的pfile，稍作修改到备库，生成spfile启动，即可

或者修改备库参数文件compatible，重启