合 ORA-15204: database version 11.2.0.4.0 is incompatible with diskgroup DATA
Tags: Oracle高可用racASMORA-15204
现象
在执行rman还原控制文件时,报错了,“ORA-15204: database version 11.2.0.4.0 is incompatible with diskgroup DATA”:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | RMAN> restore controlfile from '/rman/control_1a0lh38g_1_1.ctl'; Starting restore at 13-FEB-22 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=429 instance=odsdw1 device type=DISK channel ORA_DISK_1: restoring control file RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 02/13/2022 18:08:03 ORA-19870: error while restoring backup piece /rman/control_1a0lh38g_1_1.ctl ORA-19504: failed to create file "+DATA" ORA-17502: ksfdcre:4 Failed to create file +DATA ORA-15001: diskgroup "DATA" does not exist or is not mounted ORA-15204: database version 11.2.0.4.0 is incompatible with diskgroup DATA |
分析
源库是11.2.0.3,新库是12.2.0.1,需要迁移升级。
1 2 3 4 5 6 7 8 9 10 11 12 | SQL> set line 1000 SQL> col COMPATIBILITY form a10 SQL> col DATABASE_COMPATIBILITY form a10 SQL> col NAME form a20 SQL> select group_number, name, compatibility, database_compatibility from v$asm_diskgroup; GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILITY ------------ ------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ 1 CRS 12.2.0.1.0 10.1.0.0.0 2 DATA 12.2.0.1.0 12.2.0.1.0 3 FRA 12.2.0.1.0 12.2.0.1.0 |
所以,问题是参数的“DATABASE_COMPATIBILITY”不兼容。
解决
1 2 3 4 5 6 7 8 9 10 11 | srvctl stop diskgroup -diskgroup data sqlplus / as sysasm alter diskgroup data mount; DROP DISKGROUP DATA INCLUDING CONTENTS; create diskgroup DATA external redundancy disk '/dev/asm-diskd','/dev/asm-diske','/dev/asm-diskf' ATTRIBUTE 'compatible.rdbms' = '11.2.0.2.0', 'compatible.asm' = '11.2.0.2.0'; srvctl start diskgroup -diskgroup data |