ORA-15040错误表示“diskgroup is incomplete”,即磁盘组不完整。这个错误通常出现在Oracle的ASM(Automatic Storage Management)环境中,当ASM无法访问磁盘组中的所有磁盘时,就会报告此错误。 2. 可能导致ORA-15040错误的常见原因 磁盘缺失:磁盘组中的某些磁盘物理上已不存在或无法访问。 磁盘权限问题:ASM进程无法正确访问...
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]: ORA-15040: Diskgroup Is Incomplete When Creating a New Database If nosuid
1 1.在使用从主库传输过来的控制文件在备库上进行恢复时报如下图中的错误 2 2.根据错误提示查看了当前服务器磁盘组的状态，可以看到状态都是正常挂载的 3 3.在查看服务器状态时，可以看到服务器状态也是正常的 4 4.找到一个解决办法是把oracle用户也添加到asmadmin组中，可是添加完后执行恢复仍然是错误的，如...
ORA-15017: diskgroup "USEDATA" cannot be mounted ORA-15040: diskgroup is incomplete 下面尝试mount正常的磁盘组 SQL> alter diskgroup ACFSDATA mount; alter diskgroup ACFSDATA mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15017: diskgroup "ACFSDATA" cannot be mounted ORA-...
SQL> alter diskgroup datadg mount; alter diskgroup datadg mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15040: diskgroup is incomplete ORA-15042: ASM disk “5” is missing from group number “1” ERROR: alter diskgroup datadg mount ...
alter diskgroup datadg mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15040: diskgroup is incomplete ORA-15042: ASM disk “5” is missing from group number “1” ERROR: alter diskgroup datadg mount Wed Mar 13 07:42:03 2013 ...
ERROR: diskgroup ASM_DATA was not mounted ORA-15032: not all alterations performed ORA-15017: diskgroup "ASM_DATA" cannot be mounted ORA-15040: diskgroup is incomplete to investigate the issue check the parameter asm_diskstring , if this is set incorrectly the asm diskgroups will not mount and...
ORA-15040: diskgroup is incomplete 根据网上的资料参考,查看一下两个节点的asm_diskstring参数: 节点1: SQL> show parameter asm NAME TYPE VALUE --- --- --- asm_diskgroups string DATADG asm_diskstring string /dev/oracleasm/disks 节点2: SQL> show parameter asm...
ORA-15040: diskgroup is incomplete ORA-00210: cannot open the specified control file ORA-00202: control file: '+DATADG/STDSVP/CONTROLFILE/current.270.998251971' ORA-17503: ksfdopn:2 Failed to open file +DATADG/STDSVP/CONTROLFILE/current.270.998251971 ...
实际是参数asm_diskstring没有设置造成这两个磁盘重复,没有挂上,diskgroup is incomplete实际是唯一的磁盘没有挂上,手工可以挂上。 [grid@dell ~]$ sqlplus / as sysasmSQL> show parameter diskNAME TYPE VALUE--- --- ---asm_diskgroups stringasm_diskstring stringSQL> alter system set asm_diskstring='...