OraFAQ Forum: Server Administration » IO error while trying to put tablespace in read only mode

Home » RDBMS Server » Server Administration » IO error while trying to put tablespace in read only mode (oracle 9.2.0.7 and sorlars 5.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IO error while trying to put tablespace in read only mode [message #379497]

Tue, 06 January 2009 16:33

kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville

Member

Experts,

i am getting I/O error while i am trying to put tablespace in read only mode. i am working on transportable tablesapce, to migrate data from 9.2.0.7 to 10.2.0.3.

here is the error message, any one help me to fix this problem.

SYS> ALTER TABLESPACE TXN_BB_BKP READ ONLY;
ALTER TABLESPACE TXN_BB_BKP READ ONLY
*
ERROR at line 1:
ORA-01115: IO error reading block from file 160 (block # 1)
ORA-01110: data file 160:
'/opt/mis2/oracle/data/db7/data/BTQISRPT/BTQISRPT_TXNBB_BKP_1a.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
SVR4 Error: 2: No such file or directory
Additional information: 1

Report message to a moderator

Re: IO error while trying to put tablespace in read only mode [message #379501 is a reply to message #379497]

Tue, 06 January 2009 17:42

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Hate to ask a silly question.
Does the file exist in the said location?
Look into alert logs and post the relevant information.

Report message to a moderator

Re: IO error while trying to put tablespace in read only mode [message #379506 is a reply to message #379497]

Tue, 06 January 2009 19:22

kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville

Member

Mahesh,

Thanks for reply. file is already exist.

<ORACLE>-19% ls /opt/mis2/oracle/data/db7/data/BTQISRPT/BTQISRPT_TXNBB_BKP_1a.dbf
-rw-r-----   1 dba            0 Jan  6 21:59 /opt/mis2/oracle/data/db7/data/BTQISRPT/BTQISRPT_TXNBB_BKP_1a.dbf

alert log information:

Errors in file /opt/mis2/oracle/admin/BTQISRPT/bdump/btqisrpt_ckpt_4981.trc:
ORA-01110: data file 160: '/opt/mis2/oracle/data/db7/data/BTQISRPT/BTQISRPT_TXNBB_BKP_1a.dbf'
ORA-01115: IO error reading block from file 160 (block # 1)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 8192
Wed Jan  7 00:57:51 2009
Errors in file /opt/mis2/oracle/admin/BTQISRPT/bdump/btqisrpt_ckpt_4981.trc:
ORA-01110: data file 160: '/opt/mis2/oracle/data/db7/data/BTQISRPT/BTQISRPT_TXNBB_BKP_1a.dbf'
ORA-01115: IO error reading block from file 160 (block # 1)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 8192
Wed Jan  7 00:58:06 2009
Errors in file /opt/mis2/oracle/admin/BTQISRPT/bdump/btqisrpt_ckpt_4981.trc:
ORA-01110: data file 160: '/opt/mis2/oracle/data/db7/data/BTQISRPT/BTQISRPT_TXNBB_BKP_1a.dbf'
ORA-01115: IO error reading block from file 160 (block # 1)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 8192
Wed Jan  7 00:58:21 2009
Errors in file /opt/mis2/oracle/admin/BTQISRPT/bdump/btqisrpt_ckpt_4981.trc:
ORA-01110: data file 160: '/opt/mis2/oracle/data/db7/data/BTQISRPT/BTQISRPT_TXNBB_BKP_1a.dbf'
ORA-01115: IO error reading block from file 160 (block # 1)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 8192
Wed Jan  7 00:58:36 2009
Errors in file /opt/mis2/oracle/admin/BTQISRPT/bdump/btqisrpt_ckpt_4981.trc:
ORA-01171: datafile 160 going offline due to error advancing checkpoint
ORA-01110: data file 160: '/opt/mis2/oracle/data/db7/data/BTQISRPT/BTQISRPT_TXNBB_BKP_1a.dbf'
ORA-01115: IO error reading block from file 160 (block # 1)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 8192

Report message to a moderator

Re: IO error while trying to put tablespace in read only mode [message #379513 is a reply to message #379506]

Tue, 06 January 2009 20:24

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

May be my eyes are deceiving me
or
You are not telling the whole story.

Am i seeing a datafile with zero bytes?

Report message to a moderator

Re: IO error while trying to put tablespace in read only mode [message #379515 is a reply to message #379506]

Tue, 06 January 2009 20:26

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

use dbverify to check the files.
talk to your sysadmins to do a sanity check on the disk.

Report message to a moderator

Re: IO error while trying to put tablespace in read only mode [message #379738 is a reply to message #379515]

Wed, 07 January 2009 17:11

kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville

Member

Mahesh,

yes i ran the dbv command against the file. i can see some errors.

if i query the file status i am able to see the datafile status is 'RECOVER'

DO I NEED TO PERFORM MEDIA RECOVERY?


/opt/mis2/oracle/product/9.2.0.7/bin/dbv

BTQISRPT-<ORACLE>-10% cd /opt/mis2/oracle/product/9.2.0.7/bin/dbv

/opt/mis2/oracle/product/9.2.0.7/bin/dbv: Not a directory.

BTQISRPT-<ORACLE>-11% /opt/mis2/oracle/product/9.2.0.7/bin/dbv file='/opt/mis2/oracle/data/db7/data/BTQISRPT/BTQISRPT_TXNBB_BKP_1a.dbf'

DBVERIFY: Release 9.2.0.7.0 - Production on Wed Jan 7 01:07:08 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

DBV-00102: File I/O error on FILE (/opt/mis2/oracle/data/db7/data/BTQISRPT/BTQISRPT_TXNBB_BKP_1a.dbf) during read operation (-1)

Report message to a moderator

Re: IO error while trying to put tablespace in read only mode [message #379743 is a reply to message #379738]

Wed, 07 January 2009 17:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>DO I NEED TO PERFORM MEDIA RECOVERY?
I have no idea. Too early to conclude with the presented evidence.

Since this is a transportable tablespace, did this come from elsewhere?
Is your OS 32 bit?
What is the filesize supposed to be? (check in dba_data_files)? Is it more than 2gb?
Did you check with sysadmins for disk errors?

Ofcourse, search metalink for any possible workarounds.
Raise a tar.

Report message to a moderator

Re: IO error while trying to put tablespace in read only mode [message #379745 is a reply to message #379743]

Wed, 07 January 2009 18:07

kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville

Member

my OS is 64 bit.

are you talking about /opt/mis2/oracle/data/db7/data/BTQISRPT/BTQISRPT_TXNBB_BKP_1a.dbf size?

if yes then the file size is 30 gig. i have created this file in the past.

i am currently working with sys admins as well as oracle corp.

Report message to a moderator

Previous Topic:	enq: TT - contention when trying to offline a temporary tablespace
Next Topic:	Update table containing millions of records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 18:54:17 CST 2024