Re: Corrupted dbf file... help!!

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Tue, 11 Sep 2007 02:54:05 -0000
Message-ID: <1189479245.655692.8470@22g2000hsm.googlegroups.com>

On Sep 10, 10:33 pm, Noons <wizofo..._at_yahoo.com.au> wrote:
> On Sep 11, 12:43 am, Helma <helma.vi..._at_hotmail.com> wrote:
>
> > That sounds elaborate. Make a backup to tracefile of your controlfile
> > is easier.
>
> That will be kinda hard to do if he's having problems
> starting the db in tghe first place?

He can do a "backup to trace" if the database is mounted (I assume he has the controlfiles).

SQL> startup mount
ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size                  1218316 bytes
Variable Size              88082676 bytes
Database Buffers           75497472 bytes
Redo Buffers                2973696 bytes

Database mounted.
SQL> alter database backup controlfile to trace;

Database altered.

SQL> Received on Mon Sep 10 2007 - 21:54:05 CDT