Oracle : 12.1.0.2
OS : Linux
Hi
I have a 2 node rac. One of our admins rebooted one node on the rac.
On startup one of the partitions is missing from /dev/mapper
Node 1
RAC01-Data11
RAC01-Data11p1 -- MISSING.
Node 2. shows
/dev/mapper
| RAC01-Data11 | RAC01-Data11p1 |
Error in log:
2017-10-10 11:05:22.462381 :CLSDYNAM:1210059072: [ora.DATA01.dg]{1:27912:2} [start] DgpAgent::getConnxn new pool m_oracleHome:/u01/app/12.1.0/grid m_oracleSid:+ASM1 m_usrOraEnv:
2017-10-10 11:05:22.462395 :CLSDYNAM:1210059072: [ora.DATA01.dg]{1:27912:2} [start] ConnectionPool::ConnectionPool 2 m_oracleHome:/u01/app/12.1.0/grid, m_oracleSid:+ASM1, m_usrOraEnv: m_instanceType:2 m_instanceVersion:12.1.0.2.0
2017-10-10 11:05:22.469691 :CLSDYNAM:1210059072: [ora.DATA01.dg]{1:27912:2} [start] DgpAgent::runCheck: asm stat asmRet 0
2017-10-10 11:05:22.470287 :CLSDYNAM:1210059072: [ora.DATA01.dg]{1:27912:2} [start] DgpAgent::queryDgStatus excp no data found
2017-10-10 11:05:22.470316 :CLSDYNAM:1210059072: [ora.DATA01.dg]{1:27912:2} [start] DgpAgent::queryDgStatus no data found in v$asm_diskgroup_stat
2017-10-10 11:05:22.569981 :CLSDYNAM:1210059072: [ora.DATA01.dg]{1:27912:2} [start] ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "8" is missing from group number "1"
2017-10-10 11:05:22.570223 :CLSDYNAM:1210059072: [ora.DATA01.dg]{1:27912:2} [start] Agent::commonStart Exception OCIException
2017-10-10 11:05:22.570530 :CLSDYNAM:1210059072: [ora.DATA01.dg]{1:27912:2} [start] clsnUtils::error Exception type=2 string=
CRS-5017: The resource action "ora.DATA01.dg start" encountered the following error:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "8" is missing from group number "1"
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/rhel-dbh148/crs/trace/crsd_oraagent_grid.trc".
2017-10-10 11:05:22.570790 :CLSDYNAM:1210059072: [ora.DATA01.dg]{1:27912:2} [start] (:CLSN00107:) clsn_agent::start }
2017-10-10 11:05:22.570811 : AGFW:1210059072: {1:27912:2} Command: start for resource: ora.DATA01.dg rhel-dbh148 1 completed with status: FAIL
2017-10-10 11:05:22.571354 : AGFW:1214261568: {1:27912:2} Agent sending reply for: RESOURCE_START[ora.DATA01.dg rhel-dbh148 1] ID 4098:470
2017-10-10 11:05:22.572089 : AGFW:1214261568: {1:27912:2} Agent sending reply for: RESOURCE_START[ora.DATA01.dg rhel-dbh148 1] ID 4098:470
2017-10-10 11:05:22.577276 :CLSDYNAM:1216362816: [ora.DATA01.dg]{1:27912:2} [check] DgpAgent::runCheck: asm stat asmRet 0
2017-10-10 11:05:22.578113 :CLSDYNAM:1216362816: [ora.DATA01.dg]{1:27912:2} [check] DgpAgent::queryDgStatus excp no data found
2017-10-10 11:05:22.578144 :CLSDYNAM:1216362816: [ora.DATA01.dg]{1:27912:2} [check] DgpAgent::queryDgStatus no data found in v$asm_diskgroup_stat
How do I get that partition back ?
Any help would be appreciated.