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,
i hope which this db is not prod DB otherwise you may crazy set in
NOARCHIVE LOG mode, it's very dangerous!
do you have a physical backup for this datafile? Or a cold backup at
least?
Alberto
Received on Tue Sep 11 2007 - 05:52:07 CDT
