合 ORA-15040 diskgroup is incomplete错误解决
👉 本文共约205个字，系统预计阅读时间或需1分钟。
现象
在rac环境中，还原控制文件的时候，报错了：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | RMAN> restore controlfile from '/rman/control_at0m09cl_1_1.ctl'; Starting restore at 27-FEB-22 using channel ORA_DISK_1 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/27/2022 16:00:59 ORA-19870: error while restoring backup piece /rman/control_at0m09cl_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-15040: diskgroup is incomplete |
解决
原因主要是因为$GRID_HOME/bin/oracle和$ORACLE_HOME/bin/oracle文件的属组不对，属组应该为asmadmin才可以。
1 2 3 | -- 在rac环境中需要使用如下命令对Oracle用户和grid用户下的oracle文件都进行修复，在2个节点都运行 setasmgidwrap -o $GRID_HOME/bin/oracle setasmgidwrap -o $ORACLE_HOME/bin/oracle |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
