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)
IO error while trying to put tablespace in read only mode [message #379497] Tue, 06 January 2009 16:33 Go to next message
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
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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?


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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
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 Go to previous messageGo to next message
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)

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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
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 Go to previous message
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.

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


Current Time: Tue Dec 06 02:16:04 CST 2016

Total time taken to generate the page: 0.05851 seconds