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 -> Re: Corrupted dbf file... help!!

Re: Corrupted dbf file... help!!

From: cleveridea <cleveridea.net_at_gmail.com>
Date: Mon, 10 Sep 2007 02:24:14 -0000
Message-ID: <1189391054.081119.131710@r34g2000hsd.googlegroups.com>


On Sep 9, 3:52 pm, Kaka <kaka...._at_gmail.com> wrote:
> 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!!

Search Google for a BitTorrent site that might have a cold backup of your database? Received on Sun Sep 09 2007 - 21:24:14 CDT

Original text of this message

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