- 论坛徽章:
- 0
|
个人对oracle不是很了解，无奈环境需要，所以从网上找了一个教程，一步步安装，系统运行一年多无任何问题，今天突然提示链接不上服务器，因为直接srvctl stop 数据库没有反应，所以直接将两台服务器reboot了，然后就再也启动不起来了。。
既然rac群集无法启动，我就干脆将两台liunx rac服务器全部poweroff,然后开机，进入系统后,状态如下：
[oracle@rac2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE UNKNOWN rac1
ora....l1.inst application ONLINE UNKNOWN rac1
ora....l2.inst application ONLINE OFFLINE
ora....lsrv.cs application ONLINE UNKNOWN rac1
ora....cl1.srv application ONLINE UNKNOWN rac1
ora....cl2.srv application ONLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
然后开始重启，按照oracle技术网的重启方式实例，首先停止服务
[oracle@rac2 ~]$ export ORACLE_SID=orcl2
[oracle@rac2 ~]$ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://rac1:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
[oracle@rac2 ~]$ srvctl stop instance -d orcl -i orcl2
[oracle@rac2 ~]$ srvctl stop asm -n rac2
[oracle@rac2 ~]$ srvctl stop nodeapps -n rac2
[oracle@rac2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE UNKNOWN rac1
ora....l1.inst application ONLINE UNKNOWN rac1
ora....l2.inst application OFFLINE OFFLINE
ora....lsrv.cs application ONLINE UNKNOWN rac1
ora....cl1.srv application ONLINE UNKNOWN rac1
ora....cl2.srv application ONLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application OFFLINE OFFLINE
ora....C2.lsnr application OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip application OFFLINE OFFLINE
开启服务
[oracle@rac2 ~]$ export ORACLE_SID=orcl2
[oracle@rac2 ~]$ srvctl start nodeapps -n rac2
[oracle@rac2 ~]$ srvctl start asm -n rac2
开始报错
[oracle@rac2 ~]$ srvctl start instance -d orcl -i orcl2
PRKP-1001 : Error starting instance orcl2 on node rac2
CRS-0215: Could not start resource 'ora.orcl.orcl2.inst'.
[oracle@rac2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE UNKNOWN rac1
ora....l1.inst application ONLINE UNKNOWN rac1
ora....l2.inst application ONLINE OFFLINE
ora....lsrv.cs application ONLINE UNKNOWN rac1
ora....cl1.srv application ONLINE UNKNOWN rac1
ora....cl2.srv application ONLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
然后查看 alert_orcl2.log日志发现
ALTER DATABASE MOUNT
Tue Oct 21 00:03:37 2008
This instance was first to mount
Tue Oct 21 00:03:37 2008
Starting background process ASMB
ASMB started with pid=22, OS id=27124
Starting background process RBAL
RBAL started with pid=23, OS id=27128
Loaded ASM Library - Generic Linux, version 2.0.2 (KABI_V2) library for asmlib interface
Tue Oct 21 00:03:46 2008
SUCCESS: diskgroup DATA was mounted
Tue Oct 21 00:03:46 2008
ORA-00202: control file: '+FLASH/orcl/controlfile/current.256.613505371'
ORA-17503: ksfdopn:2 Failed to open file +FLASH/orcl/controlfile/current.256.613505371
ORA-15001: diskgroup "FLASH" does not exist or is not mounted
ORA-15001: diskgroup "FLASH" does not exist or is not mounted
SUCCESS: diskgroup DATA was dismounted
Tue Oct 21 00:03:46 2008
ORA-205 signalled during: ALTER DATABASE MOUNT...
Tue Oct 21 00:03:50 2008
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 27464
ASM 日志，相关部分
SUCCESS: diskgroup DATA was mounted
Tue Oct 21 00:01:54 2008
NOTE: recovering COD for group 1/0x847a2bbf (DATA)
SUCCESS: completed COD recovery for group 1/0x847a2bbf (DATA)
Tue Oct 21 00:01:55 2008
NOTE: start heartbeating (grp 2)
NOTE: cache opening disk 0 of grp 2: VOL3 label:VOL3
Tue Oct 21 00:01:55 2008
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 2: VOL4 label:VOL4
NOTE: F1X0 found on disk 1 fcn 0.0
NOTE: cache mounting (first) group 2/0xCFEA2BC0 (FLASH)
* allocate domain 2, invalid = TRUE
kjbdomatt send to node 0
Tue Oct 21 00:01:55 2008
NOTE: attached to recovery domain 2
Tue Oct 21 00:01:55 2008
NOTE: starting recovery of thread=1 ckpt=19.9351
NOTE: starting recovery of thread=2 ckpt=83.723
Abort recovery for domain 2
NOTE: crash recovery signalled OER-15096
ERROR: ORA-15096 signalled during mount of diskgroup FLASH
NOTE: cache dismounting group 2/0xCFEA2BC0 (FLASH)
Tue Oct 21 00:01:56 2008
kjbdomdet send to node 0
detach from dom 2, sending detach message to node 0
freeing rdom 2
Tue Oct 21 00:01:56 2008
NOTE: detached from domain 2
Tue Oct 21 00:01:56 2008
ERROR: diskgroup FLASH was not mounted
Starting background process ASMB
ASMB started with pid=17, OS id=26830
Tue Oct 21 00:06:40 2008
NOTE: ASMB process exiting due to lack of ASM file activity
感觉貌似问题处在 FLASH 无法 mount , 然后 DATA 也自动 dismounted ，谁能给分析一下，问题处在哪里，应该怎么处理。。头大。。。
ps:sqlplu 里面单独 startup 报 ORA-00205: error in identifying control file, check alert log for more info ，日志里面和上面一样。。 |
|
免费注册
发表于 2008-10-20 14:03
