Re: Creating new control File

So you want to mix a 2 month-old system.dbf with the up-to-date other.dbfs, and create a new controlfile? It won't work -at least, it won't be consistent, which amounts to the same thing. You'll never get her open.

I didn't really understand the comment about 'checking for individual checkpoints in all the datafiles while creating a new control file.', but what happens if you run the 'backup to trace' as a script is that all listed datafiles are checked for their checkpoints, the maximim found is written into the new controlfile's header, and that's the target checkpoint for the rest of the database to be recovered to... by application of redo logs which you don't have.

Your new controlfile will be at the same point in time, checkpoint-wise, as your current one -so you might just as well not bother.

The best advice I can come up with off the top of my head is... your entire database must go back to the time of your last complete (and uncorrupt) backup. And this is a prime example as to why it is inadviseable to be too energetic about getting rid of your "old" archive redo logs.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



<bhavesh_busa_at_hotmail.com> wrote in message
news:8qifpj$ubk$1_at_nnrp1.deja.com...


> 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.