Re: Datafile corruption

I don't see how you can perform recovery on an empty datafile. DDL statements are not logged, so when transactions are applied there aren't any tables to apply them to. Even if you restored the backup that had all the table definitions, recovery will fail if there has been any DDL statements (like ALTER TABLE to add a column).

What am I missing here?

Oracle wrote:
>If you are running in archiving mode, just using alter database to take the
>corrupt datafile offline and then physical delete it . . .
>Then if all the log files since the datafile was created to the present are
>available, and if your controlfile is current, then you can recover the
datafile
>without a backup. In order to do this, you will have to use the CREATE
>DATAFILE clause of the ALTER DATABASE command: e.g. ALTER DATABASE CREATE
>DATAFILE 'oldfilename' AS 'newfilename'. This will create an empty file
the
>same size as the missing file.
> Following this, you must perform media
>recovery on the empty file. During media recovery of the empty file, all
>archived and online redo logs must be available to be applied to the file
so
>that it can be brought back to a transaction consistent state
Received on Sat Nov 28 1998 - 15:36:16 CST