Restore & Recovery - Recover Datafile (ora-00376)

Background 1. Error in Tcode ST22 - DBIF_RSQL_SQL_ERROR Database error text........: "ORA-00376: file 198 cannot be read at this time#ORA-01110: data file 198: '/oracle/TCP/sapdata6/btabd_81/btabd.data81'#" Internal call code.........: "[RSQL/INSR/PPOIX ]"

2. Error in Tcode Sm21 08:04:23 BTC 30 001 70726 BY4 Database error 376 at INS access to table PPOIX 08:04:23 BTC 30 001 70726 BY0 > ORA-00376: file 198 cannot be read at this time#ORA-01110: 08:04:23 BTC 30 001 70726 BY0 > data file 198: '/oracle/TCP/sapdata6/btabd_81/bta bd.data81'# 08:04:23 BTC 30 001 70726 R68 Perform rollback 08:04:24 BTC 30 001 70726 AB0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred 08:04:25 BTC 30 001 70726 AB1 > Short dump "060615 081437 ermsr3ap 70726 " generated 08:04:25 BTC 30 001 70726 D01 Transaction termination 00 671 ( DBIF_RSQL_SQL_ERRO R 20060615081437ermsr3app01 70726 0011 ) 08:04:25 BTC 30 001 70726 R68 Perform rollback

3. Error in /oracle/TCP/saptrace/background/ alert_TCP.log Wed Jun 14 08:17:15 2006 KCF: write/open error block=0x1178f online=1 file=198 /oracle/TCP/sapdata6/btabd_81/btabd.data81 error=27063 txt: 'IBM AIX RISC System/6000 Error: 5: I/O error Additional information: -1 Additional information: 8192' Automatic datafile offline due to write error on file 198: /oracle/TCP/sapdata6/btabd_81/btabd.data81 Wed Jun 14 08:17:16 2006 Errors in file /oracle/TCP/saptrace/usertrace/tcp_ora_15519830.trc: ORA-00603: ORACLE server session terminated by fatal error ORA-00376: file 198 cannot be read at this time ORA-01110: data file 198: '/oracle/TCP/sapdata6/btabd_81/btabd.data81' ORA-00376: file 198 cannot be read at this time ORA-01110: data file 198: '/oracle/TCP/sapdata6/btabd_81/btabd.data81' Wed Jun 14 08:18:20 2006

Temporary Solution – How to recover datafile SQL>connect / as sysdba; SQL>select file#,status from v$datafile; Check the file indicated in ora-00376 is in media recovery status or not, if yes, SQL>select xxxxxxx from v$recover_log; Check datafile need to recover (contoh in this case datafile =btabd.data81) SQL>alter database datafile X offline; SQL > recover datafile X; required will be displayed SQL> brrestore ; Media recovery completed SQL>alter database datafile X online;

Nota : X = datafile = btabd.data81