重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: oracle 12c CDB数据库复制报错 RMAN-06136 [打印本页]

作者: 郑全 时间: 2020-1-17 10:29
标题: oracle 12c CDB数据库复制报错 RMAN-06136
rman target sys/oracle_4U@192.168.133.120:1521/cdb2 auxiliary sys/oracle_4U@192.168.133.120:1521/cdb3

RMAN> duplicate database to cdb3 pluggable database pdb1;

Starting Duplicate Db at 17-JAN-20
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=174 device type=DISK
current log archived
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area    289406976 bytes
Fixed Size                   2923536 bytes
Variable Size             230687728 bytes
Database Buffers             50331648 bytes
Redo Buffers                5464064 bytes
contents of Memory Script:
{
sql clone "alter system set  db_name =
''CDB2'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set  db_unique_name =
''CDB3'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set  db_name =  ''CDB2'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set  db_unique_name =  ''CDB3'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area    289406976 bytes
Fixed Size                   2923536 bytes
Variable Size             230687728 bytes
Database Buffers             50331648 bytes
Redo Buffers                5464064 bytes
Starting restore at 17-JAN-20
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=12 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/product/12.1.0/dbhome_1/dbs/c-776813329-20200117-02
channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/c-776813329-20200117-02 tag=TAG20200117T100257
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/cdb3/control01.ctl
Finished restore at 17-JAN-20
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/17/2020 10:03:01
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-00201: control file version 12.1.0.2.0 incompatible with ORACLE version 12.0.0.0.0
ORA-00202: control file: '/u01/app/oracle/oradata/cdb3/control01.ctl'

作者: 郑全 时间: 2020-1-17 10:31
错误原因是CDB3兼容参数为12.0,而源端cdb1的兼容参数为12.1.0.2
修改：

alter system set compatible='12.1.0.2.0' scope=spfile;

即可。

作者: 郑全 时间: 2020-1-17 10:32
cdb3的参数文件内容如下：

db_name=cdb3
enable_pluggable_database=true
control_files='/u01/app/oracle/oradata/cdb3/control01.ctl'
db_create_file_dest=/u01/app/oracle/oradata/cdb3/
compatible='12.1.0.2.0'

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)