GI: 188.8.131.52.170814 (26609817) RAC HOME: 184.108.40.206.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
This hits the bug “21626377 – 12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM”
1) Apply the latest PSU patch against RAC home( 220.127.116.11). For now , the latest RU for 18.104.22.168 is 22.214.171.124.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) ... .. .