文章描述了一次Oracle数据库集群由于服务器异常关闭引发的问题，包括CRS-4639错误、数据库实例无法访问ASM磁盘以及使用crsctl和srvctl工具进行手动恢复的过程。最后，作者成功重启了ASM实例并重新启动了数据库。
服务器异常关闭导致CRS-4639，集群宕机,数据库实例不能访问asm磁盘，找不到参数文件
我的数据库是单节点，安装了gi软件
[oracle@localhost dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 24 06:16:38 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
06:16:39 idle > startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/db/product/19.3/db_1/dbs/initorclasm.ora'
grid用户sqlplus / sysasm手动mount 磁盘组,再手动拉起ohas服务，crsctl start has
查看集群状态
[grid@localhost ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
OFFLINE OFFLINE localhost STABLE
ora.DATA2.dg
OFFLINE OFFLINE localhost STABLE
ora.DATA3.dg
OFFLINE OFFLINE localhost STABLE
ora.FRA.dg
OFFLINE OFFLINE localhost STABLE
ora.LISTENER.lsnr
ONLINE ONLINE localhost STABLE
ora.asm
OFFLINE OFFLINE localhost Instance Shutdown,ST
ABLE
ora.ons
OFFLINE OFFLINE localhost STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE localhost STABLE
ora.orclasm.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
拉起监听，查看监听发现asm服务没有注册上来，尝试手工拉起ora.asm服务
[grid@localhost ~]$ crsctl start resource ora.asm
CRS-4995: The command 'Start resource' is invalid in crsctl. Use srvctl for this command.
但是又有报错，12.1.0.2开始废弃使用crsctl对ora resource的修改。19c使用srvctl对集群资源进行管理
[grid@localhost ~]$ srvctl start ora.asm
Usage: srvctl <command> <object> [<options>]
commands: enable|disable|start|stop|status|add|remove|modify|update|getenv|setenv|unsetenv|config|upgrade|downgrade
objects: database|service|asm|diskgroup|listener|home|ons|oraclehome
For detailed help on each command and object and its options use:
srvctl <command> -help [-compatible] or
srvctl <command> <object> -help [-compatible]
PRKO-2001 : Invalid command line syntax
通过usage知道命令格式应该是srvctl start asm
[grid@localhost ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
OFFLINE OFFLINE localhost STABLE
ora.DATA2.dg
OFFLINE OFFLINE localhost STABLE
ora.DATA3.dg
OFFLINE OFFLINE localhost STABLE
ora.FRA.dg
OFFLINE OFFLINE localhost STABLE
ora.LISTENER.lsnr
ONLINE ONLINE localhost STABLE
ora.asm
OFFLINE OFFLINE localhost Instance Shutdown,ST
ABLE
ora.ons
OFFLINE OFFLINE localhost STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE localhost STABLE
ora.orclasm.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
成功！！！asm实例拉起来了，现在数据库实例应该可以访问asm了
[oracle@localhost dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 24 06:46:14 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
06:46:15 idle > startup
ORACLE instance started.
Total System Global Area 2516582152 bytes
Fixed Size 9137928 bytes
Variable Size 570425344 bytes
Database Buffers 1929379840 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
总结：主机非正常关闭导致集群不能自动启动，只能手动拉起集群
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
