Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-15 09:57:59 | 查看: 1351| 回复: 0

oracle集群数据库因为磁盘组故障导致数据库集群挂掉
下面是alter日志,请大哥们帮忙分析一下原因-----紧急 谢谢!

ue Apr 09 13:47:10 2013
Errors in file /oracle/app/grid_base/diag/asm/+asm/+ASM2/trace/+ASM2_smon_1914.trc:
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 5: I/O error
Additional information: -1
Additional information: 4096
WARNING: Read Failed. group:1 disk:0 AU:0 offset:0 size:4096
NOTE: SMON starting instance recovery for group ARCH domain 1 (mounted)
NOTE: SMON skipping disk 0 - no header
NOTE: cache initiating offline of disk 0 group ARCH
NOTE: process _smon_+asm2 (1914) initiating offline of disk 0.1258882717 (ARCH_0000) with mask 0x7e in group 1
WARNING: Disk 0 (ARCH_0000) in group 1 in mode 0x7f is now being taken offline on ASM inst 2
NOTE: initiating PST update: grp = 1, dsk = 0/0x4b09069d, mask = 0x6a, op = clear
Tue Apr 09 13:47:10 2013
GMON updating disk modes for group 1 at 25 for pid 17, osid 1914
ERROR: Disk 0 cannot be offlined, since diskgroup has external redundancy.
ERROR: too many offline disks in PST (grp 1)
Tue Apr 09 13:47:10 2013
NOTE: cache dismounting (not clean) group 1/0xFDE9F6A6 (ARCH)
WARNING: Offline of disk 0 (ARCH_0000) in group 1 and mode 0x7f failed on ASM inst 2
Tue Apr 09 13:47:10 2013
NOTE: halting all I/Os to diskgroup 1 (ARCH)
ERROR: No disks with F1X0 found on disk group ARCH
NOTE: aborting instance recovery of domain 1 due to diskgroup dismount
NOTE: SMON skipping lock domain (1) validation because diskgroup being dismounted
Abort recovery for domain 1
Received dirty detach msg from inst 1 for dom 2
NOTE: messaging CKPT to quiesce pins Unix process pid: 11417, image: oracle@lw-pthisd2 (B000)
List of instances:
1 2
Dirty detach reconfiguration started (new ddet inc 1, cluster inc 4)
Global Resource Directory partially frozen for dirty detach
* dirty detach - domain 2 invalid = TRUE
77 GCS resources traversed, 0 cancelled
NOTE: PST enabling heartbeating (grp 1)
Dirty Detach Reconfiguration complete
Received dirty detach msg from inst 1 for dom 3
Tue Apr 09 13:47:11 2013
ERROR: ORA-15130 in COD recovery for diskgroup 1/0xfde9f6a6 (ARCH)
ERROR: ORA-15130 thrown in RBAL for group number 1
Errors in file /oracle/app/grid_base/diag/asm/+asm/+ASM2/trace/+ASM2_rbal_1916.trc:
ORA-15130: diskgroup "ARCH" is being dismounted
List of instances:
1 2
Dirty detach reconfiguration started (new ddet inc 1, cluster inc 4)
Global Resource Directory partially frozen for dirty detach
* dirty detach - domain 3 invalid = TRUE
21 GCS resources traversed, 0 cancelled
NOTE: PST enabling heartbeating (grp 2)



手动alter后,没有报错,磁盘组可以挂上,但是过一段时间,磁盘组又自动卸载
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-1 22:28 , Processed in 0.051295 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569