In its broadest sense, learning can be defined as a process of
progressive change from ignorance to knowledge,
and from indifference to understanding....
存放控制文件挂载点满引发DB DOWN
上一篇 /
下一篇 2008-02-19 13:54:38
/ 个人分类:Error Handle
Sat Feb 16 15:43:03 2008
Thread 1 advanced to log sequence 90060
Sat Feb 16 15:43:03 2008
Current log# 2 seq# 90060 mem# 0: /opt/oracle/oradata/mrpt/redomrpt02a.rdo
Current log# 2 seq# 90060 mem# 1: /data/database/mrpt/redomrpt02b.rdo
Sat Feb 16 15:43:03 2008
ARC0: Beginning to archive log 1 thread 1 sequence 90059
Creating archive destination LOG_ARCHIVE_DEST_2: '/data/archive/mrpt/1_90059.arc'
ARC0: Completed archiving log 1 thread 1 sequence 90059
Sat Feb 16 15:54:26 2008
Errors in file /opt/oracle/admin/mrpt/bdump/mrpt_ckpt_5561.trc:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/opt/oracle/oradata/mrpt/control03.ctl'
ORA-27072: skgfdisp: I/O error
Linux Error: 4: Interrupted system call
Additional information: 2
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/opt/oracle/oradata/mrpt/control02.ctl'
ORA-27072: skgfdisp: I/O error
Linux Error: 4: Interrupted system call
Additional information: 2
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/opt/oracle/oradata/mrpt/control01.ctl'
ORA-27072: skgfdisp: I/O error
Linux Error: 4: Interrupted system call
Additional information: 2
Sat Feb 16 15:54:26 2008
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 5561
控制文件分布不合理,致使在一个挂载点使用达100%后,CKPT发生时,无一controlfile写成功,结果instance down掉。
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG: