ASM alert:
WARNING: Read Failed. group:0 disk:3 AU:0 offset:0 size:4096
Errors in file /oracle/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_27525184.trc:
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: -1
Additional information: 4096
WARNING: Read Failed. group:0 disk:4 AU:0 offset:0 size:4096
Errors in file /oracle/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_27525184.trc:
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: -1
Additional information: 4096
WARNING: Read Failed. group:0 disk:9 AU:0 offset:0 size:4096
Wed Dec 21 13:01:53 2016
SQL> ALTER DISKGROUP CRS DISMOUNT /* asm agent *//* {1:44641:3159} */
Wed Dec 21 13:01:53 2016
NOTE: ASM client ORAPOP1:ORAPOP disconnected unexpectedly.
NOTE: check client alert log.
说明:
group 0 对应的diskgroup data 已经被正常drop;但是asm alert 依然在正常操作后第二天下午1点左右开始报错。2个节点asm alert 都在报错;
---重启 数据库 lixora 发现数据库无法正常启动,手动调整 oracle_home/dbs 目录下的 pfile 到新dg spfile所在位置后 发现,没晒用,集群agent 自动又把pfile里的内容变更成crs 里pfile的原始信息:
P750a:/home/grid$crsctl start resource ora.LIXORA.db
CRS-2672: Attempting to start 'ora.LIXORA.db' on 'p750a'CRS-5017: The resource action "ora.LIXORA.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/LIXORA/spfileLIXORA.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/LIXORA/spfileLIXORA.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATA/LIXORA/spfileLIXORA.ora
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-06512: at line 4
. For details refer to "(:CLSN00107:)" in "/oracle/product/11.2.0/grid/log/p750a/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.LIXORA.db' on 'p750a' failed
CRS-2679: Attempting to clean 'ora.LIXORA.db' on 'p750a'
CRS-2681: Clean of 'ora.LIXORA.db' on 'p750a' succeeded
CRS-2528: Unable to place an instance of 'ora.LIXORA.db' as all possible servers are occupied by the resource
CRS-4000: Command Start failed, or completed with errors.
处理方式:
---查看集群资源属性:crsctl stat res ora.LIXORA.db -p
crsctl modify resource ora.LIXORA.db -attr "SPFILE=+NEWDATA/LIXORA/PARAMETERFILE/spfile.324.930589649"