Hi All
I have a few basic questions:
1] How Oracle knows that media recovery is needed
during STARTUP ? Is it based on mismatch of SCN or
ckpt# or anything else ? I understand, if the datafile
is missing then in Mount stage it throws error. Is
there any other situation where it throws media
recovery reqd.
And, can a single block corruption be the reason
enough for media recovery- error message during
Startup. I believe, block corruption in a non-system
datafile does not shutdown the instance and it gives
error for the session accessing the block. So during
next instance startup will this corrupted block cause
any problem?
2] How oracle comes to know that instance recovery is
needed during startup.
3] say we have a backup of the controlfile and we are
using it as we lost all the present control files. In
the backup controlfile in user_dump_dest I see All the
datafiles (both SYSTEM and NON-SYSTEM) are listed in
the 'create controlfile ' cmd. Then after creating the
new controlfile in NO-mount stage , how can we
associate the non system tablespace names with the
existing OK datafiles ?
Please help me clear my doubts?
Thanks a Lot
Regards
B S Pradhan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: bhabaniindia_at_rediffmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Oct 30 2003 - 23:04:25 CST
