| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent! Online redo log files corruption
you are right, Rachel, it is way too risky to open my production database
that way when Oracle explicitly told me (and log it in their database with
my CSI number perhaps!! :P) not to.
I just decide to go back to the traditional method and do perform and pure imcomplete recovery.
Thanks everyone for help!
Winnie :)
"Rachel Carmichael" <carmichr_at_hotmail.com>@fatcity.com on 10/22/2000 11:25:21 AM
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: RE: Urgent! Online redo log files corruption
NO!!!!!!!!!!!!!!!!!!!!!!!!
Oracle Support stated very clearly that the database would not be in a supported state (meaning they have the option of NOT answering any future problem questions) if the hidden parameter is used.
So you are telling Winnie that what support told her is a load of horse
hockey. Now, maybe it's true that the database will be fine if she has done
a shutdown normal or immediate (but if the online logs are lost the odds
are
high she had to do a shutdown abort to close the database in any case). But
whether or not it's true, support said that Oracle's policy is that the
database is no longer in a supported state.
It's TOTALLY irresponsible to tell someone that they do not have to do what Support told them in this case.
I'll give you the benefit of doubt and assume that the "too much travel
this
week" meant that you were tired and not thinking clearly when you said
that.
Rachel
>From: K Gopalakrishnan <kaygopal_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Urgent! Online redo log files corruption
>Date: Sun, 22 Oct 2000 07:40:45 -0800
>
>Hi Winne !
>
>There is absolutely no problem in using the hidden
>parameter if your database is shutdowned using
>NORMAL/IMMEDIATE options.
>
>The problem comes only when you have shutdowned using
>ABORT (with different scn in datafiles and system
>files). The parameter internally takes the LOWEST SCN
>and ignores the other changes after that.
>
>One typical example can be SYSTEM tablespace is with
>scn x and data tabelspce with checkpoint scn > x. In
>this case (after opening the database with the hidden
>parameter) you may have the definition about the
>table in the dictionary but the table will not exist
>in the data tablespace.
>
>Too much of travel in this week. have a nice weekend..
>!
>
>
>
>
>
>=====
>Warm Regards,
>K Gopalakrishnan
>Bangalore, INDIA
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Messenger - Talk while you surf! It's FREE.
>http://im.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: K Gopalakrishnan
> INET: kaygopal_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
>
Share information about yourself, create your own public profile at http://profiles.msn.com.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 mayReceived on Mon Oct 23 2000 - 12:29:53 CDT
 |
 |