Oracle9i - Recover Datafile From Io Error

******************************************************************************* * * * * * welcome to aix version 5.2! * * * * * * please see the readme file in /usr/lpp/bos for information pertinent to * * this release of the aix operating system. * * * * * ******************************************************************************* noel@ermsr3prd03:/home/noel> noel@ermsr3prd03:/home/noel> noel@ermsr3prd03:/home/noel>su - oratcp oratcp's password: ermsr3prd03:oratcp 1> ermsr3prd03:oratcp 1> ermsr3prd03:oratcp 1> sqlplus /nolog sql*plus: release 9.2.0.4.0 - production on thu aug 24 17:43:32 2006 copyright (c) 1982, 2002, oracle corporation.

all rights reserved.

sql> sql> conn / as sysdba connected. sql> sql> sql> sql> select name,status from v$datafile 2 where status!='online'; name -------------------------------------------------------------------------------status ------/oracle/tcp/sapdata1/system_1/system.data1 system /oracle/tcp/sapdata3/btabd_103/btabd.data103 recover sql> alter database datafile '/oracle/tcp/sapdata3/btabd_103/btabd.data103' offline; database altered. sql> recover datafile '/oracle/tcp/sapdata3/btabd_103/btabd.data103' ora-00279: change 5747663388 generated at 08/24/2006 16:08:27 needed for thread 1 ora-00289: suggestion : /oracle/tcp/saparch/tcparch1_153325.dbf ora-00280: change 5747663388 for thread 1 is in sequence #153325 specify log: {=suggested | filename | auto | cancel} ora-00279: change 5747667485 generated at 08/24/2006 16:09:43 needed for thread 1 ora-00289: suggestion : /oracle/tcp/saparch/tcparch1_153326.dbf ora-00280: change 5747667485 for thread 1 is in sequence #153326

ora-00278: log file '/oracle/tcp/saparch/tcparch1_153325.dbf' no longer needed for this recovery specify log: {=suggested | filename | auto | cancel} ora-00279: change 5747670822 generated at 08/24/2006 16:10:52 needed for thread 1 ora-00289: suggestion : /oracle/tcp/saparch/tcparch1_153327.dbf ora-00280: change 5747670822 for thread 1 is in sequence #153327 ora-00278: log file '/oracle/tcp/saparch/tcparch1_153326.dbf' no longer needed for this recovery specify log: {=suggested | filename | auto | cancel} ora-00279: change 5747674766 generated at 08/24/2006 16:12:02 needed for thread 1 ora-00289: suggestion : /oracle/tcp/saparch/tcparch1_153328.dbf ora-00280: change 5747674766 for thread 1 is in sequence #153328 ora-00278: log file '/oracle/tcp/saparch/tcparch1_153327.dbf' no longer needed for this recovery specify log: {=suggested | filename | auto | cancel} log applied. media recovery complete. sql> sql> sql> alter database datafile '/oracle/tcp/sapdata3/btabd_103/btabd.data103' online; database altered. sql> select name,status from v$datafile 2 where status!='online'; name -------------------------------------------------------------------------------status ------/oracle/tcp/sapdata1/system_1/system.data1 system sql>exit