Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Ask DBA › Question Id: 4530 | Permalink

I/O error for database file

Question ID: 4530
Created By: 2011-DEC-19 10:38:30 [Kurapatiram]
Updated By: 2011-DEC-21 23:05:37 [Kurapatiram]
Status: Open
Severity: Normal
Read Only: No
14600
2011-DEC-19 10:38:30
User
 
 
Registered On: Jun 2011
Total Posts: 4
Hi 

After connecting to RMAN catalog database when I say "resync catalog", throwing 
the below error.


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 12/19/2011 10:52:27
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 12/19/2011 
10:52:27
ORA-01115: IO error reading block from file 5 (block # 497)
ORA-01110: data file 5: '/u08/oradata/RMAN/data/users01.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error


NOTE: Able to access the database and bounce the database also nothing is there 
in alert log 

any ideas on how to resolve this pls ?

OS: AIX
Database: 10g
14607
2011-DEC-20 12:39:01
Moderator
 
 
Registered On: Mar 2006
Total Posts: 290
When you say you are able to connect to the database and bounce it are you 
connecting to the TARGET or CATALOG database?  I think your issue is with the 
CATALOG (RMAN) database.

-HTH
14613
2011-DEC-21 23:05:37
User
 
 
Registered On: Jun 2011
Total Posts: 4
> When you say you are able to connect to the database and bounce it are you 
> connecting to the TARGET or CATALOG database?  I think your issue is with 
> the CATALOG (RMAN) database.
> 
> -HTH


Thanks for your reply 

and the problem is with OS I/O not with the database and we need to change some 
maxservers using aiio command. now its resolved 

ta