Re: Corrupted dbf file... help!!

On Sep 9, 1: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!!

This is often the result of someone deleting the file with an OS command. As long as Oracle has the file open there's no problem, it just was removed from the directory inode. Once Oracle lets it go with the shutdown, you are in deep kaka.

What's the deal with ax5 and ax5.old - did you rename a directory?

jg

--
@home.com is bogus.
War of the Academics: http://www.signonsandiego.com/uniontrib/20070906/news_lz1c06academ.html