当votedisk只有一份的时候,可能出现BUG:CSSD进程会因为找不到votedisk而crash,从而导致DB无法与ASM通讯,最终instance关闭
CSSD aborting from thread clssnmvDiskPingMonitorThread当votedisk只有一份的时候,可能出现BUG:CSSD进程会因为找不到votedisk而crash,从而导致DB无法与ASM通讯,最终instance关闭。此为Oracle的bug。引发bug的原因未知。由于voting disk在asm中,安装时,只有1个(使用了外部冗余策略),在只有一个voting disk时,当csstd进程与voting disk进行通讯时,由于bug,会发生无法通讯,导致进程关闭,从而又导致了asm与db无法通讯,所以db出现宕机。相关文档:ASM Crashed Due to CSS Crash With Voting File Checks [ID 1468826.1]11.2.0
数据库突然hang了
rac2----crsd.log日志2012-02-01 16:10:05.708: [ CRSEVT][1500211520]0CAAMonitorHandler :: 0:Could not join /oracle/product/10.2.0/crs_1/bin/racgwrap(check)category: 1234, operation: scls_process_join, loc: childcrash, OS error: 0, other: Abnormal termination of the child2012-02-01 16:10:05.763: [ CRSEVT][1500211520]0CAAMonitorHandler :: 0:Action Script /oracle/product/10.2.0/crs_1/bin/racgwrap(check) timed out for ora.perac2.vip! (timeout=60)2012-02-01 16:10:05.763: [ CRSAPP][1500211520]0Ch
HSG80故障处理过程
查询状态HSG80> show disk fullName Type Port Targ Lun Used by------------------------------------------------------------------------------DISK10000 disk 1 0 0 FAILEDSET COMPAQ BD01864552 3B07 Switches: NOTRANSPORTABLE TRANSFER_RATE_REQUESTED = 20MHZ (synchronous 20.00 MHZ negotiated) Size: NOT YET KNOWNDISK10100 disk
AIX 6.1 静默安装11.1.0.6
AIX 6.1 静默安装11.1.0.6创建oracle帐号按照官方文档设定内核参数:chgsys,chuser(注意:root也要改,不然可能会出现启动crs进程时,导致启动失败或出现crs命令无法与crs进程通信的问题)按照官方文档设定网络参数no -r -o ipqmaxlen=512no -p -o sb_max=1310720no -p -o rfc1323=1no -p -o tcp_recvspace=65536no -p -o tcp_sendspace=65536no -p -o udp_recvspace=655360no -p -o udp_sendspace=65536配置hosts配置ssh出现执行了rootpre.sh都无法跳过预检测的问题,修改如下文件/home/oracle_software/clusterware/stage/prereq/
RMAN恢复(rman只备份数据库,但不备份归档,归档通过简单的rsync或scp来传送到异地备份)
只为研究研究一下备份[oracle@GGS ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Thu Jan 19 10:54:48 2012Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: ORCL (DBID=1290862477)RMAN> backup incremental level 0 device type disk format '/oracle/%U' database ;Starting backup at 19-JAN-12using channel ORA_DISK_1channel ORA_DISK_1: starting incremental level 0 datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput