Tuesday, November 20, 2012

ORA-00600 ORA-01114 ORA-27063 WARNING: failed to write mirror WARNING: IO Failed

Post related to below ORA- errors

ORA-00600: internal error code, arguments: [17183], [0x11041A2C8], [], [], [], [], [], []
ORA-01114: IO error writing block to file  (block # )
ORA-27063: number of bytes read/written is incorrect
WARNING: failed to write mirror side 0 of virtual extent  of file in group
WARNING: IO Failed.  au: diskname:

Error:



ORA-00600: internal error code, arguments: [17183], [0x11041A2C8], [], [], [], [], [], []
ORA-01114: IO error writing block to file  (block # )
ORA-01114: IO error writing block to file 201 (block # 647794)
ORA-27063: number of bytes read/written is incorrect

Mostly Seen in ASM ..

WARNING: failed to write mirror side 0 of virtual extent 5060 of file 268 in group 1
WARNING: IO Failed.  au:46079 diskname:/dev/rlv00
         rq:11a868b58 buffer:1124aa000 au_offset(bytes):933888 iosz:114688 operation:1
         status:2

Analysis:

Identifying Impacted file using file number or block# mentioned in error

select * from dba_segments where HEADER_BLOCK='647794';
select * from v$datafile  where file#=201;
select * from v$tempfile  where file#=201;

If DB files managed on ASM then .. Login to ASM instance

select * from v$ASM_FILE where file_number=268 and GROUP_NUMBER=1;

Login to DB instance , to verify file name

select * from v$tempfile where NAME like '%268%';
select * from dba_temp_files where FILE_NAME like '%268%';

AutoExtend found to set ON/YES



Resolution:

Set Autoextend off for identified file & reduce the size

alter database tempfile 1 autoextend off;
alter database tempfile 1 resize 2G;



Thats it Error will dis-appear from alert log

2 comments:

  1. Dear ajay nice one,but screen shots.....

    ReplyDelete
    Replies
    1. Thanks Yogesh .. Snaps are not clear as i want to show more details in such a small area , However you can click on each snap it will open new window with clear image

      Delete