Re: Corrupted dbf file... help!!

On Sep 11, 8:33 pm, Alberto Frosi <alberto.fr..._at_gmail.com> wrote:
> On Sep 9, 10: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!!
>
> Hi,
> another question:
> Why 'shutdown abort'? and no 'shutdown immediate' for example?
> why this choice?
>
> Alberto- Hide quoted text -
>
> - Show quoted text -

Don't ask why.

1, Check carefully at the OS level for the missing file, check the permission.
2, If OS level failured, you can offline drop this file and open the database in read only mode
3, If open success, try to export the existing data.

Else, contact me, maybe helpful.

Welcome to www.dbatools.net Received on Tue Sep 11 2007 - 10:01:04 CDT