| 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
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 Received on Sun Oct 22 2000 - 12:22:39 CDT
 |
 |