我试图在 SQL*Plus 中启动 Oracle 数据库,但出现以下错误:
ORA-39510: CRS error performing start on instance 'MYDB' on 'MYDB'
CRS-2672: Attempting to start 'ora.DATA.dg' on 'my-db'
CRS-5017: The resource action "ora.DATA.dg start" encountered the following error:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA" cannot be mounted
ORA-15040: diskgroup is incomplete
ORA-15080: synchronous I/O operation failed to read block 0 of disk 1 in disk group
ORA-15080: synchronous I/O operation failed to read block 0 of disk 0 in disk group
ORA-15186: ASMLIB error function = [kfk_asm_ioerror], error = [18446744073709551597], mesg = [No such device]
ORA-15186: ASMLIB error function = [kfk_asm_ioerror], error = [18446744073709551597], mesg = [No such dev. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/my-db/crs/trace/ohasd_oraagent_grid.trc".
CRS-2674: Start of 'ora.DATA.dg' on 'my-db' failed
CRS-2679: Attempting to clean 'ora.DATA.dg' on 'my-db'
CRS-2681: Clean of 'ora.DATA.dg' on 'my-db' succeeded
CRS-0215: Could not start resource 'ora.mydb.db'.
clsr_start_resource:260 status:215
clsrapi_start_db:start_asmdbs status:215
实际上,我没有 DATA 磁盘组中的磁盘,物理删除了它们。任何通过 ASMCMD 删除磁盘组数据的尝试也都失败了。有没有办法手动删除这个磁盘组(没有 SQL*Plus 和 ASMCMD(它们不工作!!!))?
修改磁盘组依赖性
mydb
(假设您有一个名为 MYDBDG 而不是 DATA 的磁盘组):或者删除磁盘组依赖:
从集群中删除磁盘组资源:
启动数据库: