RE: Feel good today (lost control file recovery)

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sinardy Xing
Sent: Monday, 29 November 2004 4:20 PM
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: