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_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 Received on Mon Nov 29 2004 - 05:14:17 CST