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:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-12-03  
 123456
78910111213
14151617181920
21222324252627
28293031   

数据统计

  • 访问量: 6793
  • 日志数: 928
  • 影音数: 2
  • 文件数: 2
  • 书签数: 3
  • 建立时间: 2008-02-17
  • 更新时间: 2008-12-02

RSS订阅

Open Toolbar