Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Corrupted dbf file... help!!

Corrupted dbf file... help!!

From: Kaka <kaka.hui_at_gmail.com>
Date: Sun, 09 Sep 2007 13:52:04 -0700
Message-ID: <1189371124.130276.287190@r29g2000hsg.googlegroups.com>


I shutdown the database using shutdown abort and now one of the db file is corrupted. I am not able to startup the database anymore..... NOTE: the database is in the noarchivelog mode. Does it mean, the whole database is non-recoverable? HELP..... thanks!!!!

Looks like one of the db file is corrupted.

What should I do?

SQL> startup;
ORACLE instance started.
Total System Global Area 1932496864 bytes

Fixed Size                   733152 bytes
Variable Size             402653184 bytes
Database Buffers         1476395008 bytes
Redo Buffers               52715520 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 198 - see DBWR trace file ORA-01110: data file 198: '/u01/oradata/ax5/data014.dbf '

Thanks!! Received on Sun Sep 09 2007 - 15:52:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US