eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 如何备份OutLook Express的邮件规则 | Blog首页 | 使用Oracle的外部表访问跟踪文件 »

获得Redo Block Size的非典型方法

我以前介绍过获得redo block size的方法,当然也可以通过dbfsize工具获得。

现在在这里我想介绍的是另外一种非典型方法,有多非典型呢?

问题来自于N年前我在一个客户的机器上部署的监控脚本,现在那些脚本看来还在运行着,我最近收到了大量类似如下内容的邮件:

ORA-16038: log 2 sequence# 17151 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 2 thread 1: '/export/home/oracle/oradata/cuwap/redo02.log'
ORA-19504: failed to create file "/data1/oraarc/PTL017151.arc"
ORA-19504: failed to create file "/data1/oraarc/PTL017151.arc"
ORA-27044: unable to write the header block of file
ORA-16038: log 2 sequence# 17151 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 2 thread 1: '/export/home/oracle/oradata/cuwap/redo02.log'
ORA-19504: failed to create file "/data1/oraarc/PTL017151.arc"
ORA-19504: failed to create file "/data1/oraarc/PTL017151.arc"
ORA-27044: unable to write the header block of file
ORA-16038: log 2 sequence# 17151 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 2 thread 1: '/export/home/oracle/oradata/cuwap/redo02.log'
ORA-19502: write error on file "/data1/oraarc/PTL017151.arc", blockno 169985 (blocksize=512)
ORA-27072: skgfdisp: I/O error
ORA-19502: write error on file "/data1/oraarc/PTL017151.arc", blockno 169985 (blocksize=512)
ORA-19502: write error on file "/data1/oraarc/PTL017152.arc", blockno 57345 (blocksize=512)
ORA-27072: skgfdisp: I/O error
ORA-19502: write error on file "/data1/oraarc/PTL017152.arc", blockno 57345 (blocksize=512)
ORA-16038: log 2 sequence# 17151 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 2 thread 1: '/export/home/oracle/oradata/cuwap/redo02.log'
ORA-16038: log 2 sequence# 17151 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 2 thread 1: '/export/home/oracle/oradata/cuwap/redo02.log'
ORA-16038: log 2 sequence# 17151 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 2 thread 1: '/export/home/oracle/oradata/cuwap/redo02.log'
ORA-16038: log 3 sequence# 17152 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 3 thread 1: '/export/home/oracle/oradata/cuwap/redo03.log'

我们注意到,在这些错误信息中,这样的提示至关重要:

ORA-19502: write error on file "/data1/oraarc/PTL017151.arc", blockno 169985 (blocksize=512)
ORA-27072: skgfdisp: I/O error
ORA-19502: write error on file "/data1/oraarc/PTL017151.arc", blockno 169985 (blocksize=512)
ORA-19502: write error on file "/data1/oraarc/PTL017152.arc", blockno 57345 (blocksize=512)

这里的Blocksize就告诉我们,在该系统上(Solaris),Redo Block Size是512 bytes。

这里的BlockNo让我想到了另外一个内容。

参考Steve Adams网站上的关于Log Buffer Usage的说明我们能找到另外一个有意思的内容,引用一下Steve的图:
log_buffer_mapping

我们知道,Redo Log Buffer和Redo Log File是通过Block映射(map)来完成空间分配和使用的,于是也就有了两个变量:
1.用以标示SGA中Redo Log Buffer基准位置的变量b
2.用以标示Redo Log File基准位置的变量i

如果这里存在问题的是redo log file,那么无法写入的blockno实际上就应该和variable (i)有关;当然对于归档日志文件,这里的blockno自然也是由最初的变量推进和定界的。

由以上输出的错误信息我们可以知道:

169985 * 512 /1024 /1024 = 83M

所以我们还可以判断Redo Log File的大小肯定是大于83M的,在Oracle9i中,缺省的Redo Log File大小是100M。

-The End-


历史上的今天...
    >> 2013-10-17文章:
    >> 2012-10-17文章:
    >> 2007-10-17文章:
           新的项目 装修开始
    >> 2004-10-17文章:

无觅

By eygle on 2006-10-17 16:57 | Comments (1) | Internal | 936 |

1 Comment

这种错误原因是由于磁盘有坏块还是什么原因造成的呢?
能否说明一下!


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com