ORA-01200错误的分析
一 触发ora-01200错误的原因 [Oracle@oracle ~]$ oerr ora 0120001200, 00000, actual file size of %s is smaller than correc
一 触发ora-01200错误的原因
[Oracle@oracle ~]$ oerr ora 01200
01200, 00000, "actual file size of %s is smaller than correct size of %s blocks"
// *Cause: The size of the file as returned by the operating system is smaller
// than the size of the file as indicated in the file header and the
// control file. Somehow the file has been truncated. Maybe it is the
// result of a half completed copy.
// *Action: Restore a good copy of the data file and do recovery as needed.
数据文件实际块数小于数据文件头部记录的数据文件块数
二 用bbed构造一个ora-01200错误
1 数据文件/oracle/test/jiujian1.dbf实际占用块数如下:
SQL> select file_name,blocks from dba_data_files where file_id=11;
FILE_NAME BLOCKS
---------------------------------------- ---------
/oracle/test/jiujian1.dbf 1048
2 用bbed修改数据文件头部记录的数据文件占用块数
BBED> info
File# Name Size(blks)
----- ---- ----------
1 /oracle/CRM2/system1.dbf 61440
2 /oracle/CRM2/zxb.dbf 1280
3 /oracle/CRM2/CRM/sysaux01.dbf 37120
4 /oracle/CRM2/CRM/users01.dbf 640
5 /oracle/CRM2/zxa.dbf 12800
6 /oracle/CRM2/CRM/undotbs2.dbf 25600
7 /oracle/CRM2/zxc.dbf 1280
8 /oracle/CRM2/CRM/zxbig1.dbf 262144
11 /oracle/test/jiujian1.dbf 128
BBED> set dba 11,1
DBA 0x02c00001 (46137345 11,1)
BBED> p offset 44
kcvfh.kcvfhhdr.kccfhfsz
-----------------------
ub4 kccfhfsz @44 0x00000418 (十进制1048)
BBED> set offset 44
OFFSET 44
BBED> dump /v count 30
File: /oracle/test/jiujian1.dbf (11)
Block: 1 Offsets: 44 to 73 Dba:0x02c00001
-------------------------------------------------------
18040000 00200000 0b000300 00000000 l ..... ..........
00000000 00000000 00000000 0000 l ..............
BBED> modify /x 1904
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
File: /oracle/test/jiujian1.dbf (11)
Block: 1 Offsets: 44 to 73 Dba:0x02c00001
------------------------------------------------------------------------
19040000 00200000 0b000300 00000000 00000000 00000000 00000000 0000
BBED> p offset 44
kcvfh.kcvfhhdr.kccfhfsz
-----------------------
ub4 kccfhfsz @44 0x00000419(10进制为1049)
BBED> sum apply
Check value for File 11, Block 1:
current = 0x34f4, required = 0x34f4
3 启动数据库便可触发ora-01200错误
SQL> startup
ORACLE instance started.
Total System Global Area 322961408 bytes
Fixed Size 2020480 bytes
Variable Size 92277632 bytes
Database Buffers 222298112 bytes
Redo Buffers 6365184 bytes
Database mounted.
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: '/oracle/test/jiujian1.dbf'
ORA-01200: actual file size of 1048 is smaller than correct size of 1049 blocks
三ora-01200错误的解决
方式1 通过bbed 改数据文件头部偏移量44处的值为数据文件实际占用块数
方式2 通过dd命令填充数据文件实际大小为correct size of 1049 blocks中的值
dd if=/dev/zero of=/oracle/test/jiujian1.dbf bs=8192 count=1 seek=1049
相关阅读:
SPFILE 错误导致数据库无法启动(ORA-01565)
ORA-01172、ORA-01151错误处理
ORA-00600 [2662]错误解决
推荐阅读
-
Mybaits 源码解析 (六)----- 全网最详细:Select 语句的执行过程分析(上篇)(Mapper方法是如何调用到XML中的SQL的?)
-
PHP中使用addslashes函数转义的安全性原理分析
-
为PHP安装imagick时出现Cannot locate header file MagickWand.h错误的解决方法
-
Qt3D NodeInstantiator 使用时报出index out of range错误的记录
-
微信小程序获取用户信息的两种方法wx.getUserInfo与open-data实例分析
-
[日常] 使用TCPDUMP和Ethereal抓包分析HTTP请求中的异常情况
-
apache中使用mod_log_slow分析响应慢的请求
-
Win8系统发生蓝屏提示reference by pointer错误的故障原因及解决方法
-
理性分析:存满数据的硬盘会比空盘重吗
-
jquery中ajax使用error调试错误的方法教程