ORACLE ORA-01110: ORA-27072: 處理

今天朋友的測試庫報錯， ORA-27072: File I/O error， Linux-x86_64 Error: 5: Input/output error，資料塊已經不能正常啟動，看到 Linux-x86_64 Error: 5: Input/output error多數是磁碟空間滿導致的

KCF: read, write or open error, block=0x283980 >

file=5 '/app/oradata1/general_1.dbf'

error=27072 txt: 'Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 2636160

Additional information: -1'

Errors in file /home/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_dbw1_30299.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

ORA-01114: IO error writing block to file 5 (block # 2636160)

ORA-01110: data file 5: '/app/oradata1/general_1.dbf'

ORA-27072: File I/O error

Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 2636160

Additional information: -1

DBW1 (ospid: 30299): terminating the instance due to error 1242

Termination issued to instance processes. Waiting for the processes to exit

Instance terminated by DBW1, pid = 30299

檢視磁碟使用情況，看空間還都比較富於，貌似不是空間引起的

[root@template app]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/vda3 16G 12G 3.5G 77% /

tmpfs 32G 17G 15G 53% /dev/shm

/dev/vda1 194M 32M 153M 17% /boot

/dev/vdb1 2.0T 907G 963G 49% /app

檢視主機是虛擬機器還是物理機，發現是個虛擬機器，如果是虛擬機器的話可能出現儲存超分的情況，（儲存超分就是看著使用率可能不高但是實際上物理磁碟的空間可能已經滿了）

[root@template app]# dmidecode |grep -i prod

Product Name: OpenStack Nova

刪除了/app下的部分檔案，如果刪除部分檔案能啟動的話就是儲存超分了

SQL> startup

ORACLE instance started.

Total System Global Area 2.6991E+10 bytes

Fixed Size 2213976 bytes

Variable Size 1.9596E+10 bytes

Database Buffers 7247757312 bytes

Redo Buffers 145174528 bytes

Database mounted.

Database opened.

資料庫能正常啟動了說明了儲存還是存在超分的情況，刪除部分檔案釋放了空間部分空間資料庫就能正常啟動了。

有點奇怪的是dbv檢測資料檔案居然還有壞塊

[oracle@template ~]$ dbv file=/app/oradata1/general_1.dbf blocksize=8192

DBVERIFY: Release 11.2.0.1.0 - Production on ÐÇÆÚ¶þ 10ÔÂ 29 11:19:44 2019

DBVERIFY - Verification starting : FILE = /app/oradata1/general_1.dbf

Page 2760430 is influx - most likely media corrupt

Corrupt block relative dba: 0x016a1eee (file 5, block 2760430)

Fractured block found during dbv:

Data in bad block:

type: 0 format: 2 rdba: 0x016a1eee

last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05

spare1: 0x0 spare2: 0x0 spare3: 0x0

consistency value in tail: 0x3454286e

check value in block header: 0xb884

computed block checksum: 0x5843

Page 2760431 is marked corrupt

Corrupt block relative dba: 0x016a1eef (file 5, block 2760431)

Bad header found during dbv:

Data in bad block:

type: 67 format: 4 rdba: 0x45726576

last change scn: 0x6973.6e657478 seq: 0x6f flg: 0x6e

spare1: 0x72 spare2: 0x69 spare3: 0x7661

consistency value in tail: 0x43746567

check value in block header: 0x6a2e

computed block checksum: 0x21

Page 2760432 is marked corrupt

Corrupt block relative dba: 0x016a1ef0 (file 5, block 2760432)

Bad header found during dbv:

Data in bad block:

type: 111 format: 6 rdba: 0x6f697463

last change scn: 0x786f.7250286e seq: 0x6f flg: 0x6f

spare1: 0x6e spare2: 0x65 spare3: 0x7461

consistency value in tail: 0x664f2e65

check value in block header: 0x446c

computed block checksum: 0x3f34

Page 2760433 is marked corrupt

Corrupt block relative dba: 0x016a1ef1 (file 5, block 2760433)

Bad header found during dbv:

Data in bad block:

type: 115 format: 3 rdba: 0x6f666e49

last change scn: 0x6369.76726553 seq: 0x65 flg: 0x2e

spare1: 0x79 spare2: 0x73 spare3: 0x4874

consistency value in tail: 0x6f687465

check value in block header: 0x6567

computed block checksum: 0x435d

Page 2760434 is marked corrupt

Corrupt block relative dba: 0x016a1ef2 (file 5, block 2760434)

Bad header found during dbv:

Data in bad block:

type: 100 format: 6 rdba: 0x353a6176

last change scn: 0x325b.0a293739 seq: 0x30 flg: 0x31

spare1: 0x6a spare2: 0x61 spare3: 0x3930

consistency value in tail: 0x486e6f69

check value in block header: 0x2e38

block checksum disabled

Page 2760435 is marked corrupt

Corrupt block relative dba: 0x016a1ef3 (file 5, block 2760435)

Bad header found during dbv:

Data in bad block:

type: 97 format: 6 rdba: 0x6a2e7265

last change scn: 0x3031.3a617661 seq: 0x39 flg: 0x29

spare1: 0x64 spare2: 0x6c spare3: 0x3032

consistency value in tail: 0x53707474

check value in block header: 0x5b0a

block checksum disabled

Page 2760436 is marked corrupt

Corrupt block relative dba: 0x016a1ef4 (file 5, block 2760436)

Bad header found during dbv:

Data in bad block:

type: 101 format: 2 rdba: 0x732e7465

last change scn: 0x6563.69767265 seq: 0x28 flg: 0x48

spare1: 0x76 spare2: 0x6c spare3: 0x5370

consistency value in tail: 0x74696e6f

check value in block header: 0x7474

block checksum disabled

Page 2760437 is marked corrupt

Corrupt block relative dba: 0x016a1ef5 (file 5, block 2760437)

Bad header found during dbv:

Data in bad block:

type: 111 format: 2 rdba: 0x69546c72

last change scn: 0x746c.6946656d seq: 0x65 flg: 0x72

spare1: 0x58 spare2: 0x55 spare3: 0x7661

consistency value in tail: 0x7270732e

check value in block header: 0x6a2e

block checksum disabled

Page 2760438 is marked corrupt

Corrupt block relative dba: 0x016a1ef6 (file 5, block 2760438)

Bad header found during dbv:

Data in bad block:

type: 105 format: 6 rdba: 0x656d6172

last change scn: 0x772e.6b726f77 seq: 0x65 flg: 0x62

spare1: 0x67 spare2: 0x66 spare3: 0x6c69

consistency value in tail: 0x542e6c69

check value in block header: 0x662e

block checksum disabled

Page 2760439 is marked corrupt

Corrupt block relative dba: 0x016a1ef7 (file 5, block 2760439)

Bad header found during dbv:

Data in bad block:

type: 104 format: 2 rdba: 0x6f6f5064

last change scn: 0x6d65.7449246c seq: 0x2e flg: 0x72

spare1: 0x65 spare2: 0x61 spare3: 0x5428

consistency value in tail: 0x72456573

check value in block header: 0x6e75

block checksum disabled

Page 2760440 is marked corrupt

Corrupt block relative dba: 0x016a1ef8 (file 5, block 2760440)

Bad header found during dbv:

Data in bad block:

type: 114 format: 7 rdba: 0x6f726874

last change scn: 0x7845.6c715377 seq: 0x63 flg: 0x65

spare1: 0x72 spare2: 0x2e spare3: 0x6f69

consistency value in tail: 0x33302e33

check value in block header: 0x7470

computed block checksum: 0xe79

Page 2760441 is marked corrupt

Corrupt block relative dba: 0x016a1ef9 (file 5, block 2760441)

Bad header found during dbv:

Data in bad block:

type: 50 format: 5 rdba: 0x616a2074

last change scn: 0x6c71.732e6176 seq: 0x2e flg: 0x44

spare1: 0x9 spare2: 0x61 spare3: 0x6576

consistency value in tail: 0x0a293830

check value in block header: 0x6972

computed block checksum: 0xb3c

Page 2760442 is marked corrupt

Corrupt block relative dba: 0x016a1efa (file 5, block 2760442)

Bad header found during dbv:

Data in bad block:

type: 91 format: 2 rdba: 0x39302e38

last change scn: 0x3231.2039322e seq: 0x3a flg: 0x33

spare1: 0x30 spare2: 0x31 spare3: 0x3334

consistency value in tail: 0x00000000

check value in block header: 0x3a35

block checksum disabled

Page 2760443 is marked corrupt

Corrupt block relative dba: 0x016a1efb (file 5, block 2760443)