ALTER DATABASE MOUNT 2020-07-22T08:47:54.126335+08:00 This instance was first to mount 2020-07-22T08:47:55.845223+08:00 NOTE: ASMB mounting group 2 (DATA) NOTE: ASM background process initiating disk discovery for grp 2 (reqid:0) WARNING: group 2 (DATA) has missing disks ORA-15040: diskgroup is incomplete WARNING: group 2 is being dismounted. WARNING: ASMB force dismounting group 2 (DATA) due to missing disks SUCCESS: diskgroup DATA was dismounted NOTE: ASMB mounting group 2 (DATA) NOTE: ASM background process initiating disk discovery for grp 2 (reqid:0) WARNING: group 2 (DATA) has missing disks ORA-15040: diskgroup is incomplete WARNING: group 2 is being dismounted. WARNING: ASMB force dismounting group 2 (DATA) due to missing disks SUCCESS: diskgroup DATA was dismounted 2020-07-22T08:47:55.903640+08:00 ORA-00210: cannot open the specified control file ORA-00202: control file: '+DATA/TZLV2DB0/CONTROLFILE/control02.ctl' ORA-17503: ksfdopn:2 Failed to open file +DATA/TZLV2DB0/CONTROLFILE/control02.ctl ORA-15001: diskgroup "DATA" does not exist or is not mounted ORA-15040: diskgroup is incomplete ORA-00210: cannot open the specified control file ORA-00202: control file: '+DATA/TZLV2DB0/CONTROLFILE/control01.ctl' ORA-17503: ksfdopn:2 Failed to open file +DATA/TZLV2DB0/CONTROLFILE/control01.ctl ORA-15001: diskgroup "DATA" does not exist or is not mounted ORA-15040: diskgroup is incomplete 2020-07-22T08:47:55.950258+08:00 ORA-205 signalled during: ALTER DATABASE MOUNT...
问题原因:/u01/app/oracle/product/12.2.0/db/bin/oracle文件属性发生变化
[oracle@tz-yycs-db02 bin]$ ll oracle
-rwsr-s--x 1 oracle oinstall 409357928 Jul 22 09:24 oracle
解决办法:
#chmod 6751 /u01/app/oracle/product/12.2.2.0/db/bin/oracle #chown oracle:asmadmin /u01/app/oracle/product/12.2.0/db/bin/oracle