Day: September 5, 2017

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)
...
..
.