Re: DBA problem

From: Amit Aggarwal <amaggarwal_at_kendle.com>
Date: 1997/10/30
Message-ID: <3458EB8E.7348@kendle.com>#1/1

Victor Slootsky wrote:
>
> Data file was corrupted and can't be restored.
> The datafile size does not match the size specified in the control file.
>
> Startup does not go.
> What is the way around?

Depending on if you have been doing hot/cold backups,you can restore upto a certain time. Also, if you think you do not need that datafile, you can drop the datafile in the mount mode of the database. To do this: type:

svrmgrl

SVRMGRL>startup mount
SVRMGRL>alter database datafile <datafile> offline drop.
SVRMGRL> shudown 

svrmgrl
SVRMGRL>connect internal
SVRMGRL>startup

It will bring up the database.

In case you cannot afford to lose that datafile, and if you are in archive mode, then issue 'alter database recover automatic tablespace <tablesapce_name>' after mounting the database.

In case you are not in Archive mode, then you would have to go back to the last cold backup and restore all the files.

Amit
Oracle DBA/Unix SA Received on Thu Oct 30 1997 - 00:00:00 CST