Re: Creating new control File

Sorry but you cann't just plug in an old system datafile.

If you're database is up can you Export it? If you can create a full export, then import it into a new uncorrupt database.

bhavesh_busa_at_hotmail.com wrote:
>
> In my DB, the system tablespace's datafile is corrupted.
> All the old backup's contain the corruption for that particular
> datafile. So retoration from old database backups is not possible.I
> have verified this using tool 'dbv'.
> I do have a 2 months old db backup. But I'm unable to recover from this
> status as I lost offline redo logs which will make recovery possible.
>
> I'm thinking of creating a new control file with the old system
> datafile and the other latest datafiles.
> Please advice will this work ?
> and will be the database be consistent?
>
> One possible hitch is that I'm not sure whether oracle check's for
> individual checkpoints in all the datafiles while creating a new
> control file.
> Any idea about this ?
>
> As a DBA y'all know how urgent it is!!!!
> Please reply ASAP.
>
> Regards
> -Bhavesh
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
Don Berryman
1188 Clovelly Terrace
Victoria BC  V8P 1V6
(250) 384-4328