RE: Feel good today (lost control file recovery)
- From: "Rajagopal, Vasudevan" <vasudevan.rajagopal@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 29 Nov 2004 06:11:41 -0500
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
