Re: Feel good today (lost control file recovery)

Hi,

        I remember (but I'm not 100% sure) that when issuing 'recover database using backup control file' you are telling oracle to use datafiles scn and not to check controlfile scn. During the recovery process the controlfile is updated accordingly.
Hope it helps,

        Giovanni
> here is the Scenario-
>
> Your d/b is in archive log mode,
> you lost control files, so the instance crashed.
>
> Assuming now you are starting with a backup control file,
> (either text or binary version).
>
> If you restore the control file that was checkpointed much earlier,
> oracle will prompt for recovery, so at MOUNT stage ,
> you are issuing a RECOVER DATABASE command,
>
> So what happens during RECOVER DATABASE command,
>
> is that called a media recovery (involving control file) ?
> in which you are recovering control-file
> ( by applying archived/on-line redoLogs ?!)
>
> I assume finally the recoverd control file will have the SCN ,etc.. in sync
> with
> other database files.
>
> Any insight into these control file recovery process is most welcome.
>
> Thanks
> Vasu.
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sinardy Xing
> Sent: Monday, 29 November 2004 4:20 PM
> To: oracle-l_at_freelists.org
> Subject: Feel good today
>
>
> Hi DBAs,
>
> Me feel very good and happy today, feel like to contribute something to=20
> this mailing list but no one post questions....
>
> question please....
>
>
> Sinardy
>
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>
>

-- 

----------------------------------------
Giovanni Cuccu
Sw Engineer_at_dianoema.it
Dianoema S.p.A.
Via de' Carracci 93 40131 Bologna
Tel: 051-7098211   051-4193911
e-mail:gcuccu_at_dianoema.it
----------------------------------------
No man does it all by himself,
I said young man,
put your pride on the shelf
----------------------------------------
--
http://www.freelists.org/webpage/oracle-l