SYMPTOM
GI: 12.2.0.1.170814 (26609817) RAC HOME: 12.1.0.2.160419 (22291127)
Just starting to build a standby database, and trying to put standby database controlfile into ASM diskgroup by using RMAN , got the following errors:
RMAN> restore controlfile to '+DATA' from '/tmp/standby.ctl'; Starting restore at 2017-09-05 09:44:30 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1694 instance=STYTEST1 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 09/05/2017 09:44:32 ORA-19870: error while restoring backup piece /tmp/standby.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-15040: diskgroup is incomplete
CAUSE
This hits the bug “21626377 – 12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM”
SOLUTION
1) Apply the latest PSU patch against RAC home( 12.1.0.2). For now , the latest RU for 12.1.0.2 is 12.1.0.2.170814 (26609783).
2) Retry again from RMAN successfully.
RMAN> restore controlfile to '+DATA' from '/tmp/standby.ctl'; Starting restore at 2017-09-05 10:30:39 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=989 instance=STYTEST1 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 2017-09-05 10:30:40
3) Review alert.log. The diskgroup “+DATA” was mounted successfully.
Tue Sep 05 10:30:40 2017 NOTE: ASMB mounting group 2 (DATA) ... .. . SUCCESS: mounted group 2 (DATA) ... .. .