用户使用RAC集群,A节点添加日志组没问题,B节点添加日志组现在宕机。
B节点出错情况:
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size
2073192 bytes
Variable Size
989859224 bytes
Database Buffers
603979776 bytes
Redo Buffers
14700544 bytes
Database mounted. //数据库能够启动到mount状态。
$ crs_stat -t
Name Type TargetState Host
------------------------------------------------------------
ora....B1.lsnr applicationONLINEONLINEqdcercdb1
ora....db1.gsd applicationONLINEONLINEqdcercdb1
ora....db1.ons applicationONLINEONLINEqdcercdb1
ora....db1.vip applicationONLINEONLINEqdcercdb1
ora....B2.lsnr applicationONLINEONLINEqdcercdb2
ora....db2.gsd applicationONLINEONLINEqdcercdb2
ora....db2.ons applicationONLINEONLINEqdcercdb2
ora....db2.vip applicationONLINEONLINEqdcercdb2
ora.qdcerco.db applicationONLINEONLINEqdcercdb2
ora....o1.inst applicationONLINEONLINEqdcercdb1
ora....o2.inst applicationONLINEONLINEqdcercdb2
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel /
B节点错误日志:
Errors in file /oracle/app/admin/qdcerco/udump/qdcerco2_ora_585874.trc:
ORA-00313: open failed for members of log group 5 of thread 2
ORA-00312: online log 5 thread 2: '/dev/rora_redo23_512'
查看其读写权限:
# ls -la
crw-rw---- 1 oracle oinstall 82, 12 Oct 31 17:32 rora_redo12_512m
brw-rw---- 1 oracle oinstall 82, 47 Oct 31 18:01 rora_redo13_512
crw-rw---- 1 oracle oinstall 82, 13 Oct 31 18:01 rora_redo21_512m
crw-rw---- 1 oracle oinstall 82, 14 Oct 31 16:20 rora_redo22_512m
brw-rw---- 1 oracle oinstall 82, 46 Oct 31 18:01 rora_redo23_512
crw-rw---- 1 oracle oinstall 82,3 Oct 29 22:19 rora_spfile_256m
查看对应裸设备:
SQL> select * from v$logfile;
GROUP# STATUSTYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
1 ONLINE
/dev/rora_redo11_512m
NO
2 ONLINE
/dev/rora_redo12_512m
NO
GROUP# STATUSTYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
3 ONLINE
/dev/rora_redo21_512m
NO
4 ONLINE
/dev/rora_redo22_512m
GROUP# STATUSTYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
NO
5 ONLINE
/dev/rora_redo23_512
NO
6 ONLINE
GROUP# STATUSTYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
/dev/rora_redo13_512
NO
如果大家谁遇见过这样的事情,请给个原因。我实在不能解释出错的原因。
[ 本帖最后由 anycall2010 于 2008-11-16 08:26 编辑 ]
|